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 for Oracle Cloud HCM   Begin Now

How to replace null values?

Accepted answer
41
Views
4
Comments

Summary:

How to replace null values?

Content (required):

I’ve created an HCM Export and I have compensation fields like this:


I defined a replacement criteria on MSP_Element_Entry_Value field like so:



But if the system doesn’t find a value it simply returns nothing:


If the system finds values it works fine so the structure is correct. I think it may be some sort of bog. Anyway my goal is to have “0” in case of null values.

Version (include the version you are using, if applicable):

23B

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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