Sunday, September 28, 2014

How to find employee salary details from oracle payroll tables

SELECT papf.employee_number
,papf.full_name
,pj.NAME job
,haou.NAME ORGANIZATION
,ppp.proposed_salary_n salary
FROM per_all_people_f papf
,per_all_assignments_f paaf
,per_jobs pj
,hr_all_organization_units haou
,per_position_definitions ppd
,per_all_positions pap
,per_pay_proposals ppp
WHERE 1 = 1
AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date
AND papf.current_employee_flag = 'Y'
AND papf.employee_number IS NOT NULL
AND paaf.person_id = papf.person_id
AND SYSDATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date
AND paaf.job_id = pj.job_id
AND paaf.organization_id = haou.organization_id
AND paaf.position_id = pap.position_id
AND pap.position_definition_id = ppd.position_definition_id
AND ppp.pay_proposal_id = (SELECT MAX (pay_proposal_id)
FROM per_pay_proposals
WHERE assignment_id = paaf.assignment_id)

Thursday, September 25, 2014

Java HotSpot(TM) Server VM warning: You have loaded library /u01/install/APPS/apps/tech_st/10.1.2/lib/librwu.so which might have disabled stack guard. The VM will try to fix the stack guard now. It's highly recommended that you fix the library with 'execstack -c ', or link it with '-z noexecstack'.

Error:

Upgraded several EBS 12.1.3 environments to Java 7 following note 1467892.1.

The upgrade seems to have went well - but in every case concurrent programs which use Oracle Reports log the following in the request logs on every run:

Java HotSpot(TM) Server VM warning: You have loaded library /u01/app/appltst1/apps/tech_st/10.1.2/lib/librwu.so which might have disabled stack guard. The VM will try to fix the stack guard now.
It's highly recommended that you fix the library with 'execstack -c ', or link it with '-z noexecstack'.

Otherwise all requests appear to complete normally.

SOLUTION

Please apply Reports Patch: 17645157 to the 10.1.2.3 Oracle Home and confirm that this resolves the issue.


NOTE: As documented in bug: 17762579, the rollback of patch 16207165 is expected. Patch 17645157 has only been ported for LINUX.

How to apply this Patch:

==============================
Interim Patch for Bug: 17645157
==============================

Date                 : Aug 25 2014
---------------------------------
Platform Patch for   : Linux
Product Patched      : Oracle reports
Product Version      : 10.1.2.3.0
Auto Enabled         : No

This document describes how to install the interim patch for
bug # 17645157. It includes the following sections:

       Section 1, "Prerequisites"

       Section 2, "Pre-Installation Instructions"

       Section 3, "Installation Instructions"

       Section 4, "Post-Installation Instructions"

       Section 5, "Deinstallation Instructions"

       Section 6, "Post Deinstallation Instructions"

       Section 7, "Bugs Fixed by This Patch"

1 Prerequisites
----------------

1. For non-recommended patches, you must have the exact symptoms
   described in the service request (SR).

2. Confirm the version of Perl installed and configured for the ORACLE_HOME.

Oracle requires that all customers have at least Perl 5.00503 installed
and configured for patching activities inside the ORACLE_HOME.  Follow
these steps to check the Perl version for the ORACLE_HOME being patched:

  - source the ORACLE_HOME environment
  - execute "perl -v"
  - verify that the returned version of Perl is 5.00503 or higher

If the Perl configured for the ORACLE_HOME is not at 5.00503 or
higher, follow the directions in this My Oracle Support note to update to
a more recent version:

Note 189489.1 - Oracle Data Server Interim Patch Installation
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=189489.1

3.  Verify the OUI Inventory.

OPatch needs access to a valid OUI inventory to apply patches.
Validate the OUI inventory with the following command:

  opatch lsinventory

If the command errors out, contact Oracle Support and work to validate
and verify the inventory setup before proceeding.

4.  Review and download the latest version of OPatch.

Oracle recommends that all customers be on the latest version of OPatch.
Please review the following My Oracle Support note and follow the instructions
to update to the latest version if needed:

Note 224346.1 - Opatch - Where Can I Find the Latest Version of Opatch? 
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=224346.1

5.  Confirm executables appear in your system PATH.

