R12: WEB ADI Integrator Layout Definition Missing SQL For ORG_ID And Operating Unit
(Doc ID 2080746.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Project Costing - Version 12.2.4 and later
Information in this document applies to any platform.
When users are in an ADI document, there is no LOV for Operating Unit or Organization Name. After looking at the layout, there are no SQL Statements against Operating Unit and ORG_ID
When attempting to enter the correct SQL Statements and Default Type there is an invalid statement message.
select PA_WEBADI_TRX_XFACE.Get_Default_OU_Name from dual
select PA_WEBADI_TRX_XFACE.Get_Default_OU_Id from dual
Please resolve the following error to continue.
1. Invalid default value select PA_WEBADI_TRX_XFACE.Get_Default_OU_Name from dual for field Operating Unit
2. Invalid default value select PA_WEBADI_TRX_XFACE.Get_Default_OU_Id from dual for field ORG_ID
These are also missing from seeded templates.
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