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.