My Oracle Support Banner

MFS: Task Address Change Due To Party Merge Not Sent To Mfs - Causing Task To Get Lost (Doc ID 1450854.1)

Last updated on FEBRUARY 06, 2022

Applies to:

Oracle Mobile Field Service - Version to [Release 11.5]
Information in this document applies to any platform.



On :


Find tasks to be 'missing' from the Calendar page on MFS laptop. When using advance search by task number, the task shows up, but the address is empty. This seems to be happening specifically when there is a party (site) merge after the task is assigned and sent to the ACC tables that hold the data that would download to the mobile client.

Steps to Reproduce

This seems to be happening when there is a party (site) merge, happening  after the task is assigned and inserted into the ACC tables.

NOTE: In the example below and/or the attached document, user details / company name / IDs represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


  1. Trough Contact Center, create a new customer
  2. Add 2 (identical) addresses for this customer, which create party site ids 333333 and 444444 (in hz_party_sites)
  3. Create an SR for this customer and address linked to party_site_id 333333 - as that is defaulted and the 'identifying address'
  4. Create a task -> checked that the jtf_tasks_b.address_id is also set to 333333
  5. In Receivables / Customers / Party Merge, create a new batch for this customer.
       Checked the 'site merge' so that we stay within the same party
       enter the address with id 333333 as 'From' site and 444444 as 'To' site.
       When saving, it asks for confirmation as we are merging the identifying address and if the To address should become the identifying address
       --> say yes and run the batch
  6. after the batch job is finished, run this query:
  7. that shows both the SR and the task are now pointing to the address with id 444444 (updated during batch job) - this address is in 'A' (active

    So the party merge automatically updates the address on both the SR and the Task
  8. however, when looking in CSL_HZ_PARTY_SITES_acc (which has the data that should go to the MFS user), only see a record for party_site_id 333333.
  9. Synch the MFS laptop and do not see the task on the scheduled date in the dashboard
  10. use advanced search to search and find the task, Then the task is found, but with empty Location address.





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.