Error After Upgrading To R12.2.12 PLS-00302: Component 'GET_OTM_PWD' Must
(Doc ID 2977977.1)
Last updated on OCTOBER 02, 2023
Applies to:
Oracle Shipping Execution - Version 12.2.12 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.12 version, Inbound/Outbound transactions
Error after upgrading to R12.2.12:PLS-00302: Component 'GET_OTM_PWD' must
After upgrading from R12.1.3 to R12.2.12, program package WSH_OTM_OUTBOUND encountered an error: PLS-00302: Component 'GET_OTM_PWD' must
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
SQL> alter package WSH_OTM_OUTBOUND compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY WSH_OTM_OUTBOUND:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1283/2 PL/SQL: Statement ignored
1283/32 PLS-00302: component 'GET_OTM_PWD' must be declared
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |