Skip Headers
Oracle® Fusion Middleware Administrator's Guide for Oracle SOA Suite and Oracle Business Process Management Suite
11g Release 1 (11.1.1)

Part Number E10226-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

17 Managing Cross-References

Cross-references enable you to associate identifiers for equivalent entities created in different applications. This chapter describes how to manage cross-references.

For more information about cross-references, refer to Oracle Fusion Middleware Developer's Guide for Oracle SOA Suite.

This chapter includes the following topics:

17.1 Deleting Cross-Reference Values

You can use the Cross References page to select tables and columns from which you want to delete the values.

To delete values from cross-reference tables and columns:

  1. Open the SOA Infrastructure Home page.

  2. From the SOA Infrastructure menu, select SOA Administration and then Cross References.

    The Cross References page is displayed.

    Description of med_cross_ref.gif follows
    Description of the illustration med_cross_ref.gif

  3. In the Select Tables and Columns section, select one of the following options:

    • All tables: To delete values from all tables.

    • Select a table and columns: To select either a specific table from which to delete values, or to select one or more columns from a specific table from which to delete values.

  4. In the Select Values section, select one of the following options:

    • All: To delete all values from selected table and columns.

    • Marked for delete: To delete only the values that have been marked for deletion from the selected table and columns.

    • Updated between: To delete values updated between a specific time periods.

  5. If you select the Updated between option in Step 4, then you must enter a starting date in the From field and an ending date in the To field.

  6. Click Delete.