FND_BOSS_SEARCH_DATA_CHUNK
BOSS Search indexes defined by BOSS metadata.
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
FND_BOSS_SEARCH_DATA_CHUNK_PK |
INDEX_ID, INDEX_SELECTOR, CHUNK_NUMBER |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INDEX_ID | NUMBER | 18 | Yes | Unique identifier of the index. | |
| INDEX_SELECTOR | NUMBER | 9 | Yes | Index selector, 1, 2, 3, .... | |
| CHUNK_NUMBER | NUMBER | 9 | Yes | Chunk number. | |
| FROM_KEY | VARCHAR2 | 500 | Smallest primary key value for the chunk in encoded form. | ||
| TO_KEY | VARCHAR2 | 500 | Largest primary key value for the chunk in encoded form. | ||
| INGESTION_COUNT | NUMBER | 15 | Number of rows ingested. | ||
| EXPECTED_COUNT | NUMBER | 15 | Yes | Number of rows exected for this chunk. | |
| LAST_INGESTION_KEY | VARCHAR2 | 500 | Pimary key value for the last row to be ingested. | ||
| INGESTION_START_DATE | TIMESTAMP | Start data and time of this chunk ingestion. | |||
| INGESTION_END_DATE | TIMESTAMP | Finish data and time of this chunk ingestion. | |||
| CHUNK_STATUS | VARCHAR2 | 20 | Yes | Status of this chunk. STAGED, IN_PROGRESS, SUCCESS, FAILED | |
| CHUNK_TYPE | VARCHAR2 | 20 | Yes | Type of chunk based on ingestion type. 'FULL' for full ingestion, 'BULK' for bulk ingestion. | |
| MESSAGES | CLOB | Any messages, in particular when the chunk has failed to ingest. | |||
| RETRY_COUNT | NUMBER | 9 | Yes | Number of retries on ingestion of this chunk. | |
| 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 |
|---|---|---|---|
| FND_BOSS_SEARCH_DATA_CHUNK_U1 | Unique | Default | INDEX_ID, INDEX_SELECTOR, CHUNK_NUMBER |