My Oracle Support Banner

PO Import Is Failing When There Are Extra Spaces At End Of A Column (Doc ID 2871209.1)

Last updated on MAY 20, 2022

Applies to:

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

Symptoms

On: NA version, Merch - Procurement

ACTUAL BEHAVIOR
---------------

You have observed that there are few extra spaces after the column VPN in file orddetail, sample as below:-

503594,60099259,ADAPTER NHGD XX XXA 22,855190MC01,,,,,,,US,1.0000,W,6572,,41.9700,2.0000,,N,,,,,,,,,

Here extra space is after "855190MC01" which was handled through DC Tool, but not now in API.


EXPECTED BEHAVIOR
-----------------------
Extra spaces must be handled by the API.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try PO Import through New API.
2. It is failing when there are extra spaces at end of a column

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import PO.

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


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