My Oracle Support Banner

RMSSUB_XITEM Package Throws a "DUP_PROF_HEAD" Error (Doc ID 2049267.1)

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:

  1. Run item_creation_stub.sql.
  2. 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%';
BL NO_PROF_HEAD 1 This expense profile header does not exist. RETEK Y





To view full details, 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 a vibrant support community of peers and Oracle experts.