Sunday, December 29, 2013

Oracle Application Scripts(Queries)



SQL – PL SQL

Display Negative Number in angle brackets

Insert BLOB image file in oracle database table

SQL Usefull Functions

Oracle Join Queries

EMP, DEPT and SALGRADE Tables Data

oracle SQL Query For Calender

Oracle SQL Queries

Date Between and Date Range query

Oracle PL SQL Programs

TO KNOW PRIMARY KEY DETAILS

TO FIND INDEX COLUMNS

TO FIND INDEX DETAILS

Script for getting XML tags in SQL

DATALOAD (DLD) FORMAT SQL EXTRACT OF CVR CROSS VALIDATION RULES

PL SQL Use Full Programs

SQL Usefull Functions

Script To find Oracle API's for any module

Splitting String using Oracle SQL

Find Table and Column Name with table and column description

Example of DBMS_XMLGEN.getxml to generate XML Tag using oracle query

Send e mail through PL SQL code

To Find Column

Converting amount in numbers to words Query


Oracle Database Administration(DBA)

Oracle Applications/Versions/Patch Levels and machine, server or instance Queries

Session Activity Queries.docx

Query to list out the Schemas and the status of the products in Oracle Applications

Common SQL Commands and Syntaxes for DBA

Data Base Queries

How To Find Optimizer Underscore

Oracle Database Commands and Queries:


FNDLOAD Scripts

FND Scripts to UPLOAD and Download For Request Set, Menu, Form, Function, Value Set, Lookup and Concurrent Program

FNDLOAD

Creating a LDT files in Oracle

FND LOAD

Document on Creation of LDT Files in Oracle

XXAA_ACCT_FLEXFIELD_REP - XXAA Account Flex Field Report

Oracle FNDLOAD Scripts


Oracle Inventory(INV)

This is an inventory form query for few fields which are important.

Oracle Item Price By Supplier Query

Oracle Items Extract Query

Oracle Item Extract Query

Oracle Item Disabling Script

Oracle Apps Inventory KEY Tables

Query to find Item template attribute values :

Query to get item status attribute controls :

Query to get item attributes under status control :

Query to find item status attributes :

Query to get item attributes NOT under status control :

INVENTORY Queries

To Check Open inventory Periods


Oracle Purchase Order(PO)

PO Queries

List of Approvers for a Purchase Order in Position Hierarchy

PO ALL RECEIPTS Query

WIP Queries

PO Queries

PO Interface Tables

Debugging PO Query


Oracle Account Payables(AP)

API to Cancel the Oracle AP Invoice

AP-SLA-GL Link Query

General Ledger(GL) to Account Payables(AP)

To Select Prepayment Invoice Status in Oracle Payables

REPAY INVOICE DETAILS

Script to extract expense invoices for a Company for given period Query

AP To GL Extraction Queries


Oracle R12 Suppliers

Oracle R12 Supplier Master Query

Creating a R12 Supplier Bank accounts Using API

Update R12 Supplier Contact details Using API

Oracle R12 Supplier Headers, Sites and Contacts Single Insertion Scripts

Single Insertion Scripts for R12 Supplier Banks

Supplier Sites Bank Query

Supplier Site Payment Methods in R12


Oracle Expenses

Expense report Extract Queries


Oracle Payments

Oracle Payments Query


Oracle Procure To Pay(P2P)

PROCURE TO PAY CYCLE QUERY WITH RECEIPTS

A ‘P2P’ query which Populates all PO details:

PROCURE TO PAY CYCLE QUERY WITH RECEIPTS

Procure to Pay cycle query with out Receipt

P2P Queries

P2P Query

P2P CYCLE QUERY WITH RECEIPTS


Oracle HRMS

Query to to find the Employee Supervisor name

Low Level Employee Supervisor Relationships

Oracle HRMS Appraisal Status Query

Postion Hierarchy Details with Superior in Oracle HRMS

Employee Superviser Query

HRMS Employee QUERY

HR EMPLOYEE SALARY UPDATE API

HR EMPLOYEE SUPERVISOR UPDATE API

HR EMPLOYEE ORGANIZATION UPDATE API

Getting the Position Name and Supervisor Id by Oracle User Login Name

Designation of Employee Query In Oracle


Oracle Payroll

Query for Oracle Payroll Salary Slip – Salary Slip Detail Report Query – How to find out detail of salary slip – Element wise Landscape Salary Slip at Payroll Run Level or quick pay level

Query to Find out all Earning and Deduction Elements and values after Payroll Run

Query to Find All Active Employees and Current Salary

