ERPstuff - Oracle EBS Community

Hi,


1Q) After Posting payments to GL which tables are will effect. Kindly help me on this.

2Q) When invoice created, in which time this below tables are will effect

AP_inv_lines_balance
AP_inv_int_Balance
AP_invoice_key_ind_all
AP_invoice_relationships
AP_invoice_prepays_all
AP_history_invoices_all
AP_payment_key_ind
AP_Payment_key_ind_all
AP_payment_key_ind
AP_payment_Distributions_all
AP_payment_Schedules
AP_mc_invoices
AP_chrg_allocations_all
AP_history_invoice_payments
AP_terms

Can u send with Clear Answer for above tables

My mail_id madhuarepalli2007@gmail.com

Thanks & Regards,

Madhu

I would request you to run a Diagnostic script called AP List. This script provides you with an output of all backend information of AP related tables for a Transaction (Invoice / Payment).

Run the script after creating an invoice once and after making payment to the invoice once. Now compare the outputs of the script, you can easily identity the tables that are being populated.

Same way run the script again after transferring the transaction to GL and compare the outputs.

Regards,
Karthikeyan

Hi Karthikeyan

Thanks for given inforamtion. The given some tables are not show in Diagonstic. I am daily practise like that only.

Eg: After approving the invoice internally some tables will effect like AP_ae_lines_all, AP_ae_headers_all. so that kindly advise on that tables

It looks like you are in release 11.

tables starting with AP_AE (AP refers to Accounts payable and AE refers to Accounting Entries) are all accounting related tables. They are populated when accounting is created for the transaction.
Accounting may happen online or through concurrent program.
AP_Accounting_events table gets populated when the invoice is validated
AP AE HEADER and AP AE LINES gets populated once the accounting is completed for the transaction.
When you transfer them to GL, Transfer to GL colun in AP_AE_HEADERS_ALL turns to Y.
The Accounting related tables are available in the AP list, as i have run many times myself for similar reading ....

Regards,
Karthikeyan

Hi Karthikeyan,

When will populate this given tables. can u give answer

AP_inv_lines_balance
AP_inv_int_Balance
AP_invoice_key_ind_all
AP_invoice_relationships
AP_invoice_prepays_all
AP_history_invoices_all
AP_payment_key_ind
AP_Payment_key_ind_all
AP_payment_key_ind
AP_mc_invoices
AP_chrg_allocations_all
AP_history_invoice_payments
AP_terms

If i had i could have given it in my first reply ... i dont have/know ... i am not great at technical side ... so i dont want to do guess work and mislead a fellow professional.....
But i feel most of the table names in that list are not related to invoice creation .....

Please check on ETrms...

Regards
Karthikeyan

Thanks a lot.