[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ISC_FS_PARTY_MERGE_EVENTS |
|---|---|
| Object Type: | TABLE |
| Owner: | ISC |
| Subobject Name: | |
| Status: | VALID |
This table stores data for field service tasks updated by Party Merge.
It is truncated by the initial load of ISC_FS_TASKS_F, ISC_FS_TASK_ASSIGNMNTS_F and ISC_FS_CAPACITY_F.
CUSTOMER_ID and/or ADDRESS_ID need to be updated in ISC_FS_TASKS_F if a Party Merge is performed for a customer with Field Service Tasks. The business events cannot be used to track such updates as no event is raised. Instead we will provide our own party merge routine which will insert into this table .
Rows are deleted from this table after they have been processed by the incremental load. If the table contains zero rows after deletion we will attempt to lock and truncate the table. In this case it is less expensive as our party merge routine is the only other process that uses this table. If we cannot lock the table then no error is raised.
Party merge rows are inserted into this table rather than ISC_FS_EVENTS. This is done so that we do not artifically raise the high water mark on that table (no truncations are performed on ISC_FS_EVENTS).
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SEND_DATE | DATE | Yes | Send Date (and time) of Event. Informational purposed only. | |
| SOURCE_OBJECT_TYPE_CODE | VARCHAR2 | (60) | Yes | Source Object Type identifier - typically "SR" or "TASK" |
| SOURCE_OBJECT_ID | NUMBER | Yes | Source Object identifier | |
| TASK_ID | NUMBER | Task identifier | ||
| EVENT_NAME | VARCHAR2 | (240) | Event identifier, indicates if Task Creates, Updated or Deleted or Task Assignment Created, Updated or Deleted or Service Request Updated. Informational purposes only | |
| CREATED_BY | NUMBER | Yes | Standard who column | |
| CREATION_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT SEND_DATE
, SOURCE_OBJECT_TYPE_CODE
, SOURCE_OBJECT_ID
, TASK_ID
, EVENT_NAME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM ISC.ISC_FS_PARTY_MERGE_EVENTS;
ISC.ISC_FS_PARTY_MERGE_EVENTS does not reference any database object
ISC.ISC_FS_PARTY_MERGE_EVENTS is referenced by following:
APPS
ISC_FS_PARTY_MERGE_EVENTS
|
|
|
|