EEX 9.2: Error Message (10502, 329) Incorrectly Being Triggered at Expenses Approver Assignment Page (Doc ID 2792586.1)

Last updated on JANUARY 03, 2023

Applies to:

Symptoms

Users are getting Error Message (10502, 329) when trying to add a particular User ID into the Approver Assignments set up page (EX_APPRVR_ASGN).

This is incorrect, because for the identified User ID, no other Approver Assignment has been defined under the same GL Business Unit and Approver Category combination.

REPLICATION STEPS:

    1.- At the TableSet Control configuration, ensure the following:
              a) Set Control Value US005 has Record Group EX_04 (Approval Controls) pointing to Set ID US005
              b) Set Control Value US006 has Record Group EX_04 (Approval Controls) pointing to Set ID US006
    2.- Create new Approver Types as follows:
              a) Set ID = US005 , Approver Type = EXAPPROVER , Description = Expense Manager , Approver Category = APP, and Routing ChartField = Department
              b) Set ID = US006 , Approver Type = EXAPPROVER , Description = Expense Manager , Approver Category = APP, and Routing ChartField = Department
              c) Set ID = US006 , Approver Type = PROJSUPLE , Description = Project Supplemental , Approver Category = PRS, and Routing ChartField = Project
    3.- Proceed to define new Approver Profiles as follows:
              a) Set ID = US005 , Approver Profile = EXAPPROVER , Effective Date = 01/01/1900 , Status = Active , Approver Type = EXAPPROVER , and Transaction Type = Expense Report
              b) Set ID = US005 , Approver Profile = VPAPPROVER , Effective Date = 01/01/1900 , Status = Active , Approver Type = EXAPPROVER , and Transaction Type = Expense Report
              c) Set ID = US006 , Approver Profile = EXAPPROVER , Effective Date = 01/01/1900 , Status = Active , Approver Type = EXAPPROVER , and Transaction Type = Expense Report
              d) Set ID = US006 , Approver Profile = VPAPPROVER , Effective Date = 01/01/1900 , Status = Active , Approver Type = PROJSUPLE , and Transaction Type = Expense Report
    4.- Proceed to add the following Approver Assignments:
              a) GL Business Unit = US006 , Approver Profile = EXAPPROVER , User ID = MGR1 , Department From = 10000 , and Department To = 42000
              b) GL Business Unit = US006 , Approver Profile = VPAPPROVER , User ID = MGR1 , Department From = 10000 , and Department To = 42000
    5.- At this stage, open the Approver Assignment set up for GL Business Unit US006, and Approver Profile EXAPPROVER, and add a new for User ID = VP1 , Department From = 10000 , and Department To = 42000
    6.- The system throws Error Message (10502,329)

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

ERROR MESSAGE:

    " User XXXXXXXX is already assigned to a profile with approver category XXX. (10502, 329)
      A user may not be assigned to more than one profile with the same approver type category under the same business unit. "

The User is unable to perform any changes, and save them, into the Approver Assignment set up page (EX_APPRVR_ASGN), which delays the implementation of a new User to have the access to review, and act on submitted Expense transactions, delaying potential approvals, and reimbursements.

The Approver Assignment set up page should allow the User to successfully save the configuration needed.

Changes

Cause

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