My Oracle Support Banner

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

Last updated on MAY 13, 2024

Applies to:

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



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

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)

Please note this can happen with any item that is available as a context.
It is not limited to the p_assignment_id.

To see list of contexts, please navigate to US Super HRMS Manager > Total Compensation > Basic > Fast Formula > Formula Functions > Context Usages


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

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