PP-SQLAP-10916

纵横四海

在AP中运行导入费用报销的发票报错，
PP-SQLAP-10916: apidbl/3yy:ORA-01847: day of month must be between 1 and last day of month

这是log的关键部分截图

BEGIN AP_WEB_DB_EXPLINE_PKG.GetCCPrepaidAdjustedInvAmt(:l_report_header_id,:l_invoice_total) ; END ;
Prepare the cursor
BEGIN AP_WEB_DB_EXPLINE_PKG.GetCCPrepaidAdjustedInvAmt(:l_report_header_id,:l_invoice_total) ; END ;
Prepare the cursor
BEGIN AP_WEB_DB_EXPLINE_PKG.GetCCPrepaidAdjustedInvAmt(:l_report_header_id,:l_invoice_total) ; END ;
Prepare the cursor
BEGIN AP_WEB_DB_EXPLINE_PKG.GetCCPrepaidAdjustedInvAmt(:l_report_header_id,:l_invoice_total) ; END ;
Updating reject codes
Inserting distribution records
Getting Create Lines Error...
BEGIN AP_UTILITIES_PKG.AP_Get_Message(:msgbuf_err); END;

APP-SQLAP-10916: apidbl/3yy:ORA-01847: day of month must be between 1 and last day of month
ORA-06
Cleaning allocated memory

纵横四海

回复：
这是oracle的一个bug导致的。

出错的字段是：ap_expense_report_lines_all的START_EXPENSE_DATE

运行如下代码，你可以发现有一些纪录是的值为：0000-0-0，然后联合查询ap_expense_report_headers_all表，即可找到相关的费用报表编号。在前台修改掉发票行的“收据日期”即可。

1. select distinct t.START_EXPENSE_DATE
   
2. from ap_expense_report_lines_all t
   
3. order by t.start_expense_date

复制代码

sunweijie22

收藏了,谢谢