OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » How data flows

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How data flows [message #270031]

Tue, 25 September 2007 08:33

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

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

Report message to a moderator

Re: How data flows [message #278988 is a reply to message #270031]

Tue, 06 November 2007 09:17

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 23:54:45 CDT 2024