This tech blog contains the solutions, queries related to Oracle EBS which come across real time Oracle EBS implementations/Customization. The content on this blog may help the Oracle EBS consultants at some extent. We appreciate your co-operation and understand in this regards. However every who visits this blog can comment on the posts with their views and patrons are encouraged to send any information they wanted to post in this blog.
Wednesday, April 02, 2014
Form personalization - Number
Creating softlink and registering Host concurrent program
How to find Oracle Apps password
Position Based Approval Hierarchy in Purchasing
Query to get HR Orgnization Grant Parent
SELECT OSE.organization_id_child,OU.organization_id,OU.name, OU.type
FROM (SELECT POSE.organization_id_child,
POSE.organization_id_parent
FROM per_org_structure_elements POSE
WHERE POSE.org_structure_version_id = (SELECT OSV.org_structure_version_id
FROM per_org_structure_versions OSV,
per_organization_structures OS
WHERE SYSDATE BETWEEN OSV.date_from AND NVL (OSV.date_to,SYSDATE + 1)
AND OS.ORGANIZATION_STRUCTURE_ID = OSV.ORGANIZATION_STRUCTURE_ID
AND UPPER(OS.name) = 'XX You Company' -------------------------------------------------------------
AND OS.primary_structure_flag = 'Y' ))OSE,
hr_all_organization_units OU
WHERE OSE.organization_id_parent = OU.organization_id
-- AND UPPER(OU.name) = 'GROUP 2'
AND OU.type = 'AGP'
CONNECT BY PRIOR organization_id_parent = organization_id_child
START WITH organization_id_child = (select paa.organization_id
from
per_all_people_F pea
,per_all_assignments_f paa
where pea.person_id=paa.person_id
and pea.person_id=:p_person_id
and sysdate between pea.effective_start_date and NVL(pea.effective_end_date,sysdate+1)
and sysdate between paa.effective_start_date and NVL(paa.effective_end_date,sysdate+1)
and paa.assignment_type='E')
SQL Query to get Oracle HR Organization Hierarchy
LPAD(' ',10*(LEVEL-1)) || org.name hierarchy,
org.organization_id
FROM
hr_all_organization_units org,
per_org_structure_elements pose
WHERE 1=1
AND porg.organization_id = pose.organization_id_child
AND pose.org_structure_version_id = 61
--and org.name like '201.Financiale Services'
START WITH
pose.organization_id_parent = 115 -- Orgnization of parent id -- provide the id from which level the downward hierarchy should be displaed
CONNECT BY PRIOR
pose.organization_id_child = pose.organization_id_parent
ORDER SIBLINGS BY
org.location_id,
pose.organization_id_child
SQL Query to get Oracle HR Organization Hierarchy
LPAD(' ',10*(LEVEL-1)) || org.name hierarchy,
org.organization_id
FROM
hr_all_organization_units org,
per_org_structure_elements pose
WHERE 1=1
AND porg.organization_id = pose.organization_id_child
AND pose.org_structure_version_id = 61
--and org.name like '201.Financiale Services'
START WITH
pose.organization_id_parent = 115 -- Orgnization of parent id -- provide the id from which level the downward hierarchy should be displaed
CONNECT BY PRIOR
pose.organization_id_child = pose.organization_id_parent
ORDER SIBLINGS BY
org.location_id,
pose.organization_id_child
Another work around for ieframe.dll error
If you are unable to uncheck the below option
Enable memory protection to help mitigate online attacks
goto c:\Program Files\Internet Explorer
right click on iexplore and select run as and administrator
then you should be able to uncheck Enable memory protection to help mitigate online attacks
if this does not work:
========================
Open internet browser
Goto tools --> Click Manage addons
Disable addons under Sun Microsystems
and restart the internet explorer and see
If that does not work
diable all the addons and try
PRC: Distribute Labor Costs erros with Signal 11
Oracle Apps Sample/Simple Resume Structure
Name : <Name in Full>
Contact No. : +(country Code) (Mobile)\
Mail id : xxxxx@xxxx.com
Experience Summary:
- X years of experience in <Technology> in the Development, Design, Testing, Coding
- Worked extensively on Oracle Manufacturing , System Administration modules
- Tasks executed as Computer Analyst, Programmer, Leading technical team/deliveries, documenting, handled onsite/offshore deliveries
- Extensively worked on RICE (Reports, Interfaces, Conversions and Extensions), Oracle Apps Framework development/extensions, customization, rollouts, migrations and upgrades in Oracle Applications
- Can work independently in understanding requirements, writing technical documents & application development using software development life cycle
| Employment | ||
| Organization | Designation | Duration |
<Present Company name> Oracle Consultant Jun 2009 - till date
<Previous Employer> <Position> Oct 2008 - Jun 2009
| Qualifications |
- Bachelor of Science (Computer Science) – Completed in 1993 - from XXXX University, India
Skills:
| Oracle E-Business Suite | R11 |
| Oracle Apps Modules | · Inventory (INV) · Oracle Projects |
| Tools associated to Oracle Apps | Oracle Developer/2000, Forms6i, Reports6i, SQL*Plus, SQL*Loader |
| Methodology | Oracle Application Implementation Methodology (AIM) |
| Databases | Oracle 9i,10g, Ms-Access |
| Other Tools and Utilities | Documentum, Ms-VSS |
| Operating Systems | HP-UX, IBM/AIX |
| Programming Languages | SQL, PL/SQL |
Work Expericne:
<Company>., <Location Optional ><Country Optional>
Duration: <From date> to <To date / Till date>
1)
Project : Ex: Oracle Applications Support and Development project
Client : <Client name>
Duration : From date to todate/till date
Roles & Responsibilities:
- Responsibility 1 Ex: Writing data conversion scripts
- Responsibility 2 Ex: Designing the technical document
- Responsibility 3 Ex: Responsible for raising TARs etc
- Responsibility 4 Ex: Developing Reports / Reviewing technical docs such as MD070 and MD120
Tools and Technologies:
Oracle R12, Oracle Financials (GL, AR, AP, FA), Workflow Builder, Oracle 10g, SQL, PLSQL, VSS and UNIX
2)
Project : Ex: Oracle Applications Upgrade
Client : <Client name>
Duration : From date to todate/till date
Roles & Responsibilities:
- Responsibility 1 Ex: Developing off scripts
- Responsibility 2 Ex: Designing the technical document
- Responsibility 3 Ex: Customizing workflows
- Responsibility 4 Ex: Developing Reports / Reviewing technical docs such as MD070 and MD120
Tools and Technologies:
Oracle R12, Oracle Financials (GL, AR, AP, FA), Jdeveloper, XML Publisher, TOAD, Workflow Builder, Oracle 10g, SQL, PLSQL, VSS and UNIX
……List of project in Chronological order with the organization that you worked for