Some Tips About FNDLOAD
Data Synchronization Data Synchronization is a process in which some setup data would be synchronized, and this would be more important w...
Showing posts with label Oracle Technical. Show all posts
Showing posts with label Oracle Technical. Show all posts
Creating ACL for UTL_SMTP
SELECT * FROM dba_network_acls; -- Create ACL and privilege begin dbms_network_acl_admin.create_acl ( acl => 'utl_mail....
Core HR SQL Queries
--Organization through Organization Hierarchy SELECT NAME, TYPE, organization_id FROM (SELECT hou.NAME, TYPE, organization_...
Compile Forms command line
TEST f60gen module=/u5/applupg2/uatappl/au/11.5.0/forms/US/APXINWKB.fmb userid=APPS/APPS output_file=/u5/applupg2/uatappl/ap/11.5.0/forms/US...
Check Database Locks
--To check database locks----[Kill Inactive Session] ---------------------------------------------------- SELECT * FROM dba_locks WHERE bloc...
Application Check List
Application Information Gathering ================================= Existing Operating Units ======================== select ORGANIZATION_ID...
Adding Report to Request Group using API
/********************************************************************** *PURPOSE: To Add a Concurrent Program to a Request Group from backen...
Validating Parameters in Oracle Reports using PL/SQL
Parameters can be populated and validated using various srw pl/sql triggers. The following gives examples of: Validation trigger in paramete...
ORACLE REPORTS PERFORMANCE TIPS
Doc ID 61535.1 Performing operations in SQL may be faster than performing them in Oracle Reports or PL/SQL. The list below explains the mos...
Using SRW Packaged Procedures in Reports
Oracle Reports is shipped with a collection of PL/SQL constructs that contain many functions, procedures, and exceptions that you can refere...
Running SQL*Trace on an Applications Report
There are two methods to running a Report with SQL*Trace which are: Method #1: Normally, in order to run a report with SQL*Trace, you would...
Subscribe to:
Posts
(
Atom
)