My Oracle Support Banner

PAYWSACT Payroll Balance Form Error > FRM-40735: POST-QUERY Trigger Raised Unhandled Exception ORA-01861 (Doc ID 2038827.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payroll - Version 12.1 HRMS RUP7 and later
Information in this document applies to any platform.

Symptoms

Using form PAYWSACT, Employee Payroll Balances are opening with error for SOME balances

When we search for an employee in the Assignment Process Results for a specific Payroll Period and then click on Balances Button to open the Balance Screen.
Once we query the records the error is coming for most of the rows.

Error coming while navigating the Employee Payroll Balances records


ERROR
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01861.


STEPS TO REPRODUCE
> SG HRMS Manager > View > Assignment Process Results
> [Balances]
> Blind query: F11, CTRL-F11
> Navigate to the each record using the down arrow
Error appears for "SOME" records

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.