Support For BIP Timezone Changes In BRM Reports (Doc ID 1404993.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.0.0 [Release 7.4.0]
Information in this document applies to any platform.

Symptoms

BRM Reports was functioning correctly  (Base and Optional Managers) on BIP Enterprise Standalone 10.1.3.4.1 (BIP_enterprise_for_linux_V16386-01).

But after installation of <PATCH 12574209> for BIP, the BRM reports fail at execution time. Below errors  are seen :

12/01/31 09:12:28 Oracle Containers for J2EE 10g (10.1.3.1.0)  initialized
[013112_091516252][][EXCEPTION] java.sql.SQLException: ORA-20006: Not a valid date Format
ORA-06512: at "PIN01.BIPEXT", line 198

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
        at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:633)
        at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1048)
        at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043)
        at oracle.apps.xdo.dataengine.XMLPGEN.writeDefaultGroup(Unknown Source)
        at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(Unknown Source)
        at oracle.apps.xdo.dataengine.XMLPGEN.processData(Unknown Source)
        at oracle.apps.xdo.dataengine.XMLPGEN.processXML(Unknown Source)
        at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(Unknown Source)
        at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(Unknown Source)
        at oracle.apps.xdo.dataengine.DataProcessor.processData(Unknown Source)
        at oracle.apps.xdo.servlet.data.bind.AdvancedQueryBoundValue11.getXML(AdvancedQueryBoundValue11.java:543)
        at oracle.apps.xdo.servlet.ReportContextImplV11.getReportXMLData(ReportContextImplV11.java:408)
        at oracle.apps.xdo.servlet.CoreProcessor.process(CoreProcessor.java:211)
        at oracle.apps.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:81)
        at oracle.apps.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:572)
        at oracle.apps.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:270)
        at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:265)
        at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:245)
        at oracle.apps.xdo.servlet.XDOServlet.doGet(XDOServlet.java:173)
        at oracle.apps.xdo.servlet.XDOServlet.doPost(XDOServlet.java:196)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
        at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
        at oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:100)
        at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
        at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
        at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
        at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
        at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)
        at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
        at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
        at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
        at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
        at java.lang.Thread.run(Thread.java:595)


Example: “BRM Reports” -> “Base BRMReports” -> “Price List” Report fails with ORA error connected with BIPEXT package.
The package is fully functional since the SQL calls goes through fine

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