Payroll for NA / Time and Labor - PSFT (MOSC)

MOSC Banner

Tax Form Definition

edited Mar 30, 2022 1:19PM in Payroll for NA / Time and Labor - PSFT (MOSC) 3 commentsAnswered ✓

In step 4 of re-applying dms script (upd29869845_01_imp.dms) for Tax Form Definition Fix when tax form defs were not added prior to applying 19D.  Is it supposed to fail when trying to open .dat file?

DELETE FROM PS_TAXFORM_PRT

WHERE TAXFORM_ID IN ('W','I','M','S')

AND EFFDT = %DATEIN('2019-01-01');

IMPORT *;

Started:  Fri Dec 20 10:37:05 2019

Data Mover Release: 8.54.30

Database: HPROD (ENG)

SQL Successful -  DELETE FROM PS_TAXFORM_FORM WHERE TAXFORM_ID IN ('W','I','M','S') AND EFFDT = %DATEIN('2019-01-01')

SQL Successful -  DELETE FROM PS_TAXFORM_BOX WHERE TAXFORM_ID IN ('W','I','M','S') AND BOX = '09' AND EFFDT = %DATEIN('2019-01-01')

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center