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
Last updated on JANUARY 26, 2018
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.
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
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
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.
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
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.
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
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.
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