Populating Oracle Application LOV values from server
Populating Oracle Application LOV values from server path Description This blog is used to explain how to populate the LOV values of the files placed in specific server path by…
Read MoreBank Accounts APPEND , MICR , End Date using API
AR Cash Management Description This blog is used to load Bank and Branch data from the load files. It end date the bank accounts which are invalid. Create new bank…
Read MoreReminder Alert to PO Workflow Approver
Workflow Mail Notification Description This blog is used to send an email notification to the transaction types like Purchase Order, Requisition, Requisition Change Order and IExpense. The Select queries…
Read MoreOracle HRMS- Person, Assignment , Job , Location Conversion Using Api
Workday Integration Process Description This blog is used to Creating new Person, Assignment, Job creation, Location creation, and Rehiring Person. This blog includes the updating of Person, Job, and assignment…
Read MoreRMAN ISSUES AND SOLUTIONS
Please find the below steps when u face error like below in RMAN. ISSUE ———– RMAN-00571: =========================================================== RMAN-03009: failure of delete command on ORA_DISK_1 channel at 08/30/2013 20:02:49 ORA-07217: sltln:…
Read MoreSteps to Create Baseline
File name: create_baseline.sql — — Purpose: Creates a SQL Baseline on a SQL statement in the shared pool. — Usage: This scripts prompts for…
Read MoreScript to find statements that have significantly different elapsed time than before
File name: whats_changed.sql — Purpose: Find statements that have significantly different elapsed time than before. — Usage: This scripts prompts for four values. —…
Read MoreMove SQL Profile
File name: move_sql_profile.sql — — Purpose: Moves a SQL Profile from one statement to another. – Usage: This scripts prompts for four values. —…
Read MoreScript to Find Whether SQL using Profile
break on sql_id on sql_profile on sql_text skip 1 set lines 165 col sql_profile for a30 col sql_text for a60 wrap set verify off set pagesize 999 col username format…
Read MoreScript to Build Bind Variables
Purpose: Build SQL*Plus test script with variable definitions Description: This script creates a file which can be executed in SQL*Plus. It creates bind variables, …
Read More