Contingent Worker who was Converted From Employee is not Able to Approve PO's Anymore - PO_DOCUMENT_ACTION_CHECK.authority_checks_setup ORA-01422 (Doc ID 1666695.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP5 and later
Information in this document applies to any platform.

Symptoms

In PRODUCTION
12.1 HRMS RUP5

purchase order summary screen, lov on buyer shows one employee twice

expected behavior
----------------------------------
expect the person to only show once in buyer lov


STEPS TO REPRODUCE
----------------------------------
Use responsibility : Purchasing Buyer
Navigation :purchase orders > purchase order summary
1. create new PO
2. field Buyer : press lov search for person Shygayeva, Irina
shows twice in list

ADDITIONAL INFORMATION
----------------------------------
this also result in error in PO approval process
po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_checks_setup:90:-1422ORA-01422: exact fetch returns more than requested number of rows - po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_check:20:unexpected error in authority_checks_setup - po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call


WORKAROUND
----------------------------------
NONE


Cause

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