Tuesday, October 4, 2011

Create Budget Revisions - Unable to Open form ORA-01403: no data found, FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Create Budget Revisions - Unable to Open form ORA-01403: no data found, FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502.


On 12.0.6 in Production:
When trying to create a budget revision,
the following error occurs:

ERROR
-----------------------
ORA-01403 : no data found.
FRM-40735 : when button pressed trigger raised unhandled exception ORA-06502


Symptoms:
The issue can be reproduced at will with the following steps:
1. PSB responsibility--Budget Revisions--Define.
2. Query the existing budget revisions--Get the error.



Solution:

1. Please download and apply Patch 8635281:R12.PSB.A on a test instance on which the issue can be reproduced.
2. This patch provides the latest roll up patch for PSB.
3. After patch application, bounce the apache and applications and retest the issue.
There is a number of issues fixed on the latest PSB roll up patch provided by Patch 8635281.
Users need to apply the latest roll up patch to get the latest form version. Applying the latest roll up patch for PSB resolved the issue for user.

This is also mentioned in the following bug for the roll up patch:
Bug 8635281 PUBLIC SECTOR BUDGETING ROLLUP PATCH - JUL 2009.

References:

Bug 8635281 PUBLIC SECTOR BUDGETING ROLLUP PATCH - JUL 2009.

Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: