Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - FRM Tables and Views

TABLE - FRM.FRM_ARCHIVED_LOBS
TABLE - FRM.FRM_DEFAULT_PUB_OPTIONS
TABLE - FRM.FRM_DELIVERY_CONFIGURATIONS_B
TABLE - FRM.FRM_DELIVERY_CONFIGURATIONS_TL
TABLE - FRM.FRM_DELIVERY_FTP_SERVERS_B
TABLE - FRM.FRM_DELIVERY_FTP_SERVERS_TL
TABLE - FRM.FRM_DELIVERY_MAILERS_B
TABLE - FRM.FRM_DELIVERY_MAILERS_TL
TABLE - FRM.FRM_DELIVERY_OPTIONS_B
TABLE - FRM.FRM_DELIVERY_OPTIONS_TL
TABLE - FRM.FRM_DELIVERY_PROPERTIES
TABLE - FRM.FRM_DIRECTORY_B
TABLE - FRM.FRM_DIRECTORY_TL
TABLE - FRM.FRM_DOCUMENTS_B
TABLE - FRM.FRM_DOCUMENTS_TL
TABLE - FRM.FRM_DOCUMENT_DETAILS
TABLE - FRM.FRM_DOC_PUB_OPTIONS
TABLE - FRM.FRM_DOC_REVIEWERS
TABLE - FRM.FRM_GLB_TEMPLATE_ALIASES_B
TABLE - FRM.FRM_GLB_TEMPLATE_ALIASES_TL
TABLE - FRM.FRM_HOT_REQUESTS
TABLE - FRM.FRM_MENU_USER_MAPPINGS
TABLE - FRM.FRM_PART_VALUE_SETS
TABLE - FRM.FRM_REPOSITORY_LOBS
TABLE - FRM.FRM_REP_TEMPLATE_ALIASES_B
TABLE - FRM.FRM_REP_TEMPLATE_ALIASES_TL
TABLE - FRM.FRM_REQSET_PUB_OPTIONS
TABLE - FRM.FRM_RTF_TEMPLATES
TABLE - FRM.FRM_SET_PUB_OPTIONS
TABLE - FRM.FRM_SET_SUB_OPTIONS
TABLE - FRM.FRM_USER_PUB_OPTIONS
TABLE - FRM.FRM_USER_VALUE_MAPPINGS
TABLE - FRM.FRM_XML_ADAPTORS
VIEW - APPS.ADI_WEB_FILES_VL
VIEW - APPS.FRM_DELIVERY_CONFIGURATIONS_VL
VIEW - APPS.FRM_DELIVERY_FTP_SERVERS_VL
VIEW - APPS.FRM_DELIVERY_MAILERS_VL
VIEW - APPS.FRM_DELIVERY_OPTIONS_VL
VIEW - APPS.FRM_DIRECTORY_VL
VIEW - APPS.FRM_DOCUMENTS_VL
VIEW - APPS.FRM_GLB_TEMPLATE_ALIASES_VL
VIEW - APPS.FRM_REP_TEMPLATE_ALIASES_VL

Table: FRM_ARCHIVED_LOBS

Description: Stores the Report Manager large object files, such as report output and 3rd party files.
Primary Key: FRM_ARCHIVED_LOBS_PK
  1. FILE_ID
Comments

Stores the Report Manager large object files, such as report output and 3rd party files.

Indexes
Index Type Tablespace Column
FRM_ARCHIVED_LOBS_UK1 UNIQUE APPS_TS_TX_IDX FILE_ID
SYS_IL0000399355C00004$$ UNIQUE APPS_TS_TX_DATA
FRM_ARCHIVED_LOBS_N1 NONUNIQUE APPS_TS_TX_IDX EXPIRATION_DATE
Columns
Name Datatype Length Mandatory Comments
FILE_ID NUMBER (15) Y Entity Identifier across all applications
FILE_NAME VARCHAR2 (256)
The name of the file.
FILE_CONTENT_TYPE VARCHAR2 (256) Y The type of large object being stored.
FILE_DATA BLOB (4000)
The binary large object data.
UPLOAD_DATE DATE

The date the large object was uploaded.
EXPIRATION_DATE DATE

The date that the large object is no longer required.
PROGRAM_NAME VARCHAR2 (240)
The program used to manipulate the large object.
PROGRAM_TAG VARCHAR2 (32)
Optional string used by the GFM client program to further categorize the LOB.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.

[top of page]

FRM.FRM_ARCHIVED_LOBS does not reference any database object

FRM.FRM_ARCHIVED_LOBS is referenced by following:

FRM
VIEW - FRM_ARCHIVED_LOBS#

[top of page]

Table: FRM_DEFAULT_PUB_OPTIONS

Description: Stores the basic options for a report published to the Report Manager Repository.
Primary Key: FRM_DEFAULT_PUB_OPTIONS_PK
  1. REPORT_ID
Comments

Stores the basic options for a report published to the Report Manager Repository.

Indexes
Index Type Tablespace Column
FRM_DEFAULT_PUB_OPTIONS_UK1 UNIQUE APPS_TS_TX_IDX REPORT_ID
Columns
Name Datatype Length Mandatory Comments
REPORT_ID NUMBER (15) Y Entity Identifier across all applications
TEMPLATE_CODE VARCHAR2 (80)
The template code as stored in XML Publisher.
APPLICATION_SHORT_NAME VARCHAR2 (50)
The Application Short Name for the Template Code stored in XML Publisher.
OUTPUT_TYPE VARCHAR2 (30)
The method used to output the report
PUBLISHER_TYPE VARCHAR2 (30)
The publishing engine used to process the report. Currently XML Publisher or Report Manager.
OBJECT_VERSION_NUMBER NUMBER (15)
Applications Standard column for a stateless environment.
CREATION_DATE DATE

Standard WHO Column.
CREATED_BY NUMBER (15) Y Standard WHO Column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO Column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
LAST_UPDATE_DATE DATE
Y Standard WHO column.

[top of page]

FRM.FRM_DEFAULT_PUB_OPTIONS does not reference any database object

FRM.FRM_DEFAULT_PUB_OPTIONS is referenced by following:

FRM
VIEW - FRM_DEFAULT_PUB_OPTIONS#

[top of page]

Table: FRM_DELIVERY_CONFIGURATIONS_B

Description:
Comments
Primary Key: FRM_DELIVERY_CONFIG_B_PK
  1. CONFIGURATION_ID
Indexes
Index Type Tablespace Column
FRM_DELIVERY_CONFIG_B_PK UNIQUE APPS_TS_TX_IDX CONFIGURATION_ID
Columns
Name Datatype Length Mandatory Comments
CONFIGURATION_ID NUMBER (15) Y
START_DATE DATE
Y
END_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y

[top of page]

FRM.FRM_DELIVERY_CONFIGURATIONS_B does not reference any database object

FRM.FRM_DELIVERY_CONFIGURATIONS_B is referenced by following:

FRM
VIEW - FRM_DELIVERY_CONFIGURATIONS_B#

[top of page]

Table: FRM_DELIVERY_CONFIGURATIONS_TL

Description:
Comments
Primary Key: FRM_DELIVERY_CONFIG_TL_PK
  1. CONFIGURATION_ID
  2. LANGUAGE
Indexes
Index Type Tablespace Column
FRM_DELIVERY_CONFIG_TL_PK UNIQUE APPS_TS_TX_IDX CONFIGURATION_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
CONFIGURATION_ID NUMBER (15) Y
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4) Y
USER_NAME VARCHAR2 (240) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y

