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 Database

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] ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes

on January 20, 2025

Database Oracle +0 Oracle DB

Database Oracle Oracle DB

Get link
Facebook
X
Pinterest
Email
Other Apps

Dealing with Locked Session & DB Objects in Oracle

on November 23, 2023

Database EBS oracle ebs Oracle SQL R12 SQL + SQL Queries

Database EBS oracle ebs Oracle SQL R12 SQL SQL Queries

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

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.

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

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

For this post we will be creating a new Common Lookup Type and then attaching that to a parameter of BIP ESS Job which we had already defined. Go to Manage Common Lookup screen and create a new lookup with below lookup type and values: Now create a new List of Values source with the below information List of Values Source Definition Name will be: oracle.apps.fnd.applcore.lookups.model.publicView.CommonLookupPVO Now edit the parameter of the ess job and select the Page Element as List of Values, List of Values Source as INV_SRC1 (the name which we had given to LOV), Attribute as LookupCode and Selected Attribute as Meaning and then click on Save and Close Once done click on Manage Dependencies icon after selecting the parameter row. If you're not able to click it, first save the job definition and then try again. You will see the below screen Select ByLookupType as View Criteria and enter the name of lookup type in Default Valu...

Powered by Blogger

All rights reserved