5/14/2010

問題記錄_AP_錯誤 APP-SQLAP-10000: ORA-01400

Symptoms
--------------------------------------------------------------------
應付模組下,商業發票比對採購單時提示下列錯誤資訊:

APP-SQLAP-10000: ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_LINE_ALL"."AMOUNT") occurred in
Insert_Invoice_Line<-AP_MATCHING_PKG.base_credit_rcv_match<-
APXRMTCH
with parameters (Invoice_ED = 13161, Invoice Line Number =
10, PO Distribution Id = 20399, Project Id = ,Task_Id =,
Expenditure Type = , Expenditure_Organization_id =)
while performing the following operation:
Inserting Item Line Matched to a RCV


Issue
--------------------------------------------------------------------
重啟應用後,有問題的商業發票就可以進行比對了,仍待觀察。