Oracle Fusion Data Explorer loading…

Search

Tables Views PVOs

Pillar Module

Include special tables

Audit/journal tables (…_) Temporary tables (_GT, _TMP) Interface tables (_INT) Translation tables (_TL) Referenced but undocumented

Loading data…

Hops

Direction

FKs Comment FKs Lineage

Columns

Max

Explore the Oracle Fusion data model

Search for a table, view or BICC PVO, then pick it to draw its relationships. Double-click an object in the diagram to expand it; right-click for more options.

TableViewPVOUndocumented FK (many → one) FK from comment Lineage

Working…

Built from public Oracle Fusion Cloud documentation. Not affiliated with or endorsed by Oracle. Descriptions © Oracle and/or its affiliates. by DataBerry · source

Databricks DDL export

Objects Selected object Objects on canvas Current search results Module Paste a list of names

Target

Catalog Schema

Create mode

Table/view names PVO table names

PVO column names Name prefix

Constraints & comments Informational PRIMARY KEYs Informational FOREIGN KEYs (between exported objects) Include FKs inferred from column comments Table & column COMMENTs Limit comments to 500 characters (BI tools) NOT NULL

Bronze audit columns Append audit / ingest columns

Type mapping VARCHAR2 / CHAR NUMBER (no precision) NUMBER(p), p ≤ 18 DATE TIMESTAMP

Choose objects and options, then generate.

About this data