Finance Module Troubleshooting

The following issues relate to unexpected results when uploading to Oracle ERP Cloud using the More4apps Integrators:

Integrator(s) Issue Detail

Integrator(s)	Issue	Detail
Payables Invoices	Payables Invoice remains unvalidated in Oracle after submitting Invoice Validation from Integrator.	Oracle has applied a system hold.
Payables Invoices	Applying a new Invoice Group Name to multiple invoices in an upload causes REST web service error - 'A database constraint was violated while storing the changes in the database'.	The error only occurs if the Group Name is a new unique Group Name, and an upload is attempted with multiple invoices with that identical Group Name. Once the Group Name exists inh the database table it can then be used as a reference for the invoices. You won’t encounter this error when uploading multiple headers with the same Group Name or a Group Name that has already been used. Workaround Steps: 1. If using a new Group Name, create one invoice with the new Group Name and only upload this one Invoice by selecting the header row and using the Upload Selected option from the ribbon. 2. Once the invoice is successfully uploaded, the Group Name (as per step 1) will exist in the database and multiple invoices can be uploaded in one payload with the same Group Name.
All	On download you encounter the following exception: `Flurl.Http.FlurlParsingException: Response could not be deserialized to JSON`	Please remove any Oracle keywords from your download criteria(s) and reattempt the download. Alternatively, alter your criteria to use a wildcard (%) to ensure the entire keyword is not used. Oracle Keywords include but are not limited to, 'table', 'style' and 'div' Oracle has confirmed a JDeveloper framework bug (33683557) where any download web service that includes Oracle keywords in its criteria will fail and not return data. If the problem persists after carrying out the suggested steps, please contact More4apps Support.
Customers Asset Additions	The download process in these Integrators uses a BI Report: this process must be enabled by the setting of a specific Profile Option.	To ensure only authorized users can access information, administrators manage download access through a profile option. Failure to correctly set this profile option will result in no records being able to be downloaded. Please see the following section for details: Enabling BI Report Downloads
Asset Adjustments	CLEAR functionality on Asset Key	If you attempt to clear the asset key you will get an error like `More4apps Common Exceptions InvalidException: Upload Unhandled Exception→ System.InvalidOperationException: Sequence contains no elements` This is an Oracle issue which is with them to fix.
Suppliers Integrator	Error: "You do not have sufficient Oracle privileges to perform this action"	Some Suppliers Integrator users have experienced permission issues even after granting the privileges specified by More4apps. Please review the specific privileges listed in the 'Privileges for Supplier Model' section of the following Oracle Cloud document as assigning these may resolve your issue: https://docs.oracle.com/en/cloud/saas/procurement/25b/fapra/Roles_and_Privileges.html [Oracle Procurement Roles and Privileges,window=_blank] If you are still stuck after reviewing both More4apps and Oracle documentation, please raise an SR with Oracle Support and ask for their advice.

Payables Invoices

Payables Invoice remains unvalidated in Oracle after submitting Invoice Validation from Integrator.

Oracle has applied a system hold.

Payables Invoices

Applying a new Invoice Group Name to multiple invoices in an upload causes REST web service error - 'A database constraint was violated while storing the changes in the database'.

The error only occurs if the Group Name is a new unique Group Name, and an upload is attempted with multiple invoices with that identical Group Name.

Once the Group Name exists inh the database table it can then be used as a reference for the invoices. You won’t encounter this error when uploading multiple headers with the same Group Name or a Group Name that has already been used.

Workaround Steps:
1. If using a new Group Name, create one invoice with the new Group Name and only upload this one Invoice by selecting the header row and using the Upload Selected option from the ribbon.
2. Once the invoice is successfully uploaded, the Group Name (as per step 1) will exist in the database and multiple invoices can be uploaded in one payload with the same Group Name.

All

On download you encounter the following exception:

Flurl.Http.FlurlParsingException: Response could not be deserialized to JSON

Please remove any Oracle keywords from your download criteria(s) and reattempt the download. Alternatively, alter your criteria to use a wildcard (%) to ensure the entire keyword is not used.

Oracle Keywords include but are not limited to, 'table', 'style' and 'div'

Oracle has confirmed a JDeveloper framework bug (33683557) where any download web service that includes Oracle keywords in its criteria will fail and not return data.

If the problem persists after carrying out the suggested steps, please contact More4apps Support.

Customers
Asset Additions

The download process in these Integrators uses a BI Report: this process must be enabled by the setting of a specific Profile Option.

To ensure only authorized users can access information, administrators manage download access through a profile option.

Failure to correctly set this profile option will result in no records being able to be downloaded.

Please see the following section for details: Enabling BI Report Downloads

Asset Adjustments

CLEAR functionality on Asset Key

If you attempt to clear the asset key you will get an error like More4apps Common Exceptions InvalidException: Upload Unhandled Exception→ System.InvalidOperationException: Sequence contains no elements

This is an Oracle issue which is with them to fix.

Suppliers Integrator

Error: "You do not have sufficient Oracle privileges to perform this action"

Some Suppliers Integrator users have experienced permission issues even after granting the privileges specified by More4apps.

Please review the specific privileges listed in the 'Privileges for Supplier Model' section of the following Oracle Cloud document as assigning these may resolve your issue: https://docs.oracle.com/en/cloud/saas/procurement/25b/fapra/Roles_and_Privileges.html [Oracle Procurement Roles and Privileges,window=_blank]

If you are still stuck after reviewing both More4apps and Oracle documentation, please raise an SR with Oracle Support and ask for their advice.