Home » Applications » Oracle Fusion Apps & E-Business Suite » Auto Invoice Issue
Auto Invoice Issue [message #209931] Mon, 18 December 2006 09:51 Go to next message
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 Go to previous messageGo to next message
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

Re: Auto Invoice Issue [message #209944 is a reply to message #209934] Mon, 18 December 2006 10:34 Go to previous messageGo to next message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
Hi,

I can see you are using local file pointer.
are you using local windows Apps or UNIX box?

Regards
Prashant Pathak
Re: Auto Invoice Issue [message #210002 is a reply to message #209931] Mon, 18 December 2006 21:39 Go to previous message
lakshmi surya ram
Messages: 188
Registered: June 2006
Location: HYDERABAD
Senior Member

hi ,
Iam running the running the test data in apps VISION Insatance.

thanks,
Surya
Previous Topic: Oracle HRMS EBIS Consultants
Next Topic: Understanding of GL
Goto Forum:
  


Current Time: Fri Dec 09 17:54:38 CST 2016

Total time taken to generate the page: 0.16001 seconds