Home » Applications » Oracle Fusion Apps & E-Business Suite » FDPSTP failed due to ORA-29282: invalid file ID
FDPSTP failed due to ORA-29282: invalid file ID [message #493845] Thu, 10 February 2011 03:39 Go to next message
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
Re: FDPSTP failed due to ORA-29282: invalid file ID [message #493863 is a reply to message #493845] Thu, 10 February 2011 04:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: FDPSTP failed due to ORA-29282: invalid file ID [message #493867 is a reply to message #493863] Thu, 10 February 2011 04:55 Go to previous message
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
Previous Topic: flex field creation
Next Topic: Suppress child-request from appearing in Oracle Concurrent Requests screen
Goto Forum:
  


Current Time: Thu Mar 28 09:53:29 CDT 2024