[top of page]

FRM.FRM_DELIVERY_CONFIGURATIONS_TL does not reference any database object

FRM.FRM_DELIVERY_CONFIGURATIONS_TL is referenced by following:

FRM
VIEW - FRM_DELIVERY_CONFIGURATIONS_T#

[top of page]

Table: FRM_DELIVERY_FTP_SERVERS_B

Description:
Comments
Primary Key: FRM_DELIVERY_FTP_SERVERS_B_PK
  1. SERVER_ID
Indexes
Index Type Tablespace Column
FRM_DELIVERY_FTP_SERVERS_B_PK UNIQUE APPS_TS_TX_IDX SERVER_ID
Columns
Name Datatype Length Mandatory Comments
SERVER_ID NUMBER (15) Y
HOST VARCHAR2 (240) Y
PORT NUMBER (15)
AUTH_TYPE VARCHAR2 (15) Y
USERNAME VARCHAR2 (240)
TYPE VARCHAR2 (5) Y
FILE_PERMISSION NUMBER (4)
OBJECT_VERSION_NUMBER NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y

[top of page]

FRM.FRM_DELIVERY_FTP_SERVERS_B does not reference any database object

FRM.FRM_DELIVERY_FTP_SERVERS_B is referenced by following:

FRM
VIEW - FRM_DELIVERY_FTP_SERVERS_B#

[top of page]

Table: FRM_DELIVERY_FTP_SERVERS_TL

Description:
Comments
Primary Key: FRM_DELIVERY_FTP_SERVERS_TL_PK
  1. SERVER_ID
  2. LANGUAGE
Indexes
Index Type Tablespace Column
FRM_DELIVERY_FTP_SERVERS_TL_PK UNIQUE APPS_TS_TX_IDX SERVER_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
SERVER_ID NUMBER (15) Y
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4) Y
SERVER_NAME VARCHAR2 (240) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y

[top of page]

FRM.FRM_DELIVERY_FTP_SERVERS_TL does not reference any database object

FRM.FRM_DELIVERY_FTP_SERVERS_TL is referenced by following:

FRM
VIEW - FRM_DELIVERY_FTP_SERVERS_TL#

[top of page]

Table: FRM_DELIVERY_MAILERS_B

Description:
Comments
Primary Key: FRM_DELIVERY_MAILERS_B_PK
  1. MAILER_ID
Indexes
Index Type Tablespace Column
FRM_DELIVERY_MAILERS_B_PK UNIQUE APPS_TS_TX_IDX MAILER_ID
Columns
Name Datatype Length Mandatory Comments
MAILER_ID NUMBER (15) Y
HOST VARCHAR2 (240) Y
PORT NUMBER (15)
FROM_ADDRESS VARCHAR2 (240) Y
USERNAME VARCHAR2 (240)
SSL_ENABLED VARCHAR2 (1) Y
OBJECT_VERSION_NUMBER NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y

[top of page]

FRM.FRM_DELIVERY_MAILERS_B does not reference any database object

FRM.FRM_DELIVERY_MAILERS_B is referenced by following:

FRM
VIEW - FRM_DELIVERY_MAILERS_B#

[top of page]

Table: FRM_DELIVERY_MAILERS_TL

Description:
Comments
Primary Key: FRM_DELIVERY_MAILERS_TL_PK
  1. MAILER_ID
  2. LANGUAGE
Indexes
Index Type Tablespace Column
FRM_DELIVERY_MAILERS_TL_PK UNIQUE APPS_TS_TX_IDX MAILER_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
MAILER_ID NUMBER (15) Y
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4) Y
MAILER_NAME VARCHAR2 (240) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y

[top of page]

FRM.FRM_DELIVERY_MAILERS_TL does not reference any database object

FRM.FRM_DELIVERY_MAILERS_TL is referenced by following:

FRM
VIEW - FRM_DELIVERY_MAILERS_TL#

[top of page]

Table: FRM_DELIVERY_OPTIONS_B

Description:
Comments
Primary Key: FRM_DELIVERY_OPTIONS_B_PK
  1. DELIVERY_ID
Indexes
Index Type Tablespace Column
FRM_DELIVERY_OPTIONS_B_PK UNIQUE APPS_TS_TX_IDX DELIVERY_ID
Columns
Name Datatype Length Mandatory Comments
CONFIGURATION_ID NUMBER (15) Y
DELIVERY_ID NUMBER (15) Y
DELIVERY_TYPE VARCHAR2 (240) Y
START_DATE DATE
Y
END_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y

[top of page]

FRM.FRM_DELIVERY_OPTIONS_B does not reference any database object

FRM.FRM_DELIVERY_OPTIONS_B is referenced by following:

FRM
VIEW - FRM_DELIVERY_OPTIONS_B#

[top of page]

Table: FRM_DELIVERY_OPTIONS_TL

Description:
Comments
Primary Key: FRM_DELIVERY_OPTIONS_TL_PK
  1. DELIVERY_ID
  2. LANGUAGE
Indexes
Index Type Tablespace Column
FRM_DELIVERY_OPTIONS_TL_PK UNIQUE APPS_TS_TX_IDX DELIVERY_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
DELIVERY_ID NUMBER (15) Y
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4) Y
USER_NAME VARCHAR2 (240) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y

[top of page]

FRM.FRM_DELIVERY_OPTIONS_TL does not reference any database object

FRM.FRM_DELIVERY_OPTIONS_TL is referenced by following:

FRM
VIEW - FRM_DELIVERY_OPTIONS_TL#

[top of page]

Table: FRM_DELIVERY_PROPERTIES

Description:
Comments
Primary Key: FRM_DELIVERY_PROPERTIES_PK
  1. PROPERTY_ID
Indexes
Index Type Tablespace Column
FRM_DELIVERY_PROPERTIES_PK UNIQUE APPS_TS_TX_IDX PROPERTY_ID
Columns
Name Datatype Length Mandatory Comments
PROPERTY_ID NUMBER (15) Y
DELIVERY_ID NUMBER (15) Y
PROPERTY_NAME VARCHAR2 (240) Y
PROPERTY_VALUE VARCHAR2 (2000) Y
REQUIRED_FLAG VARCHAR2 (1) Y
OBJECT_VERSION_NUMBER NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y

[top of page]

FRM.FRM_DELIVERY_PROPERTIES does not reference any database object

FRM.FRM_DELIVERY_PROPERTIES is referenced by following:

FRM
VIEW - FRM_DELIVERY_PROPERTIES#

[top of page]

Table: FRM_DIRECTORY_B

Description: Stores the un-translated parts of the Report Manager directory hierarchy.
Primary Key: FRM_DIRECTORY_B_PK
  1. DIRECTORY_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FRM_DIRECTORY_TL.DIRECTORY_ID FRM_DIRECTORY_B
FRM_DOCUMENTS_B.DIRECTORY_ID FRM_DIRECTORY_B
Comments

Stores the un-translated parts of the Report Manager directory hierarchy.

Indexes
Index Type Tablespace Column
FRM_DIRECTORY_B_UK1 UNIQUE APPS_TS_TX_IDX DIRECTORY_ID
ZD_EDITION_NAME
FRM_DIRECTORY_B_N1 NONUNIQUE APPS_TS_TX_IDX END_DATE
FRM_DIRECTORY_B_N2 NONUNIQUE APPS_TS_TX_IDX ARCHIVED_FLAG
Columns
Name Datatype Length Mandatory Comments
DIRECTORY_ID NUMBER (15) Y Entity Identifier across all applications
PARENT_ID NUMBER (15)
The next higher level in the Report Manager directory structure, null if the entry is the root directory.
SEQUENCE_NUMBER NUMBER (15) Y The order of the directory within the parent directory.
OBJECT_VERSION_NUMBER NUMBER (15) Y Applications Standard column for a stateless environment.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.
END_DATE DATE

Date that this row is archived or deleted.
ARCHIVED_FLAG VARCHAR2 (1)
Flag to indicate if the row is archived.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

FRM.FRM_DIRECTORY_B does not reference any database object

FRM.FRM_DIRECTORY_B is referenced by following:

FRM
VIEW - FRM_DIRECTORY_B#

[top of page]

Table: FRM_DIRECTORY_TL

Description: Translatable table for the Report Manager directory structure.
Primary Key: FRM_DIRECTORY_TL_PK
  1. DIRECTORY_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FRM_DIRECTORY_TL.DIRECTORY_ID FRM_DIRECTORY_B
Comments

Translatable table for the Report Manager directory structure.

Indexes
Index Type Tablespace Column
FRM_DIRECTORY_TL_UK1 UNIQUE APPS_TS_TX_IDX DIRECTORY_ID
LANGUAGE
ZD_EDITION_NAME
FRM_DIRECTORY_TL_N1 NONUNIQUE APPS_TS_TX_IDX END_DATE
FRM_DIRECTORY_TL_N2 NONUNIQUE APPS_TS_TX_IDX ARCHIVED_FLAG
Columns
Name Datatype Length Mandatory Comments
DIRECTORY_ID NUMBER (15) Y Entity Identifier across all applications
LANGUAGE VARCHAR2 (4) Y Entity Identifier across all applications
SOURCE_LANG VARCHAR2 (4) Y Applications standard column to a translatable table.
USER_NAME VARCHAR2 (240)
User tanslatable column for this table.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.
END_DATE DATE

Date that this row is archived or deleted.
ARCHIVED_FLAG VARCHAR2 (1)
Flag to indicate if the row is archived.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

FRM.FRM_DIRECTORY_TL does not reference any database object

FRM.FRM_DIRECTORY_TL is referenced by following:

FRM
VIEW - FRM_DIRECTORY_TL#

[top of page]

Table: FRM_DOCUMENTS_B

Description: Stores the un-translated parts of a Report Manager document.
Primary Key: FRM_DOCUMENTS_B_PK
  1. DOCUMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FRM_DOCUMENTS_B.DIRECTORY_ID FRM_DIRECTORY_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
FRM_DOCUMENTS_TL.DOCUMENT_ID FRM_DOCUMENTS_B
FRM_DOCUMENT_DETAILS.DOCUMENT_ID FRM_DOCUMENTS_B
Comments

Stores the un-translated parts of a Report Manager document.

Indexes
Index Type Tablespace Column
FRM_DOCUMENTS_B_UK1 UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
FRM_DOCUMENTS_B_N1 NONUNIQUE APPS_TS_TX_IDX END_DATE
FRM_DOCUMENTS_B_N2 NONUNIQUE APPS_TS_TX_IDX ARCHIVED_FLAG
FRM_DOCUMENTS_B_N3 NONUNIQUE APPS_TS_TX_IDX DIRECTORY_ID
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Y Entity Identifier across all applications
DIRECTORY_ID NUMBER (15) Y The directory id that this document is contained in.
SEQUENCE_NUMBER NUMBER (15) Y The order of the document within the directory.
EXPANDED_FLAG VARCHAR2 (1)
Is this document an expanded document or not.
DS_APP_SHORT_NAME VARCHAR2 (50)
The application short name of the datasource code in the XML Publisher template repository.
DATA_SOURCE_CODE VARCHAR2 (80)
The datasource code attached to this report.
OBJECT_VERSION_NUMBER NUMBER (15) Y Applications Standard column for a stateless environment.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.
END_DATE DATE

Date that this row is archived or deleted.
ARCHIVED_FLAG VARCHAR2 (1)
Flag to indicate if the row is archived.

[top of page]

FRM.FRM_DOCUMENTS_B does not reference any database object

FRM.FRM_DOCUMENTS_B is referenced by following:

FRM
VIEW - FRM_DOCUMENTS_B#

[top of page]

Table: FRM_DOCUMENTS_TL

Description: Stores the translated parts of a Report Manager document.
Primary Key: FRM_DOCUMENTS_TL_PK
  1. DOCUMENT_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FRM_DOCUMENTS_TL.DOCUMENT_ID FRM_DOCUMENTS_B
Comments

Stores the translated parts of a Report Manager document.

Indexes
Index Type Tablespace Column
FRM_DOCUMENTS_TL_UK1 UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
LANGUAGE
FRM_DOCUMENTS_TL_N1 NONUNIQUE APPS_TS_TX_IDX END_DATE
FRM_DOCUMENTS_TL_N2 NONUNIQUE APPS_TS_TX_IDX ARCHIVED_FLAG
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Y Entity Identifier across all applications
LANGUAGE VARCHAR2 (4) Y Entity Identifier across all applications
SOURCE_LANG VARCHAR2 (4) Y Applications standards column for a translatable table.
USER_NAME VARCHAR2 (240) Y The translatable user value.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.
END_DATE DATE

Date that this row is archived or deleted.
ARCHIVED_FLAG VARCHAR2 (1)
Flag to indicate if the row is archived.

[top of page]

FRM.FRM_DOCUMENTS_TL does not reference any database object

FRM.FRM_DOCUMENTS_TL is referenced by following:

FRM
VIEW - FRM_DOCUMENTS_TL#

[top of page]

Table: FRM_DOCUMENT_DETAILS

Description: Stores the detail level information about a document or document set.
Primary Key: FRM_DOCUMENT_DETAILS_PK
  1. DOCUMENT_ID
  2. TIMEFRAME
  3. EXPANDED_VALUE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FRM_DOCUMENT_DETAILS.DOCUMENT_ID FRM_DOCUMENTS_B
Comments

Stores the detail level information about a document or document set.

Indexes
Index Type Tablespace Column
FRM_DOCUMENT_DETAILS_UK1 UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
TIMEFRAME
EXPANDED_VALUE
FRM_DOCUMENT_DETAILS_N1 NONUNIQUE APPS_TS_TX_IDX END_DATE
FRM_DOCUMENT_DETAILS_N2 NONUNIQUE APPS_TS_TX_IDX ARCHIVED_FLAG
FRM_DOCUMENT_DETAILS_N3 NONUNIQUE APPS_TS_TX_IDX FILE_ID
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Y Entity Identifier across all applications
TIMEFRAME VARCHAR2 (240) Y Entity Identifier across all applications
EXPANDED_VALUE VARCHAR2 (240) Y Entity Identifier across all applications
FILE_ID NUMBER (15) Y The id of the report output file stored in the FRM_REPOSITORY_LOBS table.
OBJECT_VERSION_NUMBER NUMBER (15) Y Applications Standard column for a stateless environment.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.
END_DATE DATE

Date that this row is archived or deleted.
ARCHIVED_FLAG VARCHAR2 (1)
Flag to indicate if the row is archived.
PE_SEGMENT VARCHAR2 (240)
To store RptPESegm value from the GL FSG XML
PE_SEGMENT_VALUE VARCHAR2 (240)
To store RptPESegVal from the GL FSG XML

[top of page]

