My Oracle Support Banner

EAR9.2 EBill Payment Account Balance Page Returns SQL Error When on Oracle DB 12.1 (Doc ID 1923193.1)

Last updated on FEBRUARY 04, 2019

Applies to:

PeopleSoft Enterprise SCM Billing - Version 9.2 and later
Information in this document applies to any platform.


On : 9.2 version, eBill Payment

Problem with Financials/SCM DEMO environment verification test

When executing test on page 24 of PeopleSoft 9.2: Financials and Supply Chain Management Installation Verification Tests (Fin_SCM_IVT_92.docx), getting an error that is causing a core database dump: ORA-07445: exception encountered: core dump [qerixTunnelGetKey()+260].

SQL error in Exec. (2,280) AR_SUMBAL_SS.Activate PCPC:2223 Statement 14

The issue can be reproduced at will with the following steps:
1. Login as VP1 using Customer Registry (not Employee)
The Customer Registry can be accessed by changing the employee logon URL.
The Employee portal reference: (http://xxxxxxxx/psp/epXXXdmo/EMPLOYEE/ERP/h/?tab=DEFAULT)
should be replaced with the Customer portal reference: (http://xxxxxxxx/psp/epXXXdmo/CUSTOMER/ERP/h/?tab=DEFAULT)
2. Click eBill Payment
3. Click Account Balance
4. Verify that the Account Balances page appears.
5. Select the Home hyperlink to exit.

The issue has the following business impact:
Due to this issue, users cannot use this particular functionality




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

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