How You Process General Ledger Journal and Subledger Transaction Mapping Report

The General Ledger Journal and Subledger Transaction Mapping Report exports the accounting entries with detailed information from subledger and journals and lists the results using an Oracle Analytics Publisher report.

Run the process from the Scheduled Processes Overview page in Navigator - Tools.

Note: This report is used only for China localization.

Settings That Affect Data Export

This table lists the parameters associated with the process:

Parameters	Description
Data Access Set	Specify the data access set associated with your data role.
Ledger	Specify the ledger from which you want to export data. The ledger must be associated with the selected data access set.
Legal Entity	When the selected ledger is a primary ledger, specify the legal entities assigned to it. When the selected ledger is a secondary ledger, specify the legal entities that are assigned to the corresponding primary ledger.
Source	Specify the name of the journal source as defined in the Manage Journal Source page.
From Batch Name	Specify the beginning of a range of the general ledger batch name list to be included for exporting data.
To Batch Name	Specify the end of a range of the general ledger batch name list to be included for exporting data.
From Document Number	Specify the beginning of a range of general ledger sequence number to be included for exporting data.
To Document Number	Specify the end of a range of general ledger sequence number to be included for exporting data.
From Period	Specify the beginning of a range of general ledger periods to be included for exporting data.
To Period	Specify the end of a range of general ledger periods to be included for exporting data.

How Data Is Exported

The report includes these sections:

• Period

• Account

• Currency

• Rate

• Entered Amount

• Accounted Amount

• Source

• Category

• Journal Batch Name

• Journal Name

• Document Number

• Voucher Number

• Journal Line

• Customer or Supplier Name

• Receipt or Payment Number

• Receivables Transaction Number or Payables Invoice Number

• Intercompany Batch Number

• Purchase Order (PO) Number

Data is exported to the report based on these criteria:

• When a ledger is specified, only posted journal lines in the specified ledger are exported. When no legal entity is specified, the report extracts all of the journal lines in the selected ledger.

• When the source is specified, the general ledger journal lines from the specified source are extracted. When no source is specified, all the general ledger journal lines are exported.

• Only general ledger journal lines during the selected period range, including both normal period and adjustment period are extracted and exported to the report.

• Subledger information is exported only for these sources: payables, receivables, cost management, and intercompany. For other sources, only general ledger information is exported, subledger information isn't exported.

• For the journal lines with the source as Oracle Fusion Payables, subledger information, such as supplier name, Payables invoice number, and Payables document number is exported.

  When the event class in the subledger accounting journal entry belongs to the PAYMENTS event entity, only the supplier name and payment document number are extracted and exported to the report.

  When the event class in the subledger accounting journal entry belongs to the INVOICES event entity, only the supplier name, and invoice number are extracted and exported to the report.

  The supplier name is extracted from the party name field in the subledger accounting journal entry.

• For the journal lines with the source as Oracle Fusion Receivables, subledger information, such as customer name, Receivables transaction number, and Receivables receipt number is exported.

  When the event class in the subledger accounting journal entry belongs to the RECEIPTS event entity, only customer name and receipt number are extracted and exported to the report.

  When the event class in the subledger accounting journal entry belongs to the TRANSACTION and ADJUSTMENT event entity, only customer name and transaction number are extracted and exported to the report.

  The customer name is extracted from the party name field in the subledger accounting journal entry.

  For the journal lines with the source as Oracle Fusion Cost Management, the original event class of the journal line is extracted.

• For the journal lines with the source as Oracle Fusion Cost Management, the original event class of the journal line is extracted.

  When the event class in subledger accounting journal entry belongs to the RCV_ACCOUNTING_EVENTS event entity, supplier name, purchase order number, and receipt number are extracted and exported to the report.

  When the event class in subledger accounting journal entry doesn't belong to the RCV_ACCOUNTING_EVENTS event entity, the cost management subledger information isn't exported.

• For the journal lines with the source as Oracle Fusion Intercompany, the original intercompany batch number is extracted.

• For secondary ledgers, the subledger information is extracted and exported only when the data conversion level is subledger. Otherwise, only general ledger information is extracted and exported. The data conversion level is defined during accounting setup.

• For the summary report mode, when transferring subledger to general ledger, the report restores the detail level with subledger information to export on the report.

  When the subledger accounting options in the accounting setup and transfer to general ledger options in journal line type set up is summary, the subledger journal lines are summarized and transferred to general ledger.

  In such cases, one general ledger journal line may be summarized from multiple subledger journal lines. The report exports multiple lines for every subledger journal line and the amount displayed is from the corresponding subledger journal line.