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