Home » Applications » Oracle Fusion Apps & E-Business Suite » How data flows
How data flows [message #270031] Tue, 25 September 2007 08:33 Go to next message
vishalaksha
Messages: 16
Registered: September 2007
Junior Member
I am using oracle apps 11.5.10.2
When we run customer interface under oracle receivables manager responsibility to import data from interface tables to base tables then how data flows between HZ_PARTIES, HZ_LOCATIONS, HZ_PARTY_SITES and HZ_CUST_ACCOUNT_SITE from RA_CUSTOMERS_INTERFACE_all, Ra_Customer_Profiles_Int_All? I want to know that data from RA_CUSTOMERS_INTERFACE_all goes to which table first and then how other tables are populated (order in which they are populated).

[Updated on: Tue, 25 September 2007 09:48]

Report message to a moderator

Re: How data flows [message #278987 is a reply to message #270031] Tue, 06 November 2007 09:16 Go to previous messageGo to next message
dhrubajyoti_nth
Messages: 18
Registered: October 2007
Location: Renukoot
Junior Member


AutoInvoice transfers transaction data from the interface tables
RA_INTERFACE_LINES_ALL,
RA_INTERFACE_SALESCREDITS_ALL, and
RA_INTERFACE_DISTRIBUTIONS_ALL
into the following Receivables tables:
o RA_BATCHES_ALL
o RA_CUSTOMER_TRX _ALL
o RA_CUSTOMER_TRX_LINES _ALL
o RA_CUST_TRX_LINE_GL_DIST_ALL
o RA_CUST_TRX_LINE_SALESREPS_ALL
o AR_PAYMENT_SCHEDULES_ALL
o AR_RECEIVABLE_APPLICATIONS_ALL
o AR_ADJUSTMENTS_ALL
From the above tables when posted in GL the data
goes to the following tables:
0GL_JE_BATCHES
0GL_JE_HEADERS
0GL_JE_LINES

Regards

DJ Nath
icon14.gif  Re: How data flows [message #278988 is a reply to message #270031] Tue, 06 November 2007 09:17 Go to previous message
dhrubajyoti_nth
Messages: 18
Registered: October 2007
Location: Renukoot
Junior Member

AutoInvoice transfers transaction data from the interface tables
RA_INTERFACE_LINES_ALL,
RA_INTERFACE_SALESCREDITS_ALL, and
RA_INTERFACE_DISTRIBUTIONS_ALL
into the following Receivables tables:
o RA_BATCHES_ALL
o RA_CUSTOMER_TRX _ALL
o RA_CUSTOMER_TRX_LINES _ALL
o RA_CUST_TRX_LINE_GL_DIST_ALL
o RA_CUST_TRX_LINE_SALESREPS_ALL
o AR_PAYMENT_SCHEDULES_ALL
o AR_RECEIVABLE_APPLICATIONS_ALL
o AR_ADJUSTMENTS_ALL
From the above tables when posted in GL the data
goes to the following tables:
GL_JE_BATCHES
GL_JE_HEADERS
GL_JE_LINES

Regards

DJ Nath
Previous Topic: Month end close schedule
Next Topic: Difference b/w Cr memo and Dr memo
Goto Forum:
  


Current Time: Fri Dec 02 21:00:57 CST 2016

Total time taken to generate the page: 0.08445 seconds