MBMF Table With Wrong Table Value (Doc ID 1927048.1)

Last updated on DECEMBER 20, 2016

Applies to:

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

Symptoms

 PROBLEM STATEMENT
=================
Running a Quickpays / Payroll for Singapore Legislation
When the Monthly Salary < 1000.99
getting an error during the Payroll processing and not able to continue.
 
Error does not occur for higher paid people
 
 
===========
ERROR
===========
Error was encountered when processing assignment 160835
Error was encountered when processing Element Type Community fund
Error was encountered when processing formula SG_COMM_FUND
An error occurred during formula execution:
 
Too many rows returned for TO_CHAR at line 154 of SG_COMM_FUND
 
 
===========
STEPS TO REPRODUCE
===========
(1) Run a quickpay on a person with a monthly income less than 1000.99
(2) View payroll run messages and notice that the payroll processing has
errored.
 

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