Project Status Inquiry (PSI) Does Not Show Requisitions

(Doc ID 2413899.1)

Last updated on JUNE 21, 2018

Applies to:

Oracle Project Planning and Control - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

 The Project Status Inquiry form does not show requisitions:
- Querying pa_commitment_txns_v brings back requisitions according to the definition of PA_PROJ_REQ_DISTRIBUTIONS.
- Querying pa_commitments_txns only brings back one requisition. Consequently also the Form "Project Status Inquiry" only shows this one requisition after running the "PRC: Update Project Summary Amounts for a Single Project" or "PRC: Update Project Summary Amounts".

The issue with not showing the requisitions in the PSI Form is also happening with the standard definition of pa_commitment_txns_v.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms