NEW ASSETS ADDITION QUERY
This query fetches the detailed information related to those assets which are added newly for a particular period. SELECT FAL.segment1 SOL_ID ,FFV.description BRANCH_NAME …
Read MoreLeases which are expiring 15,30,60,180 days before respectively
This query fetches those leases which are going to expiry within 15,30,60,90,180 days respectively based on the parameter. SELECT GCC.segment4 SOL_ID ,gl_flexfields_pkg.get_description_SQL(GCC.chart_of_accounts_id ,4,GCC.segment4) BRANCH_NAME …
Read MoreFusion HCM – Calling a Fast Formula from another Formula
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 MoreFusion HCM – Calling a Value Set in Fast Formula
Below 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 MoreFusion HCM – Managing an Array Type Fast Formula
Below 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 MoreCreating Checkbox Tree In Oracle Apex 5.0
Required 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 MoreAPI To end date the user and their responsibilities
DECLARE CURSOR User_end is select user_name from fnd_user where user_name in (SELECT user_name FROM irm_empl_issue …
Read MoreQuery to extract FA details based on the asset book
SELECT 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 MoreList of concurrent request – its count by day, week and Month
select 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 MoreLease Expired But Not Terminated
Query 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 More