My Oracle Support Banner

Using DOC_ID and DOC_TYPE_FLG Searching For A Bill Reporting "SQL Error 999999990 occurred in module CIPBBILS:XQ010" And ORA-01013 Error From Application log (Doc ID 1491561.1)

Last updated on JUNE 04, 2018

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.3.1 and later
Information in this document applies to any platform.


On : 2.3.1 version, BI - Billing

When attempting to query billing using DOC_ID and DOC_TYPE_FLG, the following error occurs.

MPUGEDA - 749984-26860-1 2012-09-03 09:06:12,731 [Remote JVM:3 Thread 4] INFO (host.sql.CobolSQLHelper) SQL execution 'open cursor' request for cobol program 'CIPBBILS' SQL name 'S_ALTR5'
MPUGEDA - 749984-26860-1 2012-09-03 09:11:12,553 [Parent Reader:Thread-59] ERROR (support.cobol.DBLocalCobolSQLProcessBackend) SQL Error encountered sqlCode=1013, sqlState=72000 (ORA-01013: user requested cancel of current operation

The issue can be reproduced at will with the following steps:
1. In order to search by Document Number, set Install Options – Alternative Bill ID Option – Document Numbers
2. Search for a bill using DOC_ID and DOC_TYPE (Main Menu - Financial - Bill - Search by "Document Number" and "Document Type")
3. Error reported "SQL_Error_Code_999999990_in_module_CIPBBILS"
4. Search for the same bill record, search by "Bill ID", result can be shown up correctly.

The issue has the following business impact:
Due to this issue, Search by "Document Number" and "Document Type" failed if there are lots of documents existing.


To view full details, 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 a vibrant support community of peers and Oracle experts.