My Oracle Support Banner

EPC: Load Projects and Activities Process (PC_INTF_GEN) Fails With the Error: Invalid Row Number 1 for Class Rowset Method GetRow. (2,263) PC_INTF_GEN.PUBLISH.PUB_PRJ.OnExecute When There Is More Than One Future Dated Row (Doc ID 1988346.1)

Last updated on FEBRUARY 25, 2021

Applies to:

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

Symptoms

Load Projects and Activities process fails with the following error when there is more than one future dated row in the PS_INTFC_PROJ_GEN  interface table:


Steps to reproduce the issue:

1. Use ExceltoCI to upload project to PS_INTFC_PROJ_GEN table (CI is PROJECT_INTFC_PROJ).
2. Include several projects with future effective dates.
3. Navigate to Project Costing > Third Party Integration > Load Projects and Activities. Set the parameters:
    - Load Options = Projects, Activities
    - Interface Options = All
4. Run PC_INTF_GEN process.

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.