Query to find out payroll Costing Detail – How to find out payroll costed accounts – Query to find out Payroll Charged Accounts

Oracle Payroll Costing Detail Query

Oracl Payroll Query

Oracl Payroll Query

Oracle Payroll Queries

Payroll Tables


Oracle Time and Labor(OTL)

OTL_Tables_Links


Oracle Account Receivables(AR)

AR To GL Query

Oracle Receivable Contacts Query

Oracle Receivable Bill to and Ship to Address Queries

Oracle Receivables Bill To Query

Oracle Receivables SHIP TO query

AR Customer Query

Account Receivable Table Information

Create AR Invoice using API

AR Cash Receipt using API


CRM

Service Contract Query


Oracle Fixed Assets(FA)

Fixed Assets Queries


Oracle Project Accounting(PA)

Project Accounting Queries


Oracle Order Management(OM)

OM Query

Install Base creation for all the Sales Order for which it is missing

Sales Order , Customer and Receipts Related Quries

List Salesrep Salary Query

How to find order header information


Oracle Workflow(WF)

Oracle Workflow Query

Workflow Tables


UNIX
Oracle Unix System Administrator Scripts

Shell Script Tutorial


Oracle Forms

Returns the Query for the forms used by a user in the last number of days

Oracle Forms Compilation

Query used To Check The Form personalization


Oracle Reports

Find Running, Pending, On Hold and Scheduled Requests

Sending EMail After Report Code

To Check Module Wise Reports

To get report responsibility


Oracle XML Publisher(XMLP)

Oracle XML Operations XMLType, UPDATEXML, EXISTSNODE, XMLELEMENT, XMLATTRIBUTES, XMLFOREST, XMLAGG, XMLROOT and Basic XML Parsing via PL/SQL

XML Tags

How to Format Oracle output with HTML/XML

Script for getting XML tags in SQL

Delete Template and Data defination from Backend

How to Delete XML Publisher Definition and Template

Example of DBMS_XMLGEN.getxml to generate XML Tag using oracle query

Oracle XML Publisher Queries

setting the Password for PDF File sent through XML Publisher

Oracle XML Publisher Queries


Oracle Discoverer

Discoverer Query to find BA, BA_DESC, FOLDER_NAME, FOLDER_NAME_DESC

To Find Oracle Discoverer Reprt Name


Oracle General Ledger(GL)

To Get Account Description

General Ledger(GL) to Account Payables(AP)

MASS ALLOCATION MIGRATION - DATALOAD CLASSIC LAYOUT

EXTRACT MASS ALLOCATIONS INTO A DATALOAD Format

GL INTERFACE SUMMARY

LEGAL ENTITIERS & ORGANIZATIONS

GL SUMMARY TEMPLATE DEFINITIONS

SET OF BOOKS CONFIGURATION OVERVIEW

SEGMENT VALUE SET LISTINGS

GL PERIOD STATUSES

MASS ALLOCATION FORMULA REVIEW SCRIPT

GL JOURNAL LINES WITH AP SOURCE REFERENCE FIELDS

GL JOURNAL BASED TRIAL BALANCE

GL Journal Header Summary

GL INTERFACE DETAIL

FSG REPORTS AND COMPONENTS OVERVIEW

CHART OF ACCOUNTS STRUCTURE

GL : CChart of Account Segment Hierarchy Ranges

GL BALANCES & MOVEMENTS

GL AUTOPOST DEFINITIONS

GL : ADI Journal Balances

To Check Period Status(open/close) of different Oracle Apps modules

 

Oracle Sub ledger Accounting(XLA)

Queries to Check All SL Entries for an AP Invoices


Oracle Financials

JOIN CONDITIONS USED IN ORACLE APPS(GL,AP,AR,INV ETC) KEY JOINS


Oracle Application Framework(OAF)

Adding a new row in OAF


Oracle Application Object Library(AOL)

User

To Get the Oracle Application User Password in R12

To Find USER Concurrent Request in Oracle

To get assigned responsibility to a user.

Query to Find The Inactive Users

Reset Application Password

Query to Retrieve the User Concurrent Progrms, Responsibilities, Menus, Request Groups

Reset the Oracle Apps user PWD Query

API’s to Add Responsibility to USER in oracle

Getting the Position Name and Supervisor Id by Oracle User Login Name

Change User password from backend

API’s to Create User from backend in oracle

TO Retrieve the Entered USER Concurrent Programs,Responsibilities, Request Groups, Menus

How to Delete Responsibility From User

Return which functions a user can access

To get assigned responsibility to a user.

Number of users logged into Oracle E-Business Suite

