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

Last updated on OCTOBER 06, 2016

Applies to:

Oracle Property Manager - Version 11.5.10.1 and later
Information in this document applies to any platform.

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

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