Error APP-FF-33980 while Saving a Fast Formula Many of you might have got the following Error when you were writing a complicated Fast Formula which includes the usage of Fast Formula functions; APP-FF-33980: Internal error. A compilation error has been detected while attempting to generate package Please consult your system administrator. This is a very common error and I know that it says nothing that will remotely help you in solving it. But thats how Oracle is, what to do! :) Well there is a way to diagnose this kind of issue and get to the exact cause of this error. You see, the package FFPXXX_XXXXXX is actually the name generated for an underlying database package. This is usually one of the packages which houses your database function used in the formula. In order to know which function is creating a problem, log on to the console(Putty, etc) and follow the steps below; >CD $FF_TOP/BIN > FFXBCP apps/apps 0 Y -K %% %% Upon execution of the command, two files will be generated. .log and .out. We need to check the .log file. It will specify the name of the package(FFPXXXX_XXXXXX) that is not able to compile properly. On the Console; >sqlplus apps/pwd SQL> alter package compile body; SQL> Show Error The specific database procedure/function creating the problem will be mentioned. Rectify the error and try to re-verify the FF and Save. I hope this helps!! :)
Posted on: Sat, 25 Jan 2014 11:39:44 +0000
Trending Topics
Recently Viewed Topics
© 2015