
***********************************************************************
                 Oracle GoldenGate Capture for Oracle
    Version 18.1.0.0.0 OGGCORE_18.1.0.0.0_PLATFORMS_180928.0432_FBO
 Solaris, sparc, 64bit (optimized), Oracle 12c on Sep 30 2018 10:11:14
 
Copyright (C) 1995, 2018, Oracle and/or its affiliates. All rights reserved.

                    Starting at 2019-09-26 18:35:11
***********************************************************************

Operating System Version:
SunOS
Version 11.4.9.5.0, Release 5.11
Node: dware1
Machine: sun4v
                         soft limit   hard limit
Address Space Size   :    unlimited    unlimited
Heap Size            :    unlimited    unlimited
File Size            :    unlimited    unlimited
CPU Time             :    unlimited    unlimited

Process id: 12866

Description: 

***********************************************************************
**            Running with the following parameters                  **
***********************************************************************

2019-09-26 18:35:11  INFO    OGG-03059  Operating system character set identified as US-ASCII.

2019-09-26 18:35:11  INFO    OGG-02695  ANSI SQL parameter syntax is used for parameter parsing.

2019-09-26 18:35:12  INFO    OGG-01360  EXTRACT is running in Integrated mode.
EXTRACT EXTDWH
USERIDALIAS oggscb_dwh
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
TRANLOGOPTIONS MININGUSERALIAS oraggext
TRANLOGOPTIONS INTEGRATEDPARAMS (downstream_real_time_mine Y)
TRANLOGOPTIONS INCLUDEREGIONID
EXTTRAIL /ogg/ora12c/dirdat/aa
TABLE CBS_CORE.TEST;
TABLE CBS_CORE.CB_INSTALLMENT;
TABLE CBS_CORE.CB_INSTALLMENT_DTLS;
TABLE CBS_CORE.cb_serv_installment_dtls;
TABLE CBS_CORE.cb_subs_deposits;
TABLE CBS_CORE.cb_bill_cycle;
TABLE CBS_CORE.cb_order_request_dtls;
TABLE CBS_CORE.CB_WORK_ORDER;
TABLE CBS_CORE.TEST2,keycols(A);
TABLE CBS_CORE.GG;
TABLE CBS_CORE.WF_WRKFLWMGR;
TABLE CBS_CORE.CB_SUBS_PROVISIONING;
TABLE CBS_CORE.CB_POS_SERVICES;
TABLE CBS_CORE.CB_WORK_ORDER_PRODUCT_DTLS;
TABLE CBS_CORE.INV_ITEM_MASTER;
TABLE  CBS_CORE.CB_SUB_AR_AP;
TABLE CBS_CORE.CB_SUBS_INFORMATION_MASTER;
TABLE CLM_TT.WF_WORKASSIGNMENT_HISTORY;
TABLE CLM_TT.CB_FAULT_TYPES;
TABLE CLM_TT.TT_TICKET_ADDNL_INFO;
TABLE  CLM_TT.TT_TICKETINFO;
TABLE CLM_TT.WF_WORKASSIGNMENT;
TABLE CLM_TT.WF_TODOITEM;
TABLE CBS_CORE.WF_USERGROUP;
TABLE CLM_TT.WF_TODOITEM_HISTORY;
TABLE CLM_TT.TT_TICKETINCIDENT;
TABLE CBS_CORE.CB_USER_GROUP;
TABLE CLM_TT.TT_CATEGORY_MASTER;
TABLE CLM_TT.WF_WORKFLOW;
TABLE CBS_CORE.cb_offers;
TABLE CBS_CORE.CB_USERS;
TABLE CBS_CORE.CB_SUB_SERVICES;
TABLE  CBS_CORE.CB_SUB_INVOICE;
TABLE  CBS_CORE.CB_BANK_MASTER;
TABLE  CBS_CORE.CB_CR_DB_NOTES;
TABLE CBS_CORE.CB_REASON_MASTER;
TABLE CBS_CORE.CB_POS_SERVICES_PARAMS;
TABLE  CBS_CORE.CB_SUBS_OFFER_DETAILS;
TABLE CBS_CORE.CB_SUBS_PAID_ADV_DTLS;
TABLE  CBS_CORE.CB_SUBSCRIBER_SUB_CATEGORY;
TABLE  CBS_CORE.CB_SUBSCRIBER_MASTER;
TABLE  CBS_CORE.CB_SUBS_POS_SERVICES;
TABLE CBS_CORE.CB_CALCULATED_CHARGES;
TABLE CBS_CUST.CB_MULTI_ACCT_RECEIPT_DETAILS;
TABLE CBS_CUST.CB_MULTI_ACCT_INVOICE_DETAILS;
TABLE  CBS_CORE.CB_SUBSCRIBER_CATEGORY;
TABLE  CBS_CORE.CB_ADDRESS_XML;
TABLE  CBS_CORE.CB_RETAIL_OUTLETS;
TABLE  CBS_CORE.CB_RECEIPTS;
TABLE  CBS_CUST.CB_POS_TRANS_DTLS;
TABLE CBS_CUST.CB_POS_TRANSACTIONS;
TABLE  CBS_CORE.CB_RECEIPTS_ADJUST;
TABLE  CBS_CORE.fxl_cycle_summary_details;
TABLE CBS_CORE.CB_ADVANCE_RENTAL;
TABLE  CBS_CORE.CB_PACKAGE;
TABLE  CBS_CORE.CB_OFFERS;
TABLE  CBS_CORE.CB_INVOICE_DETAILS;
TABLE  CBS_CORE.CB_INVOICE;
TABLE  CBS_CORE.CB_DEALER_MASTER;
TABLE  CBS_CORE.CB_ARTICLE_GROUPS;
TABLE  CBS_CORE.CB_ARTICLES;
TABLE  CBS_CORE.PS_ACTION;
TABLE  CBS_CORE.CB_ACCOUNT_SERVICE_LIST;
TABLE  CBS_CORE.CB_ACCOUNT_RECEIVE_PAY;
TABLE  CBS_CORE.CB_ACCOUNT_MASTER;
TABLE  CBS_CORE.CB_STATUS_MASTER;
TABLE  CBS_CORE.CB_SERVICES;
TABLE  CBS_CORE.CB_ACCS_RECEIVE_PAY_ADJUST;
TABLE  CBS_CORE.CB_SUBS_REFUND;
TABLE  CBS_CORE.GSM_SERVICE_MAST;
TABLE  CBS_CORE.CB_PAY_MODE_DTLS;
TABLE  CBS_CORE.CB_PAYMENT_METHODS;
TABLE  CBS_CORE.CB_SCHEME_REFERENCE;
TABLE  CBS_CORE.CB_CANCEL_RECEIPTS;
TABLE  CBS_CORE.FXL_SERVICE_MAST;
TABLE CBS_CORE.CB_SCHEDULES;
TABLE CBS_CUST.CB_DID_HEADER_MAP;
TABLE CBS_CORE.CB_REVENUE;
TABLE CBS_CORE.CB_SAP_GL_SL_CODES;
TABLE CBS_CORE.cb_batch_process_metrics;
TABLE CBS_CORE.CB_BATCH_DETAILS;
TABLE CBS_CORE.CB_BATCH_CRITERIA_DETAILS;
TABLE CBS_CUST.GPRS_TAPIN_CDRS;
TABLE CBS_CUST.GSM_TAPIN_CDRS;
TABLE CBS_CUST.GSM_CYCLE_SUMMARY_DETAILS;
TABLE CBS_CORE.tmp_Table;
TABLE CBS_CUST.GSM_HOME_CDRS;
TABLE CBS_CUST.GPRS_HOME_CDRS;
TABLE CBS_CUST.MMS_HOME_CDRS;
TABLE CBS_CUST.FXL_RATED_CDRS;
TABLE CBS_CUST.CB_MULTI_ACCT_RECEIPT_HEADER;
TABLE CBS_CORE.inv_stock_summary;
TABLE CBS_CORE.inv_serial_items;
TABLE CBS_CUST.cb_dlr_category_master;
TABLE TT_MSO.CB_SELFCARE_USERS;
TABLE TT_MSO.TMP_REPORT_ENT_SELFCARE;

2019-09-26 18:35:17  INFO    OGG-01815  Virtual Memory Facilities for: BR
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /ogg/ora12c/BR/EXTDWH.

Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR      = /ogg/ora12c/

2019-09-26 18:35:17  INFO    OGG-01851  filecaching started: thread ID: 6.

2019-09-26 18:35:17  INFO    OGG-01815  Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /ogg/ora12c/dirtmp.

2019-09-26 18:35:17  INFO    OGG-01639  BOUNDED RECOVERY:  ACTIVE: for object pool 1: p3823_extr.

2019-09-26 18:35:17  INFO    OGG-01640  BOUNDED RECOVERY: recovery start XID: 0.0.0.0.

2019-09-26 18:35:17  INFO    OGG-01641  BOUNDED RECOVERY: recovery start position: SeqNo: 694, RBA: 1429452836, SCN: 62.259615526 (266547587878), Timestamp: 2019-09-26 18:12:03.000000, Thread: 1.

2019-09-26 18:35:17  INFO    OGG-01642  BOUNDED RECOVERY: recovery end position: SeqNo: 694, RBA: 1429452836, SCN: 62.259615526 (266547587878), Timestamp: 2019-09-26 18:12:03.000000, Thread: 1.

