My Oracle Support Banner

Difference Of FND_LOOKUP_VALUES Between EBS R12.1.1 And EBS R12.2.9 (Doc ID 2723453.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Application Object Library - Version 12.2.9 and later
Information in this document applies to any platform.

Goal

There are differences of FND_LOOKUP_VALUES table for CP_PHASE_CODE lookup between EBS R12.1.1 and EBS R12.2.9.

 

Details from EBS R12.2.9:

sql>
select view_application_id, flv.*
from apps.fnd_lookup_values flv
where flv.language='US'
and flv.start_date_active is not null
and flv.enabled_flag='Y'
and flv.lookup_type='CP_PHASE_CODE';



VIEW_APPLICATION_ID LOOKUP_TYPE    LANGUAGE LOOKUP_CODE MEANING    DESCRIPTION ENABLED_FLAG
3                                CP_PHASE_CODE                US           C               Complete           Complete Y            
3                                CP_PHASE_CODE                US           I               Inactive           Inactive        Y            
3                                CP_PHASE_CODE                US           P               Pending           Pending        Y            
3                                CP_PHASE_CODE                US           R               Running           Running        Y            
3                                CP_PHASE_CODE                US           U               Unknown           Unknown Y            
283                                CP_PHASE_CODE                US           C               Completed           Completed Y            
283                                CP_PHASE_CODE                US           I               Inactive           Inactive        Y            
283                                CP_PHASE_CODE                US           P               Pending           Pending        Y            
283                                CP_PHASE_CODE                US           R               Running           Running        Y



Why there are lines of Application_ID (=3) in Version R12.2.9?

Could they be disabled?
 

Solution

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
Goal
Solution
References


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