Get Exception Details for a File

You can use this GET REST operation to get details of the exceptions and the recommended actions for an Accounting Hub Transaction File that was uploaded.

Example URL

Here's an example of the resource URL to display data from Invoice Holds REST API:

GET

/api/erp/integrations/resources/v1/{locale}/files/{id}/transactionExceptions

cURL Command

curl --location 'https://servername.fa.us2.oraclecloud.com/api/erp/integrations/resources/v1/en-us/files/451471670902558720/transactionExceptions?flowName=fah-import' \
--header 'Authorization: Bearer <Bearer Token>

Example Response

Here's an example of the response body in JSON format:

{   
 
"fileId": "286264167286738944",    
"flowName": "fah-import",   
"stageName": "Transaction",   
"exceptions": [       
{           
"exceptionType": "Error",           
"count": 2,           
"exceptionDescription": "Required columns such as event type, ledger, or transaction date, are not provided in the header file.",           
"recommendedActions": [               
"Assign a valid value to the required column for the transaction"           
]       
 
},       
 
{           
 
"exceptionType": "Error",           
"count": 4,           
"exceptionDescription": "There are duplicate line numbers for a transaction.",           
"recommendedActions": [               
"Modify line number",               
"Delete the duplicate transaction line",                
"Modify transaction number"           
]       
 
},       
 
{           
"exceptionType": "Error",           
"count": 1,           
"exceptionDescription": "Transaction does\"nt have any line, and it is\"nt a reversal.",           
"recommendedActions": [               
"Add one or more line records for the transaction",                
"Modify transaction reversal mark for the transaction"            
 
]       
 
},       
 
{           
"exceptionType": "Error",           
"count": 1,           
"exceptionDescription": "Line number is not provided in the line file.",           
"recommendedActions": [               
"Assign a unique line number to each line for a transaction"           
]       
}   
]
}
}
}