2019-09-26 18:35:17  INFO    OGG-01643  BOUNDED RECOVERY: CANCELED: for object pool 1: p3823_extr.

2019-09-26 18:35:17  INFO    OGG-01579  BOUNDED RECOVERY: VALID BCP: CP.EXTDWH.000000090.

2019-09-26 18:35:17  INFO    OGG-01629  BOUNDED RECOVERY: PERSISTED OBJECTS RECOVERED: <<NONE TO RECOVER>>.

Database Version:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE	12.1.0.2.0	Production
TNS for Solaris: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production

Database Language and Character Set:
NLS_LANGUAGE     = "AMERICAN" 
NLS_TERRITORY    = "AMERICA" 
NLS_CHARACTERSET = "WE8MSWIN1252" 

2019-09-26 18:35:19  INFO    OGG-06604  Database CBS CPU info: CPU Count 32, CPU Core Count 4, CPU Socket Count 2.

2019-09-26 18:35:19  INFO    OGG-06604  Database DWARE1 CPU info: CPU Count 16, CPU Core Count 2, CPU Socket Count 1.

2019-09-26 18:35:21  WARNING OGG-02045  Database does not have streams_pool_size initialization parameter configured.

2019-09-26 18:35:21  INFO    OGG-02248  Logmining server DDL filtering enabled.

2019-09-26 18:35:23  INFO    OGG-02068  Integrated capture successfully attached to logmining server OGG$CAP_EXTDWH using OGGCapture API.

2019-09-26 18:35:23  INFO    OGG-02089  Source redo compatibility version is: 12.1.0.2.0.

2019-09-26 18:35:23  INFO    OGG-02086  Integrated Dictionary will be used.

2019-09-26 18:35:24  WARNING OGG-02905  Replication of OID column in object tables may diverge.

2019-09-26 18:35:24  INFO    OGG-01055  Recovery initialization completed for target file /ogg/ora12c/dirdat/aa000000228, at RBA 384006975.

2019-09-26 18:35:24  INFO    OGG-01478  Output file /ogg/ora12c/dirdat/aa is using format RELEASE 12.3/18.1.

2019-09-26 18:35:26  INFO    OGG-01026  Rolling over remote file /ogg/ora12c/dirdat/aa000000228.

2019-09-26 18:35:26  INFO    OGG-01053  Recovery completed for target file /ogg/ora12c/dirdat/aa000000229, at RBA 1407.

2019-09-26 18:35:26  INFO    OGG-01057  Recovery completed for all targets.

***********************************************************************
**                     Run Time Messages                             **
***********************************************************************


2019-09-26 18:35:28  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CUST.CB_MULTI_ACCT_INVOICE_DETAILS): TABLE "CBS_CUST"."CB_MULTI_ACCT_INVOICE_DETAILS".

2019-09-26 18:35:28  WARNING OGG-06439  No unique key is defined for table CB_MULTI_ACCT_INVOICE_DETAILS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:28  INFO    OGG-06509  Using the following key columns for source table CBS_CUST.CB_MULTI_ACCT_INVOICE_DETAILS: RECEIPT_REF_NUM_N, ACCOUNT_CODE_N, INVOICE_NUM_V, PAYMENT_AMOUNT_N.

2019-09-26 18:35:28  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CUST.CB_MULTI_ACCT_RECEIPT_DETAILS): TABLE "CBS_CUST"."CB_MULTI_ACCT_RECEIPT_DETAILS".

2019-09-26 18:35:28  WARNING OGG-06439  No unique key is defined for table CB_MULTI_ACCT_RECEIPT_DETAILS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:28  INFO    OGG-06509  Using the following key columns for source table CBS_CUST.CB_MULTI_ACCT_RECEIPT_DETAILS: RECEIPT_REF_NUM_N, ACCOUNT_CODE_N, PAYMENT_AMOUNT_N, RECEIPT_NUM_V, PAY_AGAI_INV_V, STATUS_V, REMARKS_V, VAT_NUM_V, BRN_NUM_V, SERVICE_INFO_V, PG_REF_NUMBER_V, APPROVAL_CODE_V.

2019-09-26 18:35:28  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CUST.CB_MULTI_ACCT_RECEIPT_HEADER): TABLE "CBS_CUST"."CB_MULTI_ACCT_RECEIPT_HEADER".

2019-09-26 18:35:28  INFO    OGG-06509  Using the following key columns for source table CBS_CUST.CB_MULTI_ACCT_RECEIPT_HEADER: RECEIPT_REF_NUM_N.

2019-09-26 18:35:28  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_ACCOUNT_RECEIVE_PAY): TABLE  "CBS_CORE"."CB_ACCOUNT_RECEIVE_PAY".

2019-09-26 18:35:28  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CUST.CB_MULTI_ACCT_INVOICE_DETAILS): TABLE "CBS_CUST"."CB_MULTI_ACCT_INVOICE_DETAILS".

2019-09-26 18:35:28  WARNING OGG-06439  No unique key is defined for table CB_MULTI_ACCT_INVOICE_DETAILS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:28  INFO    OGG-06509  Using the following key columns for source table CBS_CUST.CB_MULTI_ACCT_INVOICE_DETAILS: RECEIPT_REF_NUM_N, ACCOUNT_CODE_N, INVOICE_NUM_V, PAYMENT_AMOUNT_N.

2019-09-26 18:35:28  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CUST.CB_MULTI_ACCT_RECEIPT_DETAILS): TABLE "CBS_CUST"."CB_MULTI_ACCT_RECEIPT_DETAILS".

2019-09-26 18:35:28  WARNING OGG-06439  No unique key is defined for table CB_MULTI_ACCT_RECEIPT_DETAILS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:28  INFO    OGG-06509  Using the following key columns for source table CBS_CUST.CB_MULTI_ACCT_RECEIPT_DETAILS: RECEIPT_REF_NUM_N, ACCOUNT_CODE_N, PAYMENT_AMOUNT_N, RECEIPT_NUM_V, PAY_AGAI_INV_V, STATUS_V, REMARKS_V, VAT_NUM_V, BRN_NUM_V, SERVICE_INFO_V, PG_REF_NUMBER_V, APPROVAL_CODE_V.

2019-09-26 18:35:28  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CUST.CB_MULTI_ACCT_RECEIPT_HEADER): TABLE "CBS_CUST"."CB_MULTI_ACCT_RECEIPT_HEADER".

2019-09-26 18:35:28  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_ACCOUNT_RECEIVE_PAY: ACCOUNT_LINK_CODE_N, TRANS_TYPE_V, TRANS_NUM_V, SERIAL_NUM_N.

2019-09-26 18:35:28  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_SUBS_INFORMATION_MASTER): TABLE "CBS_CORE"."CB_SUBS_INFORMATION_MASTER".

2019-09-26 18:35:28  INFO    OGG-06509  Using the following key columns for source table CBS_CUST.CB_MULTI_ACCT_RECEIPT_HEADER: RECEIPT_REF_NUM_N.

2019-09-26 18:35:28  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SUBS_INFORMATION_MASTER: ACCOUNT_LINK_CODE_N.

2019-09-26 18:35:28  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_SUB_AR_AP): TABLE  "CBS_CORE"."CB_SUB_AR_AP".

2019-09-26 18:35:28  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SUB_AR_AP: TRANS_NUM_V, SERIAL_NUM_N, ACCOUNT_LINK_CODE_N, SUBSIDIARY_CODE_V.

2019-09-26 18:35:28  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_PAY_MODE_DTLS): TABLE  "CBS_CORE"."CB_PAY_MODE_DTLS".

2019-09-26 18:35:29  WARNING OGG-06439  No unique key is defined for table CB_PAY_MODE_DTLS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_PAY_MODE_DTLS: TRANS_NUM_V, TRANS_DATE_D, PAY_MODE_OPTN_V, TRANS_AMT_N, DB_CR_V, BANK_CODE_V, CARD_HOLDER_NAME_V, AUTHORISATION_NUM_V, CHQ_DATE_CC_EXPIRY_DT_D, CARD_TYPE_V, BANK_AC_CODE_V, CHEQUE_NUM_V, LOCAL_CHQ_FLG_V, LOCATION_CODE_V, CASH_BOX_NUMBER_N, STATUS_OPTN_V, BRANCH_CODE_V, PAYMENT_CHANNEL_V, UPLOAD_BANK_SAP_GL_CODE_N, ACC_REF_CODE_V, DISPLAY_REF_NO_V, CASH_STATUS_OPTION_V, DEPOSITED_TRANS_NUMB_V, FOREIGN_AMOUNT_N, FOREIGN_CHANGE_AMT_N, FOREIGN_CURRENCY_CODE_V, FOREIGN_CURRENCY_FLAG_V, LOCAL_CHANGE_AMT_N, PREFERRED_CHANGE_AMT_N, PREFERRED_CURR_CODE_V, PREPAID_POSTPAID_FLAG_V, TELLER_NUMBER_V.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_RECEIPTS): TABLE  "CBS_CORE"."CB_RECEIPTS".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_RECEIPTS: TRANS_NUM_V.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_RECEIPTS_ADJUST): TABLE  "CBS_CORE"."CB_RECEIPTS_ADJUST".

