Last updated on MARCH 31, 2017
Applies to:Oracle Fusion Receivables Cloud Service - Version 220.127.116.11.0 and later
Oracle Fusion Receivables - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
On : 22.214.171.124.0 version, Billing - Auto Invoice
AR AutoInvoice Interface Correction Spreadsheet Server Error - ADFDI-05577: Failed to retrieve table row data from the server. The remote server returned an error: (504) Gateway Timeout.
The above error is thrown when there are too many records with errors in the Autoinvoice Interface tables
A solution should exist to clear the data when there are too many erroneous transactions in interface tables.
Actual Result: when there are too many erroneous transactions in interface tables not even using the Manage AutoInvoice Errors users cannot delete them as spreadsheet is throwing ADFDI-05577: Failed to retrieve table row data from server. or Error message on spreadsheet: Action Failed (when Spreadsheet loads, when clicking 'Search' or 'Save')
ADFDI-05577: Failed to retrieve table row data from the server. The remote server returned an error: (504) Gateway Timeout.
The issue can be reproduced at will with the following steps:
1. Log in: https://ebwt-dev2.fs.ap1.oraclecloud.com/homePage/faces/AtkHomePageWelcome
2. Navigator > Billing, Go to Manage AutoInvoice Errors > Click Hyperlink 11,763 for FXL_AUD_BU > Spreadsheet Opens -> Login > Download rows 11,763 > Select rows for deletion (double click row D, autofill for all rows) > Save
3. Navigator > Monitor Scheduled Processes > Run Purge AutoInvoice Data > select FXL_AUD_BU > Submit
4. Navigator > Billing > Manage AutoInvoice Errors should show 0 for FXL_AUD_BU
The issue has the following business impact:
Due to this issue, users cannot update or delete erroneous transactions in interface tables.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms