Payroll-Personal Payment Details Real Time Target Bank Account is Null but not "IsNull" in the field — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Payroll-Personal Payment Details Real Time Target Bank Account is Null but not "IsNull" in the field

edited Sep 5, 2023 3:08PM in Reporting and Analytics for HCM 1 comment

Summary:


Content (required):

We are trying to find all the employees that have missing Bank Account Numbers or Bank Sort Codes

We are currently using Payroll - Personal Payment Details Real Time

So when we are trying to report on these fields that are showing as "Blank" they are not classed as "null" but they are also not classed as a numerical number.

So if you put in a filter of "Is Null" or is not a number nothing gets returned it negates the employees with "No data" in those fields

How can i pull the data showing the employees with "no data" within these Bank Account and Bank Sort Code fields

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!