Siebel Connector for Oracle Applications > Developer Procedures > Understanding the Oracle Receiver >
Notification Table
The Notification Table (SIE_NOTIFY_TBL) contains information about the Oracle base table and row that were updated. It identifies the primary keys and the type of update activity (Insert, Update, or Delete).
Table Structure
Notification Table columns are listed in Table 22.
Table 22. Notification Table Columns
Column
|
Description
|
Not Null
|
Column Type and Length
|
Seq_Num
|
Primary key.
|
Yes
|
Number
|
Object_Name
|
Name of the Integration Object.
|
Yes
|
Varchar2 (75)
|
Tbl_Name
|
Name of the Oracle base table containing the updated row.
|
Yes
|
Varchar2 (30)
|
Pri_Key1
|
Primary key 1. In combination with Pri_Key2, identifies the rowid.
|
No
|
Varchar2 (240)
|
Pri_Key2
|
Primary key 2. In combination with Pri_Key1, identifies the rowid.
|
|
Varchar2 (240)
|
Root_Tbl_Pri_Key1
|
|
|
Varchar2 (240)
|
Root_Tbl_Pri_Key2
|
|
|
Varchar2 (240)
|
Original_System_Reference
|
|
|
Varchar2 (240)
|
Operation
|
Type of operation (Insert, Update, Delete, and so on).
|
Yes
|
Varchar2 (1)
|
Status
|
Status of the row (Ready for Transfer, In Process, and so on).
|
Yes
|
Varchar2 (10)
|
Type
|
Data or error (usually, data).
|
Yes
|
Varchar2 (10)
|
Error_Message
|
Error message text (for example, Error).
|
|
Varchar2 (2000)
|
Last_Update_Date
|
Last date that the row was updated.
|
Yes
|
Date
|
Last_Updated_By
|
Number identifying the last person who updated the row.
|
Yes
|
Number
|
Creation_Date
|
Date that the row was created.
|
Yes
|
Date
|
Created_By
|
Number identifying the person who created the row.
|
Yes
|
Number
|
Last_Update_Login
|
Number identifying the last login.
|
|
Number
|
Adpt_Mode
|
System use only.
|
Yes
|
Varchar2 (10)
|
Queue_Name
|
Needed if the ORCL QUEUE NAME parameter is set to find matching rows.
|
Yes
|
Varachr2 (30)
|
Methods and Arguments
The Oracle Receiver program incorporates methods that are used to perform various tasks. Each method can have one or more arguments that are used to further define the method's action. An argument typically consists of data or an object that the method processes.
The Oracle Receiver can be run as a server component or business service. The following list identifies the parameter, methods, and arguments used with each type of installation.
Running as a Server Component---As a server component, the Oracle Receiver can be run with the fixed parameter and parameters listed as follows.
Fixed Parameters
- ReceiverServiceName
- ReceiverMethodName
- ReceiverDispatchService
- ReceiverDispatchMethod
Parameters
- ExtDBODBCDataSource
- ExtDBPassword
- ExtDBUserName
- ExtDBTableOwner
- ORCLQueueName
- ORCLBatchSize
The Oracle Receiver's fixed parameters are described in Table 23.
Fixed Parameters
Table 23. Oracle Receiver Fixed Parameters
Parameter Name/
Displayed Name
|
Required?
|
Description
|
ReceiverServiceName = EAI Oracle Receiver
|
Yes
|
Specifies the service (Oracle Receiver).
|
ReceiverMethodName = RunData
|
Yes
|
Specifies the method.
|
ReceiverDispatchService =
EAI Oracle Receiver Dispatch
|
Yes
|
Specifies the Dispatch Business Service that the Receiver would invoke.
|
ReceiverDispatchMethod = Execute
|
Yes
|
Specifies the method to call on the service above.
|
Parameters
The Oracle Receiver's variable parameters are described in Table 24.
Table 24. Oracle Receiver Variable Parameters
Parameter Name/
Displayed Name
|
Required?
|
Description
|
ExtDBODBCDataSource = ORCL ODBC DataSource
|
Yes
|
ODBC data source name for the Oracle database.
|
ExtDBPassword =
ORCL Password
|
Yes
|
Password for the datasource.
|
ExtDBUserName =
ORCL User Name
|
Yes
|
Username for the datasource.
|
ExtDBTableOwner = ORCLE Table Owner
|
Yes
|
Table owner for the data source.
|
ORCL BatchSize =
ORCL Batch size
|
|
If this parameter is specified, the Oracle Receiver will extract, in a single pass, the maximum number of records from the Notification Table, up to the ExtDBBatchSize.
|
ORCLQueueName =
ORCL Queue Name
|
|
System parameter.
|
