Friday, July 24, 2015

R12 Oracle Apps Login Page and Logo Hints

R12 Login Page: How to Personalize the Logo ? (Doc ID 849752.1)

Tips For Personalizing The E-Business Suite R12 Login Page (MainLoginPG) (Doc ID 741459.1)
Note 174219.1 - How To Change The Logo In The Oracle Application Menu
Note 849752.1 - R12 Login Page: How to Personalize the Logo ?
Note 741459.1 - Tips For Personalizing The E-Business Suite r12 Login Page (MainLoginPG)
Note 602995.1 - How To Change The Standard Oracle Logo in R12 Forms
Note 551795.1 - How to change the default branding on the homepage which shown as "E-Business Suite" ?
Note 421636.1 - How to replace the default Oracle Logo with a Customized Logo?
Note: 210670.1 - How To Change Look And Feel and Colors Of Oracle Applications 11.5


Note: 759551.1 - After Upgrading From 11i to R12 Custom Forms Show Blue Text Fields
R12: Font And Links Have Changed After Patching (Doc ID 1348791.1)

Look And Feel Of Self Service EBS Application Has Changed Since Upgrade To R12 And Patching (Doc ID 1595057.1)
R12: Font And Links Have Changed After Patching (Doc ID 1348791.1)
Look And Feel Of Self Service Pages Are Messed After R12 Upgrade (Doc ID 1556590.1)

NOTE:391554.1 - Oracle Application Framework Documentation Resources, Release 12
NOTE:473539.1 - How to Replace the Globe and People Images of the Release 12 Login Page
NOTE:849752.1 - R12 Login Page: How to Personalize the Logo ?
NOTE:315865.1 - How To Remove The Oracle Privacy Statement Link From SSHR Page in OA Framework 11.5.10 ?
NOTE:1272885.1 - How to Hide the Privacy Statement and Copyright Statement from iRecruitment External Candidate Pages
NOTE:1066683.1 - Entering custom text with html code on login page

NOTE:357458.1 - How to Change the Privacy Statement URL to a Custom URL in iRecruitment

NOTE:468971.1 - Tips For Personalizing The E-Business Suite 11i & 12i Login Page (AppsLocalLogin)
NOTE:344204.1 - How to use XMLImporter/XMLExporter to import/export personalization
NOTE:436092.1 - Privacy Statement is not Hidden in iRecruitment Visitor Home Page even though Personalization has been Created
NOTE:579917.1 - How to Personalize Login page in R12?

R12 - Application font, colour, feel and looks Issues after applying patch

Look And Feel Of Self Service EBS Application Has Changed Since Upgrade To R12 And Patching (Doc ID 1595057.1)
R12: Font And Links Have Changed After Patching (Doc ID 1348791.1)
Look And Feel Of Self Service Pages Are Messed After R12 Upgrade (Doc ID 1556590.1)


 Solution:
