Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Sunday, August 14, 2016

Create Applications with Special Information Types in Oracle

Task – To create a Medical Reimbursement form on SSHR screen so the employees can easily update their medical bills every month and their manager can approve these bills and at the end of the month a process have to be run which will transfer these bills into employee’s payroll elements so before payroll run these bill should be updated


Step 1 – Creating SIT
Login in as System Administrator -> Flexfield -> Key -> Segments
Search for Application (Human Resources) and Flexfield Title (Personal Analysis Flexfield)
Define a new row, we can call it MEDICAL_REIMBURSEMENT_KFF and the description can be Job Requests.
Next we click on "Segments" to define the form fields to be used in the application.

Field - ValueSet
=============
Employee Name LOV
Nature of Sickness LOV
Details of Sickness 30Char
Hospital Name 30Char
Date FND_STANDARD_DATE
Amount Allowed CRL_YES_NO
Amount Number

Then we save and compile.

Next, login as Global Super HRMS Manager. And look for the function "Define Special Information Type". Find the one we just created MEDICAL_REIMBURSEMENT_KFF and check the "Enabled" and "Other" checkboxes and save.


Step 2 – Configure WorkFlow Process
Change the node attribute of HR_SIT_JSP_PRC seeded WF to Yes or Yes Dynamic
or
Copy the seeded workflow 


open Workflow builder, login Open the HR item type. Under processes, find HR_SIT_JSP_PRC workflow process as a template Copy it, and paste. When pasting, the internal name should be MEDICAL_REIMBURSEMENT_SIT_PROC_JSP_P (i.e the name of our new workflow process). The display name can be Medical Reimbursement.

Save the workflow locally and upload it via WFLoad command

Step 3 – Define Function
After this, we go back into SysAdmin and go to Application -> Function

The function can be:

Function, User Function Name, Description
==================================
MEDICAL_REIMBURSEMENT_PROCESS., TEST Job Request Process, Special Information Types
Under the properties tab, we have:

Function, Type, Maintenance Mode, Context dependence
===========================================
MEDICAL_REIMBURSEMENT_PROCESS., SSWA jsp function , None, None

Under the Form tab we have

Parameters
==========
pAMETranType=SSHRMS&pAMEAppId=&pProcessName= MEDICAL_REIMBURSEMENT_SIT_PROC_JSP_P&pItemType=HRSSA&pCalledFrom= MEDICAL_REIMBURSEMENT_PROCESS &pPersonID=&pFromMenu=Y

Under the Web HTML tab, we have

HTML Call
=========
OA.jsp?akRegionCode=HR_CREATE_PROCESS_TOP_SS&akRegionApplicationId=800&OAFunc= MEDICAL_REIMBURSEMENT_PROCESS

MEDICAL_REIMBURSEMENT_SIT_PROC_JSP_P is the name of the workflow process we created earlier.

pCalledFrom and OAFunc must be the function name

save & Exit.


Step 4 – Map Function with Menu 
Next is to add this function (Medical Reimbursement) to the Menu for TEST Employee Self Service.
Then we also need to open the menu "Global Self Service Functions Custom". And add our function to it as well under the function column.
Next we now navigate to our function and we have to personalize the page for it.

Step 5 – Personalize the Page
After this, we have to personalize the page:

/oracle/apps/per/selfservice/specialinformation/webui/PersonSitPG

to only show our SIT at functional level.

To do this, we will click on our new function in SSHR. But this will show all of the SIT's available which is quite a lot.
So on this page, we click on the "Personalization" link at the top.

Then from here, we find the column "Flex: Key flex for Sit" near the very bottom click the pen image to personalize the page.
Now, on the next page that shows up, find the "Segment List" column.

For this field, we enter values under the function header in the format:

STRUCTURE 1|Segment 1|Segment 2||Structure 3|Segment 7|Segment 8

So for our example we can have:

MEDICAL_REIMBURSEMENT_KFF | Employee Name | Date | Amount | Hospital Name | Details of Sickness

Step 6 – Setting up AME 
The final thing to do is to setup AME rules for this workflow process:

Login as "Approvals Management Business Analyst" and create a new Rule under TEST HR

Combination, Header,

Condition - WORKFLOW_PROCESS_NAME in (HR_SIT_JSP_PRC) or (MEDICAL_REIMBURSEMENT_SIT_PROC_JSP_P) whatever you are using

Actions - Supervisory (one level up) or whatever we want it to be.

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect