Oracle Fusion HCM Fast Formula Compilation Issue – PLSQL_CREATED = N and Missing Database Objects
Summary:
Hi All,
We are currently facing a compilation issue with one of our custom Fast Formulas in Oracle Fusion HCM. I would appreciate any guidance from the community on understanding the root cause and resolving this issue.
We have several custom Fast Formulas in our environment. As part of our investigation, we reviewed the Oracle standard Fast Formula tables and extracted the Fast Formula details, compilation information, and related database objects from the ALL_OBJECTS table.
We found an interesting difference between a working Fast Formula and the problematic Fast Formula.
1. Working Fast Formula – ANNUAL LEAVE ACCRUAL MATRIX
PLSQL_CREATED
0