WEB ADI Integrator Layout Definition Missing SQL For ORG_ID And Operating Unit
Last updated on MARCH 08, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms