Creating a Supplier in Oracle Fusion 24D
Creating a Supplier in Oracle Fusion Creating a supplier in Oracle Fusion involves several key steps to ensure accurate setup and integration within your procurement processes. Here’s…
Read MoreAR Customer Collector Portfolio Report
Introduction: 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 MoreAR Customer Dunning Strategy Status Report
Introduction: 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 MoreNot able to submit the Print statement in AR
Issue :- Not able to submit the Print statement in AR Cause of the issue: Statement Periods are not defined for the New Year. How do we solve: We need…
Read MoreNeed to delete the incorrect receipt entry from Account receivables
Introduction/ Issue: Need to delete the incorrect receipt entry from Account receivables User has mistakenly made Receipt entry by selecting wrong customer now they need to delete the incorrect receipt…
Read MoreUpdate the Project Status using API
Introduction: This blog has the SQL Script to update the Project Status using API along with each task. Cause of the issue: To update status of the project and…
Read MoreAPI Script To Update Supplier Details
This blog has the script to update the supplier details using API AP_VENDOR_PUB_PKG.UPDATE_VENDOR. Cause of the issue: Some of the fields are not visible and don’t have option to…
Read MoreImplementing Inline Child Reports in Oracle APEX Interactive Reports
Introduction/ Issue: In Oracle APEX, users often need to display additional details related to a record without navigating to a new page. This can be achieved by creating an inline…
Read MoreRefresh Main Page on Dialog Close Using JavaScript in Oracle APEX
Introduction/ Issue: When working with Oracle APEX, it is common to open a modal dialog for updating records. Once the update is completed and the dialog is closed, refreshing the…
Read MoreNew TDS rate creation
Business 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 More