Posts by Venkatesh Balasubramanian

Leases 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 More

Query 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

EBS 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 More

EAM 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

Query to EAM Construction Estimation Creation

Description:  Construction units are defined at the organization level, and can include only those activities that are assigned to the same inventory organization. However, you can query construction units associated…

Read More

EAM Asset Number activity association creation API

Description: Oracle Enterprise Asset Management provides several open interfaces and APIs, enabling you to link with non-Oracle applications, applications you build, and applications on other computers. API used to maintain…

Read More

Query to EAM Asset Failure Code, Cause, Resolution creation

Description: Failure Analysis enables you to track an asset failure from the time it is reported until its resolution. Statistics from your collected failure data provide you with information on…

Read More

Capital project hours – includes PTO

Description: A capital project, defined as any project which requires capital flows for completion, usually refers to a project which requires large sums of capital. Purpose of this report is to display Project…

Read More

Add Row on the Top in the APEX Tabular Form

                                  Description: Query explains how to add row on the top in the APEX…

Read More

ASSET DEPRECIATION LOGIC QUERY

Description:  Oracle Assets calculates depreciation using either the recoverable cost or the recoverable net book value as a basis. If the depreciation method uses the asset cost, Oracle Assets calculates…

Read More