Oracle EBS: 無法收貨, 出現Error APP-PO-14142

狀況: 收貨時出現error :

  APP-PO-14142: rcv_receipts_th.insert_transaction-001:
  ORA-0000: normal, successful completion
  Cause: A SQL error has occured in rcv_receipts_th.insert_transaction.


原因: uncompiled libraries / forms 造成, 包括:

  Libraries :
    RCVRCERH.pld
    RCVRCERL.pld
    RCVCOTRX.pld

  Forms:
    RCVRCERC.fmb
    RCVCOFND.fmb


解決方式: recompile有問題的libraries / forms


Ref:
R12 Cannot Enter Any Receipt APP-PO-14142 rcv_receipts_th.insert_transaction-001: ORA-0000: (Doc ID 945443.1)


附註: 有看到另一可能原因是客製程式造成
Unable to Create Receipt APP-PO-14142: rcv_receipts_th.insert_header-000: ORA-0000 RCVRCERC (Doc ID 1072428.1)