BATCH_ORPOS_EXTRACT.KSH Batch Does Not Send New Barcode Information to ORPOS (Doc ID 2116344.1)

Last updated on MARCH 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 14.0.2 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior
---------------
BATCH_ORPOS_EXTRACT.KSH (Control Process for Foundation Data Extracts for ORPOS) Batch does not send new barcode information to Point Of Service (ORPOS).

Expected Behavior
-----------------------
Expect the batch to send the new barcode info to ORPOS. The POS_MODS table should have new barcode (ref_item) with tran_type 2.

What is Working
-----------------------
The batch sends the deleted barcode info with tran_type 22.

Steps to Reproduce
-----------------------
1. Create an item and barcode on day 1.
2. Entry goes into POS_MODS and POS_MODS is purged after nightly.
3. Create another barcode on day2 for the same item.
4. Delete the barcode created on day 1.
5. Note POS_MODS should have a new barcode(ref item) with tran_type 2 and old barcode (ref_item) with tran_type 22.
6. Run batch_orpos_extract.ksh batch.
7. Notice the new barcode info is not present on POS_MODS table.



Cause

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 hundreds of Community platforms