Posts

Schedule the Data Extract in Fusion HCM hourly or on any custom frequency

Image
We have only few Pre defined options to schedule the Data Exchange or Data Extract in Oracle Fusion, Daily/Monthly/Once/Weekly However there is always a need to schedule the extract on a different frequency such as hourly on any specific day of the week etc. Here is a solution to this: A New Fast Formula, Navigate to Fast Formula Creation Screen, Consider an example that we need to schedule the Data Extract in every hour,  Create a New formula: Formula Name: IT_TEST_1_HOUR_SCHEDULE Type: Flow Schedule Description: Optional /***************************************************************************** FORMULA NAME: Hourly Flow Schedule FORMULA TYPE: Flow Schedule DESCRIPTION: Formula to return a date time. Returns NEXT_SCHEDULED_DATE; Formula Results : NEXT_SCHEDULED_DATE This will be a date time value with yyyy-MM-dd HH:mm:ss format. *******************************************************************************/ /* Inputs */ INPUTS ARE SUBMISSION_DATE(DATE), SCHEDULED_DATE(DA...
Post a Comment
Read more

How to Hide or show asterisk for Unit Cost and Margin(values) in sales order form

Image
I myself was facing challenge from past couple of days looking into the reason why some fields on Sales Order Form(lines) showing ***** in place of values,  Checked all Form Personalization, Custom PLL, downloaded the Standard Form, going through the standard OM Api, Lastly found something which could not think of promptly , the oracle has given a Tricky way of achieving the same: Previous: After: Add the Function 'Sales Orders: View Gross Margin' to Menu where it is required to display the Units cost and Margin.
Post a Comment
Read more

Life time of a SSHR transaction in hr api transaction tables

You can achieve this by adding the parameter pNtfFyiDetails=Y to the Self Service _SS functions. if this parameter is set to Y, then the FYI notification page displays a Details Region with the proposed column and a Supporting region. With this functionality, now the recipient need not navigate to the relevant SSHR page in the Application to understand the changes that have been approved.
Post a Comment
Read more

This person either does not exist at all or does not exist as of the effective date on Contact(DEPENDENT) self service page

When we get the error as "This person either does not exist at all or does not exist as of the effective date " in Create-update Contact from Self Service Page, there is a quick fix for this. Please verify the  HR: Security Profile at Responsibility level, Open the Security Profile from HRMS Super User --> Security --> Profile -->Make the Value for View Contacts - All Clear the cache from Functional Administrator and re test your issue.
Post a Comment
Read more

How to achieve the Assignment History from ORACLE SQL query

--Create a DB View as below, and refer this where ever you need CREATE OR REPLACE FORCE VIEW ASSIGNMENT_HISTORY_V (    PERSON_ID,    ASSIGNMENT_ID,    ASSIGNMENT_NUMBER,    EFFECTIVE_START_DATE,    ORGANIZATION_ID,    NEXT_ORGANIZATION_ID,    POSITION_ID,    NEXT_POSIT,    GRADE_ID,    NEXT_GRADE,    JOB_ID,    NEXT_JOB ) AS      SELECT EFFECTIVE_START_DATE desc),            ASG_HIST."PERSON_ID",             ASG_HIST."ASSIGNMENT_ID",             ASG_HIST."ASSIGNMENT_NUMBER",             ASG_HIST."EFFECTIVE_START_DATE",             ASG_HIST."ORGANIZATION_ID",             ASG_HIST."NEXT_ORGANIZATION_ID",             ASG_HIST....
Post a Comment
Read more

Save attachments on Core Form after Approval of Contact self service Request

There is no straight way to achieve this and oracle support mentioned as this a BUG as per the Enhancement Request. Please Go Through with  Doc ID 1981366.1 , Why Attachments Attached in the Review Page While Adding New Contacts in the Region "Dependents and Beneficiaries" in Self Service Are Not Displayed on Contacts form in Core HR. (Doc ID 1981366.1)  
Post a Comment
Read more

Enable attachments on Add-Update Contact(Dependent) Self Service Review Page

ENABLE ATTACHMENTS: OAF Personalizations Renderred Yes for  :Header: Additional Information Renderred Yes: Message Check Box: Save Attachments
Post a Comment
Read more