Customer Credit Snapshot
Report will fetch and display all customer credit card snap shot details in excel format <?xml version=”1.0″ encoding=”UTF-8″ ?> <!– $Header: ARXCCS_XML.xml 120.0 2007/12/27 15:07:07 abraghun noship $ –> <!–…
Read MoreEasy to Create or Customize Interactive Reports
Steps Navigate to the Welcome dashboard. Click your name in the global area and select Edit Current Page. Click Change Layout and select Two columns, narrow left. Click Add Content for the narrow column. The Reports and…
Read MoreTVA AP VAT Report
This report will fetch all VAT details in AP module <dataTemplate name=”IRNGLBFRTVAAP” version=”1.0″> <parameters> <parameter name=”P_ACCT_FROM_DT” dataType=”DATE”/> <parameter name=”P_ACCT_TO_DT” dataType=”DATE”/> </parameters> <dataQuery> <sqlStatement name=”Q_HEAD_PARAMTERS”> <![CDATA[ Select to_char(:P_ACCT_FROM_DT,’DD-Mon-RRRR’) FROM_DATE,to_char(:P_ACCT_TO_DT,’DD-Mon-RRRR’) TO_DATE from…
Read MoreAPI to Update Customer Account in TCA R12
SET SERVEROUTPUT ON; DECLARE p_cust_account_rec HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE; p_object_version_number NUMBER; x_return_status VARCHAR2(2000); x_msg_count NUMBER; x_msg_data VARCHAR2(2000); BEGIN — Setting the Context — mo_global.init(‘AR’); fnd_global.apps_initialize ( user_id => 1318 ,resp_id => 50559 ,resp_appl_id => 222); mo_global.set_policy_context(‘S’,204); fnd_global.set_nls_context(‘AMERICAN’); — Initializing the Mandatory API parameters p_cust_account_rec.cust_account_id := 150734; p_cust_account_rec.customer_type := ‘R’; — Should be available…
Read MoreHow to Convert Comma Separated Values into Table using 'REGEXP_SUBSTR'
WITH csv AS (SELECT ‘AA,BB,CC,D33D,EE,FFDD,MM,GG’ AS csvdata FROM DUAL) SELECT REGEXP_SUBSTR (csv.csvdata, ‘[^,]+’, 1, LEVEL) pivot_char FROM DUAL, csv CONNECT BY REGEXP_SUBSTR (csv.csvdata,'[^,]+’,…
Read MoreAPI to Check Item On-hand Quantity for Specific Inventory Organization
DECLARE v_api_return_status VARCHAR2 (1); v_qty_oh NUMBER; v_qty_res_oh NUMBER; v_qty_res NUMBER; v_qty_sug NUMBER;…
Read MoreInventory Location,Item Master Organization,Inventory, Sub Inventory Item Class and Item Creation
Inventory Location,Item Master Organization,Inventory, Sub Inventory Item Class and Item Creation Step 1: Login as Application User Step 2: you will be in home page as below Step 3: we…
Read MoreFusion HCM – Query for Element Entry Details
SELECT * FROM per_all_people_f peo, per_all_assignments_f asg, per_person_names_f per_name, per_periods_of_service ser, per_person_types_tl per_typ, per_legal_employers ple, pay_rel_groups_dn payrel, pay_assigned_payrolls_dn papd, pay_all_payrolls_f pay, pay_element_entry_values_f peevf, pay_input_values_f pivf, pay_element_entries_f peef, pay_element_types_f petf, pay_entry_usages…
Read MoreFusion HCM – Query for Personal Payment Method Details
SELECT per_pay.* FROM per_all_people_f peo, per_all_assignments_f asg, per_person_names_f per_name, per_periods_of_service ser, pay_pay_relationships_dn pay_rel, pay_personal_payment_methods_f per_pay, pay_org_pay_methods_f org_pay, pay_bank_accounts bnk_act, per_legislative_data_groups ldg, per_person_types_tl per_typ, per_legal_employers ple WHERE asg.person_id = peo.person_id AND ser.person_id…
Read MoreFusion HCM – Query for OTL Time Entries Details
SELECT papf.person_number emp_id, TO_DATE (TO_CHAR (sh21.start_time, ‘DD/MM/YYYY’), ‘DD/MM/YYYY’ ) start_time, TO_DATE (TO_CHAR (sh21.stop_time, ‘DD/MM/YYYY’), ‘DD/MM/YYYY’ ) stop_time, sh26.attribute_category elements, sh27.status_value, ROUND (SUM (sh21.measure), 2) measure FROM per_all_people_f papf, per_all_assignments_m asg, …
Read More