|
|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。如果您注册时有任何问题请联系客服QQ: 83569622 。
您需要 登录 才可以下载或查看,没有帐号?注册
x
R12.1: Shipping Transactions Form Errors: APP-WSH-231210, ORA-04062 [ID 1315451.1]
Applies to:
Oracle Shipping Execution - Version: 12.1.1 and later [Release: 12.1 and later ]
Information in this document applies to any platform.
Form:WSHFSTRX.FMB - Shipping Transactions Form
Symptoms
While trying to query an order in the Shipping Transaction Form, the below error is spawned, then user is unable to enter any information into the form .
APP-WSH-231210: An Unexpected error Occured for line XXXX.
ORA-04062: signature of package "APPS.WSH_DELIVERY_DETAILS_INV" has been changed
This issue is discussed in Note 873988.1 which suggests the patch 8294645. However, the instance where the error occurs has file versions that are newer versions than what is contained in the patch 8294645
verified the following files are newer versions of the files from Patch 8294645
WSHDDICB.pls 120.10.12010000.1
WSHSTREF.fmb 120.93.12000000.24
WSHFSTRX.fmb 120.61.12010000.11
WSHQSSUI.fmb 120.20.12010000.6
Cause
During the Upgrade or patch installation there is a possibility the package WSH_DELIVERY_DETAILS_INV was not compiled correctly, thus throwing the mentioned error.
Solution
Please have your DBA complete the following:
1) drop package apps.WSH_DELIVERY_DETAILS_INV;
$WSH_TOP/patch/115/sql/@WSHDDICS.pls;
$WSH_TOP/patch/115/sql/@WSHDDICB.pls;
2) Regenerate Forms.
3) Once the above is completed, retest querying an order in the Shipping Transaction Form to see if the error messages are gone.
References
BUG:11690745 - APP-WSH-231210 SIGNATURE OF PACKAGE APPS.WSH_DELIVERY_DETAILS_INV [ID 873988.1]
NOTE:873988.1 - Shipping Forms Error: ORA-04062: Signature of package APPS.WSH_DELIVERY_DETAILS_INV
该贴已经同步到 纵横四海的微博 |
|