ERROR
-----------------------
ORA-06508: PL/SQL: could not find program unit being called in Package
OE_Order_PVT Procedure Lines
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to Create a sales Order
3.Click on the 'Line Items' tab
-- Error displayed--
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create orders for customers.
Changes
New migartion and schema was refrehsed on week end for go live
Cause
This issue is caused by some packages not being current.
Solution
1. Have your dba recompile/rebuild the ONT schema. This can be completed with the compile_schema utility as follows:
exec dbms_utility.compile_schema('ONT)
OR
2. If specific object is invalid, such as the following seen in output of Diagnostics: Apps Check,
OE_MASS_CHANGE_PVT OEXVMSCB.pls 120.8.12010000.5 BODY INVALID
do in this sequence:
alter package oe_mass_change_pvt compile specification;
alter package oe_mass_change_pvt compile body;
3.. Retest creating and booking orders.
No comments:
Post a Comment