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.


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.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.