Fast Formula execution fails when Time balance DBI is included — 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

Fast Formula execution fails when Time balance DBI is included

edited Jul 7, 2020 3:02PM in Workforce Management 5 comments

Summary

Fast Formula execution fails when Time balance DBI is included

Content

Hi,

 

I have created a time balance TEST_WORKED_HOURS_HOURS_WORKED_ASG_AAP that i am trying to refer in a Fast formula. But the formula ends with below error during execution:

Job errored for personId: 300000051001189
Job errored with message: oracle.apps.fnd.applcore.messages.ApplcoreException: JBO-FND:::FND_GENERIC_MESSAGE: <MESSAGE><NUMBER></NUMBER><TEXT>The message is ORA-20001: Formula TEST_ABILITY_ONE_SICK, user-defined function error The dynamic SQL for a database item failed..  Details: A function call raised an error during formula execution.
ORA-06512: at "FUSION.FF_EXEC", line 3769

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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