The Delivered_To Field Saves Blank Space at the Beginning of Data for an Existing Badge in the PS_MIN_ATTN_TO table. (Doc ID 2902057.1)

Last updated on OCTOBER 11, 2022

Applies to:

Symptoms

The Delivered_To field saves blank space at the beginning of data for an existing badge in the PS_MIN_ATTN_TO table.

The issue can be reproduced at will with the following steps:
              1. Insert data manually to Record PS_MIN_ATTN_TO. (Note down the Badge ID)
              2. Navigate : Mobile Inventory > Delivery (Tile) 
                            Select an item and click Add to Delivery
                            Click View Delivery
                            Click item description (Note down the Receipt details)
                            Enter Delivered To as the Badge ID inserted into the PS_MIN_ATTN_TO table
              Save
              3. Run the Query
              select a.delivered_to from ps_recv_ln_distrib a where business_unit='xxxx' and receiver_id='xxxxx';
              The Delivered_To value has a blank space in front of the value. 

Changes

Cause

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