On-demand cloud computing services are gaining in popularity. Oracle Cloud supports technologies such as IoT, Machine Learning, AI, and human interfaces. Oracle Cloud Infrastructure offers scalability, reliability, and integrated governance.…
Read Morewhen emails are struck and not send by workflow notification mailer perform the following. 1) Login into EBS applications and send a “TEST MAILER” to yourself to validate response of…
Read MoreCreates the DDL for the specified job:- SET LONG 20000 LONGCHUNKSIZE 20000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ON BEGIN DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'SQLTERMINATOR', true); DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'PRETTY',…
Read MoreScript to create foreign key DDL on all tables. SET LONG 20000 LONGCHUNKSIZE 20000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ON BEGIN DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'SQLTERMINATOR', true); DBMS_METADATA.set_transform_param…
Read MoreDBMS_ADVISOR :- 1. Gather a number of SQL statements that will form the tuning workload. 2. Check that the user running DBMS_ADVISOR has the ADVISOR privilege, and has SELECT access…
Read MoreBy default in Oracle Applications R12, users are not able to access Forms directly via the following url: http://hostname:port/forms/frmservlet The following error would pop out: APP-FND-01542: This Applications Server is…
Read More1. Overview This document will be helpful in protecting updation on a row based condition in Oracle apex interactive Grid. 2. Technologies and Tools Used Oracle Apex code. 3. Use Case In…
Read MoreCreation of Duplicate database using the RMAN Starting from 11G you can proceed with the duplicate database in 2 ways – Active cloning and backup-based cloning. Now we are going…
Read MoreOverview This document talks about how to remove the interactive grid default alert for unsaved changes.we are going to achieve this requirement using JavaScript. Technologies and Tools Used The following technologies has been used to achieve the expected output. JavaScript Use Case Assume that we are having form region and interactive grid region on the same page.We are having the same save button for the both region.In this scenario ,If we write the on change event for refresh of the interactive grid region. This will throw error for unsaved changes and the selected values in the form region will get clear. To over come this we are going for the JavaScript. This document explains how to achieve this requirement. Architecture Following steps explains in detail, Step 1: We needs to add the static ID to the interactive grid region. Step 2: In the change event of the button or item, we have to add the dynamic action to execute JavaScript and we needs to add the below code. apex.region(‘IG_REGION’).widget().interactiveGrid(‘getViews’, ‘grid’).model.clearChanges(); apex.region(“IG_REGION”).refresh(); Screen Shot Output: Using the above step we can remove the unsaved changes alert of the interactive grid.
Read MoreOverview In this document, we are going to see about how to add customized background color in report cell of interactive Report.This is achieved using CSS and JavaScript.Also,Different method to…
Read More