Error Handling and Validation
The Wizard always performs validation to ensure that the data being sent to Oracle is correct. If data is only to be validated without an upload being attempted this can be achieved by selecting ‘Validate only’ as the Validate Option.
If an upload is being attempted the validation will always be done prior to the upload when selecting ‘Validate and Update’ or ‘Validate Concurrent’ as the Validate Option.
There are multiple levels of validation:
· Validate only – All data is validated without performing uploads.
· Validate and Upload - The upload process will first validate the data and then use the APIs to create transactions in Receivables in real-time.
· Validate Concurrent - The upload process will first validate the data and then use the APIs to create transactions in Receivables by submitting a controlling concurrent request.
· Form Validation – Data is validated during field entry and closure of a form.
· API Validation – Any records that fail to create transactions will have API error messages written back to the Wizard.
Note – The API restricts the Header ‘Comments’ field and the Line ‘Description’ field at 240 characters. The Wizard validation respects this and no more than 240 characters can be uploaded to these fields in Oracle via the Wizard.
Refer to section: