D Additional Business Event Subscription Setup for Product Sync Events

In Oracle E-Business Suite, items are created in the Master Organization, and assigned to Inventory Organizations from the Item Master Org. In the delivered Process Integration Pack (PIP), default subscriptions are created for two events raised for item create and update: oracle.apps.ego.item.postItemUpdate, and oracle.apps.ego.item.postItemCreate. These subscriptions trigger the item sync flow for every item created or updated in any inventory organization. The integration flows propagate the item create and update to CRM On Demand, if the inventory organization is mapped in the INVENTORY_LOCATIONS XREF table.

It is recommended to optimize the default subscriptions to only trigger the item create and update flows for the subset of inventory organizations relevant for order processing in the PIP. This is the set of item validation organizations.

D.1 Setting Up Subscription

By default, the subscription for the oracle.apps.ego.item.postItemUpdate and oracle.apps.ego.item.postItemCreate events is processed by the PLSQL function aia_custom_subscription_pkg.aia_item_subscription. This package is created in Oracle E-Business Suite at the time of the PIP deployment.

In addition, a PLSQL package called aia_item_subscrpt_params_pkg is applied to specify the parameters used in the PLSQL package subscription. The default source for this package is available in the following file: "$AIA_HOME/services/core/Ebiz/AdapterServices/CreateItemEbizEventConsumer/aia_item_subscription_params_pkg.sql"

The following three variables must be modified as follows:

• g_validate_subscription

  Values for this should be Y or N.

  • N (default): This value implements the delivered behavior. That is, subscription triggers the item sync flow for every item created or updated in any inventory organization

  • Y: This value triggers the item sync flow for item created or updated in the master or item validation orgs specified in the g_master_organization_id and g_itemValidationOrgs variables.

• g_master_organization_id

  Set to the ID of the item master org. Example: g_master_organization_id Number:=204.

• g_itemValidationOrgs

  Set to list of Ids of Item Validation Orgs. This list should include all the organizations from the INVENTORY_LOCATIONS XREF table Example: g_itemValidationOrgs NumberList:= NumberList(204,911).

• When setup is completed, item creates and updates are synced for organizations listed in g_itemValidationOrgs (204 and 911).

After making these changes, recompile the aia_item_subscrpt_params_pkg package against the Oracle E-Business Suite database (Apps Schema).