Bookshelf Home | Contents | Index | Search | PDF

Siebel Connector for Oracle Applications > Oracle Scripts >

Oracle Applications R10.7 Scripts

---

The Oracle 107Scripts folder contains the following scripts:

siebelaccount107alert_insert_ar_customer_profile_amounts.sql

This script creates an insert alert, Siebel Customer Profile Insert, which puts an entry in the Notification Table for every new record created in table AR_CUSTOMER_PROFILE_AMOUNTS.

siebelaccount107alert_insert_ra_addresses_all.sql

This script creates an insert alert, Siebel Customer Address Insert, which puts an entry in the Notification Table for every new record created in table RA_ADDRESSES_ALL.

siebelaccount107alert_insert_ra_contacts.sql

This script creates an insert alert, Siebel Customer Contact Insert, which puts an entry in the Notification Table for every new record created in table RA_CONTACTS.

siebelaccount107alert_insert_ra_phones.sql

This script creates an insert alert, Siebel Customer Phones Insert, which puts an entry in the Notification Table for every new record created in table RA_PHONES.

siebelaccount107alert_update_ar_customer_profile_amounts.sql

This script creates an update alert, Siebel Customer Profile Update, which puts an entry in the Notification Table for any update in table AR_CUSTOMER_PROFILE_AMOUNTS.

siebelaccount107alert_update_ra_contacts.sql

This script creates an update alert, Siebel Customer Contact Update, which puts an entry in the Notification Table for any update in table RA_CONTACTS.

siebelaccount107alert_update_ra_addresses_all.sql

This script creates an update alert, Siebel Customer Address Update, which puts an entry into the Notification Table for any update in table RA_ADDRESSES_ALL.

siebelaccount107alert_update_ra_contacts.sql

This script creates an update alert, Siebel Customer Contact Update, which puts an entry into the Notification Table for any update in table RA_CONTACTS.

siebelaccount107alert_update_ra_customer_interface_all.sql

This script creates an update alert, Siebel Customer Interface Error Update, which puts an entry in the Notification Table for any update in table RA_CUSTOMERS_INTERFACE_ALL. This is to get interface_status into Siebel Applications, if the records did not successfully get created in Oracle Applications by the Customer Import.

siebelaccount107alert_update_ra_customers.sql

This script creates an update alert, Siebel Customer Header Update, which puts an entry in the Notification Table for any update in table RA_CUSTOMERS.

siebelaccount107alert_update_ra_phones.sql

This script creates an update alert, Siebel Customer Phones Update, which puts an entry in the Notification Table for any update in table RA_PHONES.

siebelaccount107procedure_sie_customer_preval_pr.sql

This script creates the prevalidation procedure SIE_CUSTOMER_PREVAL_PR, which validates the data inserted into the Oracle customer Interface tables.

siebelaccount107table_sie_contact_phones_int_all.sql

This script creates the table SIE_CONTACT_PHONES_INT_ALL, which is used in the Accounts Outbound track of the Siebel Connector for Oracle Applications. The data is inserted into this table before the prevalidation program validates and moves it into the Oracle interface table.

siebelaccount107table_sie_customer_interface_all.sql

This script creates the table SIE_CUSTOMERS_INTERFACE_ALL, which is used in the Accounts Outbound track of the Siebel Connector for Oracle Applications. The data is inserted into this table before the pre-validation program validates it and moves it into the Oracle interface table.

siebelaccount107table_sie_customer_profiles_int_all.sql

This script creates the table SIE_CUSTOMER_PROFILES_INT_ALL, which is used in the Accounts Outbound track of the Siebel Connector for Oracle Applications. The data is inserted into this table before the prevalidation program validates and moves it into the Oracle interface table.

siebelaccount107trigger_delete_ar_customer_profile_amounts.sql

This script creates an after delete trigger SIE_PROFILE_AMT_DEL_TR, which puts an entry in the Notification Table for any records deleted in table AR_CUSTOMER_PROFILE_AMOUNTS.

siebelaccount107trigger_delete_ra_phones.sql

This script creates an after delete trigger SIE_PHONE_DEL_TR, which puts an entry in the Notification Table for any records deleted in table RA_PHONES.

siebelaccount107view_sie_customer_profile_amounts.sql

