PN Lease Approval Workflow Missing Approver Found Item Type ORA-1403 (Doc ID 1993371.1)

Last updated on NOVEMBER 08, 2022

Applies to:

Symptoms

When attempting to load a PN workflow, the following error occurs:

WFLDDITR_REF NAME=SELECT_APPROVER ITEMTYPE=PNAPPRWF OBJECT=ACTIVITY
1116: Could not load item type referenced by lookup type 'APPROVER FOUND'.
210: Oracle Error: ORA-01403: no data found
. SQL text: SELECT itt.name FROM wf_item_types itt, wf_lookup_types lut WHERE lut.lookup_type = :name AND itt.name = lut.item_type


WFLDDITR_REF NAME=VALIDATE_LEASE_REQUEST ITEMTYPE=PNAPPRWF OBJECT=ACTIVITY
1116: Could not load item type referenced by lookup type 'PN_VALIDATE_REQUEST'.
210: Oracle Error: ORA-01403: no data found
. SQL text: SELECT itt.name FROM wf_item_types itt, wf_lookup_types lut WHERE lut.lookup_type = :name AND itt.name = lut.item_type

Cause

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