Thursday, 11 January 2018

Global Self Service Functions Custom and Manager Actions Menu

To include a new cutom SSHR menu option, use the following instructions.

1. Create the Custom Workflow as per the business process. Create a form function (copy a seeded ESS function) for ESS process. Make the following changes to the definition
a. Change parameter pProcessName so that it refers to the desire workflow process
b. Change parameter pCalledFrom so that it includes the internal name of the function being created
c. Change the value passed to OAFunc (HTML Call) to include the internal name of the function being created

2. Create a Form function for MSS based on any seeded MSS function. Change the value of the parameter pCalledFrom so that it refers to the internal name of the ESS function

3. Include the newly created ESS and MSS form functions in "Global Self Service Functions Custom" menu

4. Include the newly created ESS function in "Manager Actions Menu"

5. If the process is required in the ESS menu Include the newly created ESS form function in the Employee Self Service Menu

6. If the process is required in the MSS menu Include the newly created MSS form function in the Employee Self Service Menu

Please note that these steps are only relevant for SSHR. They may not work for other modules.

APP-PAY-06153:System Error. Procedure INIT_FORMS at Step 1

The above error is encountered when we try to open a form without assigning the HR: Security Profile profile option to the responsibility.

Tuesday, 9 January 2018

Balance Initialization

Balance Initialization
------------------------------
Balance initialization is used primarily to set up balances from legacy systems in case of mid year payroll implementations. If a payroll is implemented at the beginning of a tax year, it may not require initial balances. However, if a payroll is implemented in the middle of a tax year, balance initialization is important to ensure accurate calculations and payroll reporting.

Define your Element with Primary Classification = ‘Balance Initialization’

1)      Must be `Adjustment Only'
2)      Must be a non recurring type
3)      Must be processable in a payroll run
4)      Must be ‘Last Standard Process

Should default to these when ‘Balance Initialization’ is chosen

Now create Input Values

1)      Must have a start date 01-JAN-0001
2)      Each input value must feed only one balance
              If you need to set initial values for a large number of balances you can define
              Multiple input values for a single element with each input value feeding
              different balance.

Now Define an Element Link

1)      Must have a start date 01-JAN-0001
2)      Criteria must be only Link To All Payrolls - 'Yes'

Now use your Element as an Initial Feed for the Balance you wish to upload

Navigate
Total Compensation -> Basic -> Balance

Query up the Balance you want to upload initial values for

Click on Initial Feed

Under Element Name select your Initialization Element from the list of Values

Select the Input value

Save

Now Navigate back to your Balance Initialization Element

Click on Balance Feeds and you will see that this Element will feed your balance. The Initial Upload Process with create the necessary run result for this Element to populate your balance with its Initial Balance value

Costing related information Oracle Payroll

Different types are
1) Costed
2) Fix Costed
3) Distributed

1) Costed
---------------
When an element link is costed, then all five levels of costing are considered. It is important to note that this type allows you to use assignment level costing. This means you can split the run result values over more than one set of cost codes. This is done on the Assignment costing screen, you are able to enter percentages for specific sets of segments, the sum of these must be 100 percent.

2) Fix Costed
--------------------
Fix costed doesnt use assignment level and organization level costing.

3) Distributed
-------------------
A Distribution Set of elements is created(Element Set). Then this distribution set is linked at element link level.The element is then costed as a member of the distribution set, so the costing result is divided by the sum of the distribution set costings and multiplied by the number of members in the set.



Snippets from Oracle Help Page:
Select the Costable Type. The default is Not Costed, meaning that the system maintains no costing information for the element.
  • To allow entry of costing information at all levels, including the assignment and element entry levels, select Costed This is the appropriate selection for most elements representing earnings types.
  • If you do not need to cost the element at organization and assignment levels, select Fixed Costed. This is appropriate for some deductions, which are irrelevant to labor distribution analyses.
  • If you want to distribute overhead costs (such as employer contributions to a pension plan) over other elements, select Distributed.Then select a Distribution Set.
Note: Some element classifications for your legislation may be predefined as Not Costed and you cannot override this.

Sunday, 7 January 2018

Checklists and Approvals

Use AME for approvals of checklists.
Transaction Type - Checklist
approvals attribute - CHECKLIST_ATTRIBBUTE

In Checklist task definition add Approvals Identifier.
You can use Oracle Approvals Management (AME) to generate a list of performers for the task. To activate AME, you select a value in the Approvals Identifier field of the Checklist Tasks page. The application retrieves the values available for selection from the values you have defined in AME and used in the AME conditions. You can create approval rules based on the task and person's details such as business group, organization name, job, position, or supervisor name.


1)     Create PQH roles(update: When PQH roles were added to approver groups then approvals were not sent)
2)      Create approver groups in AME under Checklist Transaction types
3)      Create conditions using CHECKLIST_TYPE attribute
4)      The above value is passed from Checklist’s task definition from Approval Identifier

5)      Create rules

Make sure that the user has an employee attached or else the task will not be triggered.

Thursday, 28 December 2017

Query to fetch Menu's sub menus and function names

Select fmv.menu_id, 
                  Lpad (Level, Level) || Decode (fffv.function_name, Null, ' >') "Level  ", 
                  fmev.entry_sequence seq, 
                  fmv.menu_name, 
                  fmv.user_menu_name, 
                  Nvl (fmev.prompt, '##### NOT DISPLAYED #####') prompt, 
                  Nvl (fffv.function_name, '***** SUB-MENU *****') function_name, 
                  Nvl (fffv.user_function_name, '***** SUB-MENU *****') user_function_name, 
                  fffv.parameters 
             From fnd_menu_entries_vl fmev, fnd_menus_vl fmv, fnd_form_functions_vl fffv 
            Where fmv.menu_id = fmev.menu_id And fffv.function_id(+) = fmev.function_id And Nvl (fmev.grant_flag, 'N') = 'Y' 
       Start With fmv.menu_name =  :start_menu_name 
       Connect By Prior fmev.sub_menu_id = fmev.menu_id 
Order Siblings By fmev.entry_sequence  

Wednesday, 20 December 2017

Back end tables storing data for Job related Special Info. Type(SIT)

I am currently working on a requirement to insert/update/delete some Job related SIT info. This SIT screen would open when we click on the requirements button Job form in works structures.

Generally person related SIT data is stored in per_person_analyses and per_analysis_criteria tables, which is known to most of us. But what about Job related SIT?

In case of Job related SIT, data is stored in 2 tables- per_analysis_criteria and the other table is per_job_requirements. You will not find the analysis_criteria_id in per_person_analyses table, but you can find the same in per_job_requirements table.

per_analysis_criteria,per_job_requirements---join and query them and check the output.