Interface Trip Stop fails with ORA-06508: PL/SQL: Could Not Find Program Unit Being Called In Package ASO_ORDER_FEEDBACK_PUB Procedure UPDATE_NOTICE (Doc ID 2630551.1)

Last updated on JUNE 28, 2023

Applies to:

Symptoms

On : 12.2.4 version,

Interface Trip Stop is completing with warning due to message at time of order entry and booking
LINE_PROCESSING_MESSAGES SHOW

ORA-06508: PL/SQL: could not find program unit being called in Package ASO_ORDER_FEEDBACK_PUB Procedure UPDATE_NOTICE

Customer states all was working fine until today
When they noticed stuck pending shipping transactions for 9 orgs


Customer states they are applying patches - Specifically customer is running ONLINE PATCH CONCURRENT PROGRAM to perform upgrade from rel 12.2.4 to 12.2.8. This process has been running since 1/10/2020 but customers DBA does not know when it will complete
Customer does have customizations as well -

Turned off customizations and re ran ITS but this did not resolve
Spoke with DBA and cannot stop the concurrent program

 The issue is only in Production as same data does not exist in test


ERROR
-----------------------
ORA-06508: PL/SQL: could not find program unit being called in Package ASO_ORDER_FEEDBACK_PUB Procedure UPDATE_NOTICE


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1.Responsibility : Oracle Order Management
2.Navigate to Shipping
3.Interfaces
4.Run

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.