FRM.FRM_DOCUMENT_DETAILS does not reference any database object

FRM.FRM_DOCUMENT_DETAILS is referenced by following:

FRM
VIEW - FRM_DOCUMENT_DETAILS#

[top of page]

Table: FRM_DOC_PUB_OPTIONS

Description: Stores the document specific options for a report published to the Report Manager repository.
Primary Key: FRM_DOC_PUB_OPTIONS_PK
  1. DOCUMENT_ID
  2. TIMEFRAME
Comments

Stores the document specific options for a report published to the Report Manager repository.

Indexes
Index Type Tablespace Column
FRM_DOC_PUB_OPTIONS_UK1 UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
TIMEFRAME
FRM_DOC_PUB_OPTIONS_N1 NONUNIQUE APPS_TS_TX_IDX END_DATE
FRM_DOC_PUB_OPTIONS_N2 NONUNIQUE APPS_TS_TX_IDX ARCHIVED_FLAG
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Y Entity Identifier across all applications
TIMEFRAME VARCHAR2 (240) Y Entity Identifier across all applications
TEMPLATE_CODE VARCHAR2 (80)
The code for the template stored in the XML Publisher template repository.
APPLICATION_SHORT_NAME VARCHAR2 (50) Y The application short name attached to the template code.
OUTPUT_TYPE VARCHAR2 (30)
The type of output required for this document - Excel, PDF, or HTML etc.
AVAILABILITY_TYPE VARCHAR2 (30) Y The type of availability for this document, now, on hold, or specific date and time.
AVAILABILITY_DATE DATE

If the availability type is set to specific date and time, this column stores the date and time.
SECURITY_TYPE VARCHAR2 (30) Y The type of security implemented for this report.
SECURITY_CODE VARCHAR2 (240)
The values or value set used to secure the report.
PUBLISHER_TYPE VARCHAR2 (30)
The publishing engine used to process the report. Currently XML Publisher or Report Manager.
FUNCTION_ID NUMBER (15)
The form function id used to launch this report.
MENU_ID NUMBER (15)
The menu entry id to which the form function is attached.
MENU_ENTRY_SEQ NUMBER (15)
The order of the form function within the menu.
OBJECT_VERSION_NUMBER NUMBER (15) Y Applications Standard column for a stateless environment.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.
END_DATE DATE

Date that this row is archived or deleted.
ARCHIVED_FLAG VARCHAR2 (1)
Flag to indicate if the row is archived.
ARCHIVE_PERIOD_MONTHS NUMBER (15)
Period of time in months until this row is archived, or deleted.

[top of page]

FRM.FRM_DOC_PUB_OPTIONS does not reference any database object

FRM.FRM_DOC_PUB_OPTIONS is referenced by following:

FRM
VIEW - FRM_DOC_PUB_OPTIONS#

[top of page]

Table: FRM_DOC_REVIEWERS

Description: Stores the user id information of those who can release an onhold report.
Primary Key: FRM_DOC_REVIEWERS_PK
  1. DOCUMENT_ID
  2. TIMEFRAME
  3. USER_ID
Comments

Stores the user id information of those who can release an onhold report.

Indexes
Index Type Tablespace Column
FRM_DOC_REVIEWERS_UK1 UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
TIMEFRAME
USER_ID
FRM_DOC_REVIEWERS_N1 NONUNIQUE APPS_TS_TX_IDX END_DATE
FRM_DOC_REVIEWERS_N2 NONUNIQUE APPS_TS_TX_IDX ARCHIVED_FLAG
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER (15) Y Entity Identifier across all applications
TIMEFRAME VARCHAR2 (240) Y Entity Identifier across all applications
USER_ID NUMBER (15) Y Entity Identifier across all applications
OBJECT_VERSION_NUMBER NUMBER (15) Y Applications Standard column for a stateless environment.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.
END_DATE DATE

Date that this row is archived or deleted.
ARCHIVED_FLAG VARCHAR2 (1)
Flag to indicate if the row is archived.

[top of page]

FRM.FRM_DOC_REVIEWERS does not reference any database object

FRM.FRM_DOC_REVIEWERS is referenced by following:

FRM
VIEW - FRM_DOC_REVIEWERS#

[top of page]

Table: FRM_GLB_TEMPLATE_ALIASES_B

Description: Stores global element information for the alias engine used by the XSL:FO template editor.
Primary Key: FRM_GLB_TEMPLATE_ALIASES_B_PK
  1. ELEMENT_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
FRM_GLB_TEMPLATE_ALIASES_TL.ELEMENT_NAME FRM_GLB_TEMPLATE_ALIASES_B
Comments

Stores global element information for the alias engine used by the XSL:FO template editor.

Indexes
Index Type Tablespace Column
FRM_GLB_TEMPLATE_ALIASES_B_UK UNIQUE APPS_TS_TX_IDX ELEMENT_NAME
Columns
Name Datatype Length Mandatory Comments
ELEMENT_NAME VARCHAR2 (240) Y Entity Identifier across all applications
OBJECT_VERSION_NUMBER NUMBER (15) Y Applications Standard column for a stateless environment.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.

[top of page]

FRM.FRM_GLB_TEMPLATE_ALIASES_B does not reference any database object

FRM.FRM_GLB_TEMPLATE_ALIASES_B is referenced by following:

FRM
VIEW - FRM_GLB_TEMPLATE_ALIASES_B#

[top of page]

Table: FRM_GLB_TEMPLATE_ALIASES_TL

Description: Stores global element translatable information for the alias engine used by the XSL:FO template editor.
Primary Key: FRM_GLB_TEMPLATE_ALIASES_TL_PK
  1. ELEMENT_NAME
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FRM_GLB_TEMPLATE_ALIASES_TL.ELEMENT_NAME FRM_GLB_TEMPLATE_ALIASES_B
Comments

Stores global element translatable information for the alias engine used by the XSL:FO template editor.

Indexes
Index Type Tablespace Column
FRM_GLB_TEMPLATE_ALIASES_TL_UK UNIQUE APPS_TS_TX_IDX ELEMENT_NAME
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
ELEMENT_NAME VARCHAR2 (240) Y Entity Identifier across all applications
LANGUAGE VARCHAR2 (4) Y Entity Identifier across all applications
SOURCE_LANG VARCHAR2 (4) Y Applications standard column to a translatable table.
USER_NAME VARCHAR2 (240) Y The user translatable value for the element name.
OBJECT_VERSION_NUMBER NUMBER (15) Y Applications Standard column for a stateless environment.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.

[top of page]

FRM.FRM_GLB_TEMPLATE_ALIASES_TL does not reference any database object

FRM.FRM_GLB_TEMPLATE_ALIASES_TL is referenced by following:

FRM
VIEW - FRM_GLB_TEMPLATE_ALIASES_TL#

[top of page]

Table: FRM_HOT_REQUESTS

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y

[top of page]

FRM.FRM_HOT_REQUESTS does not reference any database object

FRM.FRM_HOT_REQUESTS is referenced by following:

FRM
VIEW - FRM_HOT_REQUESTS#

[top of page]

Table: FRM_MENU_USER_MAPPINGS

Description:
Comments
Primary Key: FRM_MENU_USER_MAPPINGS_PK
  1. NODE_ID
  2. NODE_TYPE
  3. USER_ID
