PA-AR backend tables data flow. Feedback required
Posted: Thu May 28, 2009 12:31 pm
Hi,
I have been trying to work out backend data flow for Oracle 11i Projects billing.
For PA-AR data flow.
Please let me know if i am on right track.
First the invoices are recieved by projects Open interface table PA_TRANSACTION_INTERFACE_ALL
all the invoices which dont have
transaction_status_code = 'R'
(in PA_TRANSACTION_INTERFACE_ALL table)
are send to GDI (Generate Draft Invoice) which calls Auto Accounting to detemine accounting for invoice lines (determine Debit and Credit account)
PA_DRAFT_INVOICES
PA_DRAFT_INVOICES_ITEMS
PA_PROJECTS_ALL
are populated.
then all the invoices are send to AR interface tables
RA_INTERFACE_LINES_ALL
RA_INTERFACE_SALES_CREDIT_ALL
RA_INTERFACE_DISTRIBUTIONS_ALL
Auto Invoice Import process is called to (Import, Validate and Purge)
the correct invoices are transfered in Receivables Base tables
RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL
AR_PAYMENT_SCHEDULES_ALL
AR_RECEIVABLES_APPLICATION_ALL
Tieback Invoice process checks if there are any errors in
RA_INTERFACE_ERRORS_ALL
Then this accounting transaction is transfered to GL.
Please help me to build this flow...
I am not able to find any document (oracle document) where i can find these tables data flow or may be i am missing out.
I will really appriciate if someone who has worked on PA-AR process flow or has knowledge of the oracle 11i Billing give me their valuable suggestion.
then send
I have been trying to work out backend data flow for Oracle 11i Projects billing.
For PA-AR data flow.
Please let me know if i am on right track.
First the invoices are recieved by projects Open interface table PA_TRANSACTION_INTERFACE_ALL
all the invoices which dont have
transaction_status_code = 'R'
(in PA_TRANSACTION_INTERFACE_ALL table)
are send to GDI (Generate Draft Invoice) which calls Auto Accounting to detemine accounting for invoice lines (determine Debit and Credit account)
PA_DRAFT_INVOICES
PA_DRAFT_INVOICES_ITEMS
PA_PROJECTS_ALL
are populated.
then all the invoices are send to AR interface tables
RA_INTERFACE_LINES_ALL
RA_INTERFACE_SALES_CREDIT_ALL
RA_INTERFACE_DISTRIBUTIONS_ALL
Auto Invoice Import process is called to (Import, Validate and Purge)
the correct invoices are transfered in Receivables Base tables
RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL
AR_PAYMENT_SCHEDULES_ALL
AR_RECEIVABLES_APPLICATION_ALL
Tieback Invoice process checks if there are any errors in
RA_INTERFACE_ERRORS_ALL
Then this accounting transaction is transfered to GL.
Please help me to build this flow...
I am not able to find any document (oracle document) where i can find these tables data flow or may be i am missing out.
I will really appriciate if someone who has worked on PA-AR process flow or has knowledge of the oracle 11i Billing give me their valuable suggestion.
then send