ORA-04062

 Shipping Forms Error: ORA-04062: Signature of package APPS.WSH_DELIVERY_DETAILS_INV [ID 873988.1]

Applies to:

Oracle Shipping Execution - Version: 12.1 and later   [Release: 12.0 and later ]
Information in this document applies to any platform.
FORM:WSHFSTRX.FMB - Shipping Transactions Form
Form:WSHQSSUI.FMB - Quick Ship

Symptoms

On 12.1 in Production:

When attempting to query up by order number in the Shipping Transaction form, the following error occurs:
APP-WSH-231210: An Unexpected Error Occured for Line 388866. The Error is ORA-04062: signature of package "APPS.WSH_DELIVERY_DETAILS_INV" has been changed'


Note: The same error occurs in the Quick Ship Form (WSHQSSUI.FMB)


-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Log on system as OM Super User.
2. Navigate: Shipping -> Transactions
3. Query by order number

Cause

This is explained in the following bug:
Bug 8294645 Abstract: In Shipping Transactions Form, Querying Sales Order gives 'ORA-04062:
Signature of package "APPS.WSH_DELIVERY_DETAILS_INV" has been changed' error.

Solution

-- To implement the solution, please execute the following steps::
1. Download and review the readme and pre-requisites for  Patch.8294645:R12.WSH.B

2. Ensure that you have taken a backup of your system before applying the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:

WSHDDICS.pls 120.4.12010000.1
WSHDDICB.pls 120.10.12010000.1
WSHSTREF.fmb 120.113.12010000.8
WSHFSTRX.fmb 120.61.12010000.3  -- Shipping Transactions Form
WSHQSSUI.fmb 120.20.12010000.1 -- Quick Ship Form

You can use the commands like the following:
strings -a $WSH_TOP/filename |grep '$Header'

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.






No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...