EVENT_STATUS_CODE and PROCESS_STATUS_CODE in XLA_EVENTS Table R12

 EVENT_STATUS_CODE and PROCESS_STATUS_CODE in XLA_EVENTS Table

**  EVENT_STATUS_CODE

** PROCESS_STATUS_CODE

Note:  If an event has event_status_code = P and process_status_code = F but is still in xla_ae_headers with GL_Transfer = No, then the event has successfully processed and just needs to be manually transferred to GL.

Manual GL Transfer can be completed via the concurrent request Transfer Journal Entries to GL - Assets (or for other modules = Transfer Journal Entries to GL), reference Note 459680.1.

Add Favorite icon in oracle apex 5.0

Steps to do it: 

Edit you're application (In my case it is Sample Charts)
Go to shared component.
Go to Application Definitions Attributes
Go To Substitutions Section and add substitution name: APP_FAVICONS as the following shot:

Oracle APPS (EBS) Arabic characters are displaying as question

Oracle APPS (EBS) Arabic characters are displaying as question

Oracle APPS EBS reports showing Arabic Characters as ????? ؟؟؟؟ . 

solution 1 : 

  

    Check ALBAN*.ttf files exists in the directory $OA_JRE_TOP/lib/fonts/

ls -l $OA_JRE_TOP/lib/fonts/ALBAN*.ttf

Solution 2: 

    1. Login as SYSADMIN

    2 System Adminstrator --> Profile --> System
    3 Check the profile option "FND: NATIVE CLIENT ENCODING" is set to the database character                  AR8WIN1256    OR UTF8 

    

Thanks , i hope this helps you, 

   

How to change Concurrent Request View output to view in browser

To view Concurrent Program log file in Browser:

Reports that produce an output other than a text file (for example HTML or PDF) are displayed in a browser. If you set the profile option VIEWER: TEXT to Browser.

Thank you,

CHANGE ORACLE APEX 5.1 APPLICATION LOGO

To change Apex Application Logo you should do the following steps:

1. 1. You should open application you want to change its logo.
   2. Open shared components.
   3. Then go to static application files
   4. Then upload your logo and make sure to copy reference.
   5. Go back to shared components and open user interface attributes.
   6. Change logo type from text to image then past reference to logo field.

ORACLE APEX 5.1 APPLICATION TRANSLATION

Follow these steps to translate oracle APEX application:

==> you should set primary language for application that you are working on.

Go App Builder > Select your application > Shared Components > Globalization            Attributes.

According to the previous picture we suppose that we are working on application with English language as primary language and document direction left to right.

==> Start translation by going to Shared components > Translation.

Translation process goes through multiple steps:

1. Define Application languages: to map primary language application to translated application.

suppose that we want to translate our application to Arabic language, we should create application language mapping as the following picture:

2. Seed Translatable text to copy the translatable text from the primary application into the translatable repository.

3. Download XLIFF translation file from repository.

4. translate XLFF file manually or from repository.

XLF file will look like the following picture

Source: application primary language.

target : translated text.

5. Upload XLF file with translated text and apply translation to translation repository.

6. Publish translated application to make it available to users.

7. After that you should go to application primary language and change it to Arabic so that you can see the translation.

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.