Skip to main content

The Cool Fox

Oracle Cloud Technologies Blog

Home
Site Map
Oracle OCI
Oracle OIC
Oracle VBCS
Oracle Fusion
Oracle VBS
Oracle ADF
Oracle SOA
Oracle Apps
Oracle OAF
Oracle SQL

Home
Site Map
Oracle OCI
Oracle OIC
Oracle VBCS
Oracle Fusion
Oracle VBS
Oracle ADF
Oracle SOA
Oracle Apps
Oracle OAF
Oracle SQL

Home
Site Map
Oracle OCI
Oracle OIC
Oracle VBCS
Oracle Fusion
Oracle VBS
Oracle ADF
Oracle SOA
Oracle Apps
Oracle OAF
Oracle SQL

Showing posts with the label Fusion BIP

Posts

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

on March 05, 2025

BIP Fusion BIP OIC Oracle BIP Oracle Fusion BIP + Oracle OIC

BIP Fusion BIP OIC Oracle BIP Oracle Fusion BIP Oracle OIC

Get link
Facebook
X
Pinterest
Email
Other Apps

[Fusion] SQL Query to get BU Name, Legal Entity & Ledger Information of Customer Site in Oracle Fusion ERP

on May 31, 2024

Fusion BIP Oracle Fusion Oracle Fusion ERP Oracle Fusion Financials + Oracle SQL

Fusion BIP Oracle Fusion Oracle Fusion ERP Oracle Fusion Financials Oracle SQL

Get link
Facebook
X
Pinterest
Email
Other Apps

[Fusion] How to use multi selection LOV in Oracle Fusion BIP Report?

on May 29, 2024

Call Fusion BIP Report Fusion BIP +2 Oracle BIP Oracle Fusion Oracle Fusion ERP Oracle Fusion Financials Oracle SQL

Call Fusion BIP Report Fusion BIP Oracle BIP Oracle Fusion Oracle Fusion ERP Oracle Fusion Financials Oracle SQL

Get link
Facebook
X
Pinterest
Email
Other Apps

All Categories

Account Hierarchy1 Accounting Flexfields1 API2 ASCII1 Autonomous Database1 BIP7 BIP Refresh Time1 BIP Report1 Business Unit1 Call Fusion BIP Report2

Change Password1 Code Combinations2 Compute Instance2 Data Aggregation2 Database5 Date Conversion1 DB Adapter2 Decryption1 Development1 EBS3 Encryption1 ESS Jobs3 Examine1 FBDI3 Fusion APIs1 Fusion BIP3 GIT2 GL3 GL Journals1 GL_DAILY_CONVERSION_TYPES1 GL_DAILY_RATES1 ICS1 Identity Domain1 Integrations1 Java1 Journal Import1 Keys1 Legal Entity1 LookupTypeLOV1 LOV1 LOVs1 MultiPartAPIs1 Networking1 NVL2 NVL in OIC2 OCI10 OCI Compute5 OCI Events Service1 OCI Free Tier2 OCI Notifification Service1 OCI Security2 OIC3 OIC Mapper2 Oracle18 Oracle ADF17 Oracle APEX1 Oracle Apps58 Oracle Apps R125 Oracle ATP1 Oracle BIP6 Oracle Cloud9 Oracle Cloud Free Tier1 Oracle cloud Infrastructure8 Oracle Cloud Security2 Oracle Cloud VM1 Oracle DB4 oracle ebs4 Oracle ERP2 Oracle ERP Adapter2 Oracle ERP Cloud6 Oracle financials2 Oracle Forms1 Oracle Fusion49 Oracle Fusion BIP3 Oracle Fusion ERP11 Oracle Fusion Financials13 Oracle Integration Cloud3 Oracle OAF17 Oracle OCI13 Oracle OIC21 Oracle SOA 12c10 Oracle SQL16 Oracle VBCS1 Oracle VBS2 Oracle Visual Builder Cloud Service1 Oracle Visual Builder Studio2 Oracle Workflow Notifications1 Others10 Properties1 R121 Register BIP as ESS Job1 Reset Password1 Responsibility1 REST4 Security List1 Site Map1 SOAP2 SOAP API2 SOAP UI3 SQL15 SQL Functions3 SQL Queries14 SQL Query8 SQL Tips3 SSH1 Value Sets1 VBCS1 Virtual Machine2 Virtual Machines1 XML1 XSLT1

Show more Show less

Gurpreet Singh - Oracle ACE.

Total Pageviews

Search This Blog

Popular Posts

[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...

SQL Query to fetch Exchange Rates/Daily Rates (using GL_DAILY_RATES and GL_DAILY_CONVERSION_TYPES) in Oracle Fusion Financials

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...

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,...

Change look and feel of Oracle JDeveloper to Windows

To change the look and feel of Oracle JDeveloper to Windows, follow these steps: Go to Tools Menu, then click Preferences Preferences dialog will appear. In the Environment section, change the Look and Feel from Oracle to Windows

Powered by Blogger

All rights reserved