FOS_CALLBACK_INT
This interface table stores the tasks that are successfully processed by the downstream applications like Costing, Receivables, Payables to which Supply Chain Financial Orchestration interfaces the data for cost processing and invoicing.
Details
-
Schema: FUSION
-
Object owner: FOS
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
FOS_CALLBACK_INT_PK |
INTERFACE_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_ROW_ID | NUMBER | 18 | Yes | This is the primary key and its value is an application generated unique id. | |
| SOURCE_DOCUMENT_REFERENCE | NUMBER | 18 | Yes | Contains flow instance id that refers to the transaction interfaced by supply chain financial orchestration. | |
| IMPORT_DATE | DATE | Yes | Stores the date at which the interface record was populated into transaction table. | ||
| DOCUMENT_HEADER_NUMBER | VARCHAR2 | 100 | Contains the header number of the target document that was created by this task. | ||
| DOCUMENT_HEADER_ID | NUMBER | 18 | Contains the header id of the target document that was created by this task. | ||
| DOCUMENT_LINE_NUMBER | VARCHAR2 | 100 | Contains the line number of the target document that was created by this task. | ||
| DOCUMENT_LINE_ID | NUMBER | 18 | Contains the line id of the target document that was created by this task. | ||
| DOCUMENT_LINE_DETAIL | VARCHAR2 | 100 | Contains the line detail information of the target document that was created by this task. | ||
| DOCUMENT_LINE_DETAIL_ID | NUMBER | 18 | Contains the detail id of the target document that was created by this task. | ||
| 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. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| BATCH_ID | NUMBER | 18 | Represents the identifier for a batch of tasks that needs to be processed together during callback. | ||
| PROCESSED_FLAG | VARCHAR2 | 1 | Yes | Flag used to indicate whether task status is updated in flow instances table or not. Valid values are 'Y', 'N' and 'P'. | |
| 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_CALLBACK_INT_N1 | Non Unique | Default | REQUEST_ID, BATCH_ID |
| FOS_CALLBACK_INT_N2 | Non Unique | Default | SOURCE_DOCUMENT_REFERENCE |
| FOS_CALLBACK_INT_U1 | Unique | Default | INTERFACE_ROW_ID |