In Template Form (INVIDTMP), Error FRM-40735: PICKING_RULE_ID_AQ, ORA-1403 on Picking Rule ID
Last updated on MARCH 08, 2017
Applies to:Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.
On release 12.1.3:
When reviewing the template in Item Template form (INVIDTMP), the following error gets raised.
Oracle Product Hub (EGO) is not installed.
FRM-40735: PICKING_RULE_ID_AQ trigger raised unhandled exception ORA-01403
The issue can be replicated per the following steps:
1. Go to Inventory: (N) Setup : Item : Item Templates
2. Query the related template
3. Query Picking Rule attribute
4. Error presents
The issue presented after upgrading from R11i to R12.
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