My Oracle Support Banner

STAGE: DCA - NIL_DETAIL_R Is Not Processing The Full Data Set Provided In The (Doc ID 2877679.1)

Last updated on JANUARY 10, 2024

Applies to:

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


DCA - NIL_DETAIL_R is not processing the full data set provided in the

When processing the ITEM_RANGING entity, the number of records provided in the NIL_DETAIL_R.dat file is not being processed into the ITEM_LOC table as expected.

It seems to be failing to load records beyond approx 200k lines. There is no obvious difference between the lines from those that are imported and those that are not.

The issue can be reproduced at will with the following steps:

1. Place file on SFTP
2. Run ITEM_RANGING Entity
3. The second half of the lines in the file are not loaded


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.