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.
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".
How 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 lessError APP-OFA-47227 ‘You must set up the category with default depreciation rules for at least one date range’ When Define a new Assets Category
Hello PraveenM, this error came because there is a setup of default rule was missing when you want to create new asset category. just follow this steps to complete your setup required: Navigate to Responsibility FA manager > Setup > Asset System > Category Ensure that, at the bottom of theRead more
Hello PraveenM,
this error came because there is a setup of default rule was missing when you want to create new asset category.
just follow this steps to complete your setup required:
Navigate to Responsibility FA manager > Setup > Asset System > Category
Ensure that, at the bottom of the page, there is a Default rules button.
Enter the mandatory information in the second page for Default rules and Save.
Once the category book is defined with the default rules and saved, there should be no error.
See lessHow to create synonym in oracle ?
Hello Amira, synonyms is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects. You generally use synonyms when you are granting access to an object from another schema and you don't want the users to have to worry about knowing which schemaRead more
Hello Amira,
synonyms is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects.
You generally use synonyms when you are granting access to an object from another schema and you don’t want the users to have to worry about knowing which schema owns the object.
and here is the syntax to create synonym
Example:
Hope this help.
See lesshow can i get PO Revision History details – oracle EBS R12?
Hello Chandra, First thing the revision tables is: po_headers_all, po_headers_archive_all, po_lines_archive_all, po_line_locations_archive_all and po_distributions_archive_all Note: How the Purchasing Archive tables are updated when using Archive on Approve method for archiving (To setup Archive onRead more
Hello Chandra, First thing the revision tables is:
Note: How the Purchasing Archive tables are updated when using Archive on Approve method for archiving (To setup Archive on Approve go to Setup -> Purchasing -> Document Types) and here an example to understand and to get the revision’s of PO 1- We created new PO, sent it for approval 2- PO Approved Now run this query :
which is (&p_po_header_id) is ID for po has been created above. and here is the result expected:
3- Now add a new line in PO, then sent it for reapproval. 4- PO Approved Now run this query
So now from archive table you can get all revisions for particular PO.
See lessHow to change user password in oracle apps from backend?
Hi Sara,you can use : fnd_user_pkg.ChangePassword API to change or reset password for any user from database like this:[code]DECLAREl_user_name VARCHAR2(30):= UPPER('ORAASK');l_new_password VARCHAR2(30):= 'welcome123';l_status BOOLEAN;BEGINl_status := fnd_user_pkg.ChangePassword ( username => l_uRead more
Hi Sara,
you can use : fnd_user_pkg.ChangePassword API to change or reset password for any user from database like this:
[code]
See lessDECLARE
l_user_name VARCHAR2(30):= UPPER(‘ORAASK’);
l_new_password VARCHAR2(30):= ‘welcome123’;
l_status BOOLEAN;
BEGIN
l_status := fnd_user_pkg.ChangePassword ( username => l_user_name,
newpassword => l_new_password);
—
IF l_status THEN
dbms_output.put_line (‘The password changed successfully for the User:’||l_user_name);
COMMIT;
ELSE
DBMS_OUTPUT.put_line (‘Unable to reset password due to’||SQLCODE||’ ‘||SUBSTR(SQLERRM, 1, 100));
ROLLBACK;
END IF;
—
END;
[/code]
Is there SQL Function to add space inside string value?
You can use RPAD or LPAD functions with spaces select 'Ora' || rpad(' ',5,' ') || 'Ask' from dual;
You can use RPAD or LPAD functions with spaces
error when using FND_STANDARD_DATE valueset
Hi Maran The format mask for the FND_STANDARD_DATE data type is “YYYY/MM/DD HH24:MI:SS”. As a result, PLSQL procedure will receive a value like ‘2017/07/14 00:00:00’ as the date. so if you want to query from database you need to use this format : (2017/07/14 00:00:00) not '14-JUL-2017'
Hi Maran
The format mask for the FND_STANDARD_DATE data type is “YYYY/MM/DD HH24:MI:SS”. As a result, PLSQL procedure will receive a value like ‘2017/07/14 00:00:00’ as the date.
so if you want to query from database you need to use this format : (2017/07/14 00:00:00) not ’14-JUL-2017′
See lessWhat is the difference between binary_integer and pls_integer in pl/sql?
Hi, binary_integer and pls_integer both are same. Both are PL/SQL datatypes with range -2,147,648,467 to 2,147,648,467. Compared to integer and binary_integer pls_integer very fast in excution. Because pls_intger operates on machine arithmetic and binary_integer operes on library arithmetic. pls_intRead more
Hi,
binary_integer
andpls_integer
both are same. Both are PL/SQL datatypes with range -2,147,648,467 to 2,147,648,467.Compared to
integer
andbinary_integer
pls_integer
very fast in excution. Becausepls_intger
operates on machine arithmetic andbinary_integer
operes on library arithmetic.pls_integer
comes from oracle10g.
See lessbinary_integer
allows indexing integer for assocative arrays prior to oracle9i.