WEB ADI Integrator Layout Definition Missing SQL For ORG_ID And Operating Unit (Doc ID 2080746.1)

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.

Symptoms

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
ORG_ID:
select PA_WEBADI_TRX_XFACE.Get_Default_OU_Id from dual


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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms