SPWL Error ORA-01400: Cannot Insert NULL Into ("HR"."PAY_FILE_DETAILS"."FILE_TYPE") (Doc ID 2141663.1)

Last updated on MAY 24, 2016

Applies to:

Oracle HRMS (US) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, State Quarterly Wage Listings

After performing DB upgrade ,CPU and some other Patches and  attempting to State Periodic Wage Listing (SPWL) ,
the following error occurs when it gets to the Magnetic XML Report Merger..

ERROR
-----------------------
Blob writing start time: Mon Apr 11 13:10:33 EDT 2016
Blob writing end time: Mon Apr 11 13:10:33 EDT 2016
File details inserting start time: Mon Apr 11 13:10:33 EDT 2016
--SQL Exception
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("HR"."PAY_FILE_DETAILS"."FILE_TYPE")

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. DB upgrade to 11204 + RPC + CPU + CUSTOMER REQUESTED PATCHES

2. submit State Periodic Wage Listing (SPWL)
parameters
 VA Q2016/01/01 to , 2016/03/31 Q, SQWL_OLD, , , EFW2, 0, 101, 1, Y, , , , SD=2016/04/11 00:00:00, , , , N


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