.

Wednesday, April 02, 2014

Form personalization - Number


Numeric validation in form personalization
 
Trigegr event: WHEN-VALIDATE-RECORD
 
Trigger object : ACCOUNTS
 
DECODE(TRANSLATE(:ACCOUNTS.BANK_ACCOUNT_NUM,'1234567890','0000000000'),LPAD('0',LENGTH(:ACCOUNTS.BANK_ACCOUNT_NUM),'0'),'NUMBER','NOT NUMBER')='NOT NUMBER'
 
ex: if 33123-33 is entered, then decode convers the code as 00000-00 and LPAD function returns 0000000 , hense mismatchin and not Number.
 
 

Creating softlink and registering Host concurrent program


1. Create a host file in required TOP
 
Ex: $XXGL_TOP/bin/XXGL_EMAIL.prog (the extension can be any thing)
 
2. Create a softlink using the below command (execute this command in the same path $XXGL_TOP/bin)
 
ln -s $FND_TOP/bin/fndcpesr  XXGL_EMAIL.prog
 
3. Then use the below command
 
XXGL_EMAIL XXGL_EMAIL.prog
 
4. Register the executable with XXGL_EMAIL and concurrent program and run.
 
 

How to find Oracle Apps password

Oralce apps password is stored in a file called wdbsvr.app on application server
 
in the below path
 
$IAS_ORACLE_HOME/Apache/modplsql/cfg
 
Generally this is not accessible by with your unix access. Only administrator can access.

Position Based Approval Hierarchy in Purchasing

Query to get HR Orgnization Grant Parent

Here is the query to get grant parent of organization
 
 

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

SQL Query to get Oracle HR Organization Hierarchy
 
 
SELECT
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

SQL Query to get Oracle HR Organization Hierarchy
 
 
SELECT
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

When you are extending the "PRC: Distribute Labor Costs" program and it fails with - Program was terminated by signal 11 error. Please check the following.
 
Go to Project
Setup -> System -> Implementation Options
 
Go to Expnd/Costing Tab
Uncheck - "Enable Overtime Calculations"  check box and save.
 
The "Program was terminated by signal 11 error" might occur for different reasons but while extending prc distribute labor costs program this is only the fix as per oracle support.
 
We also abserved that this program did not error when it was ran with ONLY Batch name / Project Number as parameters. We had faced the error when Batch name, project number and employee name are provided as parameters at same time.

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