GPNZ IR348 Exception Report Runs Into An Error

(Doc ID 2000370.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise HCM Global Payroll New Zealand - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
-------------------------------

The IR348 Report for exceptions runs into error:

Main Record: PS_GPNZ_IRD_EEXCEP
GPNZIR01.SQR, Process-Main, PS_GPNZ_IRD_EEXCEP, Select
[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'GPNZ_TX_CRDT_PG'.


STEPS
--------------
The issue can be reproduced at will with the following steps:

- Create IRD Data NZL (create the first and second half actuals and then the exceptions for the second half).
- Make sure there are exception data
- Create IR348 Report NZL, run by exception

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