1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

AP Tables

Discussion in 'Oracle Apps Technical' started by yknev, Mar 3, 2010.

  1. yknev

    yknev Active Member

    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    100
    Dear all,

    After running follwing programs which tables are populate.

    1) Payables Accounting Process
    2) Payables Transfer to General Ledger

    Plz specifiy table names as well as particular columns also.
     
  2. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    The Payables Accounting Process writes to the following tables:

    Code (Text):
    ap_accounting_events_all
    ap_ae_headers_all
    ap_ae_lines_all
    For invoices it updates the accounting_event_id in ap_invoice_distributions_all
    For payments it updates the accounting_event_id in ap_invoice_payments_all
    For Clearing events it updates the accounting_event_id in ap_payment_history_all

    And the Transfer to GL program basically populates the GL interface table. Of course a lot would also depend on 11i, R12 differences but this answer should suffice you for basic knowledge.