My Oracle Support Banner

XOrder Ignores USER_ID Field (Doc ID 2832851.1)

Last updated on JANUARY 10, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.


When integrating a PO (Purchase Order) via XOrder into Retail Merchandising System (RMS) , the field USER_ID in XOrderDesc is being ignored.
This should appear in the field "orig_approval_id".

Steps to reproduce:

1. Integrate a PO via XOrder.
2. Fill the "user_id" field in XOrderDesc with the user data.
3. Check the database:
select orig_approval_id from ordhead  where order_no = 'order_no';
4.  Notice that is populated with generic user.
5. ORIG_APPROVAL_ID should have the user_id value taken from  XOrderDesc. Instead is populated with a generic user.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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