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.
REP-52262 Diagnostic output is disabled when using oracle reports 11g
Hi @albert To fix this error, you will need to apply the following: Go to %DOMAIN_HOME%\config\fmwconfig\servers\WLS_REPORTS\applications\reports_11.#\configuration and open rwservlet.properties (make a backup first). Add the following parameter below the <inprocess> parameter: <!–webcommanRead more
Hi albert
To fix this error, you will need to apply the following:
- Go to %DOMAIN_HOME%\config\fmwconfig\servers\WLS_REPORTS\applications\reports_11.#\configuration and open rwservlet.properties (make a backup first).
- Add the following parameter below the <inprocess> parameter:
- <!–webcommandaccess>L1</webcommandaccess–>
- Then change the value from L1 to L2
- <webcommandaccess>L2</webcommandaccess>
- Save and close the file
- Restart WLS_REPORTS
See lessOperating Units Merge
Hello @Mohammed Isa, I know one Saudi company that may help you in this regard. Could you please PM me in the website by providing your contact details, so that i can let them call you. Regards, Hassan
Hello Mohammed Isa,
I know one Saudi company that may help you in this regard. Could you please PM me in the website by providing your contact details, so that i can let them call you.
Regards,
Hassan
See lessOracle Alert Error – APP-ALR-04150 –
Hello @mahendra try this code now : SELECT DISTINCT PAA.ABSENCE_ATTENDANCE_ID ,PAA.ABSENCE_ATTENDANCE_TYPE_ID ,PAA.ABS_INFORMATION1 ,PAA.PERSON_ID ,PAPF.FULL_NAME FNA ,PAPF.EMAIL_ADDRESS EM ,PAA.REPLACEMENT_PERSON_ID ,PAPF1.FULL_NAME FNR ,PAA.AUTHORISING_PERSON_ID ,PAPF2.FULL_NAME FNAUT ,PAA.DATE_NORead more
Hello mahendra try this code now :
SELECT DISTINCT PAA.ABSENCE_ATTENDANCE_ID ,PAA.ABSENCE_ATTENDANCE_TYPE_ID ,PAA.ABS_INFORMATION1 ,PAA.PERSON_ID ,PAPF.FULL_NAME FNA ,PAPF.EMAIL_ADDRESS EM ,PAA.REPLACEMENT_PERSON_ID ,PAPF1.FULL_NAME FNR ,PAA.AUTHORISING_PERSON_ID ,PAPF2.FULL_NAME FNAUT ,PAA.DATE_NOTIFICATION ,PAA.DATE_START ,'\ \\\\\\for a period of \\\\\\\' || PAA.ABSENCE_DAYS || '\\\\\\\ days up to\\\\\\\' ,PAA.DATE_END INTO &ABSENCE_ATTENDANCE_ID ,&ABSENCE_ATTENDANCE_TYPE_ID ,&ABS_INFORMATION1 ,&PERSON_ID ,&FULL_NAME ,&EMAIL_ADDRESS ,&REPLACEMENT_PERSON_ID ,&FULL_NAME ,&AUTHORISING_PERSON_ID ,&FULL_NAME ,&DATE_NOTIFICATION ,&DATE_START ,&ABSENCE_DAYS ,&DATE_END FROM PER_ABSENCE_ATTENDANCES PAA ,PER_ALL_PEOPLE_F PAPF ,PER_ALL_PEOPLE_F PAPF1 ,PER_ALL_PEOPLE_F PAPF2 WHERE 1 = 1 AND PAA.ABSENCE_ATTENDANCE_ID = 132128 AND PAA.PERSON_ID = PAPF.PERSON_ID AND PAA.REPLACEMENT_PERSON_ID = PAPF1.PERSON_ID(+) AND PAA.AUTHORISING_PERSON_ID = PAPF2.PERSON_ID(+) AND TRUNC (SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE AND TRUNC (SYSDATE) BETWEEN PAPF1.EFFECTIVE_START_DATE AND PAPF1.EFFECTIVE_END_DATE AND TRUNC (SYSDATE) BETWEEN PAPF2.EFFECTIVE_START_DATE AND PAPF2.EFFECTIVE_END_DATEbut in the next time you create a question could you please leave more details about what you are trying to do or the error text along with error code you face to be able to help you efficiently.
See lessHow to list all OAF customizations of a particular instance ?
Hi @Chandra You can use this query to list all customizations across all modules SELECT PATH.PATH_DOCID CUSTM_DOC_ID, JDR_MDS_INTERNAL.GETDOCUMENTNAME (PATH.PATH_DOCID) CUSTM_DOC_PATH FROM JDR_PATHS PATH WHERE PATH.PATH_DOCID IN (SELECT DISTINCT COMP_DOCID FROM JDR_COMPONENTS WHERE COMP_SEQ = 0 ANDRead more
Hi Chandra
You can use this query to list all customizations across all modules
SELECT PATH.PATH_DOCID CUSTM_DOC_ID, JDR_MDS_INTERNAL.GETDOCUMENTNAME (PATH.PATH_DOCID) CUSTM_DOC_PATH FROM JDR_PATHS PATH WHERE PATH.PATH_DOCID IN (SELECT DISTINCT COMP_DOCID FROM JDR_COMPONENTS WHERE COMP_SEQ = 0 AND COMP_ELEMENT = 'customization' AND COMP_ID IS NULL) ORDER BY CUSTM_DOC_PATH;and if you want to get only specific module you can use following query:
SELECT PATH.PATH_DOCID PERZ_DOC_ID, JDR_MDS_INTERNAL.GETDOCUMENTNAME (PATH.PATH_DOCID) CUSTM_DOC_PATH FROM JDR_PATHS PATH WHERE PATH.PATH_DOCID IN (SELECT DISTINCT COMP_DOCID FROM JDR_COMPONENTS WHERE COMP_SEQ = 0 AND COMP_ELEMENT = 'customization' AND COMP_ID IS NULL) AND (JDR_MDS_INTERNAL.GETDOCUMENTNAME (PATH.PATH_DOCID)) LIKE '%/ar/%' ORDER BY CUSTM_DOC_PATH;See lessHow 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 less