The Cool Fox

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

Use Fast Swap feature in Oracle Jdeveloper to speed up the development

You can use Fast Swap feature in Oracle Jdeveloper to speed up the development. To enable this feature use the below steps: Go to Tools Menu, then click Preferences Preferences dialog will appear. Click Run -> Weblogic and select Fast Swap radio button.

Clearing Oracle JDeveloper temp and cache directory with hotkeys

Oracle JDeveloper keeps on creating temp, cache and history files. So as a best practice to boost up your JDeveloper performance keep deleting the files frequently. Every time you can't go these directories to manually delete the files, so you can assign hotkeys to perform this delete operation. Follow the below steps to setup hotkeys: Goto run command and type prefetch and hit the OK button Copy the location of this directory, like in our case the below location Goto run command and type prefetch and hit the OK button Copy the location of this directory, like in our case the below location Goto Help -> About -> Properties Tab and search for ide.system.dir this is system directory In the system directory, there are two directories which need to be cleaned: .diagnostics and .history Now create the following batch file (.bat) with above-copied directories....

Properties file for Import Journals, Import Payables Invoices, Import Requisitions

In this post, we will get to know the structure of the .properties files for the below processes: Import Journals Import Payables Invoices Import Requisitions As we know to create .properties we need to create a file with below details: <Job Package Name>,<Import Job Definition Name>, <ZIP file prefix>,<Param1>,....<ParamN> Import Journals Import Payables Invoices Import Requisitions Related Posts: Understanding .properties file for ERP Bulk Import Jobs in Oracle Integration Cloud (OIC)

Powered by Blogger