My Oracle Support Banner

Integrate Transactions Program - PV_TRANSACT Missing Newly Added Fields (Doc ID 2560705.1)

Last updated on JULY 02, 2019

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms


Scenario# 1:
---------------
1) The record REQ_LINE and PO_LINE which has newly added fields as part of PUM31 Image.
2) The new fields added in these two records,
REQ_LINE:
-------------
UPN_TYPE_CD
UPN_ID
PRICE_INITAL

PO_LINE:
------------
LN_TYPE
UPN_TYPE_CD
UPN_ID

All the above fields are NOT NULL characters.

There are insert SQL's exists for both records REQ_LINE (Section - 18000000, Step - INSLINE, Action - SQL) and
PO_LINE (Section - 29000000, Step - PO_LINE, Action - SQL) in the application engine PV_TRANSACT.

Could see some of the existing NOT NULL character fields from both PO_LINE and REQ_LINE records does not exists in the above mentioned Insert SQL.



Changes

 

Cause

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
Symptoms
Changes
Cause
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.