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 SQL Query

Posts

[SQL] Mastering ROW_NUMBER() OVER(PARTITION BY ...) in Oracle SQL

on March 26, 2025

Database Oracle Oracle DB Oracle SQL SQL SQL Queries + SQL Query

Database Oracle Oracle DB Oracle SQL SQL SQL Queries SQL Query

Get link
Facebook
X
Pinterest
Email
Other Apps

[SQL] Mastering GROUP BY: Understanding ROLLUP, CUBE, and GROUPING() in Oracle SQL

on March 23, 2025

Database Oracle Oracle DB Oracle SQL SQL SQL Queries + SQL Query

Database Oracle Oracle DB Oracle SQL SQL SQL Queries SQL Query

Get link
Facebook
X
Pinterest
Email
Other Apps

[SQL] Generating a List of Dates Between Two Given Dates (From & To date) in Oracle SQL

on March 03, 2025

Oracle SQL SQL SQL Queries +0 SQL Query

Oracle SQL SQL SQL Queries SQL Query

Get link
Facebook
X
Pinterest
Email
Other Apps

SQL Query to get Code Combination Segment Value Description in Oracle Fusion (Invoice Tables)

on August 01, 2023

BIP Code Combinations GL Oracle +7 Oracle BIP Oracle Cloud Oracle ERP Cloud Oracle financials Oracle Fusion Oracle Fusion ERP Oracle Fusion Financials SQL SQL Queries SQL Query

BIP Code Combinations GL Oracle Oracle BIP Oracle Cloud Oracle ERP Cloud Oracle financials Oracle Fusion Oracle Fusion ERP Oracle Fusion Financials SQL SQL Queries SQL Query

Get link
Facebook
X
Pinterest
Email
Other Apps

SQL Query to get Concatenated Segments in Oracle Fusion (Invoice Tables)

on July 17, 2023

BIP Code Combinations GL Oracle +7 Oracle BIP Oracle Cloud Oracle ERP Cloud Oracle financials Oracle Fusion Oracle Fusion ERP Oracle Fusion Financials SQL SQL Queries SQL Query

BIP Code Combinations GL Oracle Oracle BIP Oracle Cloud Oracle ERP Cloud Oracle financials Oracle Fusion Oracle Fusion ERP Oracle Fusion Financials SQL SQL Queries SQL Query

Get link
Facebook
X
Pinterest
Email
Other Apps

All Categories

Account Hierarchy1 Accounting Flexfields1 API2 ASCII1 BIP7 BIP Refresh Time1 BIP Report1 Call Fusion BIP Report2 Change Password1 Code Combinations2

Compute Instance1 Database4 Date Conversion1 DB Adapter2 Development1 EBS3 ESS Jobs3 Examine1 FBDI3 Fusion BIP3 GIT2 GL3 GL Journals1 GL_DAILY_CONVERSION_TYPES1 GL_DAILY_RATES1 ICS1 Identity Domain1 Integrations1 Java1 Journal Import1 Keys1 LookupTypeLOV1 LOV1 LOVs1 MultiPartAPIs1 Networking1 NVL2 NVL in OIC2 OCI7 OCI Compute4 OCI Events Service1 OCI Free Tier2 OCI Notifification Service1 OIC3 OIC Mapper2 Oracle14 Oracle ADF17 Oracle APEX1 Oracle Apps57 Oracle Apps R124 Oracle BIP6 Oracle Cloud9 Oracle Cloud Free Tier1 Oracle cloud Infrastructure5 Oracle Cloud Security2 Oracle Cloud VM1 Oracle DB3 oracle ebs3 Oracle ERP1 Oracle ERP Adapter2 Oracle ERP Cloud6 Oracle financials2 Oracle Forms1 Oracle Fusion45 Oracle Fusion BIP2 Oracle Fusion ERP10 Oracle Fusion Financials10 Oracle Integration Cloud3 Oracle OAF16 Oracle OCI10 Oracle OIC21 Oracle SOA 12c10 Oracle SQL12 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 REST2 Security List1 Site Map1 SOAP2 SOAP API2 SOAP UI3 SQL10 SQL Queries9 SQL Query5 SSH1 Value Sets1 VBCS1 Virtual Machine1 Virtual Machines1 XML1 XSLT1

Show more Show less

Gurpreet Singh - Oracle ACE.

Total Pageviews

Search This Blog

Popular Posts

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

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

In this post we will see how to use multi select LOV in Oracle Fusion BIP Report. Login to Fusion BI Catalog of your fusion instance by using the below URL: https://<server>.fa.ocs.oraclecloud.com/analytics/saw.dll?bieehome Once logged in, create new Data Model by clicking Catalog -> Data Model It will present you untitled Data Model. Now, click on New Data Set button and choose SQL Query as type of the Data Set from the list. Enter the name of Data Set like Q1 and choose Data Source as ApplicationDB_FSCM and provide the SQL query We have the below query SELECT aia.invoice_id ,aida.invoice_distribution_id ,aila.line_number ,( SELECT hou.name FROM HR_OPERATING_UNITS hou where hou.organization_id=aia.org_id) org_name ,( SELECT ps.vendor_name FROM poz_suppliers_v ps WHERE ps.vendor_id=aia.vendor_id ) v...

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

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.

[OIC] Purge Oracle Fusion Interface Data using OIC

This post will show how to Purge Oracle Fusion Interface Data using OIC. Scenario - Consider a scenario that you have created OIC Interface to Import Journals into Oracle Fusion ERP. Now, you want that once import is completed, interface tables should purge automatically. So, follow the below steps to implement this: Callback integration of type Application Driven will be created which will be accepting the callback once " Import Journals " job will be completed. We will be using Oracle ERP Cloud Adapter Connection as trigger point of the integration with below configuration. Add another Oracle ERP Cloud Adapter Connection, just to get interface ID of import job Also, get details for Purge job from Fusion by going to Setup and Maintenance -> Search -> Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications InterfaceLoaderPurge Purge Interface Tables /oracle/apps/ess/financials/commonMo...

Powered by Blogger

All rights reserved