My Oracle Support Banner

EAP: Populate Vendor Name History process abends at Step VNDR_HST_POP.POP_LAN1.Step07 (Doc ID 1539994.1)

Last updated on JULY 21, 2020

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

Populate Vendor Name History process abends at VNDR_HST_POP.POP_LAN1.Step07.SQL with an error due to the usage of invalid fields against the VNDR_NAME_HS_LN record. The list of fields used in the Application Engine SQLs against VNDR_NAME_HS_LN doesn't match with the list of fields that exists in the VNDR_NAME_HS_LN record definition.

ERROR
SQL error. Stmt #: 1620  Error Position: 191  Return: 904 - ORA-00904: "EFF_STATUS": invalid identifier

Process ABENDED at Step VNDR_HST_POP.POP_LAN1.Step07 (SQL) -- RC = 904

STEPS
1. Login to a multi-lingual environment
2. Navigate to Set Up Financials/Supply Chain > Product Related > Procurement Options > Vendors > Set Controls-Vendor
3. Check ON 'Vendor Name History' button.
4. Select a Server Name and Save
5. Click OK for the below message

MESSAGE
Vendor name history has been turned on (7025,401)

6. Process abends with the above error

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.