EAR9.1+: AR Update Fails For Payment At Step AR_PGG_SERV.CCOFFST2.CCOFFDR When Cash Clearing and Cash AR Inheritance is On for External Bank Account. (Doc ID 1677342.1)

Last updated on DECEMBER 01, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.1 version, AR Update - Posting

When attempting to run ARUPDATE process for a payment the process is failing at Step AR_PGG_SERV.CCOFFST2.CCOFFDR when cash clearing and cash AR inheritance is on for external bank account.

ERROR
-----------------------
SQL Error: ORA-00904: "L"."ANALYSIS_TYPE": invalid identifier

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1.  Go to Receivables Definition setup and populate cash control method as payment entry under Accounting Option 2 tab.
  2.  Go to Banking > Bank Account > External Account and check Cash Clearing option.
  3.  Go to Banking > Bank Account > External Account > Chartfields, click on Cash AR and setup inheritance option as Always Inherit for fund code.
  4.  For AR distribution code setup make sure you have fund code and some project chartfields populated.
  5.  Enter pending item and post the item.
  6.  Enter the payment and post it the process will fail at AR_PGG_SERV.CCOFFST2.CCOFFDR.


BUSINESS IMPACT
-----------------------
Cannot post the payment.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms