Log Table Structure
Oracle E-Business Suite keeps a record of the plug-in activities in the TIB_BW_EBS_LOG table.
The following table shows the structure of the TIB_BW_EBS_LOG table:
| Column Names | Data Type | Null? | Default Value | Description |
|---|---|---|---|---|
| ID | NUMBER | No | An auto increment sequence ID. | |
| PROCESS_ID | VARCHAR2 (20) | Yes | Sequence ID; created automatically for each process by TIBCO BusinessWorks. | |
| NAME | VARCHAR2 (100) | No | The name of the API/Wrapper procedure, Concurrent Program, or business event. | |
| TYPE | VARCHAR2 (50) | No | The type of the activity configured in TIBCO Business Studio. | |
| REQUEST_ID | VARCHAR2 (20) | Yes | The ID of the request to run a Concurrent Program in Oracle E-Business Suite. | |
| LOG_TIME | DATE | Yes | SYSDATE | The time when the process is recorded. |
| STATUS | VARCHAR2 (50) | No | The status of the process: Success, Error, or Ignore. | |
| EVENT_QUEUE | VARCHAR2 (50) | Yes | The name of the Queue that receives the message from the Event Agent.
This field applies to Oracle Business Event only. |
|
| EVENT_AGENT | VARCHAR2 (50) | Yes | The name of the Agent that receives the message from the Oracle Business Event System.
This field applies to Oracle Business Event only. |
|
| EVENT_SUBSCRIBER | VARCHAR2 (50) | Yes | The name of the Subscriber that consumes the message.
This field applies to Oracle Business Event only. |
|
| EVENT_DATA | APPS.WF_EVENT_T | Yes | The user data of the business event message.
For more information, refer to the APPS.WF_EVENT_T data type definition in Oracle Database. This field applies to Oracle Business Event only. |
|
| DESCRIPTION | VARCHAR2 (4000) | Yes | The simple-format output result for Oracle API, Custom API, Oracle CP, and Custom CP. |
Copyright © TIBCO Software Inc. All Rights Reserved.