Adding a Sequence

If you use parent-child table relationships for Publication Service, you have to add a sequence to the metadata stored in the AE schema.

1. In the Configuration tab of the service, click the Class Reference link to open the AE Schema file in the editor.
2. Click the Classes tab, and select the referred object from the All Classes panel.
3. Click Add Attribute. In the Configuration panel, specify the following fields for the attribute:
   • Name: Type ADB_SEQUENCE_child_table_name in the Name field.
   • Return Type: Click Browse. In the Schema Selection window, select the schema of the adapter configuration. In the displayed list, select the sequence for the child table. Click OK.
   • Readable: select this check box.
   • Writable: select this check box.
4. Save the AE schema.
   The sequence is added to the metadata for the reference object.