Permission names for specific User

Simple Steps to Find Password for an Application User in Oracle Applications

Script to End Date Responsibility for a User

How many users are connected to Oracle Applications

Check User -- Application and assigned responsiblity


Responsibility

To find the responsibilty for which form was assigned

Query that shows all the repsonsibilities and what functions are attached to these responsibilities.

To get list of responsibilities.

To get responsibility and attached request groups.

Responsibilities Listing

To Get the All Menu Functions Under a Responsibility

Purpose To get all Request attached to a responsibility

To get responsibility and attached request groups

Add any responsibility (Even without Sysadmin)

How To Check Application wise Responsiblity

Query to get Request Group Details Responsibility wise

Responsibilities assigned to User Query

Add Responsibility using Sqlplus


Concurrent Request

To Get Concurrent Request Details

List Concurrent Requests Responsibility Wise....

To find out about the given Request ID Details

To calculate request time

To get all request with application

Currently held locks per concurrent request

Track and Trace E-Business Suite Concurrent Request - EBS Logs, O/S Process IDs, Locks

SQL Query to list running concurrent requests

How To Check Current Status Of Request

Get Request Group name Associated With Application


Concurrent Program

Concurrent program Queries

Move concurrent program from One Instance to Another Instance with same name. It should work under the same responsibility and request

To Get Concurrent Program Responsibility and Request Group

IMPLEMENTING CONCURRENT PROGRAM FOR SQL LOADER

TO FIND THE EXECUTABLE DETAILS

Remove Concurrent Program from Request Group From Backend via API

Delete Concurrent Program Parameter From Backend via API

Delete Concurrent Program Executable From Backend via API

Add Concurrent Program to Request Group From Backend via API

Register Concurrent Program Parameters From Backend via API

All responsibilities registered to a concurrent program

How to Delete Concurrent Program

return the scheduled concurrent programs and request sets

Concurrent Program Registration Backend

Adding a concurrent program to Request Group

To Get Concurrent Program Trace File

Register a Custom Concurrent Program and Executable

Creating a Concurrent Programe From Backend in Oracle

Concurrent program execution through back end

Concurrent Program Backend Registration Code

To Get Concurrent Program Prameters Query

 

Menu

To get submenus and Function attached to this Main menu.

To get Menus Associated with responsibility

Menus Listing

To Check Application--> Responsablity and Asssigned Menu

Menus Responsibilities Query

 

Functions

Menu and Functions Related Scripts

Pass The obtained Function id or function name to following query

Function Assigned to Responsibilities Query

 

Flex Fields

Query to get Flex Values based on Segment Independent Names

FLEXFIELD SECURITY RULE DEFINITIONS

FLEXFIELD SECURITY RULE ASSIGNMENTS TO RESPONSIBILITIES

Oracle Flex Fields

How To get Flexfilds Application wise

how to find mapping between segment name and the value set

DFF Process

 

Profile Option

All Profile options

TO FIND PROFILE OPTION DETAILS

Profile Option with Modification Date and User

To Check Profile Option value and application level

PROFILE OPTIONS: COMPARING LEVEL VALUES

PROFILE OPTIONS: WHAT LEVEL, WHAT VALUE?

To Check The Profile Options Which Are Modified

Set Profile Option Value using PL/SQL

 

Patch Information

Get Applications Version and Patch Information

Query For Current Instance Application URL

Query for Checking the Number of USER Sessions

Initialize Apps

Setting Org ID for the Current Session Query From Backend

Kill the Job and Session Query

Finding Oracle Version Query

Finding Oracle Application Product Version Query

To find all available application version

To find the base application version

To find the latest application version

Usefull AOL Queries

Registering Custom Table in Oracle Applications

Table Registration Procedure in Oracle Applications

Oracle Applications Scripts

TO FIND FOLDERS DETAILS

TO FIND CURRENCY DETAILS

Oracle Usefull Queries

CVR Overview (Cross Validation Rules )

CVR CROSS VALIDATION RULE DETAIL LISTING

Oracle Usefull Queries

Useful Queries For Oracle Applications

Query to List all the responsibilities attached to a User

Which Oracle Apps Version i am using

Query to find few business groups set up in the instance

How to set the Organization Context in R12

Which User is Locking Table Query

Submitting Job Query

All modules Interface Tables

How To Check lookup

How To check Organization

How To Check Error and Interface tables

Get Average Runtime of A Concurrent

How To Check Patch Level Status

To get form Id from database

Org ID Setting in Oracle R12 From Backend

Oracle AOL Queries

 

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect