SIM Table TSF_SHIP_CARTON.STATUS Discrepancy Between Application and Data Model (Doc ID 2206289.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Retail Store Inventory Management - Version 15.0 and later
Information in this document applies to any platform.

Goal

There is discrepancy with TSF_SHIP_CARTON.STATUS between what is observed in the application and in the data model.

The Oracle Retail Store Inventory Management Data Model Release 15.0 (sim-150-dm.pdf) and the database column comments show the values to be
1 - New, 2 - In Progress, 3 - Completed, 4 - Canceled.

But when one dispatches a transfer shipment, the TSF_SHIP_CARTON.STATUS becomes 4, and when one deletes a shipment it becomes 5. 
 

Solution

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