Manual Order Numbering
While the Oracle web service supports manual order numbering, More4apps has encountered Oracle sequencing issues that are not handled adequately and therefore we do not allow manual numbering at this point in time. If a manual number is greater than the last used automatic number, the sequence will not be able to progress beyond the manual number without database manipulation. For this reason, the integrator does not support manual numbering.
The Existing Order Number column is provided for update purposes and must be left blank when creating a new purchase order. The Integrator will reject any create purchase order uploads where a value exists in this field.
Performance
Due to performance implications of Oracle’s Web Service, More4apps recommends uploading no more than 500 lines per purchase order.
The Web Service also has a limitation for downloading records. More4apps recommends only downloading records with 1000 lines or less.
These limits may improve over time as Oracle enhances these gateways.
Descriptive Flexfields (Fixed in release 13.4.9.0)
Descriptive flexfields can be uploaded in the Integrator with the following limitations:
● The Supported Oracle ERP Cloud web service does not detect required list of values. If a DFF segment is mandatory the web service still allows a null value. We are currently working on resolving this, and present the following workaround:
○ Enter an invalid value, such as ‘XXXX’, into the Default Row (Row 10) attribute field. The web service will error as expected which will signify to the user that the attribute is a required field:
This will only work for lists of values in DFFs that are required. For text fields we suggest entering notes on rows 7 or above in the sheet:
Descriptive Flexfields List of Values
Descriptive flex fields can be uploaded in the Modules, supporting both dependent and independent lists of values. Table based lists of values are not supported (validation still is supported)
The list of values is limited to the first 500 values to ensure the integrator does not freeze or time out on large data sets. This does not affect validation. If the value is in the list below 500 it is still a valid value.
Attachments
It is only possible to create or attach documents to purchase orders that have the status of INCOMPLETE. To accomplish this, you will need to specify "Do not Approve" as the "Approval Action" when generating a purchase order.
Unfortunately, at present, we are unable to facilitate the downloading or updating of attachments.
For additional information regarding these restrictions, please consult the Attachment documentation.
