iExpense Report struck in Interface table with REJECTION CODE : LINE AMOUNT IS NULL

Follow the below Steps to fix the Expense Interface struck:

Step 1: Identify the Null Amount column by using the below query for the reported Expense,

SELECT report_header_id  

  FROM AP_EXPENSE_REPORT_HEADERS_ALL 

WHERE invoice_num  = <Expense Number>;

SELECT report_line_id 

   FROM AP_EXPENSE_REPORT_LINES_ALL 

WHERE report_header_id = <report_header_id from query 1>

   AND amount IS NULL;

Step 2: Delete the Junk entry from Expense Line and Distribution after taking the backup.

CREATE TABLE AERLA_20190715_BKP AS  SELECT * FROM AP_EXPENSE_REPORT_LINES_ALL WHERE REPORT_LINE_ID = report_line_id ;

DELETE AP_EXPENSE_REPORT_LINES_ALL WHERE REPORT_LINE_ID = report_line_id ;

CREATE TABLE AERDA_20190715_BKP AS SELECT * FROM AP_EXP_REPORT_DISTS_ALL WHERE REPORT_LINE_ID = report_line_id ;

DELETE AP_EXP_REPORT_DISTS_ALL WHERE REPORT_LINE_ID = report_line_id ;

COMMIT;

Step 3: Run the “Expense Report Export” Program from AP Manager Responsibility

After the program completion check the output of the picked expense, it will be in PAID status rather than "Invoice Amount is Null"

Then it will move the Expense report to Payable section by keeping Expense Number reference as Invoice Number.