FOS_UPGRADE_LINE_CROSS_REF
This table contains records which associate the Fusion V1 intercompany flow line record identifiers to the agreement financial 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_LINE_XREF_PK |
CROSS_REFERENCE_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CROSS_REFERENCE_LINE_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_FLOW_LINE_ID | NUMBER | 18 | Yes | This is a reference to the Transaction Flow Line Id. | |
| 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. | |
| AGREEMENT_FTR_ID | NUMBER | 18 | Yes | This is a foreign key reference to the agreement primary trade relationship record that was created in the FOS_AGREEMENT_FTR table for the source flow. | |
| 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_LINE_XREF_PK | Unique | Default | CROSS_REFERENCE_LINE_ID |
| FOS_UPGRADE_LINE_XREF_U1 | Unique | Default | SOURCE_FLOW_LINE_ID, AGREEMENT_PTR_ID |