Codes And Status Field Description For The Batch Class (Doc ID 742827.1)

Last updated on MARCH 02, 2016

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.

Goal

A series of reports are being built using the following fields:
- Status of table BATCH_GEL_SESSION_STAT_T (for REL case)
- Status of table Batch_t (for UEL and REL).

Given below are the different values for STATUS. Please provide description for the statuses given below?
1) Select Distinct batch_t.POID_TYPE , BATCH_T.STATUS from BATCH_T
     We have in the database the following status:

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
      We have in the database the following status:

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