Why Is The User Id Not Populating Correctly During Order Import?
(Doc ID 2476427.1)
Last updated on SEPTEMBER 20, 2021
Applies to:Oracle Order Management - Version 12.2.5 and later
Information in this document applies to any platform.
Working with a sales order interface and have used OE_ORDER_PUB API which is called by a concurrent program.
When running the program, the following error occurs:
"ORA-01403: no data found in Package OE_ORDER_WF_UTIL Procedure Create_HdrWorkItem
message index is: 1
message is: User-Defined Exception in Package OE_ORDER_WF_UTIL Procedure Start_HdrProcess"
It says the user id is not found in the procedure OE_ORDER_WF_UTIL.Create_HdrWorkItem.
The user id is derived by using FND_GLOBAL.user_id and checking for that user id in backend table(FND_USER) there is no data.
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