You Will Never Get Stuck Again!
This promise is immense; every day and every night, we are trying our best to fulfill it by helping others, leaving something worthwhile behind us, and living for a purpose that is "Enrich & Spread knowledge everywhere".
Join 15000+ Exceptional
Latest Python Wiki's
Python isdigit vs isnumeric vs isdecimal
Python deals with a wide variety of data types. This includes numbers, strings, objects, etc. We generally treat the digits, numerals, and decimals as different names of the same entity. However, in Python, there are significant differences between ...
Python Program to Check Prime Number using While Loop
Prime numbers are an essential concept in mathematics and computer science. They are numbers that are only divisible by 1 and themselves. In this article, we will explore the concept of prime numbers and learn how to write ...
What does this sign operator “+=” do in java?
Hi @Olivier, it common that z += 5.6 are equivalent to z = z + 5.6, it's one the assignment operators it takes the value of z then add 5.6 to it and at the end store the new result into z ex: double z = 5.5 z += 0.1 // the result of z now is : (5.6) but be careful in java because if "z" is not of tyRead more
Hi Olivier,
it common that z += 5.6 are equivalent to z = z + 5.6, it’s one the assignment operators it takes the value of z then add 5.6 to it and at the end store the new result into z
ex:
but be careful in java because if “z” is not of type double you will get an compilation error.
hope this help.
See lessError: You cannot deactivate an asset for which there are open work requests or service requests or work orders
Check for any open work orders/work requests for the asset number. If open work orders/work requests exists update work order status to close/complete/cancel. Below are the queries to check open work orders/work requests -- Check for open Work Orders SELECT COUNT (1) FROM eam_work_orders_v WHERE ( wRead more
Check for any open work orders/work requests for the asset number. If open work orders/work requests exists update work order status to close/complete/cancel. Below are the queries to check open work orders/work requests
See lessWhat are RICE components in the Oracle Apps ?
there is one article i wrote before taking about these terms and what is the difference between them ClICK HERE to read it.
there is one article i wrote before taking about these terms and what is the difference between them ClICK HERE to read it.
See lessWhen creating a Work Request via the APIs am I able to set the CREATED_BY?
by default who columns as (CREATED_BY) is one of them is handled automatically from oracle by database triggers like HRMS and when you call any API's from sql*plus or sql developer. who columns are set also automatically by anonymous user. but still you can control of this behavior by calling fnd_glRead more
by default who columns as (CREATED_BY) is one of them is handled automatically from oracle by database triggers like HRMS and when you call any API’s from sql*plus or sql developer. who columns are set also automatically by anonymous user.
but still you can control of this behavior by calling
before call your API. but keep in mind that it is your responsibility to pass in valid values, as incorrect values are not rejected.
Regards.
See lesscalling report from formbuilder 6.0 in menu to run in web server
Hi @elhamkoockak what is the error message exactly and share your code to be able to help you. thanks
Hi @elhamkoockak
what is the error message exactly and share your code to be able to help you.
thanks
See lessIt’s possible to call an oracle API from custom schema ?
You would have to grant the appropriate permissions to your custom schema.
You would have to grant the appropriate permissions to your custom schema.
See lesshow to list all linux users and groups ?
cd /home Here you can find the user and group name. type the below command ls -lrt
cd /home
Here you can find the user and group name. type the below command
ls -lrt
See lesslinux command to delete file ?
To remove (or delete) a file or directory in Linux from the command line, use the rm (remove) command Examples:- 1.To delete a single file rm filename 2.To delete multiple files rm filename1 filename2 filename3 rm *.pdf Use the -i option to confirm each file before deleting it rm -i filename(s) UseRead more
To remove (or delete) a file or directory in Linux from the command line, use the
rm(remove) commandExamples:-
1.To delete a single file
rm filename
2.To delete multiple files
rm filename1 filename2 filename3
rm *.pdf
Use the
-ioption to confirm each file before deleting itrm -i filename(s)
Use the -f(force) optionrm -f filename(s)
3. To remove non-empty directories and all the files without being prompted use the
r(recursive) and-foptionsrm -rf dirname
See lessHow to open custom.pll in form builder?
Hello Alan, It's so simple as you open regular form .fmb in form builder just follow this: First you need to download then latest version of CUSTOM library that comes with your Oracle EBS version. (downloaded from production server). You can find the path of CUSTOM.pll under ($AU_TOP/resources) foldRead more
Hello Alan,
It’s so simple as you open regular form .fmb in form builder just follow this:
- First you need to download then latest version of CUSTOM library that comes with your Oracle EBS version. (downloaded from production server).
- You can find the path of CUSTOM.pll under ($AU_TOP/resources) folder
- Open Oracle Form Builder
- Click File menu ==> Open ==> choose CUSTOM.pll from your local machine
- After opening CUSTOM.pll into your form builder you can modify (CUSTOM) Package as per your requirements.
See lessUsing between on sysdate instead of TRUNC
Use TO_DATE Function. SELECT sum(column3) from table1 where column1 = ‘XXXXXAA12’ and column2 between to_date (<yor val>,<your format>) and to_date (<yor val>,<your format>);
Use TO_DATE Function.
SELECT sum(column3)
See lessfrom table1
where column1 = ‘XXXXXAA12’
and column2 between to_date (<yor val>,<your format>) and to_date (<yor val>,<your format>);