Format Payment Instructions with Text Output' Ended with Error

Format Payment Instructions with Text Output' Ended with Error [ID 847147.1]
		修改时间 23-JUN-2009     类型 PROBLEM     状态 MODERATED

In this Document
  
  
  

Ended with the following Error

INFO: oracle.adf.share.config.ADFConfigFactory No META-INF/adf-config.xml found
Format output not exist. Saving it.
Saved attachment doc id: 24113
Exit: iby.scheduler.FDExtractAndFormatting.saveFormatOutput()
Exit: iby.scheduler.FDExtractAndFormatting.doExtractAndFormat()
Instruction status was CREATED and the transmission configuration is not avaible. So setting result status to FORMATTED_ELECTRONIC
Enter: iby.scheduler.FDExtractAndFormatting.postResults()
Executing BEGIN IBY_FD_POST_PICP_PROGS_PVT.post_results(:1, :2, :3, :4); END;
Successfully executed PL/SQL.
oracle.apps.iby.exception.PSException: An error has occured while updating instruction and payment statuses and marking them as complete.
at oracle.apps.iby.scheduler.FDExtractAndFormatting.postResults(FDExtractAndFormatting.java:507)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(FDExtractAndFormatting.java:311)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runProgram(FDExtractAndFormatting.java:146)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

An error has occured while updating instruction and payment statuses and marking them as complete.
An error occurred. Roll back any changes.
Done roll back changes.
Request completed in error.

Changes

Patches Applied 8328642 and 8277703

Profile Option

Sequential Numbering = Partial or Always

Cause

Whilst processing the format, the procedure assign_sequences ( apcnfrmb.pls ) calls the CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat ( cebavalb.pls )

The Parameters are PAYMENT_DOCUMENT_ID, PAYMENT_METHOD_CODE and BANK_ACCT_USE_ID

In Release 12, and later, Payment Documents, such as those configured in Cash Management - Bank Accounts - Manage Payment Documents are NEVER used for Electronic Processed Payments.

The first place the
CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat
will look for a Document Category when sequential numbering is used is the Payment Document. If there is no document then it will check against the Payment Method and the Bank Account. The error message appears when a Document Category cannot be found in any of the three places mentioned.

In the case of Electronic Payments

CE_PAYMENT_DOCUMENTS.payment_document_id is NULL

The procedure get_pay_doc_cat will then run the following

select count(*) into p_ap_doc_cat_count 
from ce_ap_pm_doc_categories 
where BANK_ACCT_USE_ID =  
and PAYMENT_METHOD_CODE = ; 

If this returns 0 the next sql statement is

select nvl(PAYMENT_DOC_CATEGORY, '-1') 
into P_PAYMENT_DOC_CATEGORY_CODE 
from ce_bank_acct_uses_all 
where BANK_ACCT_USE_ID = P_BANK_ACCT_USE_ID; 

This returns -1 if the bank_acct_use_id  payment_doc_category is null.

Solution

Add a Payment Document Category to the Bank Account
or
Add a Payment Document Category to the Bank Account for a Specific Payment Method.

Responsibility Cash Management

Navigate
Bank Account Create or Update

Account Access - Organization Access - Account Access Options
'Payables Options',
Find
Payment Document Category

OR

Payment Document Categories by Payment Method
expand/show the 'Payment Document Categories by Payment Method' section.
Under this section, you can 'Add A Row' to add the Payment Doc Category or update any existing ones

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/86584/viewspace-683311/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/86584/viewspace-683311/