My Oracle Support Banner

Group Numbers Being Split In Inventory History Extract Files (Doc ID 2473531.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 9.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 9.0.0 version

ACTUAL BEHAVIOR
---------------
When review logs for Generate Inventory History Extract job, transactions for group number 918645 appear in two output files.

During inventory history creation - the same group number is being split up into two separate inventory history files.



EXPECTED BEHAVIOR
-----------------------
Want all records for one group number to appear in the same file.
Expect there should be a validation to have all transactions with the same group number to be on the same inventory history file.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Schedule job : Generate Inventory History Extract
  Parameters
  schedule type: Interval, every 3 minutes
  Include activity id list: 1, 3, 19, 22, 23, 24, 25, 39, 40, 41, 49, 50, 53, 64, 65, 72, 73
  Username: Interface
  Number of Days: 100000

  other parameters are null

2. See group number 918645 in two files.

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