2019-09-26 18:35:29  WARNING OGG-06439  No unique key is defined for table CB_RECEIPTS_ADJUST. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_RECEIPTS_ADJUST: RCPT_TRANS_NUM_V, RCPT_TRANS_DATE_D, ACCOUNT_LINK_CODE_N, INV_TRANS_NUM_V, INV_TRANS_DATE_D, SRV_ACCOUNT_LINK_CODE_N, PREFERRED_CURR_CODE_V, PAID_AMOUNT_N, FOREIGN_CURRENCY_CODE_V, EXCHANGE_RATE_N, FOREIGN_AMOUNT_N.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_INVOICE): TABLE  "CBS_CORE"."CB_INVOICE".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_INVOICE: TRANS_NUM_V.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_SUB_INVOICE): TABLE  "CBS_CORE"."CB_SUB_INVOICE".

2019-09-26 18:35:29  WARNING OGG-06439  No unique key is defined for table CB_SUB_INVOICE. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SUB_INVOICE: TRANS_NUM_V, TRANS_DATE_D, SERVICE_CODE_V, BILL_CYCL_FULL_CODE_N, BILLING_REGION_V, CHRG_FROM_DATE_D, CHRG_TILL_DATE_D, INVOICE_AMT_N, TAX_AMT_N, OVER_ALL_DISC_N, INV_AMT_CLEARED_N, ADJUSTMENT_AMT_N, TEMP_CLR_AMT_N, DISPUTE_AMT_N, EARLY_PAY_DISC_OPTN_N, EARLY_PAYMENT_DISC_AMT_N, INV_CLEARED_FLG_V, PRINT_CALL_DTLS_FLG_V, ACCOUNT_CODE_N, ITEMISED_TYPE_N, CURRENCY_CODE_V, GL_CODE_N, PACKAGE_CODE_V, SERV_ACC_LINK_CODE_N.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_ACCS_RECEIVE_PAY_ADJUST): TABLE  "CBS_CORE"."CB_ACCS_RECEIVE_PAY_ADJUST".

2019-09-26 18:35:29  WARNING OGG-06439  No unique key is defined for table CB_ACCS_RECEIVE_PAY_ADJUST. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_ACCS_RECEIVE_PAY_ADJUST: ACCOUNT_LINK_CODE_N, CR_TRANS_NUM_V, CR_SERIAL_NUM_N, CR_DATE_D, DB_TRANS_NUM_V, DB_SERIAL_NUM_N, DB_DATE_D, ADJUST_AMT_N, LAST_MODIFIED_DATE_D.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CUST.CB_POS_TRANSACTIONS): TABLE "CBS_CUST"."CB_POS_TRANSACTIONS".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CUST.CB_POS_TRANSACTIONS: TRANSACTION_NUM_V.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.inv_stock_summary): TABLE "CBS_CORE"."INV_STOCK_SUMMARY".

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_ACCOUNT_RECEIVE_PAY): TABLE  "CBS_CORE"."CB_ACCOUNT_RECEIVE_PAY".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_ACCOUNT_RECEIVE_PAY: ACCOUNT_LINK_CODE_N, TRANS_TYPE_V, TRANS_NUM_V, SERIAL_NUM_N.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_SUBS_INFORMATION_MASTER): TABLE "CBS_CORE"."CB_SUBS_INFORMATION_MASTER".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SUBS_INFORMATION_MASTER: ACCOUNT_LINK_CODE_N.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_SUB_AR_AP): TABLE  "CBS_CORE"."CB_SUB_AR_AP".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SUB_AR_AP: TRANS_NUM_V, SERIAL_NUM_N, ACCOUNT_LINK_CODE_N, SUBSIDIARY_CODE_V.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_PAY_MODE_DTLS): TABLE  "CBS_CORE"."CB_PAY_MODE_DTLS".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.INV_STOCK_SUMMARY: DATE_D, LOCATION_CODE_N, ITEM_CODE_N.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CUST.CB_POS_TRANS_DTLS): TABLE  "CBS_CUST"."CB_POS_TRANS_DTLS".

2019-09-26 18:35:29  WARNING OGG-06439  No unique key is defined for table CB_PAY_MODE_DTLS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_PAY_MODE_DTLS: TRANS_NUM_V, TRANS_DATE_D, PAY_MODE_OPTN_V, TRANS_AMT_N, DB_CR_V, BANK_CODE_V, CARD_HOLDER_NAME_V, AUTHORISATION_NUM_V, CHQ_DATE_CC_EXPIRY_DT_D, CARD_TYPE_V, BANK_AC_CODE_V, CHEQUE_NUM_V, LOCAL_CHQ_FLG_V, LOCATION_CODE_V, CASH_BOX_NUMBER_N, STATUS_OPTN_V, BRANCH_CODE_V, PAYMENT_CHANNEL_V, UPLOAD_BANK_SAP_GL_CODE_N, ACC_REF_CODE_V, DISPLAY_REF_NO_V, CASH_STATUS_OPTION_V, DEPOSITED_TRANS_NUMB_V, FOREIGN_AMOUNT_N, FOREIGN_CHANGE_AMT_N, FOREIGN_CURRENCY_CODE_V, FOREIGN_CURRENCY_FLAG_V, LOCAL_CHANGE_AMT_N, PREFERRED_CHANGE_AMT_N, PREFERRED_CURR_CODE_V, PREPAID_POSTPAID_FLAG_V, TELLER_NUMBER_V.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_RECEIPTS): TABLE  "CBS_CORE"."CB_RECEIPTS".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_RECEIPTS: TRANS_NUM_V.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_RECEIPTS_ADJUST): TABLE  "CBS_CORE"."CB_RECEIPTS_ADJUST".

2019-09-26 18:35:29  WARNING OGG-06439  No unique key is defined for table CB_RECEIPTS_ADJUST. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_RECEIPTS_ADJUST: RCPT_TRANS_NUM_V, RCPT_TRANS_DATE_D, ACCOUNT_LINK_CODE_N, INV_TRANS_NUM_V, INV_TRANS_DATE_D, SRV_ACCOUNT_LINK_CODE_N, PREFERRED_CURR_CODE_V, PAID_AMOUNT_N, FOREIGN_CURRENCY_CODE_V, EXCHANGE_RATE_N, FOREIGN_AMOUNT_N.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_INVOICE): TABLE  "CBS_CORE"."CB_INVOICE".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_INVOICE: TRANS_NUM_V.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_SUB_INVOICE): TABLE  "CBS_CORE"."CB_SUB_INVOICE".

2019-09-26 18:35:29  WARNING OGG-06439  No unique key is defined for table CB_SUB_INVOICE. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SUB_INVOICE: TRANS_NUM_V, TRANS_DATE_D, SERVICE_CODE_V, BILL_CYCL_FULL_CODE_N, BILLING_REGION_V, CHRG_FROM_DATE_D, CHRG_TILL_DATE_D, INVOICE_AMT_N, TAX_AMT_N, OVER_ALL_DISC_N, INV_AMT_CLEARED_N, ADJUSTMENT_AMT_N, TEMP_CLR_AMT_N, DISPUTE_AMT_N, EARLY_PAY_DISC_OPTN_N, EARLY_PAYMENT_DISC_AMT_N, INV_CLEARED_FLG_V, PRINT_CALL_DTLS_FLG_V, ACCOUNT_CODE_N, ITEMISED_TYPE_N, CURRENCY_CODE_V, GL_CODE_N, PACKAGE_CODE_V, SERV_ACC_LINK_CODE_N.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_ACCS_RECEIVE_PAY_ADJUST): TABLE  "CBS_CORE"."CB_ACCS_RECEIVE_PAY_ADJUST".

2019-09-26 18:35:29  WARNING OGG-06439  No unique key is defined for table CB_ACCS_RECEIVE_PAY_ADJUST. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_ACCS_RECEIVE_PAY_ADJUST: ACCOUNT_LINK_CODE_N, CR_TRANS_NUM_V, CR_SERIAL_NUM_N, CR_DATE_D, DB_TRANS_NUM_V, DB_SERIAL_NUM_N, DB_DATE_D, ADJUST_AMT_N, LAST_MODIFIED_DATE_D.

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CUST.CB_POS_TRANS_DTLS: TRANSACTION_NUM_V, SEQ_NUM_N.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CLM_TT.WF_TODOITEM): TABLE "CLM_TT"."WF_TODOITEM".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CLM_TT.WF_TODOITEM: WORK_ID_N.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_USERS): TABLE "CBS_CORE"."CB_USERS".

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CUST.CB_POS_TRANSACTIONS): TABLE "CBS_CUST"."CB_POS_TRANSACTIONS".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CUST.CB_POS_TRANSACTIONS: TRANSACTION_NUM_V.

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_USERS: USER_CODE_N.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.inv_stock_summary): TABLE "CBS_CORE"."INV_STOCK_SUMMARY".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.INV_STOCK_SUMMARY: DATE_D, LOCATION_CODE_N, ITEM_CODE_N.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CUST.CB_POS_TRANS_DTLS): TABLE  "CBS_CUST"."CB_POS_TRANS_DTLS".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CUST.CB_POS_TRANS_DTLS: TRANSACTION_NUM_V, SEQ_NUM_N.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CLM_TT.WF_TODOITEM): TABLE "CLM_TT"."WF_TODOITEM".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CLM_TT.WF_TODOITEM: WORK_ID_N.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_USERS): TABLE "CBS_CORE"."CB_USERS".

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_WORK_ORDER_PRODUCT_DTLS): TABLE "CBS_CORE"."CB_WORK_ORDER_PRODUCT_DTLS".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_USERS: USER_CODE_N.

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_WORK_ORDER_PRODUCT_DTLS: TMP_SEQUENCE_NUMBER_N, SERVICE_KEY_CODE_V, SCHEME_REF_CODE_N, SERIAL_NUM_N, FACILITY_REF_ID_V.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.cb_order_request_dtls): TABLE "CBS_CORE"."CB_ORDER_REQUEST_DTLS".

