ctcLink Reference Center9.2 Finance9.2 FIN - General Ledger AFRSRunning AFRS Transactions Before Submitting to OFM

Running AFRS Transactions Before Submitting to OFM

Purpose:  Use this document to run AFRS transactions before submitting to OFM through ctcLink.

Audience:  College Accounting Staff, SBCTC Accounting Staff.

The purpose of loading the AFRS transactions is to process and review the data that is to go to AFRS. This is step one of the process.

If changes are made to the ctcLink data, the AFRS transactions must be run again.

The AFRS transactions can be run after the month is closed; there usually will be no adds/adjustments. However, it should be noted this can be run prior to the close of a month to validate the accuracy of financial data before it's submitted to the Office of Financial Management (OFM).

Run AFRS Transactions

Part 1 - Load Data

Navigation:  NavBar > Navigator > General Ledger > CTC Custom > AFRS > AFRS Report > Create AFRS Transaction

  1. The Create AFRS Transaction run control search page displays.
  2. Enter an existing Run Control ID or select the Add a New Value tab to create a new one.
  3. Select the Search button.
run control id search page
  1. The Create AFRS Transaction page displays.
  2. Enter the appropriate Business Unit.
  3. Enter Fiscal Year to process.
  4. Enter Accounting Period to process.  (NOTE:  PeopleSoft uses the month of July as Accounting Period 1 and repeats after Accounting Period 12).
  5. Select the Save button.
  6. Select the Run button.
create AFRS transaction page
  1. The Process Scheduler Request page displays.
  2. The Run Date and Run Time will default.
  3. Verify that the Select box is checked.
  4. The Format should be Txt.
  5. Select the OK button.
process scheduler request page
  1. The Create AFRS Transaction page displays.
  2. Make note of the Process Instance number.
  3. Select the Process Monitor link.
select process monitor link
  1. The Process Monitor page displays.
  2. Select the Refresh button until the Run Status = Success and Distribution Status = Posted.
  3. When at Success and Posted, the transaction data for AFRS has been loaded.
process monitor page
  1. The process to load the data is now complete.

Part 2 - Review Data

Navigation:  NavBar > Navigator > General Ledger > CTC Custom > AFRS > AFRS Review > AFRS Reporting Transactions

  1. The AFRS Transaction Validation page displays.
  2. Each section represents one of 10 modules run by the AFRS CEMLI. It is organized in two error reports;
    1. Review XX AFRS Rule Validation
    2. Review XX TC/AFRS Report
  3. Additional information on the two files can be studied in AFRS CEMLI Overview.
  4. Review a month's worth of financial data by selecting one of the modules error reports.
  5. Select Review EX AFRS Rule Validation: this is the first part of Error Report 2.
AFRS Transaction Validation
  1. The CTC_AFRS_EX_RPT - EX AFRS Rules validation CEMLI page displays.
  2. Enter Business Unit.
  3. Enter the Fiscal Year.
  4. Enter the Accounting Period.
  5. Notice the Valid (Y/N) box is unchecked. (By leaving the box unchecked the result of errors will be displayed).
  6. Select the View Results button.
  7. The results display.
  1. By checking the Valid (Y/N) box, the correct data that is staged to go to OFM will be displayed, as seen in screen shot below.
  2. Select the View Results button.
  3. The Review EX TC/AFRS Report usually does not have as many errors as the Review EX AFRS Rule Validation.
  1. You have now run the AFRS Transactions and reviewed the errors within the AFRS CEMLI for the Error Report.
  2. End of procedure.


Add your comment

E-Mail me when someone replies to this comment