Indexes
Index Type Tablespace Column
FRM_MENU_USER_MAPPINGS_PK UNIQUE APPS_TS_TX_DATA NODE_ID
NODE_TYPE
USER_ID
Columns
Name Datatype Length Mandatory Comments
NODE_ID NUMBER (15) Y
NODE_TYPE VARCHAR2 (50) Y
USER_ID NUMBER (15) Y
RECURSIVE VARCHAR2 (1)
PERMISSION_CODE VARCHAR2 (80) Y
OBJECT_VERSION_NUMBER NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y

[top of page]

FRM.FRM_MENU_USER_MAPPINGS does not reference any database object

FRM.FRM_MENU_USER_MAPPINGS is referenced by following:

FRM
VIEW - FRM_MENU_USER_MAPPINGS#

[top of page]

Table: FRM_PART_VALUE_SETS

Description: Stores value-sets that are being referenced by User to Value security.
Primary Key: FRM_PART_VALUE_SETS_PK
  1. VALUE_SET_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
FRM_USER_VALUE_MAPPINGS.VALUE_SET_ID FRM_PART_VALUE_SETS
Comments

Stores value-sets that are being referenced by User to Value security.

Indexes
Index Type Tablespace Column
FRM_PART_VALUE_SETS_UK1 UNIQUE APPS_TS_TX_IDX VALUE_SET_ID
Columns
Name Datatype Length Mandatory Comments
VALUE_SET_ID NUMBER (15) Y Entity Identifier across all applications
PARTICIPATION_FLAG VARCHAR2 (1) Y Has this value set been used by User to Value Security.
OBJECT_VERSION_NUMBER NUMBER (15) Y Applications Standard column for a stateless environment.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.

[top of page]

FRM.FRM_PART_VALUE_SETS does not reference any database object

FRM.FRM_PART_VALUE_SETS is referenced by following:

FRM
VIEW - FRM_PART_VALUE_SETS#

[top of page]

Table: FRM_REPOSITORY_LOBS

Description: Stores the Report Manager large object files, such as report output and 3rd party files.
Primary Key: FRM_REPOSITORY_LOBS_PK
  1. FILE_ID
Comments

Stores the Report Manager large object files, such as report output and 3rd party files.

Indexes
Index Type Tablespace Column
FRM_REPOSITORY_LOBS_UK1 UNIQUE APPS_TS_MEDIA FILE_ID
SYS_IL0000399302C00004$$ UNIQUE APPS_TS_MEDIA
SYS_IL0000399302C00014$$ UNIQUE APPS_TS_MEDIA
FRM_REPOSITORY_LOBS_N1 NONUNIQUE APPS_TS_MEDIA EXPIRATION_DATE
Columns
Name Datatype Length Mandatory Comments
FILE_ID NUMBER (15) Y Entity Identifier across all applications
FILE_NAME VARCHAR2 (256)
The name of the file.
FILE_CONTENT_TYPE VARCHAR2 (256) Y The type of large object being stored.
FILE_DATA BLOB (4000)
The binary large object data.
UPLOAD_DATE DATE

The date the large object was uploaded.
EXPIRATION_DATE DATE

The date that the large object is no longer required.
PROGRAM_NAME VARCHAR2 (240)
The program used to manipulate the large object.
PROGRAM_TAG VARCHAR2 (32)
Optional string used by the GFM client program to further categorize the LOB.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.
FODATA BLOB (4000)
The binary large object data for HTML output.
ATTRIBUTE1 VARCHAR2 (256)
The boolean value to specify FODATA is stored.

[top of page]

FRM.FRM_REPOSITORY_LOBS does not reference any database object

FRM.FRM_REPOSITORY_LOBS is referenced by following:

FRM
VIEW - FRM_REPOSITORY_LOBS#

[top of page]

Table: FRM_REP_TEMPLATE_ALIASES_B

Description: Un-translatable data for the Report Manager template editor aliases.
Primary Key: FRM_REP_TEMPLATE_ALIASES_B_PK
  1. APPLICATION_SHORT_NAME
  2. CONCURRENT_PROGRAM_NAME
  3. ELEMENT_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
FRM_REP_TEMPLATE_ALIASES_TL.APPLICATION_SHORT_NAME
FRM_REP_TEMPLATE_ALIASES_TL.CONCURRENT_PROGRAM_NAME
FRM_REP_TEMPLATE_ALIASES_TL.ELEMENT_NAME 		FRM_REP_TEMPLATE_ALIASES_B
Comments

Un-translatable data for the Report Manager template editor aliases.

Indexes
Index Type Tablespace Column
FRM_REP_TEMPLATE_ALIASES_B_UK UNIQUE APPS_TS_TX_IDX APPLICATION_SHORT_NAME
CONCURRENT_PROGRAM_NAME
ELEMENT_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_SHORT_NAME VARCHAR2 (50) Y Entity Identifier across all applications
CONCURRENT_PROGRAM_NAME VARCHAR2 (30) Y Entity Identifier across all applications
ELEMENT_NAME VARCHAR2 (240) Y Entity Identifier across all applications
OBJECT_VERSION_NUMBER NUMBER (15) Y Applications Standard column for a stateless environment.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.

[top of page]

FRM.FRM_REP_TEMPLATE_ALIASES_B does not reference any database object

FRM.FRM_REP_TEMPLATE_ALIASES_B is referenced by following:

FRM
VIEW - FRM_REP_TEMPLATE_ALIASES_B#

[top of page]

Table: FRM_REP_TEMPLATE_ALIASES_TL

Description: Translatable table for the Report Manager template editor aliases..
Primary Key: FRM_REP_TEMPLATE_ALIASES_TL_PK
  1. APPLICATION_SHORT_NAME
  2. CONCURRENT_PROGRAM_NAME
  3. ELEMENT_NAME
  4. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
FRM_REP_TEMPLATE_ALIASES_TL.APPLICATION_SHORT_NAME
FRM_REP_TEMPLATE_ALIASES_TL.CONCURRENT_PROGRAM_NAME
FRM_REP_TEMPLATE_ALIASES_TL.ELEMENT_NAME 		FRM_REP_TEMPLATE_ALIASES_B
Comments

Translatable table for the Report Manager template editor aliases..

Indexes
Index Type Tablespace Column
FRM_REP_TEMPLATE_ALIASES_TL_UK UNIQUE APPS_TS_TX_IDX APPLICATION_SHORT_NAME
CONCURRENT_PROGRAM_NAME
ELEMENT_NAME
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_SHORT_NAME VARCHAR2 (50) Y Entity Identifier across all applications
CONCURRENT_PROGRAM_NAME VARCHAR2 (30) Y Entity Identifier across all applications
ELEMENT_NAME VARCHAR2 (240) Y Entity Identifier across all applications
LANGUAGE VARCHAR2 (4) Y Entity Identifier across all applications
SOURCE_LANG VARCHAR2 (4) Y Applications standard column to a translatable table.
USER_NAME VARCHAR2 (240)
User tanslatable column for this table.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.

[top of page]

FRM.FRM_REP_TEMPLATE_ALIASES_TL does not reference any database object

FRM.FRM_REP_TEMPLATE_ALIASES_TL is referenced by following:

FRM
VIEW - FRM_REP_TEMPLATE_ALIASES_TL#

[top of page]

Table: FRM_REQSET_PUB_OPTIONS

Description: Stores the publishing options set for a request set.
Primary Key: FRM_REQSET_PUB_OPTIONS_PK
  1. REQUEST_SET_ID
  2. REPORT_ID
  3. STAGE_NUMBER
  4. SEQUENCE_NUMBER
Comments

Stores the publishing options set for a request set.

