To pull the date updated by eliminating the previous version we can use this truncate staement for date tracked tables which will give only the updated values.
E.g:- select nvl(pac.segment1,null) from
per_person_analyses ppa,
per_analysis_criteria pac,
per_all_people_f papf
where ppa.ANALYSIS_CRITERIA_ID=pac.ANALYSIS_CRITERIA_ID
and ppa.id_flex_num =p_id_flex_num and ppa.person_id=p_person_id
and papf.person_id=ppa.person_id and
trunc(sysdate) between papf.EFFECTIVE_START_DATE
and papf.EFFECTIVE_END_DATE and trunc(sysdate) between ppa.DATE_FROM
and nvl (ppa.DATE_TO,trunc(sysdate));
Oracle HCM & ERP insights from the field — Fusion Cloud, Redwood UI, Payroll, Absence, BIP, OTBI and integrations.
Subscribe to:
Post Comments (Atom)
Redwood Recruiting: the ESS and OSCS index ingest jobs must all succeed, or the data won't load
# Fix of the Day #25: Redwood Recruiting: the ESS and OSCS index ingest jobs must all succeed, or the data won't load Part of my Oracl...
-
Absence Management in Oracle Fusion is powerful — and easy to get wrong. The accrual plan is where most of the complexity lives. Here is a...
-
This is easily done with the following command: select to_char(to_date('56789','J'),'JSP') from dual / TO_CHAR...
-
HCM Extracts are Oracle's built-in mechanism for extracting structured HR data for payroll interfaces, benefits carriers, and third-pa...
No comments:
Post a Comment
Thanks for your comments submitted.,will review and Post soon! by admin.