Expense Report Import Issue
Requirement from client is to have balancing segment wise document sequence number generation for invoices imported from iexpense[11i) to payables.
Steps folllowed to achieve same -
1.Created sequence per balacing segment
2.Created categories per balacing segment
3. Assigned categories to SOB level
eg. LE1 EXP REP INV to SOB1
LE2 EXP REP INV to SOB1 etc
4.Trigger is written on 'ap_expense_report_headers_all' to update doc_category_code column with balancing segment wise category code.
Issue Faced -
doc_category_code column got updated once ER submitted.
ER got processed and EXPENSE_STATUS_CODE of ER is 'Pending Payables Verification' though it got picked by 'expese report import' program. But invoice not imported and no rejection reson got in exception report in output file. In log file an extra check was there 'Validating Document Category for Sequential Numbering'