RMSSUB_XITEM Package Throws a "DUP_PROF_HEAD" Error
Last updated on NOVEMBER 14, 2016
Applies to:Oracle Retail Merchandising System - Version 14.0.2 to 14.0.4 [Release 14.0]
Information in this document applies to any platform.
While creating items using RMSSUB_XITEM, item supplier country creation function (RMSSUB_XITEM_SQL.CREATE_ISC) is calculating the default expenses using expense profiles (EXP_PROF_HEAD and EXP_PROF_DETAIL). Setting up expense profiles is an optional process. If we set up expense profiles, then the package throws a "DUP_PROF_HEAD" error; otherwise it throws a "NO_PROF_HEAD" error.
Steps to Reproduce:
- Run item_creation_stub.sql.
- Verify message in the following by running the following SQL statement:
select * from rtk_errors where rtk_text like '%This expense profile header does not exist%';
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