How Do I Resolve Add-in Errors?

Validation failures

The add-in provides business user with feedback during data entry. The validation failure messages are usually self-explanatory. The business user simply needs to correct the data to proceed. See Understanding Data Validation in Managing Data Using Oracle Visual Builder Add-in for Excel.

Unable to load and analyze the service metadata

When attempting to create a new catalog or layout using the add-in's designer tools, you may encounter an error like this:

Unable to load and analyze the service metadata from <service URL>. Ensure that the service metadata is a valid OpenAPI document. (VBAFE-01006)

OpenAPI specification version <version no.> is not supported.

To resolve, verify that the initial URL provides service metadata rather than data. For example: /fscmRestApi/resources/11.13.18.05/projects provides project data whereas /fscmRestApi/resources/11.13.18.05/projects/describe provides metadata for the service.

See Create a Table Layout in an Excel Workbook for REST service metadata URL examples.

Invalid Expressions

The add-in includes an expression language. If a configuration property contains an expression that is invalid, you'll see this message:

The operation failed due to a problem evaluating a custom expression. Contact the workbook provider to review the workbook configuration. See Details for more information. (VBAFE-02001)

To resolve, correct the expression and test it thoroughly. See Use Expressions in an Integrated Workbook.

Unexpected Errors

Follow these steps if you encounter a message like this:

An unexpected error has occurred during the current operation. See Details for more information. (VBAFE-02000)

1. Click Copy to Clipboard to copy the full details to the clipboard.
2. File a service request and attach:
   • The error details copied in step 1.
   • The client health check report
   • A Diagnostic log
   • Your Integrated workbook

   See "Data Collection for the Oracle Visual Builder Add-in for Excel" at https://mosemp.us.oracle.com/epmos/faces/DocumentDisplay?id=2954147.1.

Disabled Workbooks

If the add-in has disabled your workbook, review workbook information by selecting Workbook Info from the Advanced menu. See Resolve Workbook Issues.

Create is not enabled for a child layout

The add-in supports dependent layouts for hierarchical business objects. If you can't create a row for a child layout, there are two likely causes:

• The child endpoint does not support create (POST): check the REST API documentation for that endpoint
• The child layout does not include the required fields from the parent layout. Add parent columns as required. See Add Columns from the Parent Layout to Support Row Creation.