How to Modify an Oracle Database Windows Service?
How we can change some parameters for one database winodws service. Background: I have a database called PROD with version 19.3, running on Windows. Its service looks like: This…
Read MoreOPatch error : “Unable to lock Central Inventory”
While applying Patch 31210848 “Microsoft Windows 32-Bit & x86-64 Bundle Patch 12.2.0.1.200714” on database 12.2.0.1on Windows platform I got the following error: Unable to lock Central Inventory. OPatch will…
Read MoreEBS 12.2 Upgrade Readiness Checker Tool – Database Tier (EURC-DT)
Oracle is designing many brand new tools to help customers and to increase the productivity of Oracle E-Business Suite (EBS) DBAs. One such tool is EBS 12.2 Upgrade Readiness Checker…
Read MoreRefresh the Parent Page on Closing the Modal Dialog in Oracle APEX
Introduction: Refresh the Parent Page on Closing the Modal Dialog in Oracle APEX.. Cause of the issue: The User has a requirement to refresh the Parent Page Interactive region on…
Read MoreValidating the Duplicate values using JavaScript in Oracle APEX
Introduction: To avoid duplicate values in Interactive Grid in Oracle APEX. Cause of the issue: In newly created APEX Page, there is user requirement to validate the duplicate values on…
Read MoreAR Customer Ledger with Unpaid Invoices
AR Customer Ledger with Unpaid Invoices SELECT arps.org_id, hou.NAME company, rctl.customer_trx_id, TO_CHAR (arps.trx_date, ‘MON-RRRR’) fiscal_year_month, arps.trx_number invoice_number, arps.trx_date invoice_date, arps.customer_id, NVL (arps.amount_due_original, 0) total_invoice_amount, NVL (arps.tax_original, 0) total_tax_amount, NVL (quantity_invoiced,…
Read MoreORA – bootstrap Error
ORA-00704 bootstrap process failure After Upgrading ORACLE_HOME (from 11.1.0.7.0 to 12.1.0.2.0), I was started my database by using startup command, then got below error. Connected to an idle instance. SQL>…
Read MoreADJRIINITPASSWD.sql Failed
ADJRIINITPASSWD.sql Fails With An ORA-01031 Error: Error: Unable to execute statement < Begin ad_jar.get_jripasswords(:l_storepass, :l_keypass); End; > len = 63 AD Administration error: ORA-01031: insufficient privileges ORA-06512: at “SYS.DBMS_SESSION”, line…
Read MoreWhy Oracle Apex deemed as a customer’s first choice in low-code app development?
Oracle Application Express (APEX) is a low-code web application platform that allows you to work with Oracle databases. Oracle APEX was referred to as HTML DB earlier. Professional applications can…
Read MoreHow to Choose the Best Oracle Service Provider?
The future of databases is cloud-based. In the next few years, nearly all businesses will move to the cloud. If you are considering harnessing Oracle Database Cloud, you need to…
Read More