Indexes
Index Type Tablespace Column
FRM_REQSET_PUB_OPTIONS_UK1 UNIQUE APPS_TS_TX_IDX REQUEST_SET_ID
REPORT_ID
STAGE_NUMBER
SEQUENCE_NUMBER
Columns
Name Datatype Length Mandatory Comments
REQUEST_SET_ID NUMBER (15) Y Entity Identifier across all applications
REPORT_ID NUMBER (15) Y Entity Identifier across all applications
STAGE_NUMBER NUMBER (15) Y Entity Identifier across all applications
SEQUENCE_NUMBER NUMBER (15) Y Entity Identifier across all applications
TEMPLATE_CODE VARCHAR2 (80)
The code for the template stored in the XML Publisher template repository.
APPLICATION_SHORT_NAME VARCHAR2 (50) Y The application short name attached to the template code.
OUTPUT_TYPE VARCHAR2 (30)
The type of output required for this document - Excel, PDF, or HTML etc.
AVAILABILITY_TYPE VARCHAR2 (30) Y The type of availability for this document, now, on hold, or specific date and time.
AVAILABILITY_DATE_TIME DATE

Default availability date and time for the report.
DOCUMENT_ID NUMBER (15)
The last document id of a report of this type, used to retrieve presentation location data.
EXPANDED_FLAG VARCHAR2 (1)
Was the last document of this type and expanded report.
SECURITY_TYPE VARCHAR2 (30) Y The type of security implemented for this report.
SECURITY_CODE VARCHAR2 (240)
The values or value set used to secure the report.
PUBLISHER_TYPE VARCHAR2 (30)
The publishing engine used to process the report. Currently XML Publisher or Report Manager.
VALUE_SET_ID NUMBER (15)
The value set id of the last value used for User to Value security.
PRES_FUNCTION_ID NUMBER (15)
The form function id used to launch this report.
PRES_MENU_ID NUMBER (15)
The menu entry id to which the form function is attached.
PRES_MENU_ENTRY_SEQ NUMBER (15)
The order of the form function within the menu.
PUBLISH_FLAG VARCHAR2 (1)
Status flag to determine if entity is published
TIME_FRAME VARCHAR2 (240)
Default timeframe for the report.
EXPANDED_VALUE VARCHAR2 (240)
Default expanded value for standard report.
PRES_TEMPLATE_ASN VARCHAR2 (50)
Default template Application Short Name for the report.
PRES_TEMPLATE_CODE VARCHAR2 (240)
Default template for the report.
DOCUMENT_TYPE VARCHAR2 (20)
Default document type for the report.
PRES_RESP_ID NUMBER (15)
Default responsibility Id for the report.
REVIEWERS_ID VARCHAR2 (240)
Default reviewer id's for the report.
PRES_MENU_NAME VARCHAR2 (240)
Default menu name for the report.
DOCUMENT_NAME VARCHAR2 (240)
Default document name for the report.
PRES_MENU_PATH VARCHAR2 (4000)
Default folder location for the report.
ARCHIVE_DATE DATE

Default archive date for the report.
OBJECT_VERSION_NUMBER NUMBER (15) Y Applications Standard column for a stateless environment.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.
CONFIGURATION_ID NUMBER (15)
The configuration id of the last value used for Delivery Configuration.

[top of page]

FRM.FRM_REQSET_PUB_OPTIONS does not reference any database object

FRM.FRM_REQSET_PUB_OPTIONS is referenced by following:

FRM
VIEW - FRM_REQSET_PUB_OPTIONS#

[top of page]

Table: FRM_RTF_TEMPLATES

Description: Stores a key into the FND_LOBS table for and RTF file used by the RTF to XSL-FO utility for XML Publisher
Primary Key: FRM_RTF_TEMPLATES_PK
  1. TEMPLATE_ID
Comments

Stores a key into the FND_LOBS table for and RTF file used by the RTF to XSL-FO utility for XML Publisher

Columns
Name Datatype Length Mandatory Comments
TEMPLATE_ID NUMBER (15) Y Key into the Template file table of XML Publisher Template Manager. Will be superseded by in XML Publisher 4.5.
LANGUAGE VARCHAR2 (4) Y Language code used to store the XSL:FO template.
DOCUMENT_ID NUMBER (15) Y Key into the FND_LOBS table for the stored RTF Template file.
OBJECT_VERSION_NUMBER NUMBER (15)
Applications Standard column for a stateless environment.
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

FRM.FRM_RTF_TEMPLATES does not reference any database object

FRM.FRM_RTF_TEMPLATES is referenced by following:

FRM
VIEW - FRM_RTF_TEMPLATES#

[top of page]

Table: FRM_SET_PUB_OPTIONS

Description: Stores the publishing options set for a report or request set.
Primary Key: FRM_SET_PUB_OPTIONS_PK
  1. REPORT_SET_ID
  2. REPORT_ID
  3. SEQUENCE_NUMBER
Comments

Stores the publishing options set for a report or request set.

Indexes
Index Type Tablespace Column
FRM_SET_PUB_OPTIONS_UK1 UNIQUE APPS_TS_TX_IDX REPORT_SET_ID
REPORT_ID
SEQUENCE_NUMBER
Columns
Name Datatype Length Mandatory Comments
REPORT_SET_ID NUMBER (15) Y Entity Identifier across all applications
REPORT_ID NUMBER (15) Y Entity Identifier across all applications
SEQUENCE_NUMBER NUMBER (15) Y Entity Identifier across all applications
TEMPLATE_CODE VARCHAR2 (80)
The code for the template stored in the XML Publisher template repository.
APPLICATION_SHORT_NAME VARCHAR2 (50) Y The application short name attached to the template code.
OUTPUT_TYPE VARCHAR2 (30)
The type of output required for this document - Excel, PDF, or HTML etc.
AVAILABILITY_TYPE VARCHAR2 (30) Y The type of availability for this document, now, on hold, or specific date and time.
AVAILABILITY_DATE DATE

If the availability type is set to specific date and time, this column stores the date and time.
DOCUMENT_ID NUMBER (15)
The last document id of a report of this type, used to retrieve presentation location data.
EXPANDED_FLAG VARCHAR2 (1)
Was the last document of this type and expanded report.
SECURITY_TYPE VARCHAR2 (30) Y The type of security implemented for this report.
SECURITY_CODE VARCHAR2 (240)
The values or value set used to secure the report.
PUBLISHER_TYPE VARCHAR2 (30)
The publishing engine used to process the report. Currently XML Publisher or Report Manager.
VALUE_SET_ID NUMBER (15)
The value set id of the last value used for User to Value security.
FUNCTION_ID NUMBER (15)
The form function id used to launch this report.
MENU_ID NUMBER (15)
The menu entry id to which the form function is attached.
MENU_ENTRY_SEQ NUMBER (15)
The order of the form function within the menu.
OBJECT_VERSION_NUMBER NUMBER (15) Y Applications Standard column for a stateless environment.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.
ARCHIVE_PERIOD_MONTHS NUMBER (15)
Period of time in months until this row is archived, or deleted.
PUBLISH_FLAG VARCHAR2 (1)
Status flag to determine if report is published
TIME_FRAME VARCHAR2 (240)
Default timeframe for the report.
EXPANDED_VALUE VARCHAR2 (240)
Default expanded value for standard report.
PRES_TEMPLATE_ASN VARCHAR2 (50)
Default template Application Short Name for the report.
PRES_TEMPLATE_CODE VARCHAR2 (240)
Default template for the report.
DOCUMENT_TYPE VARCHAR2 (20)
Default document type for the report.
PRES_RESP_ID NUMBER (15)
Default responsibility Id for the report.
REVIEWERS_ID VARCHAR2 (240)
Default reviewer id's for the report.
PRES_MENU_NAME VARCHAR2 (240)
Default menu name for the report.
DOCUMENT_NAME VARCHAR2 (240)
Default document name for the report.
PRES_MENU_PATH VARCHAR2 (4000)
Default folder location for the report.
ARCHIVE_DATE DATE

