How to create a package to call the SIT which will store the flexvalues in different segments.
e,g Code:
1.Note down the flexstrcture name and segment.
2.Call the flex value in the Function.
3.pass the flex value in query
CREATE OR REPLACE function xxri_passport_num(p_id_flex_num in number,p_person_id in number) return varchar2
is
l_passport varchar2(240);
begin
select pac.segment1 into l_passport from per_person_analyses ppa,per_analysis_criteria pac
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;
return l_passport;
end xxri_passport_num;
/
select xxri_passport_num(50348,61) passport from dual;
Oracle HCM & ERP insights from the field — Fusion Cloud, Redwood UI, Payroll, Absence, BIP, OTBI and integrations.
Subscribe to:
Post Comments (Atom)
Recruiting: jobs not visible on the career site
# Fix of the Day #7: Recruiting: jobs not visible on the career site Part of my Oracle Fusion HCM Fix of the Day series: real issues from...
-
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...
-
While Registering the report to instance we need to make sure od date format: 1.The default type is YYYY/MM/DD HH24:MI:SS go to propert...
-
This is easily done with the following command: select to_char(to_date('56789','J'),'JSP') from dual / TO_CHAR...
No comments:
Post a Comment
Thanks for your comments submitted.,will review and Post soon! by admin.