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.
What 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 lessIt’s possible to call an oracle API from custom schema ?
it's better and recommended from oracle to create your procedure on apps schema not on your custom schema. regards.
it’s better and recommended from oracle to create your procedure on apps schema not on your custom schema.
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 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 lessWhich symbol is used for concatenation? in plsql
its very simple you can use || symbol to concatenate two string or using concat function and here you can find full explanation with examples about how to use oracle || - oracle concatenation in knowledge base section. have a nice day.
its very simple you can use || symbol to concatenate two string or using concat function and here you can find full explanation with examples about how to use oracle || – oracle concatenation in knowledge base section.
have a nice day.
See lessWhy fnd_global.conc_request_id returns -1 ?
hello Alan The problem is that your request is not being submitted properly then it will be whatever fnd_global returns, which is most likely -1.
hello Alan
The problem is that your request is not being submitted properly then it will be whatever fnd_global returns, which is most likely -1.
See lessHow to SKIP or RETRY an oracle workflow by API from database ?
Hi Saly, this script to RETRY workflow from the backend BEGIN wf_engine.handleerror ( itemtype => ‘APINVAPR’, itemkey => 5211111_1, activity => ‘ESCALATE_DOC_APPROVAL’, command => ‘RETRY’, RESULT => NULL ); COMMIT; END; and here you can find the script for the SKIP workflow BEGIN wf_eRead more
Hi Saly,
this script to RETRY workflow from the backend
and here you can find the script for the SKIP workflow
Note :
itemtype: this is the item type of the workflow
itemkey: this is a unique key you give to workflow
activity: is the point for the activity internal name which you need to retry or skip.
How to create event alert in oracle apps ?
Hi Olivier, you can find here step by step how to create event alert in oracle apps R12 hope this helpful, Hassan AbdElrahman
Hi Olivier,
you can find here step by step how to create event alert in oracle apps R12
hope this helpful,
Hassan AbdElrahman
See lesslooking for sample md 50 document in oracle apps?
Hello Aya, you can find this article to download sample of AIM documents such as md 050 , md 070, etc.. CLICK HERE : >> AIM Documents (MD50, MD70 and MD120) Templates – Download now
Hello Aya,
you can find this article to download sample of AIM documents such as md 050 , md 070, etc..
CLICK HERE : >> AIM Documents (MD50, MD70 and MD120) Templates – Download now
See less