My Oracle Support Banner

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:

PeopleSoft Enterprise SCM Mobile Inventory Management - Version 9.2 and later
Information in this document applies to any platform.


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




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

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