PICK RELEASE FAILS FOR ISTORE ORDER BECAUSE OF TRAILING SPACES IN PO NUMBER
(Doc ID 1266968.1)
Last updated on FEBRUARY 26, 2019
Applies to:Oracle iStore - Version 220.127.116.11 and later
Information in this document applies to any platform.
When trying to Ship Confirm for a Sales Order generated from iStore that has a Purchase Order Number (PO Number) value the following error is received:
"Error: This action cannot be performed on all selected records."
"Error: The action can not be performed because the selected records could not be locked."
Login to iStore
Add an item to the cart
In the 'Checkout: Payment And Billing Information' page
Enter a value that includes leading, blank and/or trailing spaces for the PO Number field -
'If you have a purchase order, please enter Purchase Order Number:'
For example, enter characters -
Choose to Place Order and receive the order confirmation.
Navigate as the Order Management Super User -
After releasing the order
Query on order number , for example 57528
choose Actions -> Launch Pick Release
Use the following query for to check for trailing spaces:
SQL>select distinct a.org_id, a.order_number, a.header_id,
from oe_order_headers_all a,
where a.cust_po_number <> ltrim(rtrim(a.cust_po_number))
and a.header_id = b.header_id
and a.order_number = 57528;
ORG_ID ORDER_NUMBER HEADER_ID '.'||A.CUST_PO_NUMBER||'.'
204 57528 106146 . 765 432 .
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