Codes and Status Field Description for the Batch Class (Doc ID 742827.1)

Last updated on SEPTEMBER 15, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.2.1.0.0 to 7.5.0.0.0 [Release 7.2.1 to 7.5.0]
Information in this document applies to any platform.
***Checked for relevance on 25-Apr-2012***
Checked for relevance on 2-Mar-2016.
Checked for relevance on 15-Sep-2017.

Goal

A series of reports have been built using these fields:
- Status of table BATCH_GEL_SESSION_STAT_T (for REL case)
- Status of table Batch_t (for UEL and REL).

Please provide description for these statuses given below.
1) Select Distinct batch_t.POID_TYPE , BATCH_T.STATUS from BATCH_T
     In the database, status are:

POID_TYPE STATUS
  /batch/gel 0
  /batch/rel 1
  /batch/rel 0
  /batch/rel 2

 2) Select Distinct BATCH_GEL_SESSION_STAT_T.STATUS from BATCH_GEL_SESSION_STAT_T
      In the database, status are:

STATUS
0
100
101


Solution

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