My Oracle Support Banner

In Template Form (INVIDTMP), Error FRM-40735: PICKING_RULE_ID_AQ, ORA-1403 on Picking Rule ID (Doc ID 1990095.1)

Last updated on JUNE 04, 2021

Applies to:

Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

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.

 

ERROR:

FRM-40735: PICKING_RULE_ID_AQ trigger raised unhandled exception ORA-01403



STEPS:
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

Changes

 The issue presented after upgrading from R11i to R12.

Cause

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
Symptoms
Changes
Cause
Solution
References


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