My Oracle Support Banner

EAR9.1: Fatal SQL Error Occurred. (2,125) FUNCLIB_AREIP.DEPOSIT_ID.FieldFormula When Uploading Excel Deposit Where Field '000 Process ?' is Set to 'N' (Doc ID 1371990.1)

Last updated on APRIL 08, 2019

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
***Checked for relevance on 06-Nov-2013***
***Checked for relevance on 03-Jul-2015***

Symptoms

On : 9.1 version, Payment Processing

When attempting to press button 'Generate XML and Post' in ExcelUploadforDeposits.xls while having field '000 Process ?' = 'N' the following error occurs.

ERROR
-----------------------
A fatal PeopleCode SQL error occurred. Please consult your system log for details.
Fatal SQL error occurred. (2,125) FUNCLIB_AREIP.DEPOSIT_ID.FieldFormula Name:deposit_excel_edit PCPC:2139 Statement:37 Called from:AR_DEPOSIT.DepositExcel.OnExecute Name:OnNotify Statement:8
Attempt to call abstract method/property OnError of object class PS_PT:Integration:INotificationHandler. (180,845)

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

  1. Open ExcelUploadforDeposits.xls and go to tab 'Data Sheet'.
  2. Make sure field '000 Process ?' is set to 'N' and press 'Generate XML and Post' button.
  3. Navigate to PeopleTools > Integration Broker > Service Operations Monitor > Monitoring > Asynchronous Details. Click on 'Error' link to open Subscription Contract Error Messages.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot determine what's wrong (error message is not clear and descriptive).

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.