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]

I am getting an 'iTunes has detected an iPod that appears to be corrupted" message from my 80GB iPod Classic. It plays music fine and has 2.5 GB of space left. I get the message on multiple PC's and USB ports. I have tried resetting it and using Disk [More]
I have installed the trial version of CS5 Production Premium on a Windows 7 64-bit PC. I canot get the Help menus to work for any of the applications. Is this a limitation of the CS5 trial version? I recently purchased Premiere Elements, but I did no [More]
HI, I am working on an app for iPad. I have implemented Print functionality in it to print PDF and PPT files. When I tested my app on ios 4 iPad it was working fine. Then I upgraded my iPad to ios 5. Now when I test my app, the print controller never [More]
The situation is this: i have a horizontal list which i populate with images loaded from xml. After i click on any of the images, popup windows is displayed with checkbox. The same popup is displayed for all of the images after i click on them. I nee [More]
For years we have been emailing and faxing remittances to vendors. As clearly outlined in various posts on SDN, this was accomplished by activating a copy of SAMPLE_PROCESS_00002040. What is unclear to me, however, is how some posts indicate this wil [More]
We are using the SAP ALE functionality to connect to the EDI sub-system, rather than the traditional way (creating IDoc flat files). For this setup also, the RFC type is TCP/IP type. But I'm not sure of the various other details to complete the setup [More]
With Namit Agarwal and Rahul Govindan  Welcome to the Cisco Support Community Ask the Expert conversation. This is an opportunity to learn and ask questions about Cisco Adaptive Security Appliance (ASA) version 9.x (Context Aware Security and VPN Fea [More]
Hi, i am working on workflow support issue which is relating to CC31/CC32, here we create change number in CC31, but we won't change status of CC31 in CC32. it is possible thru workflow item only. but when 3 rd person updating status from 2 to 3, he [More]
I just got an Iphone 5, I have an ipod classic 160. everything in my itunes is on my ipod and fuctions fine. I synced part of my mysic and disney movies with my iphone and the playlist is largely grey and wont work on the phone. What did I do wrong?Y [More]
I recently got a new battery for my MacBook Pro and it has been lasting around 2:30 hours.  When I went home to my parents house for the holidays, I notced my battery was lasting 3:30 or more instead the entire time I was there!  Is there any explana [More]