Fusion HCM – Automating Payroll Batch Loader
Below are the Steps to Automate Payroll Batch Loader : Create an HCM Extract to deliver PBL file to UCM Content Server in required Format Create a BI Report which…
Read MoreFusion HCM – Steps to Create a Basic HCM Extract
Below Steps Shows How to Create an HCM Extract : An HCM Extract is created from the below Navigation : Navigator -> Data Exchange -> Tasks -> Manage Extract Definitions…
Read MoreFusion HCM – Getting HR Data in Fast Formula
To get HR Data in Fast Formula, 1. The Formula Type must be Payroll Access to HR2. U Must use Proper CHANGE_CONTEXTS to get required Data Below is a Sample…
Read MoreScript to get PHONE NO with area code of the customer
SELECT LISTAGG( cont_point.phone_area_code || DECODE (cont_point.contact_point_type, ‘TLX’, cont_point.telex_number, REGEXP_REPLACE (cont_point.phone_number, ‘[^[:alnum:]” ”]’, NULL ) ),’|’) WITHIN GROUP (ORDER BY cont_point.phone_number) into lv_phone_no…
Read MoreScript to get EMAIL information of the customer
SELECT LISTAGG( cont_point.EMAIL_ADDRESS,’|’) WITHIN GROUP (ORDER BY cont_point.EMAIL_ADDRESS) into lv_email_address FROM hz_contact_points cont_point, –hz_contact_points cont_point1, hz_cust_account_roles acct_role, hz_parties party, hz_parties rel_party, hz_relationships rel, …
Read MoreHow to get the DBC file for a particular instance
During OA Framework development we need to get the DBC file of the environment we want to work on.This file is located in $FND_TOP/secure for 11i and $FND_SECURE for R12…
Read MoreSQL Query for extracting the late fee data for customers in R12 Oracle Apps
SELECT aps.trx_number, aps.trx_date, cust_det.interest_rate, ROUND ( cust_det.interest_rate …
Read MoreScript for getting customer Bill to Contact in R12 Oracle Apps
FUNCTION xx_get_contact (pn_acc_number IN VARCHAR2,pn_site_use_id Number) RETURN VARCHAR2 AS v_contact VARCHAR2 (500); BEGIN SELECT DISTINCT SUBSTR (party.person_first_name, …
Read MoreScript for customers bill to email address in R12 Oracle Apps
FUNCTION xx_cust_contact_email (p_acc_id IN NUMBER,p_cust_account_site_id Number ) RETURN VARCHAR2 IS v_contact_email VARCHAR2 (1000); BEGIN SELECT DECODE (SUBSTR (cont_point.email_address, -1,…
Read MoreSGA Details – JROD COPY
/****************************************************************************************************** This section provides details from AP for NON-Employee related invoices. *******************************************************************************************************/ SELECT (SELECT period_name FROM gl_periods WHERE apd.accounting_date BETWEEN start_date…
Read More