The Cool Fox

In Oracle Fusion, GL_DAILY_RATES contains the daily conversion rates for foreign currency transactions. It replaces the GL_DAILY_CONVERSION_RATES table available in Oracle Apps. GL_DAILY_RATES contains the rate to use when converting between two currencies for a given conversion date and conversion type. Each row in this table has a corresponding inverse row in which the from and to currencies are switched. For example, if this table contains a row with a from_currency of YEN, a to_currency of CND, a conversion_type of Spot, and a conversion_date of January 1, 1997, it will also contain a row with a from_currency of CND, a to_currency of YEN, a conversion_type of Spot, and a conversion_date of January 1, 1997. GL_DAILY_CONVERSION_TYPES contains daily conversion rate types and their descriptions. This table corresponds to the Conversion Rate Types form. Use the below query to fetch Exchange Rates/Daily Rates in Oracle Fusion Financials SELECT r...

[Fusion] Passing Default Value to Date Parameters in Oracle BIP Reports

Oracle BIP Reports allow users to generate data-driven insights with dynamic parameters. One common requirement is to set default values for date parameters so users can run reports without manually selecting dates. This blog post explains how to set default values for date parameters in Oracle BI Publisher (BIP) reports. Steps to Pass Default Value to Date Parameters For this demonstration, I have created a Data Model with below SQL Query: SELECT :P_DATE FROM DUAL Also, Updated the date format string to dd-MMM-yyyy to display dates in the format 15-Apr-2025 for better readability and consistency. When clicking on View Data , the data parameter is currently coming as blank To enhance functionality, we want it to automatically populate with the current system date if no value is provided. To achieve this functionality we can write {$SYSDATE()$} in the Default Value text box: Now, when you click on View Data you will see the current date automat...

Disabling features in Oracle JDeveloper to improve the performance

Oracle JDeveloper has many features and updates which you may not be used for the current project. So, you can disable those extensions by using the following steps: Goto Tools menu and then click Features. Manage Features and Updates dialog will appear. Uncheck the features that you do not want for current application/project. You may enable it again for other projects. Like I have disabled the below-highlighted features.

[Fusion] Understanding Legal Entities and Business Units in Oracle Fusion

🔹 What is a Legal Entity? Think of a Legal Entity as a real, registered company . It’s the organization that has legal rights and responsibilities. It can enter into contracts , own assets , pay taxes , and sue or be sued . Examples: "ABC Pvt Ltd" registered in India "XYZ Inc" registered in the USA In Oracle Fusion, a Legal Entity is used to handle legal and statutory requirements like tax reporting, financial statements, etc. 👉 In real life : If you run a registered business, that business is your legal entity. 🔹 What is a Business Unit (BU)? A Business Unit is like a department or branch within the legal entity that performs day-to-day operations. It’s where business happens: sales, procurement, invoicing, etc. It’s not a separate company , but a part of the legal entity. You can have multiple BUs under one legal entity . Examples: "Sales BU – India" "Procurement BU – USA" In Oracle Fusion,...

[EBS] Retrieve All Customer Site Use Codes in Oracle E-Business Suite (EBS)

When working with Oracle E-Business Suite (EBS), especially in the context of customer data management, it’s often necessary to retrieve comprehensive information about a customer, including all the associated site use codes. Site use codes—such as BILL_TO , SHIP_TO , SOLD _TO , etc.—indicate the purpose of each customer site. In this blog post, we’ll walk through a SQL query that pulls together key customer site details, aggregating the site use codes into a single, readable format. Query 1: Aggregated Site Use Codes SELECT HP.PARTY_NAME AS CUSTOMER_NAME, HPS.PARTY_SITE_NUMBER, HPS.PARTY_SITE_NAME, LISTAGG(HCSUA.SITE_USE_CODE, ', ' ) WITHIN GROUP ( ORDER BY HCSUA.SITE_USE_CODE) AS SITE_USE_CODES FROM HZ_CUST_ACCT_SITES_ALL HCSA, HZ_PARTY_SITES HPS, HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP, HZ_CUST_SITE_USES_ALL HCSUA WHERE HPS.PARTY_SITE_ID = HCSA.PARTY_SITE_ID AND HCA.CUST_ACCOUNT_ID = HCSA.CUST_ACCOUNT_I...

Powered by Blogger