REP-52262 Diagnostic output is disabled when using reports server 11g on new installation

You may have noticed that when you have a new installation of  reports 11.1.2.0 when you try to run a PDF report or even if you simply try to do a  showjobs request you get the error REP-52262 Diagnostic output is disabled. It seems that in a new installation for security reasons diagnostic output from the URL is disabled by default.

To fix this error, you will need to apply the following:

1. Go to %DOMAIN_HOME%\config\fmwconfig\servers\WLS_REPORTS\applications\reports_11.#\configuration and open rwservlet.properties (make a backup first).
2. Add the following parameter below the <inprocess> parameter:
   • <!–webcommandaccess>L1</webcommandaccess–>
   • Then change the value from L1 to L2 
   • <webcommandaccess>L2</webcommandaccess>
3. Save and close the file
4. Restart WLS_REPORTS

Hope this works. 

Oracle APPS Query to Get File Version

/*

Using this Query to get Oracle APPS files version

 */

SELECT sub.filename, sub.version

  FROM (SELECT adf.filename filename,

               afv.version version,

               RANK ()

                   OVER (PARTITION BY adf.filename

                         ORDER BY afv.version_segment1 DESC,

                                  afv.version_segment2 DESC,

                                  afv.version_segment3 DESC,

                                  afv.version_segment4 DESC,

                                  afv.version_segment5 DESC,

                                  afv.version_segment6 DESC,

                                  afv.version_segment7 DESC,

                                  afv.version_segment8 DESC,

                                  afv.version_segment9 DESC,

                                  afv.version_segment10 DESC,

                                  afv.translation_level DESC)

                   AS rank1

          FROM ad_file_versions afv,

               (SELECT filename,

                       app_short_name,

                       subdir,

                       file_id

                  FROM ad_files

                 WHERE UPPER (filename) LIKE UPPER ('%&FileName%')) adf

         WHERE adf.file_id = afv.file_id) sub

 WHERE rank1 = 1

ORDER BY 1;



Hope This help you,

Close Oracle Open Notifications wf_notifications

 Closing WFERROR Notifications

/*

To Close Error Notifications use the Below Procedure :

 */

DECLARE

    CURSOR c_notif

    IS

        SELECT notification_id

          FROM wf_notifications

         WHERE     status = 'CLOSED'

               AND MESSAGE_TYPE = 'WFERROR'

               AND begin_date < SYSDATE - 1;

--AND ADDITIONAL CRITERIA THAT ALLOW TO LIST ALL THE FYI NOTIFICATIONS TO BE CLOSED>;

BEGIN

    FOR n IN c_notif

    LOOP

        wf_notification.close (n.notification_id, 'SYSADMIN');

    END LOOP;

--COMMIT;

END;

"Output Post Processor" Concurrent Manager not able to start R12.1

I tried to restart but still getting the same status. Later on I tried to query the "FNDOPP"
 process on the application tier
$ ps -ef|grep -i FNDOPP|grep -v grep

Manager Log Said: 

Unable to initialize state monitor.

oracle.apps.fnd.cp.gsm.GenCartCommException: ORA-01422: exact fetch returns

more than requested number of rows

ORA-06512: at "APPS.FND_CP_GSM_IPC", line 499
ORA-06512: at line 1


 at oracle.apps.fnd.cp.gsm.GenCartComm.initService(GenCartComm.java:233)
at oracle.apps.fnd.cp.gsm.GenCartComm.<init>(GenCartComm.java:80)

 at oracle.apps.fnd.cp.gsf.GSMStateMonitor.<init>(GSMStateMonitor.java:62)
at oracle.apps.fnd.cp.gsf.GSMStateMonitor.init(GSMStateMonitor.java:74)

 at oracle.apps.fnd.cp.gsf.GSMServiceController.<init>(GSMServiceController.java:66)
at oracle.apps.fnd.cp.gsf.GSMServiceController.init(GSMServiceController.java:111)

 at oracle.apps.fnd.cp.gsf.GSMServiceController.main(GSMServiceController.java:428)

Solution:

I restarted "Service Manager" and then restarted "Output Post Processor".

 Concurrent manager started successfully.

As the image Above.

Thanks.

How to reset Workspace user password in apex

1. To Reset Workspace User Password

Click Administration dropdown which you will find at the top right main menu of your workspace. then click Mange users and Groups, edit the user name and go into his profile and reset password.

2. To Reset Workspace admin password

login Internal workspace.  ( Worspace name = Internal, user name = admin, password = <type password>)

Select Administration menu  then Mange user and Groups

You will get the enire workspace and it's user list, edit  the required user to reset it's password.

3. To reset Internal admin Password

If you can't login into internal workspace for wrong password then you can reset the admin password running the script apxchpwd.sql which you will find in the Apex installation files. Remember to run this scipt you must have to login to the database using SYS with SYSDBA privilege.