APP-SQLAP-10637: The system cannot create this payment
来源:互联网 发布:基于标签的分析算法 编辑:程序博客网 时间:2024/06/05 03:40
Scenario:
- Due to typo error made last April 3, 2009, instead of paying 876.48, we paid only 376.48 in actual to tally payment in bank recon.
We did partial payment in oracle and it was successfully validated. See attached file for invoice #2811347 with the difference of 500.00
- In order to close invoice#2811347, we need to pay this in next payment batch and problem occurred while we do payment validation.
Please see attach file for the error encountered. This is not the first time we did partial payment and we successfully closed in next payment except this one.
APP-SQLAP-10637: The system cannot create this payment because one or more invoices selected for this payment have also been selected in a payment batch.Reselect the invoices for this payment before continuing
Solution:
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存在那个异常记录,做删除测试
create table ap_selected_invoices_all_bak as select * from ap_selected_invoices_all
create table ap_selected_invoice_checks_bak as select * from ap_selected_invoice_checks_all
select * from ap_selected_invoices_all
where set_of_books_id=1003
and checkrun_name='Quick Payment: ID=82696'
and invoice_id=178023
delete from ap_selected_invoices_all
where set_of_books_id=1003
and checkrun_name='Quick Payment: ID=82696'
and invoice_id=178023
select * from ap_selected_invoice_checks_all
where checkrun_name='Quick Payment: ID=82696'
delete from ap_selected_invoice_checks_all
where checkrun_name='Quick Payment: ID=82696'
此时,在系统中可以做payment动作了,测试成功
- APP-SQLAP-10637: The system cannot create this payment
- APP-SQLAP-10380: You cannot select this payment document
- APP-SQLAP-10380:You cannot select this payment document because it is in use by another payment batch
- APP-SQLAP-10380: You cannot select this payment document because it is in use by another payment
- APP-SQLAP-10006
- Visual studio cannot create or open the application because the Web server on this computer is...
- The battery cannot be identified the system will be unable to charge this battery
- Cannot create iterator for this collection 问题解决
- Cannot create iterator for this collection
- Invoice Batches打不开,APP-SQLAP-10199解决
- File xxx.ps1 cannot be loaded because the execution of scripts is disabled on this system
- 20110323_BMXAA7901E - You cannot log in at this time. Contact the system administrator
- POJ 3064 Payment System 笔记
- The system cannot execute the specified program.
- File C:\Temp\Test.ps1 cannot be loaded because the execution of scripts is disabledon this system.
- cp: cannot create symbolic link `/mnt/hgfs/SharedData/*/system.dat
- mkdir: cannot create directory `104nfstest': Read-only file system
- OutOfMemoryError: Cannot create GC thread. Out of system resources
- vs数据控件中时间显示问题
- 滚动字幕标签的用途
- jewelry Business Card Holder KH06
- 不同浏览器下图片滚动效果的js
- 联想(Lenovo) IdeaPad Y550A-TSI 15.6英寸笔记本电脑
- APP-SQLAP-10637: The system cannot create this payment
- S60用户界面控件设计(一)
- Cacti中文版:安装及汉化说明(内含cacti中文版软件包)
- commons-BeanUtils简介
- 数据库实验
- javascript动态创建Option选项
- 诺基亚(NOKIA)5800XpressMusic 黑色( 普通版)非移
- MyEclipse与tomcat 6.x 的集成
- 编写一个ASP类的方法