2019-09-26 18:35:29  WARNING OGG-06439  No unique key is defined for table CB_ORDER_REQUEST_DTLS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_ORDER_REQUEST_DTLS: TRANS_DATE_D, ORDER_REF_NO_V, SERVICE_REQ_ID_V.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_SUBSCRIBER_MASTER): TABLE  "CBS_CORE"."CB_SUBSCRIBER_MASTER".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SUBSCRIBER_MASTER: SUBSCRIBER_CODE_N.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_ACCOUNT_MASTER): TABLE  "CBS_CORE"."CB_ACCOUNT_MASTER".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_ACCOUNT_MASTER: ACCOUNT_CODE_N.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_ADDRESS_XML): TABLE  "CBS_CORE"."CB_ADDRESS_XML".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_ADDRESS_XML: ACCOUNT_LINK_CODE_N, ADDRESS_TYPE_N, ACCOUNT_TYPE_V.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.FXL_SERVICE_MAST): TABLE  "CBS_CORE"."FXL_SERVICE_MAST".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.FXL_SERVICE_MAST: SERV_ACC_LINK_CODE_N.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_SUBS_POS_SERVICES): TABLE  "CBS_CORE"."CB_SUBS_POS_SERVICES".

2019-09-26 18:35:29  WARNING OGG-06439  No unique key is defined for table CB_SUBS_POS_SERVICES. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SUBS_POS_SERVICES: ORDER_REF_NO, SERIAL_NUM_N, ORDER_TYPE_V, TRANS_NUM_V, TRANS_DATE_DT, SERVICE_CODE_V, ACCOUNT_LINK_CODE_N, SERV_ACC_LINK_CODE_N, SERVICE_KEY_CODE_V, SCHEME_REF_CODE_N, ACTION_PARM_STRG_V, PROFIT_CENTRE_CODE, PRIORITY_FLG_N, OFFER_GROUP_CODE_V, CRITICAL_SERVICE_FLG_V, CHARGES_PRESENT_FLG_V, ORDER_AMOUNT_N, COLLECTED_UPFRONT_V, RECEIPT_REF_NUM_V, STATUS_OPTN_V, EXECUTE_IMMEDIATE_FLG_V, MOVE_TO_SCHDL_FLG_V, REQUESTED_DATE_DT, PROCESSED_DATE_DT, CREATED_BY_N, AUTHORISED_BY_N, AUTHORISED_DATE_DT, CANCELLED_BY_N, CANCELLED_DATE_DT, REFUNDED_DATE_DT, REFUND_TRANS_NO_V, FROM_SELF_CARE_FLG_V, SCHDL_LINK_CODE_N, REASON_CODE_V, COMMENTS_V, CANCEL_REASON_CODE_V, CANCEL_COMMENTS_V, LOCATION_CODE_V, REJECTED_REASON_V, LOGIN_NAME_V, BANK_DETAILS_V, APPLICATION_NAME_V, MARGIN_AMOUNT_N, CHRONO_NUM_N, PRINT_WORK_ORDER_INDICATORS_V, ERROR_DESC_V, SALE_TRANSACTION_NUMBER_V, LAST_MODIFIED_DATE_D, ACC_SERV_FLAG_V, RESUBMIT_COUNT_N, WAIVE_OFF_APPROVAL_V.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_ACCOUNT_SERVICE_LIST): TABLE  "CBS_CORE"."CB_ACCOUNT_SERVICE_LIST".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_ACCOUNT_SERVICE_LIST: ACCOUNT_CODE_N, ACCOUNT_LINK_CODE_N.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_WORK_ORDER): TABLE "CBS_CORE"."CB_WORK_ORDER".

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_WORK_ORDER: ORDER_REFERENCE_NO_V.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_SCHEDULES): TABLE "CBS_CORE"."CB_SCHEDULES".

2019-09-26 18:35:29  WARNING OGG-06439  No unique key is defined for table CB_SCHEDULES. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:29  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SCHEDULES: SERVICE_CODE_V, SERVICE_KEY_CODE_V, SERV_ACC_LINK_CODE_N, SCHEME_REF_CODE_N, PROFIT_CENTRE_CODE, COLLECTED_UPFRONT_V, PRIORITY_N, ACTION_PARM_STRG_V, PROCESS_ON_DATE_D, STATUS_OPTN_V, CRITICAL_SERVICE_FLG_V, GROUP_CODE_V, EXECUTED_DT, USER_CODE_N, FROM_SELF_CARE_FLG_V, SCHDL_LINK_CODE_N, ACCOUNT_LINK_CODE_N, PROV_CHRONO_NUM_N, ORD_PROV_REQUEST_V, LAST_MODIFIED_DATE_D, ACC_SERV_FLG_V, FAILURE_REASON_V, WAIVE_OFF_APPROVAL_V.

2019-09-26 18:35:29  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.cb_subs_deposits): TABLE "CBS_CORE"."CB_SUBS_DEPOSITS".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SUBS_DEPOSITS: ACCOUNT_LINK_CODE_N, SERVICE_CODE_V, SCHEME_REF_CODE_N, ARTICLE_CODE_V, FACILITY_REF_ID_V.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CLM_TT.TT_TICKETINCIDENT): TABLE "CLM_TT"."TT_TICKETINCIDENT".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CLM_TT.TT_TICKETINCIDENT: INCIDENT_NUMBER_N.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CLM_TT.TT_TICKETINFO): TABLE  "CLM_TT"."TT_TICKETINFO".

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_WORK_ORDER_PRODUCT_DTLS): TABLE "CBS_CORE"."CB_WORK_ORDER_PRODUCT_DTLS".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_WORK_ORDER_PRODUCT_DTLS: TMP_SEQUENCE_NUMBER_N, SERVICE_KEY_CODE_V, SCHEME_REF_CODE_N, SERIAL_NUM_N, FACILITY_REF_ID_V.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.cb_order_request_dtls): TABLE "CBS_CORE"."CB_ORDER_REQUEST_DTLS".

2019-09-26 18:35:30  WARNING OGG-06439  No unique key is defined for table CB_ORDER_REQUEST_DTLS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_ORDER_REQUEST_DTLS: TRANS_DATE_D, ORDER_REF_NO_V, SERVICE_REQ_ID_V.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_SUBSCRIBER_MASTER): TABLE  "CBS_CORE"."CB_SUBSCRIBER_MASTER".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CLM_TT.TT_TICKETINFO: DOCKET_NUMBER_N.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CLM_TT.WF_WORKFLOW): TABLE "CLM_TT"."WF_WORKFLOW".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SUBSCRIBER_MASTER: SUBSCRIBER_CODE_N.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_ACCOUNT_MASTER): TABLE  "CBS_CORE"."CB_ACCOUNT_MASTER".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CLM_TT.WF_WORKFLOW: WRKFLW_INSTANCE_ID_N.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CLM_TT.WF_TODOITEM_HISTORY): TABLE "CLM_TT"."WF_TODOITEM_HISTORY".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_ACCOUNT_MASTER: ACCOUNT_CODE_N.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_ADDRESS_XML): TABLE  "CBS_CORE"."CB_ADDRESS_XML".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_ADDRESS_XML: ACCOUNT_LINK_CODE_N, ADDRESS_TYPE_N, ACCOUNT_TYPE_V.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.FXL_SERVICE_MAST): TABLE  "CBS_CORE"."FXL_SERVICE_MAST".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CLM_TT.WF_TODOITEM_HISTORY: WORK_ID_N, STATUS_V.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CLM_TT.WF_WORKASSIGNMENT): TABLE "CLM_TT"."WF_WORKASSIGNMENT".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.FXL_SERVICE_MAST: SERV_ACC_LINK_CODE_N.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_SUBS_POS_SERVICES): TABLE  "CBS_CORE"."CB_SUBS_POS_SERVICES".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CLM_TT.WF_WORKASSIGNMENT: WORK_ID_N, USER_GROUP_OPTN_V, USER_GROUP_ID_N, ASSIGNED_BY_N.

