My Oracle Support Banner

C1-TXNSQ Batch Is Failing With Null Pointer Exception , and TXN Goes in Error Status (Doc ID 3063222.1)

Last updated on DECEMBER 12, 2024

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 5.1.0.0.0 to 5.1.0.0.0 [Release 5.0]
Information in this document applies to any platform.

Symptoms

Product: Oracle Financial Services Revenue Management and Billing
Version: 5.1.0.0.0

Problem type: Batch Issue

Execution mode: Batch failing with Error
Batch name and code: C1-TXNSQ

Problem Summary: C1-TXNSQ Batch is Failing with Null pointer Exception , and TXN goes in error status
Problem Description: Issue : While running the C1-TXNSQ batch BillAfterDateDeterminationAlgorithm_Impl algorithm is throwing null pointer exception.

Exception : 02:13:23,372 [TPW51PRDWorker:1] ERROR (com.splwg.base.api.batch.ThreadWorkUnitExecutable) Error #1 encountered at work unit null - this error will be logged and the unit skipped during the database transaction replay
java.lang.NullPointerException: null
at com.splwg.ccb.domain.banking.transactionFeed.transactionFeedAgg.algorithm.BillAfterDateDeterminationAlgorithm_Impl.invoke(BillAfterDateDeterminationAlgorithm_Impl.

Cause : Seems to be an Orphaned Price Assignments linked with the Active pricing rule id in Pritm table, but that active price assignment is not linked with any pricing rule is in C1-PRC_RULE table.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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