My Oracle Support Banner

EPI: Import of YTD Tax Balances Panel - Balance periods YTD, QTR, & MTD are not (Doc ID 608687.1)

Last updated on MARCH 27, 2019

Applies to:

PeopleSoft Enterprise HCM Payroll Interface - Version 7.5 and later
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 658915




Symptoms

Issue:1
When YTD data goes to populate YTD Balance table.Pay calander balance period data isn't updated to the PI Balance tables correctly.

YTD Data is going to the table PI_TAX_BAL record, but the fields  PI_BALANCE_ID,  PI_BALANCE_YEAR, and PI_BALANCE_QTR are all being populated with "8224" (spaces in numeric comp fields).

The customer is not using the delivered YTD Balance Interface Definition which is in a Logical file format.  Instead he is using a very simple CSV file format.  

Issue: 2
I need to verify that the earnings code on the pi_earnings_bal table is on the earnings table in PeopleSoft. Please confirm that the table I need to verify is called earnings_tbl. If this is the case, why do you allow only a 3 character earnings code field when the size of the field is a 6 character field on the pi_earnings_bal 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.