Configure the EIT in standard Oracle
If you haven't already, you will need to configure the EIT in standard Oracle before you can deploy the EIT in the app. This means you need to have:
- Configured the EIT information type and attributes
- Ensure the flexfield definition is frozen
- Register the Extra Information Type by running the Register Extra Information Types (EITs) concurrent program
- Grant responsibilities access to the EIT using *HRMS Manager: Security: Information Types Security. This is not required for the app but it is required to test it in PUI.
- Test it in the standard Oracle PUI form to make sure it works
- Create a Base Oracle function that contains the workflow process name (eg, pProcessName=HR_EIT_JSP_PRC) and AME Transaction type parameters (eg, pAMETranType=SSHRMS&pAMEAppId=800). This is typically a copy of HR_EIT_SS with its parameters modified, eg, XXX_HR_EIT_SS.
Create an EIT page
Decide on a suitable page to house your new EIT. For best-practice guidance, see Create an SIT page. To learn how to create pages, please see Pages.
The page must use the {PERSON_ID} Object Id format and xxas_per_pkg.per_and_primary_asg_ctx Object Id handler.
Create an EIT view formula
Copy the XXAS_EMP_PERSONEIT_TEMPL_FF or XXAS_EMP_ASGEIT_TEMPL_FF formula and name it appropriately. We recommend the format XXX_BK_<TITLE>_VIEW, eg, XXX_BK_BUSINESS_TRIP_VIEW.
Ensure you date-track back when creating the Fast Formula and use the formula type Applaud HR Assignment.
Create a flexible EIT block
Create a flexible block with the following properties:
| Property | Value |
|---|---|
| Security type | Role and data |
| Object | Applaud HR Assignment |
| Layout | LIST if multi-row or FORM if a single row |
| Data source | Applaud HR Person EIT or Applaud HR Assignment EIT |
| Order by | As per requirements. Eg, CREATION_DATE DESC |
| View formula | As created earlier, eg, XXX_BK_BUSINESS_TRIP_VIEW. |
| Read-only | Checked if this is a read-only EIT, or unchecked if it's editable |
| Form | Person EIT (/public/xxas/emp/view/personeit.xml) or Assignment EIT (/public/xxas/emp/view/asgeit.xml) Not required if it's read-only. |
| Form handler | xxas_person_eit_pkg or xxas_asg_eit_pkg Not required if it's read-only. |
| Base Oracle function | The function you created in your Oracle setup, eg, XXX_HR_EIT_SS. |
| Extra information type | The EIT information type, eg, XXX_BUSINESS_TRIP |
Define access control for the EIT
To allow the block itself to be visible, create a Grant:
- Navigate to Grants: Add
- Choose the role that should see the block
- Choose the Object Ids against whom the block should be visible
To allow EIT rows to be visible inside the block, create a Data source grant:
- Navigate to Data source grants: Add
- Choose the role that should have access to EIT rows
- Choose Create a new one under Object Ids
- Specify the instance set title and predicate to limit the rows. For example: &TABLE_ALIAS.person_id = fnd_global.employee_id AND &TABLE_ALIAS.information_type = 'XXX_BUSINESS_TRIP'
To allow a new EIT row to be created, create an Add row grant:
- Navigate to Grants to add a row: Add
- Choose the role that should have access to create a row
- Choose the Object Ids against whom the role can create a row
To allow updating and deleting of a row, edit the Update_Allowed and Delete_Allowed outputs of your view Fast Formula. See Defining the view formula.