Home » Applications » Oracle Fusion Apps & E-Business Suite » Load data to interface table urgent
Load data to interface table urgent [message #192621] Wed, 13 September 2006 00:42 Go to next message
koushick
Messages: 2
Registered: September 2006
Location: india
Junior Member

Dear all
i have a staging table.its format is
INV_TYPE VARCHAR2 (25),
INV_SRL_NO VARCHAR2 (40),
INV_NUM VARCHAR2 (50),
INV_DATE DATE,
SUPPLIER_CODE VARCHAR2 (15),
SUPPLIER_SITE_CODE VARCHAR2 (15),
INV_AMOUNT NUMBER,
DESCRIPTION VARCHAR2 (150),
GL_DATE DATE,
OLD_ACCT VARCHAR2 (30),
MESSAGE VARCHAR2 (250),
STATUS VARCHAR2 (10)
i have to take all datas from this table and put it in AP Interface table.Datas are present till OLD_ACCT.
Plz let me know the procedure/plsql code for doing this.

Regards,
Koushick
Re: Load data to interface table urgent [message #192723 is a reply to message #192621] Wed, 13 September 2006 06:16 Go to previous message
agostino_neto
Messages: 180
Registered: July 2005
Senior Member
You need to read trm and open interface manuals to know to which fields corresponds invoice date, invoice number and so on.
Then you can use a insert as select or use a cursor for your staging table and use a insert values
Previous Topic: Fndload
Next Topic: How to relocate button in standard OA page
Goto Forum:
  


Current Time: Fri Dec 02 18:33:56 CST 2016

Total time taken to generate the page: 0.15098 seconds