ERPstuff - Oracle EBS Community

Hi all,

Im new to Oracle.Please some body respond to the below.

1. How do we transfer tha data from sub ledgers to the reporting SOBs?

2. Can we transfer all the transaction like POs and Invoices to the reporting SOBs? If so how do we query the same in the reporting SOBs?

3. Can we transfer the entries directly from subledgers to reporting SOB or do we need to transfer them to primary GL and there to reporting?

4. While performing the "PAYABLES TRANSFER TO GL" if we choose 'Transfer to Reporting SOB' is "YES" then whether only journal entries will transfer to reporting SOB or all the invoices also will transfer?


Thanks in advance,
Nikki.

Hi Nikki,

In R12 i can tell you in detail as i never worked in MRC in 11i...hope so the process will almost be similar.

In R12 if we transfer data from subledgers to GL or primary ledger and as soon we post the transaction then it is automatically replicate to the reporting ledgers further it is automatically replicate to secondary ledger depending on the type of secondary ledger whether it is Sub-ledger level secondary ledger or journal level secondary ledger.
For example:
The subledger level secondary ledger maintains subledger journals, general ledger journal entries, and balances in the additional accounting representation. This data conversion level uses both Subledger Accounting and the General Ledger Posting program to create the necessary journals in both the primary and secondary ledgers simultaneously. Subledger Accounting creates the journal entries from subledger transactions if the subledger integrates with Subledger Accounting. General Ledger Posting creates the journal entries for all other transactions that do no integrate with Subledger Accounting, including manual journal entries.

While performing the "PAYABLES TRANSFER TO GL" Only accounting entries are transferred to reporting ledger and secondary ledger while invoices/ transactions do not transfer.

thanks,

Aman