473,385 Members | 1,311 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Oracle apps Fast formula error

151 100+
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_DURATION ORA-04063 package body " APPS.FFPP3613_01011951" 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
Jan 24 '09 #1
9 4197
amitpatel66
2,367 Expert 2GB
Did you compile your package after modifying?
Jan 27 '09 #2
vamsioracle
151 100+
Yes the package is compiled and there is no error or warnings
Jan 29 '09 #3
amitpatel66
2,367 Expert 2GB
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
Jan 30 '09 #4
vamsioracle
151 100+
Thanks a lot for your timely reply. It's working now for no reason. I never made any changes and suddenly it started working.
Feb 6 '09 #5
amitpatel66
2,367 Expert 2GB
Strange but good to hear that its working now.
Feb 6 '09 #6
vamsioracle
151 100+
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.
Feb 9 '09 #7
amitpatel66
2,367 Expert 2GB
Check this Link should help you understand about fast formulas and context parameters in SSHR
Feb 9 '09 #8
vamsioracle
151 100+
Thanks a lot. The link was good. I was able to learn more from that.
Feb 9 '09 #9
amitpatel66
2,367 Expert 2GB
You are always welcome :)
We are happy that it helped you
Feb 10 '09 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: vincent delft | last post by:
Hello, I must set-up an application with an Oracle Database running on Unix and a GUI running on Windows 2000/XP machines. The size of the DB is about 5GB. The application will have about 1000...
3
by: John Kuhn | last post by:
What additional steps are needed to allow web apps to access oracle ODP.NET resources under Windows Server 2003? When using Oracle's ODP.NET (9.2.0.401) from a WebForm I get permission errors...
24
by: Alex Vinokur | last post by:
Consider the following statement: n+i, where i = 1 or 0. Is there more fast method for computing n+i than direct computing that sum? -- Alex Vinokur email: alex DOT vinokur AT gmail DOT...
13
by: BigDaDDY | last post by:
Um yeah....In case you haven't figured it out, Microsoft sucks. I'm going to be kicked back in my chair eating popcorn and watching football 10 years from now, while all you clowns are scrambling...
9
by: AnandaSim | last post by:
Hi All, I've had Access 97, 2000 connections to the corporate Oracle database for a few years now - but seldom use it. When I did use it years ago, performance was not fast but the features were...
4
by: Steve | last post by:
We are using ODP.net (version 9.2.0.4.01) as data provider for Oracle in our dotnet app. Currently we are using Microsoft.NET Framework 1.1 (VS.net IDE 2003) in our project. One thing I feel...
13
by: Chris Botha | last post by:
The machine is running XP Pro with all the latest service packs, etc. I must access an Oracle database so I installed the Oracle client stuff. I can query Oracle from a Windows app, no problem....
8
by: =?Utf-8?B?RGF2aWQrKw==?= | last post by:
Hi, I have been developing Web Services in VS2005. Usually I use the built in server in VS2005 to test and develop the Web Service. However I now want to make this Web Service available to...
2
by: Vinod Sadanandan | last post by:
All, Below listed are the new features in Oracle 11g ,please join me in this discussion to generate a testcase and analyze each of the listed features . Precompilers:...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.