My Oracle Support Banner

Unable to Create A Non Sellable Pack item with MFG_REC_RETAIL=0 (Doc ID 2556079.1)

Last updated on OCTOBER 10, 2019

Applies to:

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


Unable to integrate a non sell-able pack Item with MFG_REC_RETAIL =0.

Steps to reproduce :

1.Ensure that RPM_IND = 'N' in system_options.
2.Create a item with below setup using induction.
Item_level = 1
Pack_ind = Y
Sellable_ind = N
MFG_REC_RETAIL = 0 (or any not null value)

3.Verify that item fail with FIELD_NOT_ALLOWED error on MFG_REC_RETAIL column. Try updating MFG_REC_RETAIL column to NULL, then the record fails with REQUIRED_FIELD_IS_NULL error because RPM_IND is N.


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

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

In this Document

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