My Oracle Support Banner

Error "Field does not exist -- PO_LINE_FS.CNTRCT_ID" When Access Contract Details on PO Inquire/Item details (Doc ID 3043758.1)

Last updated on SEPTEMBER 06, 2024

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Getting error 'Field does not exist -- PO_LINE_FS.CNTRCT_ID when Access Contract Details on PO Inquire/Item details.

Field does not exist -- PO_LINE_FS.CNTRCT_ID.
DERIVED_HC.ITM_VNDR_PB.FieldChange PCPC:1791 Statement:38


The issue can be reproduced at will with the following steps:

Note: In the Replication Steps, User Details / Company Names / Addresses / Emails / Telephone Numbers / Etc. are fictitious (based upon made-up data used in the Oracle DEMO Environments), any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

1 Go to My Requisition tile
2. Search by BU 'WCGEN'
3. Select requisition id: '0000000036'
4. Click on line detail arrow.
5. Getting the error message:

Field does not exist -- PO_LINE_FS.CNTRCT_ID.
DERIVED_HC.ITM_VNDR_PB.FieldChange PCPC:1791 Statement:38


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