This script creates the view SIE_CUSTOMER_PROFILE_AMOUNTS, which is used in the Accounts Inbound track of the Siebel Connector for Oracle Applications.

siebeldiscount107alert_insert_so_discount_lines.sql

This script creates an insert alert, Siebel Discount Lines Insert, on table SO_DISCOUNT_LINES. This creates Discount entries as a single Oracle discount line is pulled into Siebel Applications as separate discount and price list line entries.

siebeldiscount107alert_insert_so_price_break_lines.sql

This script creates an insert alert, Siebel Price Break Lines Insert, which puts an entry in the Notification Table for every new record created in table SO_PRICE_BREAK_LINES.

siebeldiscount107alert_update_so_discount_lines.sql

This script creates an update alert, Siebel Discount Lines Update, which puts a Discount entry in the Notification Table for any update in table SO_DISCOUNT_LINES.

siebeldiscount107alert_update_so_discounts.sql

This script creates an alert, Siebel Discounts Update, which puts Price List entries in the Notification Table as Oracle discount is pulled into Siebel Applications as price list for any update in table SO_DISCOUNTS.

siebeldiscount107alert_update_so_price_break_lines.sql

This script creates an alert, Siebel Price Break Lines Update, which puts an entry in the Notification Table for any update in table SO_PRICE_BREAK_LINES.

siebeldiscount107trigger_delete_so_price_break_lines.sql

This script creates an after delete trigger SIE_SO_PRICE_BRK_TR, which puts an entry in the Notification Table for any records deleted in table SO_PRICE_BREAK_LINES.

siebeldiscount107view_sie_discount_lines_v.sql

This script creates the view SIE_DISCOUNT_LINES_V, which is used in the Discounts Inbound track of the Siebel Connector for Oracle Applications.

siebeldiscount107view_sie_price_break_lines_v.sql

This script creates the view SIE_PRICE_BREAK_LINES_V, which is used in the Discounts Inbound track of the Siebel Connector for Oracle Applications.

siebelgeneral107package_sie_notify_pkg.sql

This script creates SIE_NOTIFY_PKG, which is executed by all the alerts to insert records into the Notification Table.

siebelgeneral107package_sie_notify_pkg2.sql

This script creates SIE_NOTIFY_PKG2, which is executed by all the alerts on the Oracle interface tables to insert records into the Notification Table.

siebelgeneral107script_notify_discount.sql

This script can be used to insert records into the Notification Table to pull all the Discounts from Oracle Applications into Siebel Applications as an initial data load of Discounts and Discount Lines.

siebelgeneral107script_notify_invloc.sql

This script can be used to insert records into the Notification Table to pull all the Inventory Organizations from Oracle Applications into Siebel Applications as an initial data load of Inventory Locations.

siebelgeneral107script_notify_org.sql

This script can be used to insert records into the Notification Table to pull all the Operating Units from Oracle Applications into Siebel Applications as an initial data load of Organizations.

siebelgeneral107script_notify_pricelist.sql

This script can be used to insert records into the Notification Table to pull all the Price Lists from Oracle Applications into Siebel Applications as an initial data load of Price Lists and price List Items.

siebelgeneral107script_notify_product.sql

This script can be used to insert records into the Notification Table to pull all the Items from Oracle Applications into Siebel Applications as an initial data load of products.

siebelgeneral107sequence_sie_notify_s.sql

This script creates the sequence SIE_NOTIFY_S, which is used to generate unique SEQ_NUM values in the Notification Table.

siebelgeneral107setup.sql

This script has to be run at the SQL prompt after logging in as the SIEBEL user. This script creates all the Siebel Connector for Oracle Applications Objects and grants the necessary privileges to the APP user.

siebelgeneral107setup1.sql

This script grants the necessary privileges to SIEBEL from APPS on the Oracle Applications base tables that will be accessed by the SIEBEL user.

siebelgeneral107setup2.sql

This script creates the necessary synonyms and all the Oracle Connector objects under the SIEBEL user. It also grants the necessary privileges to the APPS user on the Oracle Connector objects.

siebelgeneral107setup3.sql

This script creates the necessary synonyms, alerts, and triggers for the connector under the APPS user.

siebelgeneral107table_sie_notify_tbl.sql

This script creates the Notification Table SIE_NOTIFY_TBL.