2019-09-26 18:35:30  WARNING OGG-06439  No unique key is defined for table CB_SUBS_POS_SERVICES. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SUBS_POS_SERVICES: ORDER_REF_NO, SERIAL_NUM_N, ORDER_TYPE_V, TRANS_NUM_V, TRANS_DATE_DT, SERVICE_CODE_V, ACCOUNT_LINK_CODE_N, SERV_ACC_LINK_CODE_N, SERVICE_KEY_CODE_V, SCHEME_REF_CODE_N, ACTION_PARM_STRG_V, PROFIT_CENTRE_CODE, PRIORITY_FLG_N, OFFER_GROUP_CODE_V, CRITICAL_SERVICE_FLG_V, CHARGES_PRESENT_FLG_V, ORDER_AMOUNT_N, COLLECTED_UPFRONT_V, RECEIPT_REF_NUM_V, STATUS_OPTN_V, EXECUTE_IMMEDIATE_FLG_V, MOVE_TO_SCHDL_FLG_V, REQUESTED_DATE_DT, PROCESSED_DATE_DT, CREATED_BY_N, AUTHORISED_BY_N, AUTHORISED_DATE_DT, CANCELLED_BY_N, CANCELLED_DATE_DT, REFUNDED_DATE_DT, REFUND_TRANS_NO_V, FROM_SELF_CARE_FLG_V, SCHDL_LINK_CODE_N, REASON_CODE_V, COMMENTS_V, CANCEL_REASON_CODE_V, CANCEL_COMMENTS_V, LOCATION_CODE_V, REJECTED_REASON_V, LOGIN_NAME_V, BANK_DETAILS_V, APPLICATION_NAME_V, MARGIN_AMOUNT_N, CHRONO_NUM_N, PRINT_WORK_ORDER_INDICATORS_V, ERROR_DESC_V, SALE_TRANSACTION_NUMBER_V, LAST_MODIFIED_DATE_D, ACC_SERV_FLAG_V, RESUBMIT_COUNT_N, WAIVE_OFF_APPROVAL_V.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_SUBS_PROVISIONING): TABLE "CBS_CORE"."CB_SUBS_PROVISIONING".

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_ACCOUNT_SERVICE_LIST): TABLE  "CBS_CORE"."CB_ACCOUNT_SERVICE_LIST".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_ACCOUNT_SERVICE_LIST: ACCOUNT_CODE_N, ACCOUNT_LINK_CODE_N.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_WORK_ORDER): TABLE "CBS_CORE"."CB_WORK_ORDER".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_WORK_ORDER: ORDER_REFERENCE_NO_V.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_SCHEDULES): TABLE "CBS_CORE"."CB_SCHEDULES".

2019-09-26 18:35:30  WARNING OGG-06439  No unique key is defined for table CB_SCHEDULES. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SCHEDULES: SERVICE_CODE_V, SERVICE_KEY_CODE_V, SERV_ACC_LINK_CODE_N, SCHEME_REF_CODE_N, PROFIT_CENTRE_CODE, COLLECTED_UPFRONT_V, PRIORITY_N, ACTION_PARM_STRG_V, PROCESS_ON_DATE_D, STATUS_OPTN_V, CRITICAL_SERVICE_FLG_V, GROUP_CODE_V, EXECUTED_DT, USER_CODE_N, FROM_SELF_CARE_FLG_V, SCHDL_LINK_CODE_N, ACCOUNT_LINK_CODE_N, PROV_CHRONO_NUM_N, ORD_PROV_REQUEST_V, LAST_MODIFIED_DATE_D, ACC_SERV_FLG_V, FAILURE_REASON_V, WAIVE_OFF_APPROVAL_V.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.cb_subs_deposits): TABLE "CBS_CORE"."CB_SUBS_DEPOSITS".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SUBS_PROVISIONING: CHRONO_NUM_N, PROCESS_NO_N.

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SUBS_DEPOSITS: ACCOUNT_LINK_CODE_N, SERVICE_CODE_V, SCHEME_REF_CODE_N, ARTICLE_CODE_V, FACILITY_REF_ID_V.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CLM_TT.TT_TICKETINCIDENT): TABLE "CLM_TT"."TT_TICKETINCIDENT".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CLM_TT.TT_TICKETINCIDENT: INCIDENT_NUMBER_N.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CLM_TT.TT_TICKETINFO): TABLE  "CLM_TT"."TT_TICKETINFO".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CLM_TT.TT_TICKETINFO: DOCKET_NUMBER_N.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CLM_TT.WF_WORKFLOW): TABLE "CLM_TT"."WF_WORKFLOW".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CLM_TT.WF_WORKFLOW: WRKFLW_INSTANCE_ID_N.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CLM_TT.WF_TODOITEM_HISTORY): TABLE "CLM_TT"."WF_TODOITEM_HISTORY".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CLM_TT.WF_TODOITEM_HISTORY: WORK_ID_N, STATUS_V.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CLM_TT.WF_WORKASSIGNMENT): TABLE "CLM_TT"."WF_WORKASSIGNMENT".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CLM_TT.WF_WORKASSIGNMENT: WORK_ID_N, USER_GROUP_OPTN_V, USER_GROUP_ID_N, ASSIGNED_BY_N.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_SUBS_PROVISIONING): TABLE "CBS_CORE"."CB_SUBS_PROVISIONING".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SUBS_PROVISIONING: CHRONO_NUM_N, PROCESS_NO_N.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CLM_TT.TT_TICKET_ADDNL_INFO): TABLE "CLM_TT"."TT_TICKET_ADDNL_INFO".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CLM_TT.TT_TICKET_ADDNL_INFO: DOCKET_NUMBER_N.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CLM_TT.WF_WORKASSIGNMENT_HISTORY): TABLE "CLM_TT"."WF_WORKASSIGNMENT_HISTORY".

2019-09-26 18:35:30  WARNING OGG-06439  No unique key is defined for table WF_WORKASSIGNMENT_HISTORY. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CLM_TT.WF_WORKASSIGNMENT_HISTORY: WORK_ID_N, USER_GROUP_OPTN_V, USER_GROUP_ID_N, ASSIGNED_BY_N, ASSIGMENT_DATE_D, ASSIGN_FLAG_V.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CLM_TT.TT_TICKET_ADDNL_INFO): TABLE "CLM_TT"."TT_TICKET_ADDNL_INFO".

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CLM_TT.TT_TICKET_ADDNL_INFO: DOCKET_NUMBER_N.

2019-09-26 18:35:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CLM_TT.WF_WORKASSIGNMENT_HISTORY): TABLE "CLM_TT"."WF_WORKASSIGNMENT_HISTORY".

2019-09-26 18:35:30  WARNING OGG-06439  No unique key is defined for table WF_WORKASSIGNMENT_HISTORY. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:30  INFO    OGG-06509  Using the following key columns for source table CLM_TT.WF_WORKASSIGNMENT_HISTORY: WORK_ID_N, USER_GROUP_OPTN_V, USER_GROUP_ID_N, ASSIGNED_BY_N, ASSIGMENT_DATE_D, ASSIGN_FLAG_V.

2019-09-26 18:35:31  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CUST.GSM_HOME_CDRS): TABLE "CBS_CUST"."GSM_HOME_CDRS".

2019-09-26 18:35:31  WARNING OGG-06439  No unique key is defined for table GSM_HOME_CDRS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:31  INFO    OGG-06509  Using the following key columns for source table CBS_CUST.GSM_HOME_CDRS: TYPE_OF_CALL_V, SWITCH_CALL_TYPE_V, RECORD_TYPE_V, PROMOTION_CODE_V, IN_OUT_V, TARF_TYPE_V, CALL_CHRG_TYPE_V, FAX_DATA_VOICE_V, CALC_ON_V, PERCENTAGE_VAL_N, INTERIM_CALL_INDICATOR_V, CALL_SEQ_NUM_N, TELE_SERVICE_NUM_V, BEARER_SERVICE_NUM_V, SUPPLIMENTARY_NUM_V, TRANSMISSION_MODE_V, MS_CLASS_MARK_V, ACCOUNT_LINK_CODE_N, ROAM_SERVICE_PROVIDER_V, OFFLINE_DISC_OVER_V, CHRONO_NUM_N, CALL_DATE_DT, CALL_DURATION_N, SUMMARY_SEQ_NUM_N, ARTICLE_CODE_V, PRINT_IN_DTL_V, SINGLE_TARF_FLAG_V, LDC_FLAG_V, IMSI_NUM_N, MOBL_NUM_V, IMEI_NUM_V, ORGINATE_CELL_ID_V, BTS_SECTOR_V, MSC_NUM_V, CIRCUIT_ID_V, IN_TRUNK_V, OUT_TRUNK_V, NUM_PLAN_V, STD_CODE_LENGTH_N, CALLED_CALLING_NUM_V, ACTUAL_NUM_IF_FRWD_V, DIALED_DIGIT_V, UTC_OFFSET_TIME_N, UTC_INC_DEC_V, ICSRV_PROVIDER_CODE_V, IC_RATE_ZONE_V, IC_CONCT_ZONE_V, IC_SWITCH_PULSE_N, PULSE_CALC_SWITCH_V, COUNTRY_CODE_V, STATE_CODE_V, CITY_CODE_V, TARIFF_CODE_V, RATING_FILE_ID_N, DAY_CODE_V, TIME_BAND_V, IC_RATE_PLAN_CODE_N, IC_KEY_CODE_N, IC_VOICE_FRML_N, IC_VOICE_UNIT_RATE_N, IC_UNITS_N, IC_VOICE_AMT_N, IC_TAX_CODE_V, IC_TAX_AMT1_N, IC_TAX_AMT2_N, IC_TAX_AMT3_N, MOBL_ORIGINATE_ZONE_CODE_V, MOBL_TERMINATE_ZONE_CODE_V, AIRTM_RATE_PLAN_CODE_N, AIRTM_KEY_CODE_N, AIRTM_FRML_N, AIRTM_VOICE_UNIT_RATE_N, AIRTM_VOICE_UNITS_N, AIRTM_AMT_N, AIRTM_TAX_CODE_V, AIRTM_TAX_AMT1_N, AIRTM_TAX_AMT2_N, AIRTM_TAX_AMT3_N, DISC_TYPE_V, DISC_UNITS_N, LDC_RATING_ZONE_V, LDC_RATING_FRML_N, LDC_VOICE_UNIT_RATE_N, LDC_VOICE_UNITS_N, LDC_AMT_N, LDC_TAX_CODE_V, LDC_TAX_AMT1_N, LDC_TAX_AMT2_N, SURCHARGE_N, DESTINATION_TYPE_V, RATE_ON_V, DEST_SERVICE_TYPE_CODE_V, CONTENT_PROV_TARIFF_CODE_V, CONTENT_PROV_PLAN_CODE_N, SERVICE_CATEGORY_CODE_V, CHARGED_DURATION_N, DISC_QTM_TYPE_V, DISCOUNTED_VALUE_N, DISCOUNTED_AMOUNT_N, OUTPUT_DISC_ARTICLE_V, CHARGE_BEFORE_DISC_N, PROCESSED_DATE_D, BILL_CYCL_FULL_CODE_N, ACCOUNT_CODE_N, DISC_VARBL_CODE_V, PROCESS_FLAG_V, DISC_CODE_AMT_V, U_TYPE_DISC_AMT_V, A_TYPE_DISC_AMT_V, P_TYPE_DISC_AMT_V.

