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

Last updated on SEPTEMBER 16, 2016

Applies to:

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

Symptoms

On : 9.2 version, eBill Payment

Problem with Financials/SCM 9.2.00.00 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].


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


STEPS
-----------------------
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.

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

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