Error 'ORA-00904: "Lock_OWNER_ROLE":invalid identifier' and 'FRM-40505 :ORACLE error:unable to perform query' Occurs when Querying PO in Purchase Orders Form（POXPOEPO）
(Doc ID 2511455.1)
Last updated on AUGUST 06, 2020
Applies to:Oracle Purchasing - Version 12.2.6 and later
Information in this document applies to any platform.
On : 12.2.6 version, Purchase Order
When attempting to query purchase order in Purchase Orders form,
the following error occurs.
ORA-00904: "Lock_OWNER_ROLE":invalid identifier
FRM-40505 :ORACLE error:unable to perform query.
The issue can be reproduced at will with the following steps:
1. Navigate to Purchasing responsibility>Purchase Orders.
2. Try to query the PO.
3. Then get above error.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document