My Oracle Support Banner

How To Extract The Information Needed From the Database on a Custom Object (Doc ID 2242344.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

 This Document will show you how to retrieve the information nedded when making SQL Predicates on Custom Objects.

You will learn the needed SQL Queries  to find out where custom fields and custom objects are stored in the database, tables and columns. 

This Document will not teach you how to build SQL Predicates but how to get all the info you need form the database regarding custom object

Solution

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
Goal
Solution
  1 - Find out in what table is a custom object been stored.
 2 - Find out in what columns are custom fields that are on a custom object
 3 - See Details of the Custom Object 
 4 - See the records in the custom object
 Example 

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