My Oracle Support Banner

When run Expedite Requisition - PV_PO_CREATE process Error 'Cannot Find The Object 'PS_ PO_WOXREF_T4' is Triggered (Doc ID 2441472.1)

Last updated on DECEMBER 12, 2019

Applies to:

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

Symptoms

When run expedite requisition - PV_PO_CREATE process error 'cannot find the object 'PS_ PO_WOXREF_T4' is triggered.

The was noticed after migrating the FSCM environment from image 19 to Image 28.

If SQL check, SELECT * FROM PS_PO_WOXREF_T, the table exists in database.

User process errors out
File: E:\pt85610b-retail\peopletools\src\psappeng\psaesql.cppSQL error. Stmt #: 3091 Error Position : 0 Return: 601 - [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot find the object "PS_ PO_WOXREF_T4" because it does not exist or you do not have permissions. Failed SQL stmt: TRUNCATE TABLE PS_PO_WOXREF_T4


ERROR
-----------------------
SQL error. Stmt #: 3091 Error Position : 0 Return: 601 - [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot find the object "PS_ PO_WOXREF_T4" because it does not exist or you do not have permissions. Failed SQL stmt: TRUNCATE TABLE PS_PO_WOXREF_T4


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Applied FSCM PUM 28 maintenance for financials.
2. Tried to run Expedite Requisition (PV_PO_CREATE)
3. Program PV_PO_CREATE is failing due to error

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.