Monthly Archives: September 2021

How to choose the Best Offshore Oracle Service Provider?

In the current business environment, cloud-based services have grown in high popularity among companies. Statistically, 93% of enterprises preferred the multi-cloud approach, while 87% focused on hybrid cloud strategies in…

Read More

Oracle APEX Page Item shuttle with filter

Introduction: Here is small tip how to create filter / search field for APEX shuttle item values. For this you need just place jQuery code to page JavaScript Function and…

Read More

Interactive Report Row Highlight Based on Application User

Introduction First create interactive report. In this example rows where manager name equals APP_USER value are highlighted. I have used following query joining EMP and DEPT tables for interactive report:…

Read More

Creating Excel File in Oracle Forms

Below is the example to create an excel file in Oracle Forms. Pass the Sql query string to the below procedure to generate an Excel file using Ole2 package. Sample…

Read More

Using Find_Alert and Show_Alert in Oracle Forms

Introduction Show_alert is used to display model window messages in Oracle Forms and Find_alert searches the list of valid alerts in Form Builder, when the given alert is located, the…

Read More

Using Post_Query Trigger in Oracle Forms

Introduction When a query is open in the block, the Post-Query trigger fires each time Form Builder fetches a record into a block. The trigger fires once for each record…

Read More

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 More

Error: 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 More

weblogic error ‘could not get the server file lock’

Down the Admin server console Clear AdminServer.lok file from tmp foleder under Admin server

Read More

Getting prepared for the Changing world

Due to current situations, the desk, sofa or even the dining table has become our office. Now, working from home is a very common affair for people like us who…

Read More