General Ledger & Intercompany

Get Involved. Join the Conversation.

Topic

    Raj Mohanraju
    Intercompany Transaction Tables
    Topic posted June 6, 2019 by Raj MohanrajuRed Ribbon: 250+ Points, tagged Financials, General Ledger, Intercompany, Payables, Receivables, Reports, Subledger Accounting 
    130 Views, 2 Comments
    Title:
    Intercompany Transaction Tables
    Summary:
    Intercompany Transaction Tables
    Content:

    We are uploading intercompany transactions via FBDI from a legacy system. Now we are looking for a way to reconcile the intercompany transactions to source to avoid transactions being lost in transit.
    So I'm exploring a report which will list of all impacted Intercompany Inbound and Outbound Transaction Tables [as I would see in the UI]
    a/ populate all intercompany transactions using the batch name [as entered in the FBDI]

    In addition to this I will also need to provide the end result of each intercompany transaction from invoice creation and accounting details as well. SO the report should also:
    b/ populate all intercompany receivables and payables invoice details created for these intercompany transactions
    c/ tables that relate to accounting entries created after intercompany receivables and payables invoices have been created

    Any advise will be greatly appreciated.

    Comment

     

    • Raj Mohanraju

      To summarise, I'm looking for a list of tables that affect intercompany transactions [after import] + tables that affect intercompany receivable and payable invoices + tables to obtain accounting entries.

    • Ravi Kanth Vuddagiri

      1. Take count of transactions and values before loading IC batch into cloud. Use Create transactions in spreadsheet. Once the batches are imported Validate counts again in Manage Intercompany Outbound Transactions. If there are any missing mandatory information batch will be created in New status with Errors.

      2. Use seeded Intercompany Reconciliation available for reconciling IC AP and IC AR Invoices after the batches are processed completely. Navigation: Intercompany > Reconciliation. This bubble will be beside Transactions bubble. 

      If you still want to BIP create reports for this you can start with below table. You can find all table @ https://docs.oracle.com/en/cloud/saas/financials/19a/oedmf/FUN_INTERCO_ORGANIZATIONS-tbl.html

      FUN_INTERFACE_BATCHES

      FUN_INTERFACE_REJECTIONS

      FUN_TRX_HEADERS

      FUN_TRX_LINES

      If you are creating a query, please share the SQL with me.