Default archive date for the report.
AVAILABILITY_DATE_TIME DATE

Default availability date and time for the report.
CONFIGURATION_ID NUMBER (15)
The configuration id of the last value used for Delivery Configuration.

[top of page]

FRM.FRM_SET_PUB_OPTIONS does not reference any database object

FRM.FRM_SET_PUB_OPTIONS is referenced by following:

FRM
VIEW - FRM_SET_PUB_OPTIONS#

[top of page]

Table: FRM_SET_SUB_OPTIONS

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
REPORT_SET_ID NUMBER (15) Y
REPORT_ID NUMBER (15) Y
SEQUENCE_NUMBER NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
SUBMISSION_FLAG VARCHAR2 (1) Y
CONTENT_SET_ID NUMBER (15)
ROW_ORDER_ID NUMBER (15)
EXCEPTIONS_FLAG VARCHAR2 (1)
ROUNDING_OPTION VARCHAR2 (1)
LEDGER_SHORT_NAME VARCHAR2 (20) Y
REPORT_DISPLAY_SET_ID NUMBER (15)
PERIOD_NAME VARCHAR2 (15) Y
ACCOUNTING_DATE DATE
Y
SEGMENT_OVERRIDE VARCHAR2 (2000)
UNIT_OF_MEASURE_ID VARCHAR2 (30) Y

[top of page]

FRM.FRM_SET_SUB_OPTIONS does not reference any database object

FRM.FRM_SET_SUB_OPTIONS is referenced by following:

FRM
VIEW - FRM_SET_SUB_OPTIONS#

[top of page]

Table: FRM_USER_PUB_OPTIONS

Description: Stores the publishing options for a report by user.
Primary Key: FRM_USER_PUB_OPTIONS_PK
  1. DOCUMENT_ID
  2. REPORT_ID
  3. USER_ID
Comments

Stores the publishing options for a report by user.

Indexes
Index Type Tablespace Column
FRM_USER_PUB_OPTIONS_UK1 UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
REPORT_ID
USER_ID
Columns
Name Datatype Length Mandatory Comments
REPORT_ID NUMBER (15) Y Entity Identifier across all applications
USER_ID NUMBER (15) Y Entity Identifier across all applications
TEMPLATE_CODE VARCHAR2 (80)
The code for the template stored in the XML Publisher template repository.
APPLICATION_SHORT_NAME VARCHAR2 (50) Y The application short name attached to the template code.
OUTPUT_TYPE VARCHAR2 (30)
The type of output required for this document - Excel, PDF, or HTML etc.
AVAILABILITY_TYPE VARCHAR2 (30) Y The type of availability for this document, now, on hold, or specific date and time.
AVAILABILITY_DATE DATE

If the availability type is set to specific date and time, this column stores the date and time.
DOCUMENT_ID NUMBER (15) Y The last document id of a report of this type, used to retrieve presentation location data.
EXPANDED_FLAG VARCHAR2 (1)
Was the last document of this type and expanded report.
SECURITY_TYPE VARCHAR2 (30) Y The type of security implemented for this report.
SECURITY_CODE VARCHAR2 (240)
The values or value set used to secure the report.
PUBLISHER_TYPE VARCHAR2 (30)
The publishing engine used to process the report. Currently XML Publisher or Report Manager.
VALUE_SET_ID NUMBER (15)
The value set id of the last value used for User to Value security.
FUNCTION_ID NUMBER (15)
The form function id used to launch this report.
MENU_ID NUMBER (15)
The menu entry id to which the form function is attached.
MENU_ENTRY_SEQ NUMBER (15)
The order of the form function within the menu.
OBJECT_VERSION_NUMBER NUMBER (15) Y Applications Standard column for a stateless environment.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.
ARCHIVE_PERIOD_MONTHS NUMBER (15)
Period of time in months until this row is archived, or deleted.

[top of page]

FRM.FRM_USER_PUB_OPTIONS does not reference any database object

FRM.FRM_USER_PUB_OPTIONS is referenced by following:

FRM
VIEW - FRM_USER_PUB_OPTIONS#

[top of page]

Table: FRM_USER_VALUE_MAPPINGS

Description: Stores the user to value mappings and permissions.
Primary Key: FRM_USER_VALUE_MAPPINGS_PK
  1. VALUE_SET_ID
  2. FLEX_VALUE_ID
  3. USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
FRM_USER_VALUE_MAPPINGS.VALUE_SET_ID FRM_PART_VALUE_SETS
Comments

Stores the user to value mappings and permissions.

Indexes
Index Type Tablespace Column
FRM_USER_VALUE_MAPPINGS_UK1 UNIQUE APPS_TS_TX_IDX VALUE_SET_ID
FLEX_VALUE_ID
USER_ID
Columns
Name Datatype Length Mandatory Comments
VALUE_SET_ID NUMBER (15) Y Entity Identifier across all applications
FLEX_VALUE_ID NUMBER (15) Y Entity Identifier across all applications
USER_ID NUMBER (15) Y Entity Identifier across all applications
VALUE VARCHAR2 (30) Y The value to be mapped to a user.
PERMISSION_CODE VARCHAR2 (80) Y The permissions that have been assigned to this user value mapping.
OBJECT_VERSION_NUMBER NUMBER (15) Y Applications Standard column for a stateless environment.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.

[top of page]

FRM.FRM_USER_VALUE_MAPPINGS does not reference any database object

FRM.FRM_USER_VALUE_MAPPINGS is referenced by following:

FRM
VIEW - FRM_USER_VALUE_MAPPINGS#

[top of page]

Table: FRM_XML_ADAPTORS

Description: Stores the java class path and name of datasource to XML Publisher adaptor.
Primary Key: FRM_XML_ADAPTORS_PK
  1. ADAPTOR_TYPE
Comments

Stores the java class path and name of datasource to XML Publisher adaptor.

Columns
Name Datatype Length Mandatory Comments
ADAPTOR_TYPE VARCHAR2 (30) Y The type of adaptor eg. FSG Financial Statement Generator adaptor.
APPLICATION_ID NUMBER (15) Y The Application ID of the product group who owns the adaptor.
ADAPTOR_JAVA_CLASS VARCHAR2 (2000) Y The fuly qualified class of the adaptor.
OBJECT_VERSION_NUMBER NUMBER (15)
Applications Standard column for a stateless environment.
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

FRM.FRM_XML_ADAPTORS does not reference any database object

FRM.FRM_XML_ADAPTORS is referenced by following:

FRM
VIEW - FRM_XML_ADAPTORS#

[top of page]

View: ADI_WEB_FILES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Obsoleted view

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (2089)
Obsolete
MIME_TYPE VARCHAR2 (255)
Obsolete
DOC_SIZE NUMBER

Obsolete
CONTENT BLOB (4000)
Obsolete

[top of page]

APPS.ADI_WEB_FILES_VL references the following:

