Below is a Sample Formula showing How to Call a Fast Formula from another Formula : DEFAULT FOR ASG_HR_ASG_ID is 0DEFAULT FOR PAY_EARN_PERIOD_END is ‘4712/12/31 00:00:00’ (date) SET_INPUT(‘HR_ASSIGNMENT_ID’,ASG_HR_ASG_ID)v_asg_id = ASG_HR_ASG_ID l_date_earned…
Read MoreBelow is a Sample Formula shows How to Call a Value set in Fast Formula : Inputs are hr_id (number), eff_st_date(text), eff_end_date(text), mode (text) l_hr_per_id = hr_idl_eff_st_date = eff_st_datel_eff_end_date =…
Read MoreBelow is a Sample Array Type Fast Formula : DEFAULT_DATA_VALUE FOR PER_HIST_ASG_ASSIGNMENT_ID IS 0 DEFAULT_DATA_VALUE FOR PER_HIST_ASG_ASSIGNMENT_TYPE IS ‘x’DEFAULT_DATA_VALUE FOR PER_HIST_ASG_EFFECTIVE_START_DATE IS ‘1951/01/01 00:00:00’ (DATE)DEFAULT_DATA_VALUE FOR PER_HIST_ASG_EFFECTIVE_END_DATE IS ‘4712/12/31 00:00:00’…
Read MoreRequired Tools vOracle Apex (Version 5) Step 1 Create Tree Region Sample code: SELECT CASE WHEN CONNECT_BY_ISLEAF = 1 THEN 0 WHEN LEVEL = 1 THEN 1 ELSE –1 END AS status, LEVEL, Ename AS title, NULL AS icon,…
Read MoreDECLARE CURSOR User_end is select user_name from fnd_user where user_name in (SELECT user_name FROM irm_empl_issue …
Read MoreSELECT fp.period_name, adt.asset_number, adt.tag_number, bks.book_type_code, ltrim(rtrim(cat.segment1)) ||’-‘|| ltrim(rtrim(cat.segment2)) ||’-‘|| ltrim(rtrim(cat.segment3)) category, bks.date_placed_in_service, bks.original_cost, adt.description, adt.context subject_to_property_tax, adt.attribute1 property_tax_code, dn.deprn_reserve, nvl(bks.original_cost,0) – nvl(dn.deprn_reserve,0) net_book_value, dn.ytd_deprn, (select dhcc.segment1||’.’||dhcc.segment2||’.’||dhcc.segment3||’.’||dhcc.segment4||’.’||dhcc.segment5||’.’||dhcc.segment6||’.’||dhcc.segment7||’.’||dhcc.segment8||’.’||dhcc.segment9 from gl_code_combinations dhcc,fa_distribution_history…
Read Moreselect USER_CONCURRENT_PROGRAM_NAME,REQUEST_DATE,CNTPERDAY,week_no, case when week_no=1 then sum(CNTPERDAY) OVER (PARTITION BY USER_CONCURRENT_PROGRAM_NAME,week_no) else 0 end week_no_1, case when week_no=2 then sum(CNTPERDAY) OVER (PARTITION BY USER_CONCURRENT_PROGRAM_NAME,week_no) else 0 end week_no_2 ,case when…
Read MoreQuery to Fetch Leases which are expired but not terminated. SELECT GCC.segment4 SOL_ID ,PLA.lease_id Lease_number ,PLDA.attribute7 Agreement_no ,PAA.address_line1||’,’||PAA.address_line2||’,’||PAA.address_line3||’,’||PAA.address_line4||’,’||PAA.city||’,’||PAA.state…
Read MoreHRMS API :Create Position Hierarchy by Using APIs (hr_pos_hierarchy_ele_api.create_pos_hierarchy_ele) Hierarchy Name Checking query =========================== select * from per_position_structures where name=’Sample Hierarchy’ Parent Position Name Checking Query =================================== select *…
Read MoreOracle API Script for SHIP CONFIRMATION Using (WSH_DELIVERIES_PUB.Delivery_Action) —Ship Confirm Delivery using WSH_DELIVERIES_PUB.Delivery_Action—- Declare –Standard Parameters. p_api_version NUMBER; …
Read More