siebelgeneral107table_sie_obj_priority_tbl.sql

This script creates the priority table SIE_OBJ_PRIORITY_TBL and also the records that indicate the priority in which the records need to be processed.

siebelinventorylocation107view_sie_invloc_v.sql

This script creates the view SIE_INVLOC_V, which is used in the InvLoc Inbound track of the Siebel Connector for Oracle Applications.

siebelorder107alert_insert_so_line_details.sql

This script creates an insert alert, Siebel Schedule Details Insert, which puts an entry into the Notification Table for every new RESERVED line detail record created in table SO_LINE_DETAILS.

siebelorder107alert_insert_so_lines_all.sql

This script creates an insert alert, Siebel Order Line Insert, which puts an entry in the Notification Table for every new record created in table SO_LINES_ALL.

siebelorder107alert_insert_so_order_hold_all.sql

This script creates an insert alert, Siebel Order Hold Insert, which puts an entry into the Notification Table for every new record created in table SO_ORDER_HOLDS_ALL.

siebelorder107alert_insert_so_picking_lines_all.sql

This script creates an insert alert, Siebel Shipment Details Insert, which puts an entry into the Notification Table for every new record created in table SO_PICKING_LINES_ALL.

siebelorder107alert_update_so_headers_all.sql

This script creates an update alert, Siebel Order Header Update, which puts an entry in the Notification Table for any update in table SO_LINES_ALL.

siebelorder107alert_update_so_headers_interface_all.sql

This script creates an update alert, Siebel Order Header Interface Update, which puts an entry in the Notification Table for any update in table SO_HEADERS_INTERFACE_ALL. This puts interface_status into the Siebel application, if the records are not successfully created in Oracle Applications by the Order Import.

siebelorder107alert_update_so_lines_all.sql

This script creates an update alert, Siebel Order Line Update, which puts an entry in the Notification Table for any update in table SO_LINES_ALL.

siebelorder107alert_update_so_order_hold_all.sql

This script creates an update alert, Siebel Order Hold Update, which puts an entry into the Notification Table for any update in table SO_ORDER_HOLDS_ALL.

siebelorder107alert_update_so_picking_lines_all.sql

This script creates an insert alert, Siebel Shipment Details Update, which puts an entry in the notification table for any update in table SO_PICKING_LINES_ALL

siebelorder107procedure_sieordervalidate.sql

This script creates the prevalidation procedure, SIEORDERVALIDATE, which validates the data inserted into the Oracle Order Entry Interface tables.

siebelorder10.7alert_update_so_line_details.sql

This script creates an update alert, Siebel Schedule Details Update, which puts an entry into the Notification Table for every RESERVED line detail record updated in table SO_LINE_DETAILS.

siebelorder107table_sie_headers_interface_all.sql

This script creates the table, SIE_HEADERS_INTERFACE_ALL, which is used in the Orders Outbound track of the Siebel Connector for Oracle Applications. The data is inserted into this table before the prevalidation program validates it and moves it into the Oracle interface table.

siebelorder107table_sie_lines_interface_all.sql

This script creates the table, SIE_LINES_INTERFACE_ALL, which is used in the Orders Outbound track of the Siebel Connector for Oracle Applications. The data is inserted into this table before the prevalidation program validates it and moves it into the Oracle interface table.

siebelorder107table_sie_price_adjustments_int.sql

This script creates the table, SIE_PRICE_ADJUSTMENTS_INT, which is used in the Orders Outbound track of the Siebel Connector for Oracle Applications. The data is inserted into this table before the prevalidation program validates it and moves it into the Oracle interface table.

siebelorder107trigger_delete_so_headers_all.sql

This script creates an after delete trigger, SIE_ORDER_HEADER_DEL_TR, which puts an entry in the Notification Table for any records deleted in table SO_HEADERS_ALL.

siebelorder107trigger_delete_so_lines_all.sql

This script creates an after delete trigger, SIE_ORDER_LINE_DEL_TR, which puts an entry in the Notification Table for any records deleted in table SO_LINES_ALL.

siebelorder107view_sie_headers_all_v.sql

This script creates the view, SIE_HEADERS_ALL_V, which is used in the Orders Inbound track of the Siebel Connector for Oracle Applications.

siebelorder107view_sie_lines_all_v.sql

