SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FDPSTP failed due to ORA-01722

594709May 21 2008 — edited May 21 2008

Hi

There is a prcodeure which has suddenly failed in the front end with the following error:

Cause: FDPSTP failed due to ORA-01722: invalid number
ORA-06512: at "APPS.AXX_PROGRAM_PACK1", line 51
ORA-06512: at line 1

The program has been running fine from the front end from when it was implemented and it has failed for the first time this way( no modifications are done after its for long time). The Program is also working for other Operating Units its failing for only one Operating Unit.
Any idea why this might be happening?

Thanks
Rahul.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 18 2008

Added on May 21 2008

2 comments

866 views