R12: Problem with Expense Report Export Program

Our A/P group reported an issue when a line on the Expense Report Export Program showed up indicating "Expense Report Line and Distribution Totals do not match" while the table AP_EXPENSE_REPORT_HEADERS_ALL showed "EXPENSE LINE DIST MISMATCH" for the REJECT_CODE.  This was news to me as I had not seen it in R11 nor the past three months we had been running on R12 so off to My Oracle Support I went, and I found document 1582981.1 entitled "Expense Report Export Rejection: Expense Report Line and Distribution Totals do not match".  This has the patch or patches which may have caused this, one of which WAS in our system, matches our exact error messages/text, and has additional SQL statements which allow you to verify if this note applies to the data in your tables.

You have two options to fix this, as you do with most issues found in MOS: patch or get a datafix.  Luckily after submitting the information requested in this note via the SR process, the Oracle analyst indicated it was a rather simple datafix and after applied it DID resolve the issue at hand.  I wanted to highlight this problem because the cause of it as detailed in the MOS note needs to be in your testing suite if you're on or thinking of going to R12 since it could be more frequent for your shop or happen a lot sooner after implementation.

Supplier issue in Expense Report Import

This post will run closer to the type of things I deal with daily, and hopefully will be helpful to everybody out there that runs into the same type of problem!  Our business ran the Expense Report Import, just like they usually do every day, but encountered the following error message on this run:

Next import invoice: 6196224
Getting work location address
Validating vendor
Getting Create Sites Error...
BEGIN  AP_UTILITIES_PKG.AP_Get_Message(:msgbuf_err); END;
This Site name already exists for this supplier.  
Re-enter.
APP-SQLAP-10916: apiivs/3:ORA-20001: APP-SQLAP-10357: This Site name already exists for this supplier
Cleaning allocated memory

In my research on My Oracle Support I found and used the following Oracle notes:

Expense Report Import Errors With APP-SQLAP-10916: apiivs/3:ORA-20001: APP-SQLAP-10357 [ID 1228868.1] - this was more on point and useful
"Expense Report Import" Is Finishing In Error When No Purchasing Sites Available For Supplier [ID 1351417.1]

Which helped me understand that I had to run this script to find the expense information in question:

select * from ap_expense_report_headers_all
where report_header_id = 6196224

That lead me to the supplier information from the expense report:

select a.* from po_vendors a, ap_expense_report_headers_all b
where a.vendor_id = b.vendor_id
and b.report_header_id = 6196224

Then I was able to use this script to find the supplier site information:

select a.* from po_vendor_sites_all a, ap_expense_report_headers_all b
where a.vendor_id = b.vendor_id
and a.vendor_site_id = b.vendor_site_id
and b.report_header_id = 6196224

With the information we've gathered at this point, we know that the supplier site has been end dated for the OFFICE site that the Expense Report Import expects to be open when it runs.  Having the business remove the end date via the application allowed them to re-run the Expense Report Import without any further issues!