MFS MP: Add New Fields In Mobile Field Service Report

(Doc ID 2126990.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Mobile Field Service - Version 12.1.3 and later
Information in this document applies to any platform.


The following fields are needed to be part of SR header section in report.

a)description cs_incident_types_tl
b)external_reference csi_item_instances
c)serial_number csi_item_instances
d)party_name hz_parties can be fetched by joining hz_parties.party_id and hz_party_sites.party_id, (bill to customer) hz_party_sites.party_site_id and cs_incidents_all_b.bill_to_site_id
e)account_number hz_cust_accounts can be fetched by passing cs_incidents_all_b.bill_to_account_id (bill to account number)
f)contract_number||' '|| contract_number_modifier okc_k_headers_b
g)Ship to Customer
h) Ship to Account Number.
i) Engineer/Technician Name in Signature object.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms