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
http://www.free-online-exams.com
Problem: ORA-04063: package body "APPS.PSB_GL_INTERFACE_PVT" has errors
On 12.0.6 in Production:
When attempting to Approve the Budget revisions workflow then system showing
the following error occurs:
ERROR
-----------------------
To SYSADMIN
Sent 04-Nov-2009 09:14:55
ID 18070
An Error occurred in the following Workflow.
Item Type = PSBBR
Item Key = 235
User Key =1001
Error Name = -4063
Error Message = ORA-04063: package body "APPS.PSB_GL_INTERFACE_PVT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.PSB_GL_INTERFACE_PVT"
Error Stack =
PSBBR.Post_Revisions_To_GL()
Wf_Engine_Util.Function_Call(PSB_SUBMIT_REVISION_PVT.POST_REVISIONS_TO_GL, PSBBR, 235, 210932, RUN)
Activity Id = 210932
Activity Label = SUBMIT_REVISION:POST_REVISIONS_TO_GL-1
Result Code = #EXCEPTION
Notification Id =
Assigned User =
Symptoms:
The issue can be reproduced at will with the following steps:
1. Create a budget revision and approve the budget revision
Solution:
To implement the solution, please execute the following steps:
1) Please download and review the readme for Patch.7639620.
2) Please apply Patch.7639620 in a test environment.
3) Please confirm the following file versions:
PSBVOGLB.pls 120.24.12000000.13
psbotgl.odf ----------120.0.12000000.5
4) Please retest the issue.
No comments:
Post a Comment