SGA 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 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 MoreEBS to FUSION PA (Project Accounting) Table Changes
Description: One of the most common requirement for every technical consultant working in oracle and Related technologies is to find out specific database tables which hold a particular piece of…
Read MoreEAM Preventive maintenance Last service reading API
Description: EAM enables you to generate Work Orders automatically using a preventive maintenance schedule, based on Runtime Rules, Day Interval Rules, and List Dates. API used for while generating Preventive…
Read More