My Oracle Support Banner

PYUGEN Programs Fail with ORA-01400: cannot insert NULL into ("HR"."PAY_PAYROLL_ACTIONS"."PAYROLL_ACTION_ID") (Doc ID 2768212.1)

Last updated on APRIL 12, 2021

Applies to:

Oracle Payroll - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:

Payroll PYUGEN programs (e.g. Payroll Process, Payroll Run, Maintain Person Security List information(Internal)...etc) fail with the error below.

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01400: cannot insert NULL into ("HR"."PAY_PAYROLL_ACTIONS"."PAYROLL_ACTION_ID")

SQL_NO 441
TABLE_NAME PAY_PAYROLL_ACTIONS
APP-PAY-06881: Error ORA-01400: cannot insert NULL into ("HR"."PAY_PAYROLL_ACTIONS"."PAYROLL_ACTION_ID") has occurred in table PAY_PAYROLL_ACTIONS at location 441

Cause: an oracle error has occurred. The failure was reported on table PAY_PAYROLL_ACTIONS at location 441 with the error text ORA-01400: cannot insert NULL into ("HR"."PAY_PAYROLL_ACTIONS"."PAYROLL_ACTION_ID")

Action: Please contact your support representative.

 

 

Steps to Reproduce:

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

  1.  Upgrade to R12.2.
  2.  Run PYUGEN program
  3.  Request fail with the error

Changes

 Upgrade to R12.2.

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
References


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