FOS_UPGRADE_CROSS_REFERENCE
This table contains records which associate the Fusion V1 intercompany flow header record identifiers to the agreement primary trade relationship record identifiers which were created from them during the release 9 upgrade process. The cross reference records in this table are used by the post-upgrade verification scripts to determine which V1 intercompany flows failed to upgrade successfully.
Details
-
Schema: FUSION
-
Object owner: FOS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
FOS_UPGRADE_CROSS_REF_PK |
CROSS_REFERENCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CROSS_REFERENCE_ID | NUMBER | 18 | Yes | This is the primary key and its value is an application generated unique id. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| SOURCE_TABLE | VARCHAR2 | 30 | Yes | The name of the inventory intercompany table that was the source of the cross reference. Valid values are 'INV_TRANSACTION_FLOW_HEADERS' and 'INV_INTERORG_PARAMETERS'. | |
| SOURCE_FLOW_ID | NUMBER | 18 | Yes | This is a reference to the record in the source table which is identified by the SOURCE_TABLE column. | |
| AGREEMENT_PTR_ID | NUMBER | 18 | Yes | This is a foreign key reference to the agreement primary trade relationship record that was created in the FOS_AGREEMENT_PTR table for the source flow. | |
| PRICING_OPTION | VARCHAR2 | 1 | Holds different values based on the following Qualifiers 'Asset Item Pricing Option' and 'Expense Item Pricing Option'. Possible values are 'E', 'A', 'B'. E- Expense Item Pricing Option A- Asset Item Pricing Option B- Both (when both the qualifiers are equal) | ||
| ENTERPRISE_ID | NUMBER | 18 | Yes | Identifier of Enterprise, used for multi-tenancy partitioning. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FOS_UPGRADE_CROSS_REF_PK | Unique | Default | CROSS_REFERENCE_ID |
| FOS_UPGRADE_CROSS_REF_U1 | Unique | Default | SOURCE_TABLE, SOURCE_FLOW_ID, AGREEMENT_PTR_ID |