Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
How to check and test read/write permissions of Oracle directory?
Check the below query :SELECT * FROM all_tab_privs WHERE table_name = 'your_directory';
Check the below query :
SELECT * FROM all_tab_privs WHERE table_name = ‘your_directory’;
See lessWhat is FNDLOAD command to move Value Sets from one instance to another ?
Hello Matheo, You can use this command to download and upload value sets : FNDLOAD to Download Valueset: $FND_TOP/bin/FNDLOAD username/password 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME="XX Value Set Name" FNDLOAD to Upload Valueset: $FND_TOP/Read more
Hello Matheo,
You can use this command to download and upload value sets :
FNDLOAD to Download Valueset:
FNDLOAD to Upload Valueset:
Repeat same previous record or item in oracle forms ?
You can use DUPLICATE_RECORD built-in
You can use DUPLICATE_RECORD built-in
See lessHow to show a message in a report at runtime?
hi Albert, You can display a message in Oracle report builder by using the standard built-in srw.message. The basic syntax for using this package is: srw.message(error_no,'YOUR MESSAGE'); the error no will appear along with the message text. and here is the sample to do this in a particular functionRead more
hi Albert,
You can display a message in Oracle report builder by using the standard built-in srw.message.
The basic syntax for using this package is:
the error no will appear along with the message text. and here is the sample to do this in a particular function
See lessHow to add “Auto Refresh” feature in EBS submit request form like version 12.2.6?
Hello Beter,here you will find how to implement this functionality inside 12.1.3 + versions:Click Here : Implement Auto Refresh functionality in EBS 12.1.3+
Hello Beter,
here you will find how to implement this functionality inside 12.1.3 + versions:
Click Here : Implement Auto Refresh functionality in EBS 12.1.3+
See lessOracle R12 EBS not working on Firefox 52
hello albert,the problem with mozilla firefox new version 52, there is another version working good called mozilla firefox ESR.Mozilla Firefox 52 Extended Support Release (ESR) is certified as a Windows-based client browser for Oracle E-Business Suite 12.1 and 12.2.you can download your version fromRead more
hello albert,
the problem with mozilla firefox new version 52, there is another version working good called mozilla firefox ESR.
Mozilla Firefox 52 Extended Support Release (ESR) is certified as a Windows-based client browser for Oracle E-Business Suite 12.1 and 12.2.
you can download your version from this link :
Download Now
Note : you should download 86 bit version NOT x64.
hope this will help.
See lessHow to pass date parameter to oracle reports from oracle forms
your code looking good but let me ask you some questions : 1- is your report exists in the directory you provide it to your code ? 2- is your report compiled and working fine itself ? then please share full error message and number with when this error is throwing. thanks.
your code looking good but let me ask you some questions :
See less1- is your report exists in the directory you provide it to your code ?
2- is your report compiled and working fine itself ?
then please share full error message and number with when this error is throwing.
thanks.
How to INSERT row when only doesn't exist ?
hello albert, as mr. sandeeptiwari mentioned on your question as comment you can use merge statement and here i will share with you sample example for merge and not exists with regular insert statement first we need to create dummy table to test our code on it : CREATE TABLE testtab ( id NUMBER PRIMRead more
hello albert,
as mr. sandeeptiwari mentioned on your question as comment you can use merge statement and here i will share with you sample example for merge and not exists with regular insert statement
first we need to create dummy table to test our code on it :
now we will using not exists clause with regular insert statement but with select like this :
now the result would be :
1 row created.
then trying to execute same statement again and check the result :
0 rows created.
that because the row is already exists before
now we will trying to do the same but in this time we will using merge statement :
now the result would be :
1 row merged.
then trying to execute same statement again and check the result :
0 row merged.
hope this help 🙂
See lessis there oracle function to remove spaces in the string ?
hi albert, try this : select replace('Oracle Forms 10G', chr(32), '') from dual; hope this help.
hi albert,
try this :
hope this help.
See lessFRM-47001: Cannot create parameter list myparam : list with this name already exists
just you need every time to check if the parameter list exists.... If so , delete it before you try to create it. DECLARE pl_id ParamList; BEGIN pl_id := Get_Parameter_List('tempdata'); IF NOT Id_Null(pl_id) THEN Destroy_Parameter_List(pl_id); END IF; END; hope this helpfull :)
just you need every time to check if the parameter list exists…. If so , delete it before you try to create it.
hope this helpfull 🙂
See less