My Oracle Support Banner

POR_ITEM_TYPE Lookup Meaning Values Changes In Upgraded Instance from 12.1.3 To 12.2.8 (Doc ID 2724343.1)

Last updated on AUGUST 31, 2022

Applies to:

Oracle iProcurement - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Oracle application has been upgraded from 12.1.3 to 12.2.8 ,POR_ITEM_TYPE lookup meaning values changed in upgraded instance 12.2.8:

In 12.1.3 Instance:

select lookup_code, meaning, description
from fnd_lookup_values_vl
where lookup_type = 'POR_ITEM_TYPE';

LOOKUP_CODE         MEANING                                              DESCRIPTION

GOODS                    Goods billed by quantity                        Goods billed by quantity
SERVICES                 Services billed by quantity                     Services billed by quantity
TOTAL_AMOUNT        Goods or services billed by amount        Goods or services billed by amount

In 12.2.8 Instance:

select lookup_code, meaning, description
from fnd_lookup_values_vl
where lookup_type = 'POR_ITEM_TYPE';

LOOKUP_CODE       MEANING                                                                                    DESCRIPTION
GOODS                  Goods.I can provide description, item price and quantity                 Goods billed by quantity
SERVICES              Services.I can provide description, rate and quantity                       Services billed by quantity
TOTAL_AMOUNT      Goods or Services.I can provide description and Total Amount          Goods or services billed by amount


Is it possible to modify those lookup values as per old instance(12.1.3) and if so is there any impact by changing those lookup values?

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.