My Oracle Support Banner

Handy SQL for the Oracle Applications (Doc ID 731190.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle Inventory Management - Version 11.5.10 and later
Information in this document applies to any platform.
This document includes all versions of 11i and R12 and later


@ To Support:

Do you have suggestions on some helpful SQL scripts when working with the Oracle Applications?

NOTE: One customer had issues viewing the content of this note. They had to highlight the text to see the code snippets. The code snippets are following the standard Oracle KM guidelines with standard code widgets so should be the same as other code snippets used in other notes. The note was edited to bring it to the latest formats available. Sorry in advanced if you face this issue. Please highlight the text to see it.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Database
 1.1 General Objects / Tables / Columns
 1.2 Invalids / Compiling
 1 .3 Bugs and Patching
 1.4 Other Objects
 1.5 Helpful SQL Syntax
 2. Foundation (FND/ATG/AOL)
 2.1 SQL related to Oracle Application Messages
 2.2. Review Oracle Application Programs
 2.3. Users and Responsibilities
 2.4 Set Context / Initialize
 3. Manufacturing
 3.1 Manufacturing General
 3.2. Setup
 3.2.1. Inventory
 3.3. Transactions
 3.3.0 Inventory + Order Management
 3.3.1. Inventory Transactions

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.