My Oracle Support Banner

PUPL Three Step Batch Flow Is Not Working As Expected (Doc ID 3019200.1)

Last updated on APRIL 29, 2024

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 6.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On RMB v6.1.0.0.0, PUPL Three step batch flow is not working as expected.

PUPL Three step batch flow is not working as expected and it is observed that the errors are recorded in each of the batch jobs.

The issues are:

1. Batch Control: PUPL (batch is not picking records with Three step process batch parameter value as ‘Y’).
2. Batch Control: PUPLDF (One of the columns in a query in the implementation does not exist on the table).
3. Batch Control: PUPLCMPL

ACTUAL BEHAVIOR
-----------------------------
Job failed with Error for PUPLDF batch run.
ERROR (com.splwg.ccb.domain.payment.payment.batch.PUPLDistributeAndFreezeBatch)
Exception in processExecuteWorkUnitFlow() : org.hibernate.exception.SQLGrammarException: ORA-00904: "TMP"."PROCESSED_SW": invalid identifier.

EXPECTED BEHAVIOR
---------------------------------
PUPLDF job should run successfully with at least one record.

STEPS
------------
Run PUPL batch in 3 steps mode:
1. Run PUPL (1st step) job
2. Then run PUPLDF (2nd step) job
3. Finally run PUPLCMPL

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