My Oracle Support Banner

Issue With TRAN_DATA_IMPORT_SQL Package (Doc ID 2996765.1)

Last updated on JANUARY 10, 2024

Applies to:

Oracle Retail Merchandising System - Version 16.0.3 to 16.0.3 [Release 16.0]
Information in this document applies to any platform.


Issue with TRAN_DATA_IMPORT_SQL package
POPULATE_GTT function in TRAN_DATA_IMPORT_SQL package is having a bug which picks up already processed records for processing and incorrectly updates their status in case if their is a validation failure.


1) stage_ext_tran_data has two records for same item-loc one with status P, one with status N.

2) Record with status N has a different dept class subclass so that it fails the validation.

3) Execute trandata process.

4) Notice the status updated to E for previously processed record as well.

Issue is with POPULATE_GTT function inside TRAN_DATA_IMPORT_SQL package as there is no filter to pick up records with status N only, similar filter exists in INSERT_TRAN_DATA function which inserts data for new records only.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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