The patching process will use the unzip and the opatch executables.  After
sourcing the ORACLE_HOME environment, confirm both of these exist before
continuing:

  - "which opatch"
  - "which unzip"

If either of these executables do not show in the PATH, correct the problem
before proceeding.

2 Pre-Installation Instructions
-------------------------------

N/A


3 Installation Instructions
---------------------------

1. Unzip the patch zip file into the PATCH_TOP.

   $ unzip -d PATCH_TOP p17645157_101230_Linux.zip

    NOTE: In WINDOWS, the unzip command might not work as this zip has
    certain contents which passes the 256 characters limit.
    To overcome this problem, please use alternate ZIP utility like
    7-Zip to unzip the patch.

    For example: To unzip using 7-zip, run the command:
         "c:\Program Files\7-Zip\7z.exe"  x p17645157_101230_Linux.zip

2. Set your current directory to the directory where the patch is located.

   $ cd PATCH_TOP/17645157

3. Run OPatch to apply the patch.

       $ opatch apply

When OPatch starts, it validates the patch and makes sure that there are no
conflicts with the software already installed in the ORACLE_HOME.
  OPatch categorizes two types of conflicts:

     a. Conflicts with a patch already applied to the ORACLE_HOME
        In this case, stop the patch installation, and contact Oracle Support
        Services.

     b. Conflicts with subset patch already applied to the ORACLE_HOME
        In this case, continue the install, as the new patch contains all the
        fixes from the existing patch in the ORACLE_HOME.

Important Instruction:
----------------------

   Relink the reports
   cd $ORACLE_HOME/reports/lib
   make -f ins_reports.mk install


4 Post-Installation Instructions
---------------------------------

   N/A

5 Deinstallation Instructions
------------------------------

If you experience any problems after installing this patch, remove the patch as
follows:

1. Make sure to follow the same Prerequisites or pre-install steps (if any)
   when deinstalling a patch.
   This includes setting up any environment variables like ORACLE_HOME and
   verifying the OUI inventory before deinstalling.

2. Change to the directory where the patch was unzipped.

   $ cd PATCH_TOP/17645157

3. Run OPatch to deinstall the patch.
   
   $ opatch rollback -id 17645157

6 Post Deinstallation Instructions
-----------------------------------

N/A

7 Bugs Fixed by This Patch
--------------------------
The following are the bugs fixed by this patch:

17645157 - APPS6:GETTING JAVA SERVER VM WARNING WITH 10.1.2 ORACLE_HOME EXE , JDK 1.7.0_40
                                                                                                                                                                                                              

-----------------------------------------------------------------------------
DISCLAIMER:

This interim patch has only undergone basic unit testing, and has not been
through a complete test cycle generally followed for a production patch set.
Though the fixes in this document rectifies the bug, Oracle Corporation will
not be responsible for other issues that may arise due to these fixes.
Oracle Corporation recommends to later upgrade to the next production patch
set, when available. Applying this patch could overwrite other interim
patches applied since the last patch set. Customers need to make a request
to Oracle Support for a patch that includes those fixes, as well as inform
Oracle Support about all the patches installed when a Service Request is
opened. Please download, test, and provide feedback as soon as possible
to assist in the timely resolution of this problem.

Copyright (c) 2014, Oracle and/or its affiliates. All rights reserved.
-----------------------------------------------------------------------------


Wednesday, September 24, 2014

Not able to populate retained earning account in ledger setup in 12.2.3 - "Please choose an existing combination"

Issue:

Not able to populate retained earning account in ledger setup.
First time Create button is set, it displays the error message: Please choose an existing combination
Then pressing the Create button does nothing.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup-->ASM-->Ledger


Solution:

To implement the solution, please execute the following steps:

1. Download and review the readme and pre-requisites for Patch:18123067>:R12.FND.C

2. Ensure that you have taken a backup of your system before applying the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:
KeyFlexfield.java 120.12.12020000.3
You can use the commands like the following:
strings -a $JAVA_TOP/oracle/apps/fnd/flexj/KeyFlexfield.class | grep '$Header'

5. Bounce the instance after applying the patch

6. Re-test the issue.

7. Migrate the solution as appropriate to other environments.