2019-09-26 18:35:31  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CUST.GSM_CYCLE_SUMMARY_DETAILS): TABLE "CBS_CUST"."GSM_CYCLE_SUMMARY_DETAILS".

2019-09-26 18:35:31  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CUST.GSM_HOME_CDRS): TABLE "CBS_CUST"."GSM_HOME_CDRS".

2019-09-26 18:35:31  INFO    OGG-06509  Using the following key columns for source table CBS_CUST.GSM_CYCLE_SUMMARY_DETAILS: ACCOUNT_LINK_CODE_N, SUMMARY_SEQ_NO_N, ARTICLE_CODE_V.

2019-09-26 18:35:31  WARNING OGG-06439  No unique key is defined for table GSM_HOME_CDRS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:31  INFO    OGG-06509  Using the following key columns for source table CBS_CUST.GSM_HOME_CDRS: TYPE_OF_CALL_V, SWITCH_CALL_TYPE_V, RECORD_TYPE_V, PROMOTION_CODE_V, IN_OUT_V, TARF_TYPE_V, CALL_CHRG_TYPE_V, FAX_DATA_VOICE_V, CALC_ON_V, PERCENTAGE_VAL_N, INTERIM_CALL_INDICATOR_V, CALL_SEQ_NUM_N, TELE_SERVICE_NUM_V, BEARER_SERVICE_NUM_V, SUPPLIMENTARY_NUM_V, TRANSMISSION_MODE_V, MS_CLASS_MARK_V, ACCOUNT_LINK_CODE_N, ROAM_SERVICE_PROVIDER_V, OFFLINE_DISC_OVER_V, CHRONO_NUM_N, CALL_DATE_DT, CALL_DURATION_N, SUMMARY_SEQ_NUM_N, ARTICLE_CODE_V, PRINT_IN_DTL_V, SINGLE_TARF_FLAG_V, LDC_FLAG_V, IMSI_NUM_N, MOBL_NUM_V, IMEI_NUM_V, ORGINATE_CELL_ID_V, BTS_SECTOR_V, MSC_NUM_V, CIRCUIT_ID_V, IN_TRUNK_V, OUT_TRUNK_V, NUM_PLAN_V, STD_CODE_LENGTH_N, CALLED_CALLING_NUM_V, ACTUAL_NUM_IF_FRWD_V, DIALED_DIGIT_V, UTC_OFFSET_TIME_N, UTC_INC_DEC_V, ICSRV_PROVIDER_CODE_V, IC_RATE_ZONE_V, IC_CONCT_ZONE_V, IC_SWITCH_PULSE_N, PULSE_CALC_SWITCH_V, COUNTRY_CODE_V, STATE_CODE_V, CITY_CODE_V, TARIFF_CODE_V, RATING_FILE_ID_N, DAY_CODE_V, TIME_BAND_V, IC_RATE_PLAN_CODE_N, IC_KEY_CODE_N, IC_VOICE_FRML_N, IC_VOICE_UNIT_RATE_N, IC_UNITS_N, IC_VOICE_AMT_N, IC_TAX_CODE_V, IC_TAX_AMT1_N, IC_TAX_AMT2_N, IC_TAX_AMT3_N, MOBL_ORIGINATE_ZONE_CODE_V, MOBL_TERMINATE_ZONE_CODE_V, AIRTM_RATE_PLAN_CODE_N, AIRTM_KEY_CODE_N, AIRTM_FRML_N, AIRTM_VOICE_UNIT_RATE_N, AIRTM_VOICE_UNITS_N, AIRTM_AMT_N, AIRTM_TAX_CODE_V, AIRTM_TAX_AMT1_N, AIRTM_TAX_AMT2_N, AIRTM_TAX_AMT3_N, DISC_TYPE_V, DISC_UNITS_N, LDC_RATING_ZONE_V, LDC_RATING_FRML_N, LDC_VOICE_UNIT_RATE_N, LDC_VOICE_UNITS_N, LDC_AMT_N, LDC_TAX_CODE_V, LDC_TAX_AMT1_N, LDC_TAX_AMT2_N, SURCHARGE_N, DESTINATION_TYPE_V, RATE_ON_V, DEST_SERVICE_TYPE_CODE_V, CONTENT_PROV_TARIFF_CODE_V, CONTENT_PROV_PLAN_CODE_N, SERVICE_CATEGORY_CODE_V, CHARGED_DURATION_N, DISC_QTM_TYPE_V, DISCOUNTED_VALUE_N, DISCOUNTED_AMOUNT_N, OUTPUT_DISC_ARTICLE_V, CHARGE_BEFORE_DISC_N, PROCESSED_DATE_D, BILL_CYCL_FULL_CODE_N, ACCOUNT_CODE_N, DISC_VARBL_CODE_V, PROCESS_FLAG_V, DISC_CODE_AMT_V, U_TYPE_DISC_AMT_V, A_TYPE_DISC_AMT_V, P_TYPE_DISC_AMT_V.

2019-09-26 18:35:31  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CUST.GSM_CYCLE_SUMMARY_DETAILS): TABLE "CBS_CUST"."GSM_CYCLE_SUMMARY_DETAILS".

2019-09-26 18:35:31  INFO    OGG-06509  Using the following key columns for source table CBS_CUST.GSM_CYCLE_SUMMARY_DETAILS: ACCOUNT_LINK_CODE_N, SUMMARY_SEQ_NO_N, ARTICLE_CODE_V.

2019-09-26 18:35:35  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CUST.GPRS_HOME_CDRS): TABLE "CBS_CUST"."GPRS_HOME_CDRS".

2019-09-26 18:35:35  WARNING OGG-06439  No unique key is defined for table GPRS_HOME_CDRS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:35  INFO    OGG-06509  Using the following key columns for source table CBS_CUST.GPRS_HOME_CDRS: TYPE_OF_CALL_V, SWITCH_CALL_TYPE_V, RECORD_TYPE_V, TARF_TYPE_V, PROMOTION_CODE_V, CALL_CHRG_TYPE_V, CALC_ON_V, PERCENTAGE_VAL_N, INTERIM_CALL_INDICATOR_V, CALL_SEQ_NUM_N, ACCOUNT_LINK_CODE_N, OFFLINE_DISC_OVER_V, CHRONO_NUM_N, CALL_DATE_DT, CALL_DURATION_N, SUMMARY_SEQ_NUM_N, ARTICLE_CODE_V, KEY_CODE_N, PRINT_IN_DTL_V, SINGLE_TARF_FLAG_V, IMSI_NUM_N, MOBL_NUM_V, IMEI_NUM_V, ORGINATE_CELL_ID_V, TARIFF_CODE_V, RATE_PLAN_CODE_N, RATE_PLAN_KEY_N, RATING_FIELD_ID_N, DAY_CODE_V, TIME_BAND_V, MULTI_RATE_INDICATOR_V, CDR_CHRONO_NUMBER_N, DISC_TYPE_V, DISC_UNITS_N, TYPE_OF_CONTROLLING_NODE_V, PDP_TYPE_V, PDP_ADDRESS_V, CHARGING_CHARACTERISTICS_V, APN_CODE_V, CALL_TERMINATION_CAUSE_V, PARTIAL_TYPE_INDICATOR_V, CHARGING_ID_N, QOS_REQUESTED_1_V, QOS_USED_1_V, DATA_VOLUME_INCOMING_1_N, DATA_VOLUME_OUTGOING_1_N, OUTGOING_UNITS_1_N, INCOMING_UNITS_1_N, OUTGOING_AMOUNT_1_N, INCOMING_AMOUNT_1_N, QOS_REQUESTED_2_V, QOS_USED_2_V, DATA_VOLUME_INCOMING_2_N, DATA_VOLUME_OUTGOING_2_N, OUTGOING_UNITS_2_N, INCOMING_UNITS_2_N, OUTGOING_AMOUNT_2_N, INCOMING_AMOUNT_2_N, QOS_REQUESTED_3_V, QOS_USED_3_V, DATA_VOLUME_INCOMING_3_N, DATA_VOLUME_OUTGOING_3_N, OUTGOING_UNITS_3_N, INCOMING_UNITS_3_N, OUTGOING_AMOUNT_3_N, INCOMING_AMOUNT_3_N, CHARGED_ITEM_V, TOT_CHARGE_N, CHARGED_UNITS_N, TAX_CODE_V, TAX_AMT_1_N, TAX_AMT_2_N, TAX_AMT_3_N, GGSN_ADDRESS_V, SGSN_ADDRESS_V, CHARGE_AT_V, UPLOAD_VOL_FRML_CODE_N, DOWNLOAD_VOL_FRML_CODE_N, DURATION_FRML_CODE_N, DURATION_AMT_N, SESSION_FEE_N, DESTINATION_TYPE_V, RATE_ON_V, DEST_SERVICE_TYPE_CODE_V, MOBL_ORIGINATE_ZONE_CODE_V, ACCESS_POINT_NAME_V, DURATION_UNITS, VOLUME_CONS_SEP_V, CHARGED_DURATION_N, CHARGED_VOLUME_N, DISC_QTM_TYPE_V, DISCOUNTED_VALUE_N, DISCOUNTED_AMOUNT_N, OUTPUT_DISC_ARTICLE_V, CHARGE_BEFORE_DISC_N, PROCESSED_DATE_D, BILL_CYCL_FULL_CODE_N, ACCOUNT_CODE_N, DISC_CODE_AMT_V, U_TYPE_DISC_AMT_V, A_TYPE_DISC_AMT_V, P_TYPE_DISC_AMT_V.

