Home » Applications » Oracle Fusion Apps & E-Business Suite » AR Implementation & Interfaces
AR Implementation & Interfaces [message #239881] Wed, 23 May 2007 09:37 Go to next message
Krishna_dev
Messages: 32
Registered: May 2007
Member
Need helping of autolockbox interface with oracle receivables. Flat format has header information for batches and detail section that carries receipts information. Would be liking to upload data into staging tables before validations are done. Since there is header information and detail information, is this mean I have to create 2 staging tables or the one table it enough to upload data from flat file?
Re: AR Implementation & Interfaces [message #239917 is a reply to message #239881] Wed, 23 May 2007 11:40 Go to previous messageGo to next message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
Yes.
Re: AR Implementation & Interfaces [message #239918 is a reply to message #239881] Wed, 23 May 2007 11:44 Go to previous messageGo to next message
Krishna_dev
Messages: 32
Registered: May 2007
Member
Do you mean yes that have I to create 2 staging tables or that I have to use the one staging table to store flat file values.
Re: AR Implementation & Interfaces [message #239944 is a reply to message #239918] Wed, 23 May 2007 13:00 Go to previous messageGo to next message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
it would your own architecture.
How you want to handle the validation?


If you are doing your own validation before lockbox performs it own? Need more detail!!!!!
Re: AR Implementation & Interfaces [message #239981 is a reply to message #239881] Wed, 23 May 2007 16:07 Go to previous messageGo to next message
Krishna_dev
Messages: 32
Registered: May 2007
Member
Yes. My validation will occur before upload to AR_PAYMENTS_INTERFACE_ALL table, so I would perform validations before lockbox performing its own validations.
Re: AR Implementation & Interfaces [message #240090 is a reply to message #239881] Thu, 24 May 2007 02:08 Go to previous message
vin_odks
Messages: 153
Registered: July 2006
Location: -
Senior Member
Maybe you could have a look here

http://www.orafaq.com/forum/t/81556/88207/

Regards

Vinod
Previous Topic: ABC Compile
Next Topic: How do we track remote users in Oracle APPS
Goto Forum:
  


Current Time: Thu Jul 04 02:09:17 CDT 2024