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 find dbc file in oracle apps ?
Hello @chandra to find dbc file in release 11i $FND_TOP/secure and to find dbc file in release 12 $INST_TOP/appl/fnd/12.0.0/secure hope this help.
Hello Chandra
to find dbc file in release 11i
and to find dbc file in release 12
hope this help.
See lessWhat 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 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 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 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;