2019-09-26 18:35:35  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CUST.GPRS_HOME_CDRS): TABLE "CBS_CUST"."GPRS_HOME_CDRS".

2019-09-26 18:35:35  WARNING OGG-06439  No unique key is defined for table GPRS_HOME_CDRS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:35:35  INFO    OGG-06509  Using the following key columns for source table CBS_CUST.GPRS_HOME_CDRS: TYPE_OF_CALL_V, SWITCH_CALL_TYPE_V, RECORD_TYPE_V, TARF_TYPE_V, PROMOTION_CODE_V, CALL_CHRG_TYPE_V, CALC_ON_V, PERCENTAGE_VAL_N, INTERIM_CALL_INDICATOR_V, CALL_SEQ_NUM_N, ACCOUNT_LINK_CODE_N, OFFLINE_DISC_OVER_V, CHRONO_NUM_N, CALL_DATE_DT, CALL_DURATION_N, SUMMARY_SEQ_NUM_N, ARTICLE_CODE_V, KEY_CODE_N, PRINT_IN_DTL_V, SINGLE_TARF_FLAG_V, IMSI_NUM_N, MOBL_NUM_V, IMEI_NUM_V, ORGINATE_CELL_ID_V, TARIFF_CODE_V, RATE_PLAN_CODE_N, RATE_PLAN_KEY_N, RATING_FIELD_ID_N, DAY_CODE_V, TIME_BAND_V, MULTI_RATE_INDICATOR_V, CDR_CHRONO_NUMBER_N, DISC_TYPE_V, DISC_UNITS_N, TYPE_OF_CONTROLLING_NODE_V, PDP_TYPE_V, PDP_ADDRESS_V, CHARGING_CHARACTERISTICS_V, APN_CODE_V, CALL_TERMINATION_CAUSE_V, PARTIAL_TYPE_INDICATOR_V, CHARGING_ID_N, QOS_REQUESTED_1_V, QOS_USED_1_V, DATA_VOLUME_INCOMING_1_N, DATA_VOLUME_OUTGOING_1_N, OUTGOING_UNITS_1_N, INCOMING_UNITS_1_N, OUTGOING_AMOUNT_1_N, INCOMING_AMOUNT_1_N, QOS_REQUESTED_2_V, QOS_USED_2_V, DATA_VOLUME_INCOMING_2_N, DATA_VOLUME_OUTGOING_2_N, OUTGOING_UNITS_2_N, INCOMING_UNITS_2_N, OUTGOING_AMOUNT_2_N, INCOMING_AMOUNT_2_N, QOS_REQUESTED_3_V, QOS_USED_3_V, DATA_VOLUME_INCOMING_3_N, DATA_VOLUME_OUTGOING_3_N, OUTGOING_UNITS_3_N, INCOMING_UNITS_3_N, OUTGOING_AMOUNT_3_N, INCOMING_AMOUNT_3_N, CHARGED_ITEM_V, TOT_CHARGE_N, CHARGED_UNITS_N, TAX_CODE_V, TAX_AMT_1_N, TAX_AMT_2_N, TAX_AMT_3_N, GGSN_ADDRESS_V, SGSN_ADDRESS_V, CHARGE_AT_V, UPLOAD_VOL_FRML_CODE_N, DOWNLOAD_VOL_FRML_CODE_N, DURATION_FRML_CODE_N, DURATION_AMT_N, SESSION_FEE_N, DESTINATION_TYPE_V, RATE_ON_V, DEST_SERVICE_TYPE_CODE_V, MOBL_ORIGINATE_ZONE_CODE_V, ACCESS_POINT_NAME_V, DURATION_UNITS, VOLUME_CONS_SEP_V, CHARGED_DURATION_N, CHARGED_VOLUME_N, DISC_QTM_TYPE_V, DISCOUNTED_VALUE_N, DISCOUNTED_AMOUNT_N, OUTPUT_DISC_ARTICLE_V, CHARGE_BEFORE_DISC_N, PROCESSED_DATE_D, BILL_CYCL_FULL_CODE_N, ACCOUNT_CODE_N, DISC_CODE_AMT_V, U_TYPE_DISC_AMT_V, A_TYPE_DISC_AMT_V, P_TYPE_DISC_AMT_V.

2019-09-26 18:35:41  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.inv_serial_items): TABLE "CBS_CORE"."INV_SERIAL_ITEMS".

2019-09-26 18:35:41  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.INV_SERIAL_ITEMS: ITEM_CODE_N, SERIAL_NO_V.

2019-09-26 18:35:41  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.inv_serial_items): TABLE "CBS_CORE"."INV_SERIAL_ITEMS".

2019-09-26 18:35:41  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.INV_SERIAL_ITEMS: ITEM_CODE_N, SERIAL_NO_V.

2019-09-26 18:35:45  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.GSM_SERVICE_MAST): TABLE  "CBS_CORE"."GSM_SERVICE_MAST".

2019-09-26 18:35:45  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.GSM_SERVICE_MAST: ACCOUNT_LINK_CODE_N.

2019-09-26 18:35:45  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.GSM_SERVICE_MAST): TABLE  "CBS_CORE"."GSM_SERVICE_MAST".

2019-09-26 18:35:45  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.GSM_SERVICE_MAST: ACCOUNT_LINK_CODE_N.

2019-09-26 18:35:55  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_SUBS_OFFER_DETAILS): TABLE  "CBS_CORE"."CB_SUBS_OFFER_DETAILS".

2019-09-26 18:35:55  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SUBS_OFFER_DETAILS: ACCOUNT_LINK_CODE_N, OFFER_CODE_V, FACILITY_REF_ID_V.

2019-09-26 18:35:55  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_SUBS_OFFER_DETAILS): TABLE  "CBS_CORE"."CB_SUBS_OFFER_DETAILS".

2019-09-26 18:35:55  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SUBS_OFFER_DETAILS: ACCOUNT_LINK_CODE_N, OFFER_CODE_V, FACILITY_REF_ID_V.

2019-09-26 18:36:12  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_SUBS_PAID_ADV_DTLS): TABLE "CBS_CORE"."CB_SUBS_PAID_ADV_DTLS".

2019-09-26 18:36:12  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SUBS_PAID_ADV_DTLS: RECEIPT_NO_V, MAIN_ACCOUNT_LINK_CODE_N, SERV_ACC_LINK_CODE_N.

2019-09-26 18:36:13  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_SUBS_PAID_ADV_DTLS): TABLE "CBS_CORE"."CB_SUBS_PAID_ADV_DTLS".

2019-09-26 18:36:13  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SUBS_PAID_ADV_DTLS: RECEIPT_NO_V, MAIN_ACCOUNT_LINK_CODE_N, SERV_ACC_LINK_CODE_N.

2019-09-26 18:36:49  INFO    OGG-01021  Command received from GGSCI: STATUS.

2019-09-26 18:37:19  INFO    OGG-01971  The previous message, 'INFO OGG-01021', repeated 2 times.

2019-09-26 18:38:04  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CUST.FXL_RATED_CDRS): TABLE "CBS_CUST"."FXL_RATED_CDRS".

2019-09-26 18:38:04  INFO    OGG-06509  Using the following key columns for source table CBS_CUST.FXL_RATED_CDRS: SWITCH_CALL_TYPE_V, ACCOUNT_LINK_CODE_N, CALL_DATE_DT, CALLED_CALLING_NUM_V, EXTN_NUMBER_V.

