Author Archives: ashishszone

Oracle Human Capital Management Course Online


Learn Oracle 11i/R12 Human Capital Management *HCM/HRMS, online at your own pace and time. Also, you can use the same course on your mobile devices like iPhone, iPad and other smart phones or tablets.

Udemy offers many online courses, including HCM- Link Here https://www.udemy.com/oracle-human-capital-management

The course is only $15, and totally worth it. It covers Functional background of Oracle ERP, HCM, Payroll, OLM, Time Management and many other aspects of the HRMS suite. Functional setups and configs, how tos, technical information, table mappings and many more things to learn for almost no cost.

Oracle HRMS 11i/R12 Training Special Offer – Ltd time only


Dear Readers – For the month of August – We are celebrating the Indian Independence Day (August 15th) with a very special offer for you.

Now you can get the 4 DVD set for Oracle HRMS Techno-Functional Training for $99 discount. Currently, its available in USA for $199 with free shipping anywhere in the United States. With the special coupon code FREEDOM100 you’ll get this DVD set for only $100.

This offer is only valid from August 1st till August 31st. This coupon expired on August 31st at 12:00 pm PST.

What do you get in the DVD set? Here’s the list -

http://logicwala.com/index.php?option=com_content&task=view&id=52&Itemid=50

Oracle HRMS Online Training Sessions in October 2011


Dear Friends,
If you are looking for Instructor Led training for Oracle HCM suite (core HR, Payroll, Benefits etc.), Please register at Logicwala today.
KnowOracle and Logicwala is scheduling an exclusive Oracle HRMS techno-functional training. Our next batch is scheduled to start in October, and we are planning on either IST evenings or mornings depending on the number of students preference for each.

To register for the upcoming HCM Training seeions Click Here!

Cheers!
KnowOracle & Logicwala team.

Oracle Timecard (OTL) Automation


Recently i have seen many requests for OTL timecard automations in Oracle. One of the reasons is the financial downturn in the martket.

Many companies have announced furlough for employees- meaning the offices and manufacturing units will be shutdonw for a specified amount of time and it will be mandatory for employees to either take that time off from their vacation time, flex time, may be borrow it from next year or simply be unpaid for that time period. Whatever be the case, it saves company a lot of money that it was otherwise obligated to pay in vacation time or paid days. Now because its mandatory, it has to be in the system for the payroll to pick it up.

If the organization uses time entry system – like oracle – to enter vacation/flex time, and processes payroll then following needs to happen in order for a succesfull furlough automation.

- Employees time must be entered on the online timecard.

- The timecard must be approved by manager or Auto-approval process.

- This OTL timecard must be transferred to Batch Element Entries for Payroll.

To automate this process we will use HXC Timecard APIs provided by Oracle. These APIs help us in creating a timecard for a day, week, and also attach elements/ projects to the timecard. Also, the APIs submit the timecard with a workflow process type so it can either be picked for AUTO processing or Manual approval.

Before we go into the details, we have to see how a typical timecard is built. For the sake of simplicity, we will consider Monthly Paid (exempt) employees.

A timecard is a combination of DAYS. Each DAY will be one Row in a table. For Every day that you need to enter time (e.g. Saturday Sunday will not need a time entry being a holiday) you need a DETAIL type row also. And, for each DETAIL record that has to go into an element or project for costing or payroll purpose, we need an ATTRIBUTE also.

These are nothing but the TIME BUILDING BLOCKS. To make things simple, lets go and see these records:

select * from hxc_time_building_blocks

TYPE: MEASURE ( Number of hours to be put in that particular day) or RANGE (For period like week or day).
SCOPE: TIMECARD, DAY, DETAIL or APPLICATION_PERIOD

Now, if you see a typical timecard, this is how it looks (Use the hierarchical Query below):

TIMECARD (12/1/2008  – 12/7/2008) TYPE: RANGE
|_  DAY (12/1/2008 – 12/1/2008) TYPE: RANGE
|_  DETAIL (12/1/2008):  8 HRS   (may have attributes)  TYPE:MEASURE
|_  DAY (12/2/2008 – 12/2/2008)
|_  DETAIL (12/2/2008):  8 HRS
|_  DAY (12/3/2008 – 12/3/2008)
|_  DETAIL (12/3/2008):  8 HRS
|_  DAY (12/4/2008 – 12/4/2008)
|_  DETAIL (12/4/2008):  8 HRS
|_  DAY (12/5/2008 – 12/5/2008)
|_  DETAIL (12/5/2008):  8 HRS
|_  DAY (12/6/2008 – 12/6/2008)
|_  DAY (12/7/2008 – 12/7/2008)

SELECT htbb.time_building_block_id, htbb.TYPE, htbb.measure, htbb.unit_of_measure, htbb.start_time, htbb.stop_time,htbb.parent_building_block_id, ‘N’ parent_is_new, htbb.SCOPE,htbb.object_version_number, htbb.approval_status,htbb.resource_id, htbb.resource_type, htbb.approval_style_id,htbb.date_from, htbb.date_to, htbb.comment_text,htbb.parent_building_block_ovn, ‘N’ NEW, ‘N’ changed,htbb.application_set_id, htbb.translation_display_key
FROM apps.hxc_time_building_blocks htbb START WITH ( htbb.time_building_block_id in (6848088) AND htbb.object_version_number in (1 ) )CONNECT BY PRIOR htbb.time_building_block_id = htbb. parent_building_block_id AND PRIOR htbb.object_version_number = htbb.parent_building_block_ovn ORDER BY htbb.time_building_block_id ASC

NOW Over to APIs….

