EGL: Global Payroll Message Inserting New Rows in GP_ACC_LINE In HCM When Data Send Back From PeopleSoft Financial System Instead Of Updating Existing Rows (Doc ID 1960702.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

CUSTOMER ENVIRONMENT
=======================
Application releases

Global Payroll:
apps release and bundle level: 9.1 with Global Pay bundles 2014 C
tools version and patch level: 8.52.07
database type and version: Oracle 11g

Finance:
apps release and bundle level: 9.2 Image 5
tools version and patch level: 8.53.11
database type and version: Oracle Database 11g Enterprise Edition Release

Database:
TEST
We are currently implementing Global Payroll for India. We are in the Integration test phase. We are currently live with other PeopleSoft modules - HR, North American Payroll, Self-Service, Absence Management, etc.



ISSUE/ ERROR
===============
Instead of updating the existing rows, it inserts NEW rows only populating the data that is usually updated via journal generator
1. Data interfaced from HCM using application Engine program GP_GL_PREP. Using the Integration Broker message GP_POST_GL from GP_ACC_LINE to a financials database
2. The data is sent correctly
3. The data is received correctly
4. The data gets journal generated correctly created journals in FSCM
5. But after journal generator completes the data from GL does not get updated back to global payroll correctly


EXPECTED RESULTS
===================
After successful journal generation of interfaced data from global payroll,we expect data to be updated with journal id, journal date, journal line, etc to the existing lines in GP_ACC_LIN in HCM to complete the interface cross reference.

ACTUAL RESULTS
=====================
When data is routed back to global payroll database for journal id, journal date, journal line, etc, the data is created as newly inserted lines in GP_ACC_LIN rather than update to existing lines


BUSINESS IMPACT
================
Existing lines are not properly updates for checking reconciliation between global payroll(HCM) and General Ledger(FSCM)

We are currently in Integration Test for our GP implementation. We must pass the GL test during this phase or it will impact our go-live. Integration/Regression test ends 01/09/2015.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms