EAR9.2 EBill Payment Account Balance Page Returns SQL Error When on Oracle DB 12.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.
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].
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
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