hxc_timestore_deposit.create_timecard_bb
— Create a Timecard building block (only timecard, no days, or details)
— Here are the parameters it takes
(
p_start_time => to_date(’01-DEC-2008 00:00:00′,’DD-MON-YYYY HH24:MI:SS’) ,
p_stop_time =>  to_date(’07-DEC-2008 23:59:59′,’DD-MON-YYYY HH24:MI:SS’),
p_resource_id => emp.person_id ,
p_comment_text => ‘Automated TimeCard: DEC08′,
p_approval_style_id => 41, –This is your workflow approval style, default to AUTO APPROVE
p_app_blocks => l_tbl_timecard_info,
p_time_building_block_id => l_tc_bb_id –returns the id of  TC Building block
);

hxc_timestore_deposit.create_day_bb
— Creates a DAY building block (only DAY no details)
— Here are the parameters it takes
(
p_day => l_start_date,
p_parent_building_block_id => l_tc_bb_id,
p_comment_text => ‘Automated TimeCard: DEC08′,
p_app_blocks => l_tbl_timecard_info,
p_time_building_block_id => l_day_bb_id
);

hxc_timestore_deposit.create_detail_bb
– Creates a DETAIL building block, in next step we have to attach the attribute to this DETAIL
— Here are the parameters it takes
(
p_type => ‘MEASURE’,
p_measure => 8, –Number of Hours
p_parent_building_block_id => l_day_bb_id,
p_comment_text => ‘Automated TimeCard: DEC08′,
p_app_blocks => l_tbl_timecard_info,
p_app_attributes => l_tbl_attributes_info,
p_time_building_block_id => l_detail_bb_st_id
);
hxc_timestore_deposit.create_attribute (
p_building_block_id=> l_detail_bb_st_id,
p_attribute_name=> ‘Dummy Element Context’,
p_attribute_value=> ‘ELEMENT – 60110′, –This is the Accrual PTO Element we want to update through this API.
p_app_attributes=> l_tbl_attributes_info);

HXC_TIMESTORE_DEPOSIT.EXECUTE_DEPOSIT_PROCESS
–This is the Submission Call. This process will submit the timecard, days and details with attributes. Timecard will stay in SUBMITTED State until approved via Manual or AUTO Approve process.
(
p_validate => FALSE,
p_app_blocks => l_tbl_timecard_info,
p_app_attributes => l_tbl_attributes_info,
p_messages => l_tbl_messages,
p_mode => ‘SUBMIT’,
p_deposit_process => ‘OTL Deposit Process’,
p_retrieval_process => ‘BEE Retrieval Process’,
p_timecard_id => l_new_timecard_id,
p_timecard_ovn => l_new_timecard_ovn
);

Hope this article helped you in understanding the basics of the Time Entry APIs. Please note that this is  the initial and basic knowledge. You will need some more knowledge – like DELETE timecards API for rollback in case of any issues. UPDATE timecard APIs etc for a full fledge capability on OTL timecard automation.

Oracle Payroll Elements and Balances Tutorial


Dear Friends,

This video is an introductory video about Oracle Apps HRMS – Payroll elements and balances.

Its just a sample of what you can expect in our Oracle Apps HRMS training DVD.

If the above video is not playing, click here to watch it on youtube

Buy Now: India (100$ only…use coupon code IND100)

*Note: For India Based Delivery, use coupon code IND100…and we will deduct 99$ from the total. If you are not comfortable paying with a Credit card, or you do not have a credit/debit card, you can send us an email at contact@logicwala.com and we will provide you with our Indian bank a/c number for easy transaction. (For India Based customers only)

Salary form in Oracle HR


I have been asked this question by many clients and consultants recently, and the solution is pretty straight forward. So, i thought i’ll share it here with y’all.

Oracle released a Family pack RUP 2 for HRMS last year, and it brought in a new feature – The web based Salary Administration form.

For many users, it was a thrill. But for a lot others, it was a challenge to get it to work. They are used to the old form based salary administration interface. Some of them even have custom hooks on the form that can not be implemented on the webpage so easily.

So, the Question is, how to revert to the salary form after applying this RUP, so you can still continue using the form based salary administration.

Here’s the answer. And as i said, its pretty straightforward.

Taskflows come to rescue.

Here are the steps to replace “New Salary Framework Page” with “Old Salary Form”:

  • Select any HRMS or Super HRMS Manager Responsibility (Example: US HRMS Manager)
  • Open the “Define Taskflow” form. (Security->Task Flow Definitions)
  • Query the Taskflow that is used by the Person form function (For Example: US HRMS PERSON TASKFLOW). Normally, this is the custom Taskflow.
  • Go to “Node section – Name field” and add “SALFORMNODE” by inserting a new row and selecting “SALFORMNODE” from Lov in the Name field.
  • Then Query “NASSIGN” node in “Node Section”.
  • In “Navigation Options Section”, delete record that has “SALREVIEW” for Node. Select “Yes” in the delete warning window.
  • In Navigation Options, insert new record with the following details:
    Seq: 1
    Node: SALFORMNODE
    Button: Checked
    Label: &Salary (leave the default &Salary as is)
  • Save and Exit the “Define Taskflow” form.
  • Logout the current applications and re-login to check that the “Old Salary form” is launched instead of “New Salary Page” when “Salary” button is selected in Assignment Window.

Try this, and let us know if you still have any issues. Most probably, it’s because you are using Oracle ;-)

cheers!

Oracle HRMS Functional Questions


What is the difference between rehire and reverse-termination?
What is a security profile in HRMS?
Is Address form date tracked?
What are the date tracking options while deleting a record?
Can we delete an employee forever? How?
What is required to be able to pay someone in Oracle Payroll?

before i post answers to these questions, lets hear from you..Post your answers in the comments and then who knows, may be i won’t have to answer at all ;-)

-ashish