My Oracle Support Banner

EPC: PCQ6010-Current Project Status Query Is Missing Criteria for Effective Sequence and Returns Multiple Rows With the Same Date (Doc ID 2689839.1)

Last updated on JULY 15, 2020

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

If the current effective-date of a project status has multiple changes on that date, the PCQ6010 (Current Project Status) returns multiple rows ignoring the sequence value. It should return a single row for a project.

Steps
1. Create a project.
2. Add multiple project statuses for the same effective date.
3. Run the PCQ6010 query. Results will have multiple rows for the project created.

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.