How to quickly compile Fast Formulas and Regenerate the Function Wrapper from the prompt

When working the other day on some new FastFormula to be used in Oracle Time and Labour and trying to test that function, OTL generated a nice and user friendly (:-) error message to me that there was something wrong with the function wrapper and that my new FastFormula was in an uncompiled state.

To fix these kind of problems with your FastFormula implementation you have several ways of recompiling all the FastFormulas.

1) You can start a seeded Concurrent Program from Oracle Payroll (Select Bulk Compile of Formulas)
2) Do everything from the command prompt and execute the recompile.

To get rid of the Function Wrapper message you need to regenerate the function wrapper by running a sql file from the FF_TOP.

Let’s show you the command prompt way.

Recompile your FastFormulas

Connect with your E-Business Suite instance through the command prompt and execute the below:

$FF_TOP/bin/FFXBCP APPS/<appspassword> 0 Y %% %%

Regenerate the Function Wrapper

To regenerate the function wrapper issue the below sqlplus command to fire the regenerate statement from the FF_TOP:

sqlplus APPS/<appspassword> @$FF_TOP/patch/115/sql/ffgenwrap.sql

Hope the above helps if you encounter any of the problems I experienced. Happy commenting!