This script creates the view, SIE_LINES_ALL_V, which is used in the Orders Inbound track of the Siebel Connector for Oracle Applications.

siebelorder107view_sie_order_header_status_v.sql

This script creates the view, SIE_ORDER_HEADER_STATUS_V, which is used in the view, SIE_HEADERS_ALL_V, to get the Order Header status.

siebelorder107view_sie_order_line_status_all_v.sql

This script creates the view, SIE_ORDER_LINE_STATUS_ALL_V, which is used in the view, SIE_ORDER_LINE_STATUS_V, to get the Order Line status.

siebelorder107view_sie_order_line_status_v.sql

This script creates the view, SIE_ORDER_LINE_STATUS_V, which is used in the view, SIE_LINES_ALL_V, to get the Order Line status.

siebelorder107view_sie_schedule_quantities_v.sql

This script creates the view, SIE_SCHEDULE_QUANTITIES_V, which is used in the Orders Inbound track of the Siebel Connector for Oracle Applications.

siebelorder107view_sie_shipment_quantities_v.sql

This script creates the view, SIE_SHIPMENT_QUANTITIES_V, which is used in the Orders Inbound track of the Siebel Connector for Oracle Applications.

siebelorganization107view_sie_org_v.sql

This script creates the view, SIE_ORG_V, which is used in the Organizations Inbound track of the Siebel Connector for Oracle Applications.

siebelpricelist107alert_insert_so_price_list_lines.sql

This script creates an insert alert, Siebel Price Lists Lines Insert, which puts an entry in the Notification Table for every new record created in table SO_PRICE_LIST_LINES.

siebelpricelist107alert_insert_so_price_lists.sql

This script creates an insert alert, Siebel Price Lists Insert, which puts an entry in the Notification Table for every new record created in table SO_PRICE_LISTS.

siebelpricelist107alert_update_so_price_list_lines.sql

This script creates an update alert, Siebel Price Lists Lines Update, which puts an entry in the Notification Table for any update in table SO_PRICE_LIST_LINES.

siebelpricelist107alert_update_so_price_lists.sql

This script creates an update alert, Siebel Price Lists Update, which puts an entry in the Notification Table for any update in table SO_PRICE_LISTS.

siebelpricelist107view_sie_price_list_lines_v.sql

This script creates the view, SIE_PRICE_LIST_LINES_V, which is used in the Price Lists Inbound track of the Siebel Connector for Oracle Applications.

siebelpricelist107view_sie_price_lists_v.sql

This script creates the view, SIE_PRICE_LISTS_V, which is used in the Price Lists Inbound track of the Siebel Connector for Oracle Applications.

siebelproduct107alert_insert_mtl_system_items.sql

This script creates an insert alert, Siebel Product Insert, which puts an entry in the Notification Table for every new Customer Order Enabled - Standard or Model Item created in table MTL_SYSTEM_ITEMS.

siebelproduct107alert_update_mtl_system_items.sql

This script creates an update alert, Siebel Product Update, which puts an entry in the Notification Table for any update to a Standard or Model Item in table MTL_SYSTEM_ITEMS.

siebelproduct107trigger_update_mtl_system_items.sql

This script creates an after update trigger SIE_UPDATE_ITEMS_TR, which puts an entry in the Notification Table for any update in table MTL_SYSTEM_ITEMS.

An alert, also exists as a trigger for updates on table MTL_SYSTEM_ITEMS. By default, this alert, is created when the Siebel Connector for Oracle Applications objects are created. The trigger checks the old and the new customer order enabled flag values without adding corresponding entries to the Notification Table. The customer may delete the alert, and enable the trigger.

siebelproduct107view_sie_prod_invloc_v.sql

This script creates the view, SIE_PROD_INVLOC_V, which is used in the Products Inbound track of the Siebel Connector for Oracle Applications.

siebelproduct107view_sie_prod_org_v.sql

This script creates the view, SIE_PROD_ORG_V, which is used in the Products Inbound track of the Siebel Connector for Oracle Applications.

siebelproduct107view_sie_product_v.sql

This script creates the view, SIE_PRODUCT_V, which is used in the Price Lists Inbound track of the Siebel Connector for Oracle Applications.

Bookshelf Home | Contents | Index | Search | PDF