SELECT eer.expense_report_num AS “EXPENSE REPORT NUM”, ee.expense_source AS “EXPENSE SOURCE”, papf.person_number AS “EMPLOYEE NUMBER”, ppnf.full_name AS “EMPLOYEE NAME”, pea.email_address AS “EMPLOYEE EMAIL”, ecp.card_program_name AS “CREDIT CARD TYPE”, ec.card_reference_id AS “CARD_REFERENCE_ID”,…
Read MoreSELECT taxdet.invoice_id, taxdet.invoice_amount, taxdet.line_type_lookup_code, taxdet.description, taxdet.invoice_date, taxdet.gl_date, taxdet.supplier_site_name, taxdet.supplier_name, taxdet.supplier_number, taxdet.party_state, taxdet.supplier_gst_number, taxdet.invoice_number, taxdet.invoice_currency_code, taxdet.related_invoice_number, taxdet.line_number, taxdet.rec_nonrec_flag, taxdet.uom_code, taxdet.quantity, taxdet.unit_price, taxdet.transaction_line_amount, taxdet.taxable_line_amount, taxdet.tax_type_code, taxdet.hsn_code, taxdet.sac_code, taxdet.tax_rate, taxdet.charge_account_ap, taxdet.tax_natural_account, taxdet.cancelled_date, (…
Read MoreManual-Usage: The manual should be used along with the Fusion HCM application in order to familiarize themselves with the navigation and functionality. 1. Login to Oracle Fusion-HCM: This section covers…
Read More1.- Log in with our credentials 2.- Clic on the “Purchase” module and select “Purchase order” 3.- Go to the task bar and choose the “Create order”…
Read MoreIntroduction: This blog has the SQL query that can be used to pull the data for the AR Customer Collector Portfolio Report Cause of the issue: Business wants to see the Customer Collector Portfolio Details How do we solve: Create a BI report in fusion using below SQL query to extract the details. SELECT customer_name, account_number, portfolio, portfolio_description, business_unit, account_profile_class_effective_end_date, account_profile_class, account_profile_collector FROM ( SELECT hp.party_name customer_name, hca.account_number account_number, hca.attribute10 portfolio, ( CASE WHEN hca.attribute10 = ‘Default – Portfolio’ THEN ‘Portfolio Default for Unclassified Customer Accounts’ WHEN hca.attribute10 != ‘Default – Portfolio’ THEN hca.attribute10 END ) portfolio_description, hou.name business_unit,…
Read MoreIntroduction: This blog has the SQL query that can be used to pull the data for the AR Customer Dunning Strategy Status Report Cause of the issue: Business wants to see the AR Customer Dunning Strategy Status Report How do we solve: Create a BI report in fusion using below SQL query to extract the details. With cust as ( select hp.party_id, hp.party_number cust_number, hp.party_name cust_name, hca.cust_account_id, hca.account_number CUST_ACCOUNT_NUMBER from hz_parties hp, hz_cust_accounts hca where hp.party_id = hca.party_id ) , cltr as ( select acl.collector_id, acl.employee_id, acl.name collector, pmail.email_address collector_email from ar_collectors acl, per_email_addresses_v pmail where acl.employee_id = pmail.person_id ) , stg_temp as ( select WORK_ITEM_TEMP_ID, name task, DESCRIPTION from IEX_STRY_TEMP_WORK_ITEMS_VL group by WORK_ITEM_TEMP_ID, name, DESCRIPTION )…
Read MoreBusiness requested a new TDS rate for the supplier to apply at invoice level. Steps: Load new recovery tax rate. Navigator: Setup and Maintenance à Financials à Manage tax codes …
Read Moredeclare l_ctx dbms_xmlquery.ctxHandle; l_clob clob; begin l_ctx := dbms_xmlquery.newContext(‘select * from <TABLE_NAME>’); dbms_lob.createtemporary(:g_clob,true,dbms_lob.session); :g_clob := dbms_xmlquery.getXml(l_ctx); end;
Read MoreBusiness requested a new VAT to apply the tax at the invoice level. Steps: Go to Set up and Maintenance > Financials > Transaction Tax > Manage Tax Rates and…
Read MoreIntroduction: The purpose of this document is to demonstrate how we pass multiple set of parameters in REST API through Postman. Cause of the issue: Whenever we test any REST…
Read More