Expense report in payables

[Liang-Sir]

I can't find the lines in UI after I created an expense report. But it can be got in database, and it can be imported. Why?

[M Morton]

Please explain more about your issue.

[MasterPiece]

If you mean that you cant see exp report details , run below queries on SQL*Plus or toad .

update ap_expense_reports_all
set org_id = null
where report_type = 'Seeded Personal Expense';

update ap_expense_report_params_all
set org_id = null
where expense_report_id in
(select expense_report_id from ap_expense_reports_all
where report_type = 'Seeded Personal Expense');

commit;

Good luck