Customers Integrator Limitations
Download uses a BI Report
In the absence of a suitable Oracle web service, we've implemented a download solution using a BI Report.
The data downloaded through the BI Report leverages some, but not all, of the access controls used in the Oracle Fusion ERP UI. To ensure only authorized users can access information, administrators manage download access through a profile option.
The download is intended for the following types of users: Users that are restricted by Business Units or Users with Implementer roles.
This download is not designed for users with data access restricted by the "VIEW" access function security.
DFFs not supported in Parties section
The REST web service does not support DFFs at Party level.
DFFs are not implemented for Account or Site Profiles sections
DFFs at Account and Site Profiles levels are currently not implemented due to web service issues. More4apps has raised a Service Request (SR) with Oracle Support requesting these shortfalls be addressed. We will monitor the progress of the SR and consider future enhancements in this area should the functionality become available.
DFFs - Searchable LOVs
Due to the inability to run SQL queries dynamically in the Integrator, we are not able to provide searchable LOVs.
The Integrator’s DFF forms support LOVs for both dependent and independent DFF segments. However, table-based LOVs are currently not supported.
DFFs - Downloads are not implemented
Downloading of values entered against DFFs and Global DFFs is not currently supported, as at Oracle release 24A, due to the relevant Oracle Package failing to retrieve the DFF data.
More4apps will monitor this situation in anticipation of a future fix from Oracle.
Account and Site Profile Global DFFs
While Global DFFs at Account and Site Profile levels appear to be available in the web service, there are limitations in the support of this functionality. Oracle has indicated that a bug number (Bug 35036501) has been raised regarding this functionality. However, a fix is not currently planned.
Details of the bug number are available from the link below:
Download of Original Systems and Original System References is not supported.
Update of Site Purpose Reference Accounts is not supported
The Integrator has only the Create function available in this section. There is no web service enabled for Updates.
Attachments
Processing of Attachments is not supported in the Customers Integrator.
Addresses
Since the Oracle web services do not support geographical address validation, creating/updating addresses using the Customers Integrator will not validate address information against the master geography data.
The ESS Job ‘Validate Geographies of Addresses Against Master Geographies’ can be submitted in Oracle Fusion to validate the geography elements, e.g. state, city, postal code are valid against the master geography data. This process also stores the Geography Name Referencing information for the address.
Sections:
