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".
ORA-12705 invalid or unknown NLS parameter value specified error when connect to oracle 11g from a php application
Hello Waqas, ORA-12705 invalid or unknown NLS parameter value specified Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or characRead more
Hello Waqas,
ORA-12705 invalid or unknown NLS parameter value specified
Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or character set.
Action: Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable. For more information about the syntax of the ALTER SESSION command, see Oracle8i SQL Reference.
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 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