++ Remove the files from the following directories
      $OA_HTML/cabo/images/cache/*
      $OA_HTML/cabo/styles/cache/*
++ Re-start the application(adstrtal.sh)
++ Delete the cache from browner and retry the Application URL

>> If you still have the problem

++ Remove the files from the following directories
      $OA_HTML/cabo/images/cache/*
      $OA_HTML/cabo/styles/cache/*
++ perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile -p 6 -log /tmp/ojspCompile.log --flush

Wednesday, July 22, 2015

How to find out the query fetching the serial numbers in th LOV using the trace file o/p

How to find out the query fetching the serial numbers in th LOV using the trace file o/p

Use the following steps to enable trace.
 a. Navigate to the point in the application right before you are
 experiencing the problem.
 b. Turn trace on by:
  Help > Diagnostics > Trace > Trace with Binds and Waits
 c. Duplicate the issue and then stop immediately afterwards.
 d.  Retrieve trace file from the user_dump_dest, which can be located as
 follows:
  select value from V$PARAMETER where name like 'user%';

 e. In the raw trace file ,search for the table 'Mtl_serial_numbers'
This will you take you to the query used in the LOV to fetch those serial numbers.

Tuesday, July 14, 2015

iRecruitment Internal Vacancies/Jobs SQL Query


SELECT pav.NAME, ipc.org_name, ipc.job_title, pgt.NAME,
       ipc.posting_content_id, pav.status, pav.date_from, pav.date_to,
       hl.location_code, pav.attribute19,
       REPLACE (regexp_replace (ipc.brief_description, '<[^<>]*>', ''),
                ' ',
                ''
               ) brief_description,
       REPLACE
             (regexp_replace (ipc.detailed_description, '<[^<>]*>', ''),
              ' ',
              ''
             ) detailed_description,
       REPLACE (regexp_replace (ipc.job_requirements, '<[^<>]*>', ''),
                ' ',
                ''
               ) job_requirements,
       REPLACE (regexp_replace (ipc.additional_details, '<[^<>]*>', ''),
                ' ',
                ''
               ) additional_details,
       REPLACE (regexp_replace (ipc.how_to_apply, '<[^<>]*>', ''),
                ' ',
                ''
               ) how_to_apply
  FROM irc_posting_contents_tl ipc,
       per_all_vacancies pav,
       hr_locations_all hl,
       per_grades_tl pgt,
       per_recruitment_activities pra
 WHERE 1 = 1
   AND pav.primary_posting_id = ipc.posting_content_id
   AND ipc.posting_content_id = pra.posting_content_id
   AND ipc.LANGUAGE = 'US'
   AND pav.location_id = hl.location_id
   AND pav.grade_id = pgt.grade_id
   AND pgt.LANGUAGE = 'US'
   AND pra.recruiting_site_id = 1
   AND pav.status NOT IN ('CLOSED', 'CNCL', 'HOLD')
   AND job_title IS NOT NULL;

Wednesday, July 8, 2015

SQL Query for Interface Managers

--Admin Interface Managers
SELECT   x.process_type "Name",
         DECODE ((SELECT '1'
                    FROM apps.fnd_concurrent_requests cr,
                         apps.fnd_concurrent_programs_vl cp,
                         apps.fnd_application a
                   WHERE cp.concurrent_program_id = cr.concurrent_program_id
                     AND cp.concurrent_program_name = x.process_name
                     AND cp.application_id = a.application_id
                     AND a.application_short_name = x.process_app_short_name
                     AND phase_code != 'C'),
                 '1', 'Active',
                 'Inactive'
                ) "Status"
    FROM (SELECT mipc.process_code, mipc.process_status,
                 mipc.process_interval, mipc.manager_priority,
                 mipc.worker_priority, mipc.worker_rows,
                 mipc.processing_timeout, mipc.process_name,
                 mipc.process_app_short_name, a.meaning process_type,
                 FLOOR (mipc.process_interval / 3600) process_hours,
                 FLOOR (  (  mipc.process_interval
                           - (FLOOR (mipc.process_interval / 3600) * 3600)
                          )
                        / 60
                       ) process_minutes,
                 (  mipc.process_interval
                  - (FLOOR (mipc.process_interval / 3600) * 3600)
                  - (  FLOOR (  (  mipc.process_interval
                                 - (FLOOR (mipc.process_interval / 3600)
                                    * 3600
                                   )
                                )
                              / 60
                             )
                     * 60
                    )
                 ) process_seconds,
                 FLOOR (mipc.processing_timeout / 3600) timeout_hours,
                 FLOOR (  (  mipc.processing_timeout
                           - FLOOR (mipc.processing_timeout / 3600) * 3600
                          )
                        / 60
                       ) timeout_minutes
            FROM apps.mtl_interface_proc_controls mipc, apps.mfg_lookups a
           WHERE a.lookup_type = 'PROCESS_TYPE'
             AND a.lookup_code = mipc.process_code) x
   WHERE DECODE ((SELECT '1'
                    FROM apps.fnd_concurrent_requests cr,
                         apps.fnd_concurrent_programs_vl cp,
                         apps.fnd_application a
                   WHERE cp.concurrent_program_id = cr.concurrent_program_id
                     AND cp.concurrent_program_name = x.process_name
                     AND cp.application_id = a.application_id
                     AND a.application_short_name = x.process_app_short_name
                     AND phase_code != 'C'),
                 '1', 'Active',
                 'Inactive'
                ) = 'Inactive'
ORDER BY 1;

SQL Query for Concurrent Request Failures

--Admin Concurrent Request Failures

SELECT DISTINCT cr.request_id, cr.description,
                cp.user_concurrent_program_name, u.user_name,
                cr.actual_start_date
           FROM apps.fnd_lookup_values lv,
                apps.fnd_concurrent_programs_vl cp,
                apps.fnd_executables e,
                apps.fnd_concurrent_requests cr,
                apps.fnd_user u
          WHERE e.executable_id = cp.executable_id
            AND lv.lookup_type = 'CP_EXECUTION_METHOD_CODE'
            AND lv.lookup_code = e.execution_method_code
            AND cr.concurrent_program_id = cp.concurrent_program_id
            AND cr.requested_by = u.user_id
            AND u.user_name IN
                             ('TFADMIN', 'BIADMIN', 'SYSADMIN', 'SHAZ052036')
            AND cr.status_code = 'E'
            AND cr.phase_code = 'C'
            AND TRUNC (cr.actual_start_date) >= TRUNC (SYSDATE - 1)
       ORDER BY cr.actual_start_date DESC, cr.request_id;

SQL query for Concurrent Request Paused Jobs

--Admin Concurrent Request Paused Jobs

SELECT DISTINCT cr.request_id, cr.description,
                cp.user_concurrent_program_name, u.user_name,
                cr.actual_start_date
           FROM apps.fnd_lookup_values lv,
                apps.fnd_concurrent_programs_vl cp,
                apps.fnd_executables e,
                apps.fnd_concurrent_requests cr,
                apps.fnd_user u
          WHERE e.executable_id = cp.executable_id
            AND lv.lookup_type = 'CP_EXECUTION_METHOD_CODE'
            AND lv.lookup_code = e.execution_method_code
            AND cr.concurrent_program_id = cp.concurrent_program_id
            AND cr.requested_by = u.user_id
            AND u.user_name IN ('TFADMIN', 'BIADMIN', 'SYSADMIN')
            AND cr.status_code = 'W'
            AND cr.phase_code = 'R'
            AND TRUNC (cr.actual_start_date) >= TRUNC (SYSDATE - 1)
       ORDER BY cr.actual_start_date DESC, cr.request_id;