How To PLAY_SOUND in Oracle Forms
Introduction Play sound is used to play audio files in Oracle Forms, Play Sound plays the sound object in the specified sound item PLAY_SOUND examples The following plsql block you…
Read MoreError: resource-env-ref,CDI Container and disable policy
org.apache.cxf.jaxws.context.WebServiceContextResourceResolver/bus’ declared in the standard descriptor or annotation has no JNDI name mapped to it. The resource-env-ref must be mapped to a JNDI name using the resource-env-description element of the…
Read Moreweblogic error ‘could not get the server file lock’
Down the Admin server console Clear AdminServer.lok file from tmp foleder under Admin server
Read MoreLsInventorySession failed: RawInventory gets null OracleHomeInfo
Description: In Oracle EBS Instance, recently I have faced the error as lsinventory session failed while try to run ./opatch lsinventory in our Instance.OPatch wasn’t able to find the database…
Read MoreInline External Tables
Overview Inline external tables enable the run time definition of an external table to be part of a SQL statement, thus eliminating the need to create an external table as…
Read MoreLoading CSV Files from External Tables
Overview This topic provides examples of how to load CSV files from external tables under various conditions. Some of the examples build on previous examples. Technologies and Tools Used The…
Read More19C LISTAGG DISTINCT
Overview The LISTAGG aggregate function now supports duplicate elimination by using the new DISTINCT keyword. The LISTAGG aggregate function orders the rows for each group in a query according to…
Read MoreOracle Analytical Functions
The easiest way to understand analytic functions is to start by looking at aggregate functions. An aggregate function aggregates data from several rows into a single result row. The aggregate…
Read MoreFacing performance issue after upgrading database from 12.1.0.2 to 19C with Ebusiness suite 12.2
Scenario : Facing performance issue after upgrading database from 12.1.0.2 to 19C with Ebusiness suite 12.2 Analysis : While analyzing we came across the parameter “_lm_res_hash_bucket” which inturn mentioned for…
Read MoreMissing Archive log error in Golden gate integrated capture.
Scenario: There was a missing archive log error and we need to change the archive log location for integrated capture process in Goldengate. Error : ERROR OGG-00868 Error code 1291,…
Read More