My Oracle Support Banner

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

Last updated on OCTOBER 07, 2019

Applies to:

Oracle Advanced Benefits - Version 12.1.3 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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