OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » FDPSTP failed due to ORA-29282: invalid file ID

Home » Applications » Oracle Fusion Apps & E-Business Suite » FDPSTP failed due to ORA-29282: invalid file ID

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

FDPSTP failed due to ORA-29282: invalid file ID [message #493845]

Thu, 10 February 2011 03:39

cylin
Messages: 5
Registered: October 2010

Junior Member

hi

am getting the following error when i run the concurrent program

+---------------------------------------------------------------------------+
Enterprise Asset Management: Version : 11.5.0 - Development

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

NAPESCO_CREATE_JOB module: NAPESCO Create Work Order
+---------------------------------------------------------------------------+

Current system time is 10-FEB-2011 11:44:37

+---------------------------------------------------------------------------+

**Starts**10-FEB-2011 11:44:38
ORACLE error 29282 in FDPSTP

Cause: FDPSTP failed due to ORA-29282: invalid file ID
ORA-06512: at "SYS.UTL_FILE", line 774
ORA-06512: at "APPS.EAM_ERROR_MESSAGE_PVT", line 1987
ORA-06512: at "APPS.EAM_ERROR_MESSAGE_PVT", line 1197
ORA-065
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

+---------------------------------------------------------------------------+
Executing request completion options...

Finished executing request completion options.

+---------------------------------------------------------------------------+
Exceptions posted by this request:
Concurrent Request for "NAPESCO Create Work Order" has completed with error.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 10-FEB-2011 11:44:42

+---------------------------------------------------------------------------+

kindly guide

Report message to a moderator

Re: FDPSTP failed due to ORA-29282: invalid file ID [message #493863 is a reply to message #493845]

Thu, 10 February 2011 04:48

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-29282: invalid file ID
 *Cause:  A file ID handle was specified for which no corresponding
          open file exists.
 *Action: Verify that the file ID handle is a value returned from a
          call to UTL_FILE.FOPEN.

Regards
Michel

Report message to a moderator

Re: FDPSTP failed due to ORA-29282: invalid file ID [message #493867 is a reply to message #493863]

Thu, 10 February 2011 04:55

cylin
Messages: 5
Registered: October 2010

Junior Member

hi

i just found out ever since i added my peice of code to the already wrking fine concurrent pgm this error is showing

so i figure the prob is with my peice of code which i added

i require a sequence number generation
ie YYYY-0001 format till 9999

say a job is registered in the year 2011 on feb 2 the sequence wud be 2011 -0001

on feb 3 for another job it wud be 2011-0002
well this wht i tried
/*NEWLY ADDED ON 8TH FEB FOR SEQ NUM*/
Begin
select to_char (sysdate , 'RRRR')||'-0001' into V_Invoice_no from dual ;
End ;

INSERT INTO WIP_DISCRETE_JOBS
(ATTRIBUTE14 )
VALUES
(V_Invoice_no );

but will it increment from 0001 to 0002
kindly guide me
thanking in advance

Report message to a moderator

Previous Topic:	flex field creation
Next Topic:	Suppress child-request from appearing in Oracle Concurrent Requests screen

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 16:11:04 CST 2024