CMF_FISCAL_DOC_HOLDS_B
This table will store Fical Document Holds information.
Details
-
Schema: FUSION
-
Object owner: CMF
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CMF_FISCAL_DOC_HOLDS_B_PK |
FISCAL_DOC_HOLD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FISCAL_DOC_HOLD_ID | NUMBER | 18 | Yes | Generated Identifier for tolerance rules. | |
| 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. | |
| DOCUMENT_HEADER_ID | NUMBER | 18 | Fiscal Document against which the Hold is being created. | ||
| DOCUMENT_LINE_ID | NUMBER | 18 | Fiscal Document Line against which the Hold is being created. | ||
| FISCAL_DOC_SCHEDULE_ID | NUMBER | 18 | Fiscal Document Schedule against which the Hold is being created. | ||
| TOLERANCE_RULE_ID | NUMBER | 18 | If this is a System Exception, Tolerance Rule which originated it. | ||
| HOLD_CODE | VARCHAR2 | 30 | Yes | This should be storing the lookup values of Hold_type. | |
| EXCEPTION_TYPE_CODE | VARCHAR2 | 30 | This field will store that Lookup code for Hold reason | ||
| HELD_BY | VARCHAR2 | 64 | Yes | Indicates who places the hold, Values can be System or User. By default it would be System post validation process. However if the Hold Name is Manually Placed, then Held By will show the Name of the User who has placed the hold. | |
| RELEASE_REASON_CODE | VARCHAR2 | 30 | This field will have the value of the Lookup code for Release reason. | ||
| RELEASE_TYPE | VARCHAR2 | 30 | Short Name for the Release Indicates type of releases: -Release -Resolve -Reference | ||
| RELEASED_BY | VARCHAR2 | 64 | Indicates who releases the hold, values can be System or User. If the root cause of issue gets fixed and on rerun system does not identify, then the hold is released by System itself. If Manual intervention is made, then the name of the user will be stamped. | ||
| RELEASE_DATE | TIMESTAMP | Indicates the Date when the hold is released | |||
| PROCESSOR_NAME | VARCHAR2 | 30 | Identifies the processor that created the message. | ||
| RUN_CONTROL | VARCHAR2 | 30 | Identifies the Run Control used allocation run. . In case of online calls it will be hardcoded to ONLINE. User may not be able to define run control with the name ONLINE. | ||
| MESSAGE_NAME | VARCHAR2 | 30 | Identifies the event that occurred. This value maps to the MESSAGE_NAME column of the FND_MESSAGES table. | ||
| MESSAGE_TYPE | VARCHAR2 | 30 | FND message type for this message. | ||
| TOKEN1_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN1_VALUE | VARCHAR2 | 240 | Token name as required by error code message. | ||
| TOKEN2_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN2_VALUE | VARCHAR2 | 240 | Token name as required by error code message. | ||
| TOKEN3_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN3_VALUE | VARCHAR2 | 240 | Token name as required by error code message. | ||
| TOKEN4_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN4_VALUE | VARCHAR2 | 240 | Token name as required by error code message. | ||
| TOKEN5_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN5_VALUE | VARCHAR2 | 240 | Token name as required by error code message. | ||
| TOKEN6_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN6_VALUE | VARCHAR2 | 240 | Token name as required by error code message. | ||
| 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. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| cmf_fiscal_doc_holds_tl | cmf_fiscal_doc_holds_b | FISCAL_DOC_HOLD_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMF_FISCAL_DOC_HOLDS_B_N1 | Non Unique | Default | DOCUMENT_LINE_ID, HOLD_CODE, EXCEPTION_TYPE_CODE |
| CMF_FISCAL_DOC_HOLDS_B_N2 | Non Unique | Default | DOCUMENT_HEADER_ID, RELEASE_DATE |
| CMF_FISCAL_DOC_HOLDS_B_PK | Unique | FUSION_TS_TX_IDX | FISCAL_DOC_HOLD_ID |