Understanding the FEC Extractor Functionality

You run the FEC Extractor of Statutory Accounting Audit File program (R74F210) to create the CSV audit file using the Oracle Business Intelligence Publisher (BIP) functionality to extract the data. You can process the extraction before or after running the FEC Sequential Number Generation Process program.

(Release 9.2 Update) You can create the text file to extract the data without using the Oracle BIP functionality by entering 1 in the Generate Text File processing option.

The FEC Extractor of Statutory Accounting Audit File reports only those posted transactions from F0911 that are included in ledger type AA and the ledger type specifically defined for opening balances. It does not consider any other transactions for the text file that it generates.

When you run the Extractor of Statutory Accounting Audit File after generating the sequenced number, the report shows the number of the accounting entry in chronological and sequential numbering. The system displays in field 3 under the EcritureNum column, theGLREG#(if ordered by GL Date) or Batch Type+GLREG#(if ordered by Batch Type) from the Account Ledger table (F0911).

Without running the FEC Sequential Number Generation Process program, the system sorts data from F0911 by batch type, GL date, batch number, document company, document number, and document type and the system shows in field 3 under the EcritureNum column as DOC/DCT. If you need details of transactions written in the FEC, then you can run the FEC Sequential Number Generation Process program in Proof mode.

Note: To generate the text file, you must activate the BIP Template before you run the FEC Extractor of Statutory Accounting Audit File program. To activate the BIP template, you must complete the start and end dates in BI Publisher Object Repository application (P95600) for the objects of the Report Definitions associated with the version of the FEC Extractor of Statutory Accounting Audit File program.