加密相数据导入(APP: 错误：已存在此客户和金额的收款编号)

纵横四海

TAR Number 4417705.995  Open Date01-MAY-05 09:09:22
Support Identifier 14036519  NameHu Wanjun
Severity 2  Last Update17-MAY-05 00:26:56
ProductOracle Receivables  Product Version  11.5.9
PlatformLinux x86  Detailed StatusHard Close
TAR Reference  15291764.6  BUG Referencen/a

Abstract

CANNOT IMPORT LOCKBOX DATA (AR)

ACTION PLAN
============
1)
I see that the 11 receipts shown (RECEIPT_NUMBER FS0504300001 to FS0504300010) all got impor
ted today.
Could you confirm this?

2) This means, the lockbox import in general is possible but it fails for the 15 receipts mentioned only. Is that correct?


3)
I'm a bit confused about AR_PAYMENTS_INTERFACE_ALL.
I would expect to see records with error code AR_PLB_DUP_PMT (Receipt number already exists for this
customer and amount) in there, but there are none.

Could you please re-check? Was your previous select statement run from the correct instance?

4)
What version of file arlvdp.lpc are you on?

5)
Please go to AR > Receipts > Batches > View > Find
> Enter Batch Type: "Manual Quick"
> Enter GL dates: 30-APR-05
> click: Find Button

Do you see the batch with the 15 receipts?

If s

6)
Please click "ost Quick Cash" button

7) Please upload me out-file and log-file of this request (ARCAPB)

[此贴子已经被作者于2005-5-26 12:09:08编辑过]

纵横四海

如果没有“开速过帐实现”（Post Quick Cash）请参考如下文档
Doc ID: Note:1041058.6
Subject: UNPOSTED ITEMS REPORT SHOWS UNPOSTED QUICK CASH
Type: PROBLEM
Status: PUBLISHED
Content Type: TEXT/X-HTML
Creation Date: 13-JAN-1998
Last Revision Date: 06-JUN-2002



Problem Description:
===================
You have rows on the 'Unposted Items Report.'   The legend says that 'This
receipt is part of an unposted quick cash batch.' There are no quickcash
batches that show ready to import.

Problem Explanation:
===================
Receipts are showing on the 'Unposted Items Report'.
Message 'This receipt is part of an unposted quick cash batch'
is on the bottom of the page.  The credit column is blank.

There are no quick cash batches showing on the form, which is used to post
quick cash batches.

These records exist on the ar_interim_cash_receipts table.  There are no rows
on ar_cash_receipts for the same cash_receipt_id.  The batch_id of the receipts
is obtainable from ar_interim_cash_receipts.  The batch may have a
batch_applied_status of 'POST BATCH WAITING' and a status of 'OP', but not
always.

Use these scripts to look at the data:

Select cash_receipt_id,batch_id
From ar_interim_cash_receipts_all
Where receipt_number = &receiptnumber;

See if the cash_receipt_id exists on ar_cash_receipts;

Select cash_receipt_id
From ar_cash_receipts_all
Where cash_receipt_id = &cashrecid;

If it dosen't exist, then what probably happened is that the post quick cash
batch process abended.  See solution.

Solution Description:
====================
If the cash_receipt_id does not exist on AR_CASH_RECEIPTS_ALL, then the post
quick cash process probably abended.   You need to reset the request_id and the
operation_request_id to null for that batch_id;

Solution Explanation:
====================

Step 1.
-------

Obtain the batch_id from ar_interim_cash_receipts_all for this receipt_number.

Select batch_id,cash_receipt_id,receipt_number
From ar_interim_cash_receipts_all
Where gl_date between '01-MAR-98' and '31-MAR-98';

(use the date range for your GL period)

Select batch_id,batch_applied_status,status,operation_request_id
From ar_batches
Where batch_id =&batchid;

Step 2.
-------

If the batch_applied_status is not = 'POSTBATCH_WAITING'  
and the cash_receipt_id does not exist on ar_cash_receipts_all, then:  

Update ar_batches
Set request_id = null,
    batch_applied_status = 'POSTBATCH_WAITING',
    status = 'OP',
    operation_request_id = null
Where batch_id = &batch_id;
commit;

Step 3.
-------
Select your batch for Quick Cash Posting.

Step 4.
-------
Run your General Ledger Posting.




Search Words:
============
Post Quick Cash Unposted ARGLTP Unposted Receipt Receipts
failed terminated abended killed stopped postbatch post
batch interim lockbox

[此贴子已经被作者于2005-5-26 12:05:55编辑过]

纵横四海

里面的Update SQL的AR_BATCHS为AR_BATCHS_ALL

[此贴子已经被作者于2005-5-26 13:42:59编辑过]