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 in 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. image::image151.png[] 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	Error: "You do not have sufficient Oracle privileges to perform this action"	Some Suppliers Integrator users have encountered permission issues despite being assigned the M4A Suppliers Integrator Custom Job Role, as detailed in the Integrator Privileges section of the User Documentation. Please note that the M4A Custom Role for the Suppliers Integrator enables users to create Suppliers with a 'Prospective' Business Relationship. If users are required to create Suppliers with a 'Spend Authorized' Business Relationship, it has been found that users could, in addition to the M4A Custom Role, also be assigned a Supplier management–level Role. If you do decide to assign a Supplier management-level Role to your users, you will need to review the additional functionality this provides and ensure that this complies with your user security processes. The specific privileges required for the Suppliers Integrator are listed in the 'Privileges for Supplier Model' section of the following Oracle Cloud document: https://docs.oracle.com/en/cloud/saas/procurement/25b/fapra/Roles_and_Privileges.html [Oracle Procurement Roles and Privileges] If you are still experiencing issues after reviewing both the More4apps and Oracle documentation, please raise an SR with Oracle Support and ask for their advice.
Asset Mass Additions	Scheduled Processing: The parameter "Book" List of Values (LOV) used during the submission process does not display the specific book you are looking for.	The Book LOV will only display books that you have security access to and that have transactions currently in the Post queue. If there are no transactions ready to post, the LOV will appear empty. If you believe there should be data visible, please try clearing your cache by logging out and then back in again.
Asset Mass Additions	I ran Post Mass Additions but some of my transaction did not get selected?	Possible reasons: 1. If the "Date Placed in Service" is in a future period (relative to the current active period of the ASset Book), the process will ignore it. 2. Merged Records: If the record is part of a "Merge" (where multiple lines become one asset), the process only looks at the Parent record. If you are looking at a child lline that hasn’t been properly linked, it won’t move. 3. Queue must be Post.

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 in 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.

image::image151.png[]

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

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

Some Suppliers Integrator users have encountered permission issues despite being assigned the M4A Suppliers Integrator Custom Job Role, as detailed in the Integrator Privileges section of the User Documentation.

Please note that the M4A Custom Role for the Suppliers Integrator enables users to create Suppliers with a 'Prospective' Business Relationship.

If users are required to create Suppliers with a 'Spend Authorized' Business Relationship, it has been found that users could, in addition to the M4A Custom Role, also be assigned a Supplier management–level Role. If you do decide to assign a Supplier management-level Role to your users, you will need to review the additional functionality this provides and ensure that this complies with your user security processes.

The specific privileges required for the Suppliers Integrator are listed in the 'Privileges for Supplier Model' section of the following Oracle Cloud document:
https://docs.oracle.com/en/cloud/saas/procurement/25b/fapra/Roles_and_Privileges.html [Oracle Procurement Roles and Privileges]

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

Asset Mass Additions

Scheduled Processing: The parameter "Book" List of Values (LOV) used during the submission process does not display the specific book you are looking for.

The Book LOV will only display books that you have security access to and that have transactions currently in the Post queue. If there are no transactions ready to post, the LOV will appear empty.

If you believe there should be data visible, please try clearing your cache by logging out and then back in again.

Asset Mass Additions

I ran Post Mass Additions but some of my transaction did not get selected?

Possible reasons:

1. If the "Date Placed in Service" is in a future period (relative to the current active period of the ASset Book), the process will ignore it.
2. Merged Records: If the record is part of a "Merge" (where multiple lines become one asset), the process only looks at the Parent record. If you are looking at a child lline that hasn’t been properly linked, it won’t move.
3. Queue must be Post.