PA-AR backend tables data flow. Feedback required

To discuss Oracle Projects & Property Manager setup and costing related matters.
Post Reply
akumar.oracle
Posts: 195
Joined: Sat May 31, 2008 1:29 pm
Location: India

PA-AR backend tables data flow. Feedback required

Post by akumar.oracle »

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
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests