[急!]做付款时出现APP-SQLAP-10637错误提示!--已解决!

richardliu1123

只有付款批才会用到 AP_SELECTED_INVOICES_ALL/ AP_SELECTED_INVOICE_CHECKS

---------------------------------------------------------------------------
AP_SELECTED_INVOICES_ALL is a temporary table that stores
information about invoices selected for payment in a
payment batch. Your Oracle Payables application
inserts into this table after you initiate a payment batch.
There will be one row for each invoice that Payables selects for
payment in the current payment batch. When you build payments
in a payment batch, your Oracle Payables
application uses information in this table to create
rows in AP_SELECTED_INVOICE_CHECKS.
Information from this table appears in the Modify
Payment Batch window.

建议对这两个表做个备份,然后删除掉,再试试看/

feixiang007

原帖由 richardliu1123 于 2009-7-17 15:27 发表
只有付款批才会用到 AP_SELECTED_INVOICES_ALL/ AP_SELECTED_INVOICE_CHECKS

---------------------------------------------------------------------------
AP_SELECTED_INVOICES_ALL is a temporary table that stores
information about invoices selected for payment in a
payment batch. Your Oracle Payables application
inserts into this table after you initiate a payment batch.
There will be one row for each invoice that Payables selects for
payment in the current payment batch. When you build payments
in a payment batch, your Oracle Payables
application uses information in this table to create
rows in AP_SELECTED_INVOICE_CHECKS.
Information from this table appears in the Modify
Payment Batch window.

建议对这两个表做个备份,然后删除掉,再试试看/

AP_SELECTED_INVOICE_CHECKS_ALL is a temporary table that
stores payment information during a payment batch. Your Oracle
Payables application inserts into this table when you build payments in
a payment batch. There will be one row for each payment issued during
the current payment batch. When you confirm a payment batch, your
Oracle Payables application inserts these payments into
AP_CHECKS_ALL and creates a payment file.
Within a payment batch, SELECTED_CHECK_ID in this table joins with
PRINT_SELECTED_CHECK_ID and PAY_SELECTED_CHECK_ID in
AP_SELECTED_INVOICES to associate a selected invoice with its
payment.

刚刚查看到AP_SELECTED_INVOICES_ALL和AP_SELECTED_INVOICE_CHECKS_ALL确实有我的那个异常记录,我删除试试看

feixiang007

经richardliu1123老兄指点,这个问题可以解决了,谢谢各位的回复,特别鸣谢richardliu1123老兄,呵呵

richardliu1123

总算松一口气啦,呵呵

feixiang007

原帖由 richardliu1123 于 2009-7-17 16:33 发表
总算松一口气啦,呵呵

是啊,呵呵

想飛的魚

能不能说说问题是什么？如何解决的？想学习一下。谢谢！！

ora2008

原帖由 richardliu1123 于 2009-7-17 12:03 发表
select ai.invoice_id,ai.invoice_amount,ai.amount_paid,ai.payment_status_flag,
       aps.payment_status_flag,aps.payment_status_flag,aps.amount_remaining
from ap.ap_invoices_all ai,
     ap.ap_payment_schedules_all aps
where ai.invoice_id=aps.invoice_id
  and ai.invoice_id=&invoice_id     

把结果传上来

呵呵，我也遇到了

ora2008

原帖由 richardliu1123 于 2009-7-17 15:27 发表
只有付款批才会用到 AP_SELECTED_INVOICES_ALL/ AP_SELECTED_INVOICE_CHECKS

---------------------------------------------------------------------------
AP_SELECTED_INVOICES_ALL is a temporary table that stores
information about invoices selected for payment in a
payment batch. Your Oracle Payables application
inserts into this table after you initiate a payment batch.
There will be one row for each invoice that Payables selects for
payment in the current payment batch. When you build payments
in a payment batch, your Oracle Payables
application uses information in this table to create
rows in AP_SELECTED_INVOICE_CHECKS.
Information from this table appears in the Modify
Payment Batch window.

建议对这两个表做个备份,然后删除掉,再试试看/

我这边，是AP_SELECTED_INVOICE_CHECKS空．
但AP_SELECTED_INVOICES_ALL有一条记录．

ora2008

richardliu1123 大师在吗？
我的这个问题不适用啊

feixiang007

原帖由 ora2008 于 2009-9-1 16:34 发表
richardliu1123 大师在吗？
我的这个问题不适用啊

删除掉试试看呢，保险起见，先在测试系统中做吧，呵呵