Amicuk Programming Answers

Oracle Functions

-0001-11-30   Views:0


Does there exist any documentation which contains a description of all Oracle Apps seeded functions? ThanksHi, Module specific API guides are there. I doubt if there are any master API documentation available. Message was edited by: AMARRead other 4

Does there exist any documentation which contains a description of all Oracle Apps seeded functions?

The replay answer
Module specific API guides are there. I doubt if there are any master API documentation available.
Message was edited by:

Go to See the other 4 answers

XML Error while calling webservice from oracle function.

Category:DefaultRelease time:2015-10-11Views:130

I am getting an error while I am trying to call webservice from oracle function. Any ideas? Thanks. select get_new_string ('proxy:80', 'http://xxx/PatternVariations/SourceTest/WebMethods','Scott') from dual ERROR at line 1: ORA-31011: XML parsing fai[More]

Can't open oracle functions after installation R12 On windows 2008 64 bit

Category:DefaultRelease time:2015-10-11Views:130

Hi guys i am installed oracle R12.1.1 on windows server 2008 R2 64 bit,then the application is opening but all oracle forms functions can't open,the message appear frm-92101 ,i am try the solutions in net but no effect,and i am getting another messag[More]

How to call oracle Function which has If else condition in Data Template

Category:DefaultRelease time:2015-10-11Views:130

Hi, currently I am working on creating Data Template which uses a Oracle Function which I need to make use in my data template. But I have some confusions on using the same. Could anybody please help me in this regard. I have a function like this, fu[More]

Calling oracle function in OMB script

Category:DefaultRelease time:2015-10-11Views:130

Hi Can anyone please tell me how can i get the returned value of an oracle function in OMB script. or how can i get the value into OMB variable and use it. Basically i want to set the properties of OWB mapping via OMB script. Following OMB code sets[More]

Order by clause  Dynamic in Oracle function

Category:DefaultRelease time:2015-10-11Views:130

How can i get order by Clause Dynamic in Oracle function My function Returns sql query with SYS_REFCURSOR . and i will pass the order by column as input parameter   create or replace FUNCTION TEST_SSK         p_srot  number RETURN SYS_REFCURSOR AS C_[More]

Using oracle function in order by clause

Category:DefaultRelease time:2015-10-11Views:130

Hello, can i use report query or report that generate query like this : select fname, lname from peoples order by dbms_random.value; dbms_random is an oracle function to generate random value. Thnaksadd the following call to your query: query.addOrde[More]

How to set Oracle function as a PreparedStatement parameter?

Category:DefaultRelease time:2015-10-11Views:130

Hi all, I was wondering if it is possible to use Oracle function as a PreparedStatement parameter? For example: PreparedStatement pstmt = new PreparedStatement("update table set date=? where ..."); pstmt.set???(1, sysdate);I can put the function[More]

How to use oracle functions in Crystal Reports XI using Oracle Server

Category:DefaultRelease time:2015-10-11Views:130

Hi all, Is it possible  to use oracle functions in Crystal Reports XI using Oracle Server as Data Source. If i try to use a procedure,i am getting error with message "Invalid Arguement Provided". Functions are not visible objects like tables,vie[More]

I can't execute oracle functions with c#.  i'm using oracle 9i version.

Category:DefaultRelease time:2015-10-11Views:130

i have a problem trying to execute an oracle function with The Oracle version i'm using is Oracle 9i. This is the function definition: (it's defined and working right because i have tryed it with SQLWorksheet) CREATE OR REPLACE Function NRegi[More]

Oracle Function call from JDBC Adapter

Category:DefaultRelease time:-0001-11-30Views:130

Hi,   Is it possible to call Custom Oracle Function from JDBC Adapter?  I know we can call stored procedure but I need to call Oracle function. Please explain how? Regards, Shweta.You'll need to provide a column alias for the function call: select fu[More]

Call oracle function in ODI

Category:DefaultRelease time:-0001-11-30Views:130

I am new to ODI. I need to call a function created on the database which return a value. In ODI I created a variable. In the select (of the variable) I don't know how to call the source table value that needs to be passed to the function. My oracle f[More]

In Pages preferences, I have chosen to open the template chooser window, but for some reason when I open Pages, it continually opens in a finder type window and I have to choose "new document" and then I will get the template chooser [More]
My wife and I decided that we needed separate accounts for our two 4s phones.  To do this, the data from her phone needed to be transferred out, then transferred back in under the different account.  The pictures were transferred back in using Itunes [More]
We our main inbox we have 3 separate email boxes (home - which is main address from AT&T, my address and my wife's address). Recently we have been gettng mail in the right inbox but also the main address even though it is addressed to the sub email a [More]
How would one send a message(error/success/information) to the sending(external) system to inform them of the statuses of the messages they've sent to our SAP system?Hi Baumann, you have an option called Audit reporting in which you can have the stat [More]
I just finished a project with several hundred vi's and "they" want each vi password protected. Is there a way to do this without going into each individual vi? LV5.1.1In LabVIEW 8.0, you can use vi.lib\utility\libraryn.llb\Recursive File List.v [More]
Hi All, We have MII hosted on windows 2012 64-bit server. We are planning to install latest GA version of PCo which happens to be 2.3. From the product availability matrix it seems that PCo 2.3 is not listed in the OS for it. I know that PCo 15 which [More]
Hi, I have this module in a web form which should be populating the dropdown when a user is logged into a secure zone. However it can't select the correct country form the dropdown - it was taking the selected option. I removed the selected option so [More]
How do I download CS5.5 on my new computer at work? I already have a serial number.You had better check with your IT dept. before installing.  It could get you fired.  If there is any sort of network security on your work computer you probably won't [More]
I know OS X handles memory more efficiently than Windows, but I'd still like to disable or delay start of some services to improve boot time or performance in general. Is there a list anywhere of what services/startup items it is safe to disable? Tha [More]
Hi, I got an url-safe base64 encoded  email message( including headers and body) retrieved from gmail. I need to send this message directly to exchange server without specifying To,From,Subject and body as my message contains it all together. Is ther [More]