APPS
SYNONYM - FND_DOCUMENTS_LONG_RAW
VIEW - FND_DOCUMENTS_VL
VIEW - FND_DOCUMENT_CATEGORIES_VL

APPS.ADI_WEB_FILES_VL is not referenced by any database object

[top of page]

View: FRM_DELIVERY_CONFIGURATIONS_VL

Comments
Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CONFIGURATION_ID NUMBER (15) Y
START_DATE DATE
Y
END_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (15) Y
USER_NAME VARCHAR2 (240) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y

[top of page]

APPS.FRM_DELIVERY_CONFIGURATIONS_VL references the following:

APPS
SYNONYM - FRM_DELIVERY_CONFIGURATIONS_B
SYNONYM - FRM_DELIVERY_CONFIGURATIONS_TL

APPS.FRM_DELIVERY_CONFIGURATIONS_VL is not referenced by any database object

[top of page]

View: FRM_DELIVERY_FTP_SERVERS_VL

Comments
Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
SERVER_ID NUMBER (15) Y
SERVER_NAME VARCHAR2 (240) Y
HOST VARCHAR2 (240) Y
PORT NUMBER (15)
USERNAME VARCHAR2 (240)
TYPE VARCHAR2 (5) Y
FILE_PERMISSION NUMBER (4)
AUTH_TYPE VARCHAR2 (15) Y
OBJECT_VERSION_NUMBER NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y

[top of page]

APPS.FRM_DELIVERY_FTP_SERVERS_VL references the following:

APPS
SYNONYM - FRM_DELIVERY_FTP_SERVERS_B
SYNONYM - FRM_DELIVERY_FTP_SERVERS_TL

APPS.FRM_DELIVERY_FTP_SERVERS_VL is not referenced by any database object

[top of page]

View: FRM_DELIVERY_MAILERS_VL

Comments
Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
MAILER_ID NUMBER (15) Y
MAILER_NAME VARCHAR2 (240) Y
HOST VARCHAR2 (240) Y
PORT NUMBER (15)
FROM_ADDRESS VARCHAR2 (240) Y
USERNAME VARCHAR2 (240)
SSL_ENABLED VARCHAR2 (1) Y
OBJECT_VERSION_NUMBER NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y

[top of page]

APPS.FRM_DELIVERY_MAILERS_VL references the following:

APPS
SYNONYM - FRM_DELIVERY_MAILERS_B
SYNONYM - FRM_DELIVERY_MAILERS_TL

APPS.FRM_DELIVERY_MAILERS_VL is not referenced by any database object

[top of page]

View: FRM_DELIVERY_OPTIONS_VL

Comments
Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
DELIVERY_ID NUMBER (15) Y
CONFIGURATION_ID NUMBER (15) Y
DELIVERY_TYPE VARCHAR2 (240) Y
START_DATE DATE
Y
END_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (15) Y
USER_NAME VARCHAR2 (240) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y

[top of page]

APPS.FRM_DELIVERY_OPTIONS_VL references the following:

APPS
SYNONYM - FRM_DELIVERY_OPTIONS_B
SYNONYM - FRM_DELIVERY_OPTIONS_TL

APPS.FRM_DELIVERY_OPTIONS_VL is not referenced by any database object

[top of page]

View: FRM_DIRECTORY_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

FRM_DIRECTORY_VL is a standard translation view over the FRM_DIRECTORY entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Entity Identifier across all applications
DIRECTORY_ID NUMBER (15) Y Entity Identifier across all applications
PARENT_ID NUMBER (15)
The next higher level in the Report Manager directory structure, null if the entry is the root directory.
SEQUENCE_NUMBER NUMBER (15) Y The order of the directory within the parent directory.
OBJECT_VERSION_NUMBER NUMBER (15) Y Applications Standard column for a stateless environment.
USER_NAME VARCHAR2 (240)
User tanslatable column for this table.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.
END_DATE DATE

End Date for directory entity
ARCHIVED_FLAG VARCHAR2 (1)
Flag to determine archive status for entity

[top of page]

APPS.FRM_DIRECTORY_VL references the following:

APPS
SYNONYM - FRM_DIRECTORY_B
SYNONYM - FRM_DIRECTORY_TL

APPS.FRM_DIRECTORY_VL is not referenced by any database object

[top of page]

View: FRM_DOCUMENTS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

FRM_DOCUMENTS_VL is a standard translation view over the FRM_DOCUMENTS entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Entity Identifier across all applications
DOCUMENT_ID NUMBER (15) Y Entity Identifier across all applications
DIRECTORY_ID NUMBER (15) Y The directory id that this document is contained in.
SEQUENCE_NUMBER NUMBER (15) Y The order of the document within the directory.
EXPANDED_FLAG VARCHAR2 (1)
Is this document an expanded document or not.
DS_APP_SHORT_NAME VARCHAR2 (50)
The application short name of the datasource code in the XML Publisher template repository.
DATA_SOURCE_CODE VARCHAR2 (80)
The datasource code attached to this report.
OBJECT_VERSION_NUMBER NUMBER (15) Y Applications Standard column for a stateless environment.
USER_NAME VARCHAR2 (240) Y The translatable user value.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.
END_DATE DATE

Document entity end date
ARCHIVED_FLAG VARCHAR2 (1)
Flag to detemrine archive status.

[top of page]

APPS.FRM_DOCUMENTS_VL references the following:

APPS
SYNONYM - FRM_DOCUMENTS_B
SYNONYM - FRM_DOCUMENTS_TL

APPS.FRM_DOCUMENTS_VL is not referenced by any database object

[top of page]

View: FRM_GLB_TEMPLATE_ALIASES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

FRM_GLB_TEMPLATE_ALIASES_VL is a standard translation view over the FRM_GLB_TEMPLATE_ALIASES entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Entity Identifier across all applications
ELEMENT_NAME VARCHAR2 (240) Y Entity Identifier across all applications
OBJECT_VERSION_NUMBER NUMBER (15) Y Applications Standard column for a stateless environment.
USER_NAME VARCHAR2 (240) Y The translatable user value.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.

[top of page]

APPS.FRM_GLB_TEMPLATE_ALIASES_VL references the following:

APPS
SYNONYM - FRM_GLB_TEMPLATE_ALIASES_B
SYNONYM - FRM_GLB_TEMPLATE_ALIASES_TL

APPS.FRM_GLB_TEMPLATE_ALIASES_VL is not referenced by any database object

[top of page]

View: FRM_REP_TEMPLATE_ALIASES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

FRM_REP_TEMPLATE_ALIASES_VL is a standard translation view over the FRM_REP_TEMPLATE_ALIASES entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Entity Identifier across all applications
APPLICATION_SHORT_NAME VARCHAR2 (50) Y Entity Identifier across all applications
CONCURRENT_PROGRAM_NAME VARCHAR2 (30) Y Entity Identifier across all applications
ELEMENT_NAME VARCHAR2 (240) Y Entity Identifier across all applications
OBJECT_VERSION_NUMBER NUMBER (15) Y Applications Standard column for a stateless environment.
USER_NAME VARCHAR2 (240)
User tanslatable column for this table.
CREATION_DATE DATE
Y Standard WHO column.
CREATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Y Standard WHO column.

[top of page]

APPS.FRM_REP_TEMPLATE_ALIASES_VL references the following:

APPS
SYNONYM - FRM_REP_TEMPLATE_ALIASES_B
SYNONYM - FRM_REP_TEMPLATE_ALIASES_TL

APPS.FRM_REP_TEMPLATE_ALIASES_VL is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract