Fast Formula Erroring on Database Item HR_Assignment_ID (Doc ID 2582429.1)

Last updated on MAY 13, 2024

Applies to:

Goal

Issue:

When creating a Fast Formula which sends a call to an External Function,
Seeing the error:

   APP-FF-33005: The local variable HR_ASSIGNMENT_ID was used before being initialized
   Cause: The variable named in the error message is being used before any value has been assigned to it, so it has no meaningful value.
   Action: Please ensure variables have been assigned to before using them.

Review of Database Items does not show one called HR_ASSIGNMENT_ID

Cause:
 
When creating the External Function, customer declared the ASSIGNMENT_ID as a context - but they were also declaring the p_assignment_id as a parameter.
     - Then in the formula they called the function like this:

              x = function_name(p_assignment_id)

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.