Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Perform Shipping Transaction Import ESS Job not populating Request Id in WSH_NEW_DEL_INTERFACE table

edited Mar 27, 2024 12:56PM in Reporting & Analytics for Fusion Service 1 comment

Hi All,

We have below requirement,

  1. Create and confirm shipment through REST API
  2. Call "Perform Shipping Transaction Import" ESS Job through SOAP. Once done respective order will be shipped in the Oracle Order Management.
  3. If the "Perform Shipping Transaction Import" ESS job fails and the process shows an error, then a custom BIP report needs to be invoked to check the errored records from interface tables based on ESS job Process Id/Request Id. But here, "Perform Shipping Transaction Import" ESS job not populating Process Id/Request Id to the WSH tables WSH_DEL_DETAILS_INTERFACE and WSH_NEW_DEL_INTERFACE. Kindly help me here to get the ESS job process id/request id. Thanks in advance.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!