Troubleshooting
Problem
Certain Oracle 11i triggers inserting records into cai_notification table event ids in cai_notification table which trigger why are these triggers there?
Symptom
PART: System Administration 6.2 SP2 DCS
COMPONENT: Oracle 11i Integration
kit
Certain Oracle 11i triggers inserting records into cai_notification
table event ids in cai_notification table which trigger why are these triggers
there?
Cause
Resolving The Problem
Various triggers on the Oracle Host side are written to capture any changes
made to entities such as orders, items, POs, customer data on the Oracle host
side for download into the WMS Application. Trigger names,their use and the
corresponding interface job are described below:
Trigger name
like Triggered On Event TypeID
in CAI Interface job
cst_item_costs UPD ON
apps.CST_ITEM_COSTS 1
mtl_sys_item INS/ UPD/DEL ON APPS_USER..MTL_SYSTEM_ITEM
1
po_header INS/ UPD ON
PO_HEADERS_ALL 2
po_rl_line
INS/ UPD/DEL ON PO_RELEASES_ALL 2
po_line_location
INS ON PO_LINE_LOCATIONS_ALL approved_flag = 'Y
3
wsh_new_deliveries INS/ UPD/DEL ON WSH_NEW_DELIVERIES 6
ORDD
wip_discrete_job INS/ UPD ON
wip_discrete_job 10
WORD
ra_customers INS/ UPD/DEL ON RA_CUSTOMERS
12 CCST
po_vendors INS/ UPD/DEL ON
PO_VENDORS 18 VNDR
Interface
Type Event Type SYSTEM_ID1 SYSTEM_ID2 SYSTEM_ID3
PORD 2 PO_HEADER_ID
3
PO_HEADER_ID PO_LINE_ID PO_RELEASE_ID
WORD 10 WIP_ENTITY_ID
ORGANIZATION_ID
ORDD 6 DELIVERY_ID ORGANIZATION_ID
CCST 12 CUSTOMER_ID
ORGANIZATION_ID
VNDR 18 VENDOR_ID ORGANIZATION_ID
CSKU 1
INVENTORY_ITEM_ID ORGANIZATION_ID
Historical Number
PRI49071
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21526943