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 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>);
How to order by number inside of character for a query like ’25 AB’ ,’30 MT’ ?
Use REGEXP_SUBSTR Syntax : REGEXP_SUBSTR( string, pattern [, start_position [, nth_appearance [, match_parameter [, sub_expression ] ] ] ] ) code : SELECT t.*, REGEXP_SUBSTR (COL1, '(d+)') as sort_by_col FROM test_table t Order by sort_by_col ; Result : application2 25 AB 30 AB 3125 50 50000 AS740TRead more
Use REGEXP_SUBSTR
See lessHow to convert text with comma separated to array in pl/sql ?
Use REGEXP_SUBSTR to Extract desired info REGEXP_SUBSTR( string, pattern [, start_position [, nth_appearance [, match_parameter [, sub_expression ] ] ] ] ) And CONNECT BY to loop over the string searching for the "," and use it as a delimiter. SELECT REGEXP_SUBSTR ('text1, text2, text3', '[^,]+',Read more
Use REGEXP_SUBSTR to Extract desired info
REGEXP_SUBSTR( string, pattern [, start_position [, nth_appearance [, match_parameter [, sub_expression ] ] ] ] )
And CONNECT BY to loop over the string searching for the “,” and use it as a delimiter.
SELECT REGEXP_SUBSTR (‘text1, text2, text3’,
See less‘[^,]+’,
1,
LEVEL),LEVEL
FROM DUAL
CONNECT BY REGEXP_SUBSTR (‘text1, text2, text3’,
‘[^,]+’,
1,
LEVEL)
IS NOT NULL;
Which 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 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 less