AWR REPORT
Description Introduced in Oracle 10g and having evolved from the Statspack functionality of Oracle 8i/9i, the Automatic Workload Repository report or AWR report (as it is more commonly known as)…
Read MoreSGA Details – JROD COPY
Description: The System Global Area (SGA) is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The SGA…
Read MoreScript to get dependents for Employee
Description: Script to get dependents for employee describes dependencies between procedures, packages, functions, package bodies, and triggers accessible to the current user, including dependencies on views created without any database…
Read MoreScript to get Aging Bucket Due for Customer
Description: Aging reports help to identify how old the customer Invoice due for the payment. This helps to identify and to decide those Invoice is due last 30 or Last…
Read MoreQA Collection Elements creation
Description: The collection elements that you define can be added to collection plans to determine what quality results data to collect, track, and report. API used for EAM preventive collection…
Read MoreScript to Open Project with Terminated PMs or PDs
Description: Oracle Projects provides default processes for each workflow. You can modify the default processes and create additional methods to accommodate the needs of your business, using the Oracle Workflow…
Read MoreQuery to New Assets Addition in Oracle apps
Description: This query fetches the detailed information related to those assets which are added newly for a particular period. Script to New Asset Addition SELECT FAL.segment1 SOL_ID ,FFV.description BRANCH_NAME ,FAA.tag_number …
Read MoreList of concurrent request – its count by Day, Week and Month
Description: When you define a concurrent program, you can list those programs you want it to be incompatible with. You can also list the program as inconsistent with itself, which…
Read MoreLeases which are expiring 15, 30, 60, 180 days before respectively
Description: This query fetches those leases which are going to expire within 15,30,60,90,180 days, respectively, based on the parameter. SELECT GCC.segment4 SOL_ID ,gl_flexfields_pkg.get_description_SQL(GCC.chart_of_accounts_id ,4,GCC.segment4) BRANCH_NAME ,PLA.lease_id Lease_number ,PLDA.attribute7 Agreement_no ,PAA.address_line1||’,’||PAA.address_line2||’,’||PAA.address_line3||’,’||PAA.address_line4||’,’||PAA.city||’,’||PAA.state…
Read MoreQuery to Create Position Hierarchy by Using APIs
Description: The Hierarchy Diagrammer, included with Oracle HRMS, enables you to create your position hierarchies graphically, and make intuitive drag-and-drop changes to them. HRMS API :Create Position Hierarchy by Using…
Read More