Sunday, September 16, 2012

How to Enable/Disable Concurrent Program Parameter Dynamically

concurrent program is a data-intensive task.A concurrent program is an executable file that runs simultaneously with other concurrent programs and with online operations, fully utilizing system's hardware capacity.

Standard Request Submission (SRS) is an Oracle Applications feature that allows us to select and run any concurrent programs from a single, standard form (Submit Request) or window (Schedule Request). Requests to run concurrent programs are called concurrent requests.

Basic Requirement 
Our basic requirement is to enable or disable concurrent program parameter dynamically.Here we will take two different requirement scenario
Scenario I
We have to define a concurrent program with the following parameter
Run Mode:- The parameter will contain a list of values.

  • REPORT           :- Report mode will generate a report.(as per requirement)
  • ROLLBACK    :- Rollback mode will rollback/delete the data changes done by previously executed request
Request Id:- This parameter will allow the user to select any of the previously executed concurrent request.

Request Id parameter will be enabled and mandatory if the Run Mode is selected as "ROLLBACK".
If the Run Mode is selected as "REPORT", then Request Id parameter will remain disable.




To read the full document go to Shareapps4u



Thursday, July 12, 2012

How to Add Element Value in Oracle Online Payslip

Online Payslip enables employees to view their own payslip, via the Employee Self Service menu after payroll processing has been completed. Managers can also search for, and access the payslip of individual employees via the Payroll Professional menu.
The information displayed on the payslip is generated by an archiver program during the payroll process. This process and the payslip are localised for each payroll legislation supplied by Oracle to satisfy local requirements.
Each legislation has it's own requirements regarding what information to display on the Online Payslip. There will be standard information including header details such as Name, Address, Employee Number and National Identifier, and also statutory deductions and balances. There is also a user-definable capability as each legislation allows the user to specify additional site specific elements and balances that they wish to include on their payslip

Basic Requirement


Our basic requirement is related to US legislation requirement.
It says:- Over Time rate must be displayed for all "Hourly" employee irrespective of their elligibility of OverTime payment.
This can be extent to any legislation or method can be used to fullfill other business requirement of similar kind.










To read the full document go to Shareapps4u





Monday, April 30, 2012

How to Send Reminder Notification to Approver

Oracle Workflow provide us several standrad functions which helps us to implement our business requirement.
 
Here we will discuss about two such standard functions to implement our requirement.
Basic Requirement
Our old requirement looks like "when a person applies for a leave it should go his/her supervisor for approval.Approver must be able to provide his/her approval/rejection comments. The comments must be entered by the approver while rejecting the leave requisition.If he/she rejects the leave requisition without entering comments, then it should raise an application error.If he/she approves the requisition it should be optional.Approver must also be able to select theOrganization Leave Type from a list of values . If the leave gets rejected, don’t store any information in database.The approver should able to view/edit the person "Special Information Types" before approving the leave request.Before approving the sick leave request the approver must able to see the submitted medical document."
 
Apart from the above requirement, We will introduce an additional requirement that "A reminder notification(email) must go to approver in every 2 days untill he/she takes action (Approve or Reject) on the leave notification."
 
 
To read the full document go to Shareapps4u