Posts by Siva Chandaran

AR 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 More

AR 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 More

Configuration to update the same customer tax registration number for multiple customers/sites

Introduction : This blog has the configuration update the same customer tax registration number for multiple customers/sites Why we need to do : As per the legal requirement, Business requested…

Read More

How to skip deletion of the entries from AR_STATEMENT_HEADERS and AR_STATEMENT_LINE_CLUSTERS

Introduction : This blog has the configuration to skip the deletion of the entries from AR_STATEMENT_HEADERS and AR_STATMENT_LINE_CL   Why we need to do : While creating/customizing/debugging the customer statement…

Read More

Non-PO invoice report in Cloud

Introduction: This blog has the script to get the Non po invoice details in Oracle Cloud application for Audit purpose. Cause of the issue: Auditor wanted to see the Non-PO…

Read More

Credit Memo Application Report

Introduction: This blog has the script to get the credit memo application details in Oracle Cloud application for Audit purpose. Cause of the issue: Auditor wanted to see the credit…

Read More

Update customer send statement and send dunning flag Using SOAP Webservice – Oracle Fusion

Introduction:  This blog has the SOAP Webservice details that can be used to update the customer send statement and send dunning flag into Oracle Cloud application.    Cause of the…

Read More

Update customer statement delivery method Using SOAP Webservice – Oracle Fusion

Introduction:   This blog has the SOAP Webservice details that can be used to update the customer statement delivery method into Oracle Cloud application.    Cause of the issue:  Business…

Read More

Query to get HR Contingent Worker – Oracle EBS to Fusion

Introduction: This blog has the SQL query that can be used to pull the HR Contingent Worker details per country for EBS to Cloud data migration. SQL Query : SELECT  …

Read More

Query to get Lease assets – Oracle EBS to Fusion

Introduction: This blog has the SQL query that can be used to pull the lease assets details per asset book for EBS to Cloud data migration. SQL Query:  SELECT  fb.book_type_code…

Read More