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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Isssues with PER_ASG_ATTRIBUTE_DATE2 database in Fast Formula

edited Jun 7, 2021 1:16PM in Payroll and Global Payroll Interface (GPI) 1 comment

Content

Hello experts,

I've successfully validated the following fast formula:

default FOR PER_ASG_ATTRIBUTE_DATE2 is '0001/01/01 00:00:00'(DATE)

dataesodabilita = PER_ASG_ATTRIBUTE_DATE2

return dataesodabilita

It works as it should, but I need to solve the following issues:

1) There are some employees with PER_ASG_ATTRIBUTE_DATE2 null, but when launching the fast formula it displays 0001/01/01 00:00:00 instead of null value. In this case I would like the FF returns a null value and not the 0001/01/01 00:00:00 date format.

2) The Fast Formula returns the date in the following format:

2030-07-05T00:00:00.00Z

Is there a way to return the following format: 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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