My Oracle Support Banner

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 11.5.10.1 and later
Information in this document applies to any platform.

Symptoms

11.5.10

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."


Steps:
Login to iStore
Add an item to the cart
Choose Checkout
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 -
765 432

Choose to Place Order and receive the order confirmation.


Navigate as the Order Management Super User -
After releasing the order
Shipping ->Transactions
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,
'.'||a.cust_po_number||'.'
from oe_order_headers_all a,
oe_order_lines_all b
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 .

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
References


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