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

Posts

[SQL] Mastering COUNT(*) OVER() in Oracle SQL

on May 03, 2025

Data Aggregation Oracle SQL SQL +1 SQL Functions SQL Queries SQL Query SQL Tips

Data Aggregation Oracle SQL SQL SQL Functions SQL Queries SQL Query SQL Tips

Get link
Facebook
X
Pinterest
Email
Other Apps

[SQL] Encrypting and Decrypting Data Using Oracle's DBMS_CRYPTO Package

on April 28, 2025

Decryption Encryption Oracle SQL SQL SQL Functions + SQL Queries

Decryption Encryption Oracle SQL SQL SQL Functions SQL Queries

Get link
Facebook
X
Pinterest
Email
Other Apps

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

on April 20, 2025

oracle ebs Oracle ERP Oracle SQL SQL SQL Queries SQL Query + SQL Tips

oracle ebs Oracle ERP Oracle SQL SQL SQL Queries SQL Query SQL Tips

Get link
Facebook
X
Pinterest
Email
Other Apps

[OAF] Run Programmatic Code When a Drop-Down Value Changes in Oracle OAF

on April 19, 2025

Oracle Oracle Apps Oracle Apps R12 + Oracle OAF

Oracle Oracle Apps Oracle Apps R12 Oracle OAF

Get link
Facebook
X
Pinterest
Email
Other Apps

[SQL] Mastering LISTAGG in Oracle SQL: Combine Rows into Strings

on April 17, 2025

Data Aggregation Database Oracle DB +3 Oracle SQL SQL SQL Functions SQL Queries SQL Query SQL Tips

Data Aggregation Database Oracle DB Oracle SQL SQL SQL Functions SQL Queries SQL Query SQL Tips

Get link
Facebook
X
Pinterest
Email
Other Apps

[OCI] Understanding Network Security Group in Oracle Cloud (OCI)

on April 06, 2025

OCI OCI Compute +0 Oracle Cloud

OCI OCI Compute Oracle Cloud

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 Customer1 Data Aggregation2 Database5 Date Conversion1 DB Adapter2 Decryption1 Development1 EBS4 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 Apps59 Oracle Apps R126 Oracle ATP1 Oracle BIP6 Oracle Cloud9 Oracle Cloud Free Tier1 Oracle cloud Infrastructure8 Oracle Cloud Security2 Oracle Cloud VM1 Oracle DB4 oracle ebs5 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 TCA1 Value Sets1 VBCS1 Virtual Machine2 Virtual Machines1 XML1 XSLT1

Show more Show less

Gurpreet Singh - Oracle ACE.

Total Pageviews

Search This Blog

Popular Posts

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

Fix java.lang.OutOfMemory Java Heap Space error in JDeveloper

Why out-of-memory error is thrown? Permanent Generation: The Permanent Generation is where class files are kept. These are the result of compiled classes and JSP pages. If this space is full, it triggers a Full Garbage Collection. If the Full Garbage Collection cannot clean out old unreferenced classes and there is no room left to expand the Permanent Space, an Out‐of‐ Memory error (OOME) is thrown and the JVM will crash. There are three basic JVM command switches that control the amount of memory in the Java heap. -XX:Xms -XX:Xmx -XX:MaxPermSize -XX:Xms used to set memory available to JVM initially. -XX:Xms used to set maximum amount of memory into which the JVM can grow . -XX:MaxPermSize are used to set size for Permanent Generation. Fixing out-of-memory error Find the location of Oracle Middleware Home. Click here to see Navigate to the location: <Oracle_Middleware_Home_Location> \ jdev\bin and open the file jdev.c...

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

Use the below query to get BU Name, Legal Entity & Ledger Information of Customer Site in Oracle Fusion ERP: SELECT hp.party_id, hca.cust_account_id, hps.party_site_id, hcas.cust_acct_site_id, hcsu.site_use_id, hl.location_id, hp.party_number, hp.party_name, hca.account_number, hps.party_site_number, hcsu.site_use_code, hcsu.primary_flag, hl.address1, hl.address2, hl.address3, hl.address4, hl.city, hl.state, hl.county, hl.province, hl.country, hl.postal_code, hcsu.set_id, bu.bu_id, bu.bu_name, bu.short_code, bu.legal_entity_id, bu.primary_ledger_id FROM hz_partie...

How to create List Of Values (LOV) using SQL Query in BIP ESS Job in Oracle Fusion?

In this post we will look at how to create List Of Values (LOV) using SQL Query in BIP ESS Job In previous post we had defined an ESS Job from BIP Report with one parameter Invoice Source. Now we will make this parameter as LOV. In Manage Enterprise Scheduler Job Definitions , go to Manage List of Values Sources tab and click on Add button Select the Application Name as Application Toolkit , LOVType as User Defined . Enter the LOV Source Name, description and enter below query then click Save and Close button SELECT rownum AS LOV_ID , NAME FROM ( SELECT DISTINCT source NAME FROM ap_invoices_all ) ORDER BY 2 LOV will be saved with LOV Definition Name as sessiondef.oracle.apps.atk.essMeta.model.publicView.INV_SRCAtkEssLOVVO Now we can assign this LOV to o...

Understanding .properties file for ERP Bulk Import Jobs in Oracle Integration Cloud (OIC)

In this post, we will understand how to import FBDI files using OIC and how to create .properties file for the process. To import FBDI file using OIC we need two files: FBDI zip file .properties file While working with ERP Adapter in OIC, we select the below option to Import FBDI in Oracle Fusion Cloud. Then we select the Bulk Import Process name Here we selected Import Journals process. Make a note of Import Job Name and...

Powered by Blogger

All rights reserved