Oracle apps Fast formula error

[vamsioracle]

Hi all

I am working on a support project. I need to change logic in a fast formula in oracle applicationhs which was developed a long time back. I made the changes in pl/sql packages that include passing 3 more paramaters to the porcedure. Now my fast formula should will call this procedure with 2 already existing parameters. now i added the other 3 new parameters and saved it.

when i try to apply a leave in SSHR, which calls this formula it errors out, shown below

" Formula BG_ABSENCE_DURA TION ORA-04063 package body " APPS.FFPP3613_0 1011951" has errors.ORA -06506 PLSQL could not find program unit being called cause. During the PL/SQL execution part, an Oracle error was detected. Action. Please refer to your system administrator."

What could be the reason for this

Thanks in advance
vamsi

[amitpatel66]

Did you compile your package after modifying?

[vamsioracle]

Yes the package is compiled and there is no error or warnings

[amitpatel66]

Are you getting same error before modifying a package??

Please post the following information:

1. Schema in which package is compiled
2. Schema from where you are calling a package for execution
3. Are necessary GRANTS given to calling Schema on a package if the schema for point 1 and 2 above is different

[vamsioracle]

Thanks a lot for your timely reply. It's working now for no reason. I never made any changes and suddenly it started working.

[amitpatel66]

Strange but good to hear that its working now.

[vamsioracle]

While adding the 3 new parameter to a function which is called in fast formula. One parameter is Context parameter (ORG Id). When i checked back in th formula, this particular function has only 4 parameters, i.e it is not showing context parameter there. My question is is it true that context parameters though not visible will take values at runtime.

[amitpatel66]

Check this Link should help you understand about fast formulas and context parameters in SSHR

[vamsioracle]

Thanks a lot. The link was good. I was able to learn more from that.

[amitpatel66]

You are always welcome :)
We are happy that it helped you