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


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?




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

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