Page 1 of 1
Expense report in payables
Posted: Thu Oct 18, 2007 12:06 am
by 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?
Posted: Thu Oct 18, 2007 12:23 pm
by M Morton
Please explain more about your issue.
Posted: Fri Oct 19, 2007 8:51 pm
by 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