My Oracle Support Banner

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.

SQL Statements:
Operating Unit:
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

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