My Oracle Support Banner

EBS to OTM Delivery Integrations Failing In Production. "Could Not Find Program Unit Being Called" (Doc ID 2633906.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle Shipping Execution - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Integrations & Conc. Program

When attempting to run the Shipping-Transportation Outbound Interface it does pickup the delivery but end of log shows error

Shipping-Transportation Outbound Interface (parent log shows)

Request restarted at :28-JAN-2020 11:58:12
In the method getStatus for request Id 73651543
 Status from the api FND_CONCURRENT.get_request_status : Error
73651543 : Unexcepted Error returned from Bpel Process


Shipping-Transportation outbound interface - Child log shows this:

SEVERE: java.io.FileNotFoundException: ./config/jps-config.xml (No such file or directory)
SEVERE: java.io.FileNotFoundException: ./config/jps-config.xml (No such file or directory)
SEVERE: java.io.FileNotFoundException: ./config/jps-config.xml (No such file or directory)
...
authenticated true
For more detailed information on the processing of deliveries in this batch
Please look at Bpel Instance Id :3404955
OTM Transmission Id null
ReturnStatus from BPEL process: U


BPEL instance id shows the following:
This log is filled with the 6508 and "could not find program unit being called" error many times:

First section is for: Invoked 2-way operation "WshGenLocRefData" on partner "WshGenLocRefData".
Second section is for: "{http://xmlns.oracle.com/apps/wsh/outbound/ref/WshSendLocRefDataToOtm}refDataError" has been thrown.

The errors: ORA-06508 and "could not find program unit being called" are for WSH_UTIL_VALIDATE.VALIDATE_LOCATION and WSH_OTM_INBOUND_GRP.initiate_planned_shipment

Routine WSH_UTIL_VALIDATE.VALIDATE_LOCATION, Oracle Error - -6508 ORA-06508: PL/SQL: could not find program unit being called Unexpected Error: Error in Routine WSH_OTM_INBOUND_GRP.initiate_planned_shipment, Oracle Error - -6508 ORA-06508: PL/SQL: could not find program unit being called ------------------------------------ Unexpected Error: Error in Routine WSH_OTM_INBOUND_GRP.initiate_planned_shipment, Oracle Error - -6508 ORA-06508: PL/SQL: could not find program unit being called ------------------------------------


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit Shipping-Transportation Outbound Interface
2. Job completes but it shows "Unexcepted Error returned from Bpel Process"
3. Child log and Bpel instance id show reported errors
4. Shipment is not interfaced from EBS to OTM

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are not able to ship orders.

Changes

 

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
Changes
Cause
Solution


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