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

Last updated on JANUARY 31, 2023

Applies to:

Symptoms

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.

  All other parameters are null.

2. See group number 918645 split into two files.

Cause

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