Polling Column

The Polling Column form allows you to add, modify, and delete custom fields for importing data. The form also displays system-defined polling column records. The polling column records are mapped to a specific interface prompt on the Polling Map form. These fields are used by the IN_ORACLE_EBS service when importing data.

You can also Validate these fields against the Sender database to make sure the field will import the data correctly.

See Also:

Polling Column Field Descriptions

Add a Polling Column

Modify a Polling Column

Delete a Polling Column

Validate a Polling Column

 

Polling Column Field Descriptions

Interface Name

Identifies the Interface to which the record applies. Interface names are defined on the Interface form.

Transaction Name

Indicates the type of transaction to which the data applies. Available options are defined for the specified Interface Name on the Interface Trans tab of the Interface form.

Sender Name

Identifies the sender of the data. Available options are defined on the Interface Host form.

You must click the Filter button to display this field. The Sender Name field is used when you Validate a Polling Column record.

Column Datatype

Identifies the data type of the record (Int, Nvarchr, Char, etc.)

Column Name

Identifies the table column from which the data originates.

Column Statement

Indicates how the data is selected from the table.

System Required

When this box is checked, the record is system required and cannot be modified.

Description

Description of the record.

Update Date, Updated By

These fields display when the record was created or updated, and the person who created or updated the record.

 

Add a Polling Column

When you add a Polling Column record, a corresponding record will also be created on the Polling Map form.

  1. Click Main Menu > Configuration > Interfaces > Database Polling > Polling Column.

  2. Click Add.

  3. Select an Interface Name, Transaction Name, and Column Datatype.

  4. Enter the Column Name, Column Statement, and a Description of this record.

  5. If you want to add more than one Polling Column record, click Save and Add to save your settings and keep the Add Polling Column pop-up form open. Or click Save to save your Polling Column record and return to the main form

 

Modify a Polling Column

  1. Click Main Menu > Configuration > Interfaces > Database Polling > Polling Column.

  2. Select the record you want to change and click Modify.

    You cannot modify System Required records.

  3. Change the Column Statement and Description and click Save.

 

Delete a Polling Column

When you delete a Polling Column record, its corresponding record will also be deleted on the Polling Map form.

  1. Click Main Menu > Configuration > Interfaces > Database Polling > Polling Column.

  2. Select the record you want to remove and click Delete.

    You cannot delete System Required records.

  3. Click OK to confirm the action.

 

Validate a Polling Column

  1. Click Main Menu > Configuration > Interfaces > Database Polling > Polling Column.

  2. If necessary, click the  Filter button to display the filter fields.

  3. Select the Interface Name, Transaction Name, and Sender Name of the record you want to validate.

  4. Click Find.

  5. Select the record in the middle of the form and click Validate.

The system will use the sender’s data source (defined in the Interface Host form) to validate the record.