My Oracle Support Banner

Customer Order Fails With ORA-22160 Error (Doc ID 2017884.1)

Last updated on FEBRUARY 04, 2021

Applies to:

Oracle Retail Merchandising System - Version 14.0.2 to 14.0.3 [Release 14.0]
Information in this document applies to any platform.

Symptoms

Creating a Commerce Anywhere order fails with the following error

Instructions to Re-create

  1. For the CORESVC_FULFILORD web service Build Customer Order Request with all mandatory attributes for warehouse (WH) to Customer with Source Loc Type : WH.
  2. Fulfill Location is a virtual store and location type is 'V' on the message.
  3. Call the API STGSVC_FULFILORD.POP_CREATE_TABLES and CORESVC_FULFILORD.CREATE_FULFILLMENT.
  4. Notice the customer order request is not created and calling the web service failed with the mentioned error.

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


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