Fast Formula Error : PLS-00123: program too large (codegen operands) — 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

Fast Formula Error : PLS-00123: program too large (codegen operands)

edited Jul 4, 2025 2:08PM in HCM Integrations 21 comments

Team,

We have an extract rule Fast Formula that returns balance values using database items based on element name input.

The current code works fine, but we're facing challenges adding more IF conditions for new elements.

Error Message: PLS-00123: program too large (codegen operands)

When we try to add them, the formula fails to compile. We have over 30 IF conditions and need to add more for future elements. (Ex. UD_203_ASG_RUN, UD_204_ASG_RUN, List goes on…)

Our client prefers not to hardcode element names in the Fast Formula; instead, they want to maintain them in a User-Defined Table (UDT) for dynamic handling. We've tried, but Fast Formulas can't evaluate database items dynamically by name. (Previous post:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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