My Oracle Support Banner

EGO_ITEM_PUB.PROCESS_ITEM_PHASE_AND_STATUS API Is Failing With No Error Message (Doc ID 1642715.1)

Last updated on DECEMBER 10, 2024

Applies to:

Oracle Product Hub - Version 12.2.3 and later
Information in this document applies to any platform.
EGO_ITEM_PUB.has_role_on_item
EGO_ITEM_PUB.PROCESS_ITEM_PHASE_AND_STATUS APIne

Symptoms

You are using the EGO_ITEM_PUB.PROCESS_ITEM_PHASE_AND_STATUS API to update the item status.  You use the fnd_global.apps_initialize before calling the API with item author as user and it is failing for a few users randomly.

Found EGO_ITEM_PUB.has_role_on_item procedure that there is a dynamic query built based on user privileges and assigning it to a variable and its causing an exception due to insufficient length.

It is failing without error message.

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
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.