SIM 12.x: Authorization Number Is Mandatory in Return to Vendor Processed Through Handheld, While in SIM PC It Is Not

(Doc ID 2139681.1)

Last updated on JUNE 27, 2016

Applies to:

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


The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.

While creating a return to vendor (RTV), Authorization Code is required or not depending on column ST_RETURN_NUM_IND of PA_SPR table.
After changing this value to 'N' for all suppliers, the system is not asking for the authorization code for any supplier when creating the RTV through the SIM desktop application (SIM PC).
However, the SIM handheld application (SIM HH) always asks for an authorization code, regardless of the value specified in the ST_RETURN_NUM_IND column.

Steps to Reproduce:

1. Create RTV in SIM HH for supplier that does not require an authorization number (has value PA_SPR.ST_RETURN_NUM_IND = 'N').
2. Observe that SIM HH still requests the authorization number.


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