2019-09-26 18:38:04  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.fxl_cycle_summary_details): TABLE  "CBS_CORE"."FXL_CYCLE_SUMMARY_DETAILS".

2019-09-26 18:38:04  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.FXL_CYCLE_SUMMARY_DETAILS: ACCOUNT_LINK_CODE_N, SUMMARY_SEQ_NO_N, ARTICLE_CODE_V.

2019-09-26 18:38:05  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CUST.FXL_RATED_CDRS): TABLE "CBS_CUST"."FXL_RATED_CDRS".

2019-09-26 18:38:05  INFO    OGG-06509  Using the following key columns for source table CBS_CUST.FXL_RATED_CDRS: SWITCH_CALL_TYPE_V, ACCOUNT_LINK_CODE_N, CALL_DATE_DT, CALLED_CALLING_NUM_V, EXTN_NUMBER_V.

2019-09-26 18:38:05  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.fxl_cycle_summary_details): TABLE  "CBS_CORE"."FXL_CYCLE_SUMMARY_DETAILS".

2019-09-26 18:38:05  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.FXL_CYCLE_SUMMARY_DETAILS: ACCOUNT_LINK_CODE_N, SUMMARY_SEQ_NO_N, ARTICLE_CODE_V.

2019-09-26 18:43:33  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_CALCULATED_CHARGES): TABLE "CBS_CORE"."CB_CALCULATED_CHARGES".

2019-09-26 18:43:33  WARNING OGG-06439  No unique key is defined for table CB_CALCULATED_CHARGES. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:43:33  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_CALCULATED_CHARGES: SERV_ACC_LINK_CODE_N, SUBSIDIARY_CODE_V, SERVICE_CODE_V, SCHEME_REF_CODE_N, FINACC_CATEGORY_V, ARTICLE_CODE_V, SCHEME_ARTICLE_REFER_ID_N, DB_CR_V, BILLED_DATE_D, SCHEME_CURRENCY_CODE_V, PREFERRED_CURRENCY_CODE_V, EXCHNG_RATE_ON_INCLUSION_N, EXCHNG_RATE_ON_INVOICE_N, ARTICLE_AMT_N, AMT_IN_PREFERD_CURRNCY_N, DISCOUNT_AMT_N, TAX_OPTN_V, TAX_PLAN_CODE_V, PROFIT_COST_CENTER_OPTN_V, PROFIT_COST_CENTER_V, GL_CODE_N, ON_CREDIT_FLG_V, STATUS_OPTN_V, PART_OF_INVOICE_FLG_V, POSTED_TO_REVENUE_FLG_V, RESOURCE_TYPE_V, RESOURCE_REFERENCE_ID_V, BILL_CYCL_FULL_CODE_N, TRANS_SOURCE_OPTN_V, TRANS_SOURCE_REFR_NO_V, ORDER_REF_NO_V, TRANS_NUM_V, DESCRIPTION_V, SCHEME_AMOUNT_N.

2019-09-26 18:43:34  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_CALCULATED_CHARGES): TABLE "CBS_CORE"."CB_CALCULATED_CHARGES".

2019-09-26 18:43:34  WARNING OGG-06439  No unique key is defined for table CB_CALCULATED_CHARGES. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:43:34  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_CALCULATED_CHARGES: SERV_ACC_LINK_CODE_N, SUBSIDIARY_CODE_V, SERVICE_CODE_V, SCHEME_REF_CODE_N, FINACC_CATEGORY_V, ARTICLE_CODE_V, SCHEME_ARTICLE_REFER_ID_N, DB_CR_V, BILLED_DATE_D, SCHEME_CURRENCY_CODE_V, PREFERRED_CURRENCY_CODE_V, EXCHNG_RATE_ON_INCLUSION_N, EXCHNG_RATE_ON_INVOICE_N, ARTICLE_AMT_N, AMT_IN_PREFERD_CURRNCY_N, DISCOUNT_AMT_N, TAX_OPTN_V, TAX_PLAN_CODE_V, PROFIT_COST_CENTER_OPTN_V, PROFIT_COST_CENTER_V, GL_CODE_N, ON_CREDIT_FLG_V, STATUS_OPTN_V, PART_OF_INVOICE_FLG_V, POSTED_TO_REVENUE_FLG_V, RESOURCE_TYPE_V, RESOURCE_REFERENCE_ID_V, BILL_CYCL_FULL_CODE_N, TRANS_SOURCE_OPTN_V, TRANS_SOURCE_REFR_NO_V, ORDER_REF_NO_V, TRANS_NUM_V, DESCRIPTION_V, SCHEME_AMOUNT_N.

2019-09-26 18:44:16  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.cb_serv_installment_dtls): TABLE "CBS_CORE"."CB_SERV_INSTALLMENT_DTLS".

2019-09-26 18:44:16  WARNING OGG-06439  No unique key is defined for table CB_SERV_INSTALLMENT_DTLS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:44:16  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SERV_INSTALLMENT_DTLS: SERV_ACC_LINK_CODE_N, CHARGE_CODE_V, CHARGE_START_DATE_D, CHARGE_END_DATE_D, CHARGE_STATUS_V, CHARGE_POSTED_REF_NO_V, CHARGE_POSTED_DATE_D, INSTALLMENT_AMOUNT_N, ORDER_REF_NUM_V, SCHEME_REF_CODE_N, ITEM_CODE_N, INSTALLMENT_TYPE_V, ITEM_CHARGE_CODE_V.

2019-09-26 18:44:17  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.cb_serv_installment_dtls): TABLE "CBS_CORE"."CB_SERV_INSTALLMENT_DTLS".

2019-09-26 18:44:17  WARNING OGG-06439  No unique key is defined for table CB_SERV_INSTALLMENT_DTLS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 18:44:17  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_SERV_INSTALLMENT_DTLS: SERV_ACC_LINK_CODE_N, CHARGE_CODE_V, CHARGE_START_DATE_D, CHARGE_END_DATE_D, CHARGE_STATUS_V, CHARGE_POSTED_REF_NO_V, CHARGE_POSTED_DATE_D, INSTALLMENT_AMOUNT_N, ORDER_REF_NUM_V, SCHEME_REF_CODE_N, ITEM_CODE_N, INSTALLMENT_TYPE_V, ITEM_CHARGE_CODE_V.

2019-09-26 19:06:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_BATCH_DETAILS): TABLE "CBS_CORE"."CB_BATCH_DETAILS".

2019-09-26 19:06:30  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_BATCH_DETAILS: BATCH_ID_V, REF_NUM_N, BILL_CYCLE_FULL_CODE_N, BILL_RUN_TYPE_V.

2019-09-26 19:06:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_BATCH_CRITERIA_DETAILS): TABLE "CBS_CORE"."CB_BATCH_CRITERIA_DETAILS".

2019-09-26 19:06:30  WARNING OGG-06439  No unique key is defined for table CB_BATCH_CRITERIA_DETAILS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 19:06:30  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_BATCH_CRITERIA_DETAILS: BATCH_ID_V, CRITERIA_ID_N, SERVICE_TYPE_V, BILL_REGION_V, CATEGORY_V, PACKAGE_CODE_V, START_ACC_NO_N, END_ACC_NO_N, START_SERV_ACC_NO_N, END_SERV_ACC_NO_N, BATCH_TYPE_V, BILL_GROUP_ID_N.

2019-09-26 19:06:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_BATCH_DETAILS): TABLE "CBS_CORE"."CB_BATCH_DETAILS".

2019-09-26 19:06:30  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_BATCH_DETAILS: BATCH_ID_V, REF_NUM_N, BILL_CYCLE_FULL_CODE_N, BILL_RUN_TYPE_V.

2019-09-26 19:06:30  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.CB_BATCH_CRITERIA_DETAILS): TABLE "CBS_CORE"."CB_BATCH_CRITERIA_DETAILS".

2019-09-26 19:06:30  WARNING OGG-06439  No unique key is defined for table CB_BATCH_CRITERIA_DETAILS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-09-26 19:06:30  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_BATCH_CRITERIA_DETAILS: BATCH_ID_V, CRITERIA_ID_N, SERVICE_TYPE_V, BILL_REGION_V, CATEGORY_V, PACKAGE_CODE_V, START_ACC_NO_N, END_ACC_NO_N, START_SERV_ACC_NO_N, END_SERV_ACC_NO_N, BATCH_TYPE_V, BILL_GROUP_ID_N.

2019-09-26 19:08:01  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.cb_batch_process_metrics): TABLE "CBS_CORE"."CB_BATCH_PROCESS_METRICS".

2019-09-26 19:08:01  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_BATCH_PROCESS_METRICS: BATCH_ID_V, PROCESSING_STAGE_V.

2019-09-26 19:08:02  INFO    OGG-06507  MAP (TABLE) resolved (entry CBS_CORE.cb_batch_process_metrics): TABLE "CBS_CORE"."CB_BATCH_PROCESS_METRICS".

2019-09-26 19:08:02  INFO    OGG-06509  Using the following key columns for source table CBS_CORE.CB_BATCH_PROCESS_METRICS: BATCH_ID_V, PROCESSING_STAGE_V.

2019-09-26 19:55:46  INFO    OGG-01026  Rolling over remote file /ogg/ora12c/dirdat/aa000000229.
