OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Auto Invoice Issue

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

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

Attachment: JP_SALES99_CTL.ctl
(Size: 0.35KB, Downloaded 1245 times)

Report message to a moderator

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

Report message to a moderator

Re: Auto Invoice Issue [message #209944 is a reply to message #209934]

Mon, 18 December 2006 10:34

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

Report message to a moderator

Re: Auto Invoice Issue [message #210002 is a reply to message #209931]

Mon, 18 December 2006 21:39

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

Report message to a moderator

Previous Topic:	Oracle HRMS EBIS Consultants
Next Topic:	Understanding of GL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 17:38:35 CDT 2024