ECM: Fatal SQL Error When Running The App Engine TR_BTB_CALC

(Doc ID 2175718.1)

Last updated on MARCH 02, 2018

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

The following error occurs when running the AppEngine TR_BTB_CALC. The bank account for which the process was run had no transactions for the period in question, and there are no issues with other bank accounts which do have transactions.

ERROR

Fatal SQL error occurred. (2,125) TR_EVENT_LOG.EventUtils.OnExecute Name:getNextTrackingID PCPC:447 Statement:13

Called from:TR_BTB_CALC.iBTBHdr.GBL.default.1900-01-01.EventLog.OnExecute Statement:2

Process 23162 ABENDED at Step TR_BTB_CALC.iBTBHdr.EventLog (PeopleCode) -- RC = 8 (108,524)

STEPS

1. Navigate to Banking > Reconcile Statements > Select Book to Bank Statements
2. Run TR_BTB_CALC

Changes

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