+ Reply to Thread + Post New Thread
Results 1 to 2 of 2

Thread: AP Tables

  1. #1
    yknev's Avatar
    yknev is offline Junior Member
    Join Date
    03 Mar 2010
    Posts
    18
    Say Thanks
    1
    Thanked 0 Times in 0 Posts
    Documents
    2
    Uploads
    0

    Default AP Tables

    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.    Club-Oracle Complementary E-Books and Magazines
    Get your free Complementary Copy of Oracle Magazine

    You can also browse the Free Magazines and E-Books section to see the complete list of free magazines, e-books and Whitepapers.

  3. #2
    apps_expert's Avatar
    apps_expert is offline Forum Genius
    Join Date
    20 Dec 2008
    Location
    Chennai, India
    Posts
    320
    Say Thanks
    2
    Thanked 25 Times in 23 Posts
    Documents
    0
    Uploads
    4

    Default Re: AP Tables

    The Payables Accounting Process writes to the following tables:

    Code :
    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.

Similar Threads

  1. Link between PO Tables and AP Tables
    By Monziac in forum Oracle Apps Technical
    Replies: 8
    Last Post: 01-13-2010, 01:44 PM

Tags for this Thread