This topic is part of the Process of Creating the Physical Layer from Relational Data Sources and the Process of Creating the Physical Layer from Multidimensional Data Sources.
A physical table is an object in the Physical layer of the Administration Tool that corresponds to a table in a physical database. Physical tables are usually imported from a database or another data source. They provide the metadata necessary for the Oracle BI Server to access the tables with SQL requests.
In addition to importing physical tables, you can create virtual physical tables in the Physical layer, using values in the Table Type field in the Physical Table dialog box. A virtual physical table can be a stored procedure or a Select statement. Creating virtual tables can provide the Oracle BI Server and the underlying databases with the proper metadata to perform some advanced query requests