My Oracle Support Banner

Load Project And Activities Process Is Not Loading Data Into Project And Activity Core Tables. The data is cleared from interface tables INTFC_PROJ_GEN and INTFC_PROJ_ACT (Doc ID 2479582.1)

Last updated on NOVEMBER 27, 2019

Applies to:

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

Symptoms

On : 9.2 version, Interfaces

ACTUAL BEHAVIOR
---------------
Load Project and Activities Process is not loading data into Project and activity core tables.

They are also getting removed from the interface tables without loading into the core tables.

EXPECTED BEHAVIOR
-----------------------
Load Project and Activities Process should load data into Project and activity core tables.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load data into PS_INTFC_PROJ_GEN
2. Run PC_INTFC_GEN or Load Projects and Activities Process

Review that the rows are getting deleted from PS_INTFC_PROJ_GEN and yet no actual projects are being created in PS_PROJECT table.


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


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