Home » Applications » Oracle Fusion Apps & E-Business Suite » Auto Invoice Issue
Auto Invoice Issue [message #209931] |
Mon, 18 December 2006 09:51 |
lakshmi surya ram
Messages: 188 Registered: June 2006 Location: HYDERABAD
|
Senior Member |
|
|
Hi Folks,
Iam facing problem while running the auto Invoice program.
I dumped a row into interface tables
RA_INTERFACE_LINES_ALL
RA_INTERFACE_DISTRIBUTIONS_ALL
RA_INTERFACE_SALESCREDITS_ALL
But while Iam running the Auto Invoice Program,the process is never ending like request is still running
here Iam attching my ctl and dat files..
Pls check it and suggest me the best ASAP.
If any dat file along with the mandatory columns is highly appreciable
thanks,
Surya
|
|
|
Re: Auto Invoice Issue [message #209934 is a reply to message #209931] |
Mon, 18 December 2006 09:54 |
lakshmi surya ram
Messages: 188 Registered: June 2006 Location: HYDERABAD
|
Senior Member |
|
|
hi ,
Iam not able to upload the file.
here Iam pasting the same.
LOAD DATA
INFILE 'C:\Documents and Settings\apps\Desktop\new_auto\JP_LINES99.dat'
BADFILE 'C_CNV_HDR_TEMP.bad'
APPEND
INTO TABLE AR.RA_INTERFACE_LINES_ALL
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
TRX_NUMBER,
BATCH_SOURCE_NAME,
TRX_DATE,
CURRENCY_CODE,
GL_DATE,
INTERFACE_LINE_CONTEXT,
INTERFACE_LINE_ATTRIBUTE1,
INTERFACE_LINE_ATTRIBUTE2,
INTERFACE_LINE_ATTRIBUTE3,
INTERFACE_LINE_ATTRIBUTE4,
INTERFACE_LINE_ATTRIBUTE5,
INTERFACE_LINE_ATTRIBUTE6,
INTERFACE_LINE_ATTRIBUTE7,
INTERFACE_LINE_ATTRIBUTE8,
INTERFACE_LINE_ATTRIBUTE9,
INTERFACE_LINE_ATTRIBUTE10,
INTERFACE_LINE_ATTRIBUTE11,
INTERFACE_LINE_ATTRIBUTE12,
INTERFACE_LINE_ATTRIBUTE13,
INTERFACE_LINE_ATTRIBUTE14,
INTERFACE_LINE_ATTRIBUTE15,
ORIG_SYSTEM_SHIP_CUSTOMER_ID,
ORIG_SYSTEM_BILL_CUSTOMER_ID,
TERM_ID,
PRIMARY_SALESREP_ID,
PRINTING_OPTION,
TAX_EXEMPT_FLAG,
INTERNAL_NOTES,
COMMENTS,
PURCHASE_ORDER,
ORIG_SYSTEM_BILL_ADDRESS_ID,
ORIG_SYSTEM_SOLD_CUSTOMER_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
ORG_ID,
SET_OF_BOOKS_ID,
CONVERSION_TYPE,
LINE_NUMBER,
LINE_TYPE,
DESCRIPTION,
MEMO_LINE_ID,
UOM_CODE,
QUANTITY_ORDERED,
UNIT_SELLING_PRICE,
AMOUNT,
INVOICING_RULE_NAME,
INVOICING_RULE_ID,
ACCOUNTING_RULE_NAME,
ACCOUNTING_RULE_ID,
ACCOUNTING_RULE_DURATION,
RULE_START_DATE
)
9999,SRLEGACY,24-OCT-2005,USD,01-APR-1996,VISIONBUILD,1234567891,1,,,,,,,,,,,,,,,4545,9,1818,,,,,,4273,216,93,18-DEC-2006,2044,18-DEC -2006,204,126,Corporate,1,LINE,TEST DATA,,Ea,,,14499,,,,,,,
distributions:
LOAD DATA
INFILE 'C:\Documents and Settings\apps\Desktop\new_auto\JP_DIST99.dat'
BADFILE 'C_CNV_HDR_TEMP.bad'
APPEND
INTO TABLE AR.RA_INTERFACE_DISTRIBUTIONS_ALL
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
ACCOUNT_CLASS,
CODE_COMBINATION_ID,
PERCENT,
AMOUNT,
ORG_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE
)
REC,15515,100,14499,204,93,18-DEC-2006,2044,18-DEC-2006
salescredits:
LOAD DATA
INFILE 'C:\Documents and Settings\apps\Desktop\new_auto\JP_SALES99.dat'
BADFILE 'C_CNV_HDR_TEMP.bad'
APPEND
INTO TABLE AR.RA_INTERFACE_SALESCREDITS_ALL
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
INTERFACE_LINE_ID,
SALESREP_ID,
ORG_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE
)
999234,1359,204,93,18-DEC-2006,2044,18-DEC-2006
thanks,
Surya
|
|
|
|
|
Goto Forum:
Current Time: Tue Dec 24 11:56:17 CST 2024
|