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.


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.


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