
***********************************************************************
                 Oracle GoldenGate Delivery 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:16
 
Copyright (C) 1995, 2018, Oracle and/or its affiliates. All rights reserved.

                    Starting at 2019-09-26 19:48:10
***********************************************************************

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: 19071

Description: 

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

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

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

2019-09-26 19:48:16  INFO    OGG-01360  REPLICAT is running in Integrated mode.
REPLICAT REPLOGGT
ASSUMETARGETDEFS
DDLOPTIONS REPORT
USERIDALIAS oraggext
ddl include mapped
MAP CBS_CORE.CB_SUB_INVOICE,TARGET CBSOGG.CB_SUB_INVOICE;
MAP CBS_CORE.CB_INVOICE,TARGET CBSOGG.CB_INVOICE;
MAP CBS_CORE.CB_ADDRESS_XML, TARGET CBSOGG.CB_ADDRESS_XML;
MAP CBS_CORE.CB_SUB_AR_AP,TARGET CBSOGG.CB_SUB_AR_AP ;
MAP CBS_CORE.CB_RECEIPTS,TARGET CBSOGG.CB_RECEIPTS;
MAP CBS_CORE.CB_ACCS_RECEIVE_PAY_ADJUST,TARGET CBSOGG.CB_ACCS_RECEIVE_PAY_ADJUST;
MAP CBS_CORE.CB_SUBS_REFUND,TARGET CBSOGG.CB_SUBS_REFUND  ;
MAP CBS_CORE.GSM_SERVICE_MAST,TARGET CBSOGG.GSM_SERVICE_MAST   ;
MAP CBS_CORE.CB_PAY_MODE_DTLS,TARGET CBSOGG.CB_PAY_MODE_DTLS   ;
MAP CBS_CORE.CB_ACCOUNT_SERVICE_LIST,TARGET CBSOGG.CB_ACCOUNT_SERVICE_LIST ;
MAP CBS_CORE.CB_ACCOUNT_RECEIVE_PAY,TARGET CBSOGG.CB_ACCOUNT_RECEIVE_PAY  ;
MAP CBS_CORE.CB_ACCOUNT_MASTER,TARGET CBSOGG.CB_ACCOUNT_MASTER  ;
MAP CBS_CORE.CB_INVOICE_DETAILS,TARGET CBSOGG.CB_INVOICE_DETAILS ;
MAP CBS_CUST.CB_POS_TRANS_DTLS,TARGET CBSOGG.CB_POS_TRANS_DTLS  ;
MAP CBS_CUST.CB_POS_TRANSACTIONS,TARGET CBSOGG.CB_POS_TRANSACTIONS;
MAP CBS_CORE.CB_RECEIPTS_ADJUST,TARGET CBSOGG.CB_RECEIPTS_ADJUST    ;
MAP CBS_CORE.CB_CALCULATED_CHARGES,TARGET CBSOGG.CB_CALCULATED_CHARGES ;
MAP CBS_CORE.CB_RECEIPTS_ADJUST,TARGET CBSOGG.CB_RECEIPTS_ADJUST ;
MAP CBS_CORE.FXL_CYCLE_SUMMARY_DETAILS,TARGET CBSOGG.FXL_CYCLE_SUMMARY_DETAILS ;
MAP CBS_CORE.CB_SUBSCRIBER_MASTER,target cbsogg.CB_SUBSCRIBER_MASTER  ;
MAP CBS_CORE.CB_SUBS_POS_SERVICES,target cbsogg.CB_SUBS_POS_SERVICES ;
MAP CBS_CORE.CB_CR_DB_NOTES,target cbsogg.CB_CR_DB_NOTES   ;
MAP CBS_CUST.CB_MULTI_ACCT_RECEIPT_DETAILS,target CBSOGG.CB_MULTI_ACCT_RECEIPT_DETAILS ;
MAP CBS_CUST.CB_MULTI_ACCT_INVOICE_DETAILS,target CBSOGG.CB_MULTI_ACCT_INVOICE_DETAILS ;
MAP CBS_CORE.CB_SUBS_OFFER_DETAILS,TARGET CBSOGG.CB_SUBS_OFFER_DETAILS,KEYCOLS(ACCOUNT_LINK_CODE_N,FACILITY_REF_ID_V,OFFER_CODE_V);
MAP CBS_CORE.CB_SUBS_INFORMATION_MASTER,TARGET CBSOGG.CB_SUBS_INFORMATION_MASTER,FILTER ( @GETENV ('TRANSACTION', 'CSN') > 266550779456)  ;
MAP TT_MSO.CB_SELFCARE_USERS,TARGET CBSOGG.CB_SELFCARE_USERS,FILTER ( @GETENV ('TRANSACTION', 'CSN') > 266550779456)  ;
MAP TT_MSO.TMP_REPORT_ENT_SELFCARE,TARGET CBSOGG.TMP_REPORT_ENT_SELFCARE,FILTER ( @GETENV ('TRANSACTION', 'CSN') > 266550779456)  ;
MAP CBS_CORE.CB_SUBS_PAID_ADV_DTLS,TARGET CBSOGG.CB_SUBS_PAID_ADV_DTLS;
MAP CBS_CORE.CB_SUBS_PROVISIONING,TARGET CBSOGG.CB_SUBS_PROVISIONING ;
MAP CLM_TT.TT_TICKETINFO,TARGET CBSOGG.TT_TICKETINFO;
MAP CLM_TT.TT_CATEGORY_MASTER,TARGET CBSOGG.TT_CATEGORY_MASTER ;
MAP CLM_TT.WF_TODOITEM_HISTORY,TARGET CBSOGG.WF_TODOITEM_HISTORY ;
MAP CLM_TT.TT_TICKET_ADDNL_INFO,TARGET CBSOGG.TT_TICKET_ADDNL_INFO,keycols(DOCKET_NUMBER_N) ;
MAP CLM_TT.WF_WORKFLOW,TARGET CBSOGG.WF_WORKFLOW ;
MAP CLM_TT.WF_WORKASSIGNMENT_HISTORY,TARGET CBSOGG.WF_WORKASSIGNMENT_HISTORY ;
MAP CLM_TT.WF_WORKASSIGNMENT,TARGET CBSOGG.WF_WORKASSIGNMENT ;
MAP CLM_TT.WF_TODOITEM,TARGET CBSOGG.WF_TODOITEM ;
MAP CLM_TT.TT_TICKETINCIDENT,TARGET CBSOGG.TT_TICKETINCIDENT ;
MAP CBS_CORE.WF_USERGROUP, TARGET CBSOGG.WF_USERGROUP;
MAP CBS_CORE.CB_USER_GROUP, TARGET CBSOGG.CB_USER_GROUP ;
MAP CBS_CORE.CB_USERS, TARGET CBSOGG.CB_USERS ;
MAP CBS_CORE.CB_SUB_SERVICES, TARGET CBSOGG.CB_SUB_SERVICES ;
MAP CBS_CORE.CB_BANK_MASTER, TARGET CBSOGG.CB_BANK_MASTER ;
MAP CBS_CORE.CB_SUBSCRIBER_SUB_CATEGORY, TARGET CBSOGG.CB_SUBSCRIBER_SUB_CATEGORY ;
MAP CBS_CORE.CB_SUBSCRIBER_CATEGORY, TARGET CBSOGG.CB_SUBSCRIBER_CATEGORY ;
MAP CBS_CORE.CB_RETAIL_OUTLETS, TARGET CBSOGG.CB_RETAIL_OUTLETS ;
MAP CBS_CORE.CB_ADVANCE_RENTAL, TARGET CBSOGG.CB_ADVANCE_RENTAL ;
MAP CBS_CORE.CB_PACKAGE, TARGET CBSOGG.CB_PACKAGE ;
MAP CBS_CORE.CB_OFFERS, TARGET CBSOGG.CB_OFFERS ;
MAP CBS_CORE.CB_DEALER_MASTER, TARGET CBSOGG.CB_DEALER_MASTER ;
MAP CBS_CORE.CB_ARTICLE_GROUPS, TARGET CBSOGG.CB_ARTICLE_GROUPS ;
MAP CBS_CORE.CB_ARTICLES, TARGET CBSOGG.CB_ARTICLES ;
MAP CBS_CORE.PS_ACTION, TARGET CBSOGG.PS_ACTION ;
MAP CBS_CORE.CB_STATUS_MASTER, TARGET CBSOGG.CB_STATUS_MASTER ;
MAP CBS_CORE.CB_SERVICES, TARGET CBSOGG.CB_SERVICES ;
MAP CBS_CORE.CB_PAYMENT_METHODS, TARGET CBSOGG.CB_PAYMENT_METHODS ;
MAP CBS_CORE.CB_SCHEME_REFERENCE, TARGET CBSOGG.CB_SCHEME_REFERENCE ;
MAP CBS_CORE.CB_CANCEL_RECEIPTS, TARGET CBSOGG.CB_CANCEL_RECEIPTS ;
MAP CBS_CORE.FXL_SERVICE_MAST, TARGET CBSOGG.FXL_SERVICE_MAST ;
MAP CBS_CORE.CB_POS_SERVICES, TARGET CBSOGG.CB_POS_SERVICES ;
MAP CBS_CORE.CB_WORK_ORDER_PRODUCT_DTLS, TARGET CBSOGG.CB_WORK_ORDER_PRODUCT_DTLS ;
MAP CBS_CORE.CB_REASON_MASTER, TARGET CBSOGG.CB_REASON_MASTER ;
MAP CBS_CORE.CB_POS_SERVICES_PARAMS, TARGET CBSOGG.CB_POS_SERVICES_PARAMS ;
MAP CBS_CORE.cb_order_request_dtls, TARGET CBSOGG.cb_order_request_dtls ;
MAP CBS_CORE.WF_WRKFLWMGR, TARGET CBSOGG.WF_WRKFLWMGR ;
MAP CBS_CORE.CB_INSTALLMENT, TARGET CBSOGG.CB_INSTALLMENT ;
MAP CBS_CORE.CB_INSTALLMENT_DTLS, TARGET CBSOGG.CB_INSTALLMENT_DTLS ;
MAP CBS_CORE.cb_serv_installment_dtls, TARGET CBSOGG.cb_serv_installment_dtls ;
MAP CBS_CORE.cb_subs_deposits, TARGET CBSOGG.cb_subs_deposits ;
MAP CBS_CORE.cb_bill_cycle, TARGET CBSOGG.cb_bill_cycle ;
MAP CBS_CUST.CB_DID_HEADER_MAP, TARGET CBSOGG.CB_DID_HEADER_MAP ;
MAP CBS_CORE.CB_REVENUE, TARGET CBSOGG.CB_REVENUE ;
MAP CBS_CORE.CB_SAP_GL_SL_CODES, TARGET CBSOGG.CB_SAP_GL_SL_CODES ;
MAP CBS_CORE.CB_SCHEDULES, TARGET CBSOGG.CB_SCHEDULES,FILTER ( @GETENV ('TRANSACTION', 'CSN') > 266550779456) ;
MAP CBS_CORE.cb_batch_process_metrics, TARGET CBSOGG.cb_batch_process_metrics ;
MAP CBS_CORE.CB_BATCH_CRITERIA_DETAILS, TARGET CBSOGG.CB_BATCH_CRITERIA_DETAILS ;
MAP CBS_CORE.inv_stock_summary, TARGET CBSOGG.inv_stock_summary ;

2019-09-26 19:48:18  INFO    OGG-06451  Triggers will be suppressed by default.

2019-09-26 19:48:18  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.

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 19:48:18  INFO    OGG-06604  Database DWARE1 CPU info: CPU Count 16, CPU Core Count 2, CPU Socket Count 1.

2019-09-26 19:48:18  WARNING OGG-05673  CSN-based duplicate suppression is disabled because there is no checkpoint table for this Replicat.

2019-09-26 19:48:18  INFO    OGG-02545  Parameter GROUPTRANSOPS is ignored by Integrated Replicat when parallelism is greater than 1.

2019-09-26 19:48:18  INFO    OGG-02527  Integrated Replicat does not populate a trace table.

2019-09-26 19:48:20  INFO    OGG-02530  Integrated replicat successfully attached to inbound server OGG$REPLOGGT.

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


2019-09-26 19:48:20  INFO    OGG-02243  Opened trail file /ogg/ora12c/dirdat/cd000000233 at 2019-09-26 19:48:20.184260.

2019-09-26 19:48:20  WARNING OGG-02760  ASSUMETARGETDEFS is ignored because trail file /ogg/ora12c/dirdat/cd000000233 contains table definitions.

2019-09-26 19:48:20  INFO    OGG-03522  Setting session time zone to source database time zone '+04:00'.

2019-09-26 19:48:20  INFO    OGG-03506  The source database character set, as determined from the trail file, is we8mswin1252.

2019-09-26 19:48:20  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_SUBS_POS_SERVICES): MAP "CBS_CORE"."CB_SUBS_POS_SERVICES",target cbsogg.CB_SUBS_POS_SERVICES.

2019-09-26 19:48:23  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 19:48:23  INFO    OGG-02756  The definition for table CBS_CORE.CB_SUBS_POS_SERVICES is obtained from the trail file.

2019-09-26 19:48:23  INFO    OGG-06511  Using following columns in default map by name: 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 19:48:23  INFO    OGG-06510  Using the following key columns for target table CBSOGG.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 19:48:23  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_SCHEDULES): MAP "CBS_CORE"."CB_SCHEDULES", TARGET CBSOGG.CB_SCHEDULES,FILTER ( @GETENV ('TRANSACTION', 'CSN') > 266550779456).

2019-09-26 19:48:23  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 19:48:23  INFO    OGG-02756  The definition for table CBS_CORE.CB_SCHEDULES is obtained from the trail file.

2019-09-26 19:48:23  INFO    OGG-06511  Using following columns in default map by name: 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 19:48:23  INFO    OGG-06510  Using the following key columns for target table CBSOGG.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 19:48:23  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_SUBS_PROVISIONING): MAP "CBS_CORE"."CB_SUBS_PROVISIONING",TARGET CBSOGG.CB_SUBS_PROVISIONING.

2019-09-26 19:48:23  INFO    OGG-02756  The definition for table CBS_CORE.CB_SUBS_PROVISIONING is obtained from the trail file.

2019-09-26 19:48:23  INFO    OGG-06511  Using following columns in default map by name: CHRONO_NUM_N, ACTION_CODE_V, ACTION_DATE_DT, ACCOUNT_LINK_CODE_N, SERVICE_ID_V, SERVICE_CODE_V, SUB_SERVICE_CODE_V, STATUS_V, SWITCH_NUM_N, USER_CODE_N, EXECUTION_DATE_DT, NO_OF_TIMES_EXECUTED_N, REMARK_V, TOTAL_COMMANDS_SENT_N, TOTAL_RESPONSE_RECEIVED_N, ABILLITY_KEY_CODE_V, REQUEST_OBJECT_X, RESPONSE_OBJECT_X, PROCESS_NO_N, CAI_CMD_REQ_STRING, CAI_CMD_RESP_STRING, DEP_PROCESS_SEQ_NO_N, ORDER_REF_NO_V, SCHEME_REF_CODE_N, ACK_DATE_DT, PROCESS_ID_N, INSTANCE_ID_N, URL_V.

2019-09-26 19:48:23  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_SUBS_PROVISIONING: CHRONO_NUM_N, PROCESS_NO_N.


2019-09-26 19:48:23  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_WORK_ORDER_PRODUCT_DTLS): MAP "CBS_CORE"."CB_WORK_ORDER_PRODUCT_DTLS", TARGET CBSOGG.CB_WORK_ORDER_PRODUCT_DTLS.

2019-09-26 19:48:23  INFO    OGG-02756  The definition for table CBS_CORE.CB_WORK_ORDER_PRODUCT_DTLS is obtained from the trail file.

2019-09-26 19:48:23  INFO    OGG-06511  Using following columns in default map by name: TMP_SEQUENCE_NUMBER_N, ACCOUNT_LINK_CODE_N, SERVICE_CODE_V, CONTRACT_TYPE_V, SERV_ACCOUNT_LINK_CODE_N, SERVICE_KEY_CODE_V, SCHEME_REF_CODE_N, SCHEME_TYPE_V, CHARGE_UPFRONT_FLG_V, ORDER_REFERENCE_NO_V, SERIAL_NUM_N, DEVICE_CHARGE_FLG_V, SERVICE_ID_V, FACILITY_REF_ID_V, QUANTITY_N.

2019-09-26 19:48:23  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_WORK_ORDER_PRODUCT_DTLS: TMP_SEQUENCE_NUMBER_N, SCHEME_REF_CODE_N, SERIAL_NUM_N, SERVICE_KEY_CODE_V, FACILITY_REF_ID_V.


2019-09-26 19:48:23  INFO    OGG-06505  MAP resolved (entry CBS_CORE.cb_order_request_dtls): MAP "CBS_CORE"."CB_ORDER_REQUEST_DTLS", TARGET CBSOGG.cb_order_request_dtls.

2019-09-26 19:48:25  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 19:48:25  INFO    OGG-02756  The definition for table CBS_CORE.CB_ORDER_REQUEST_DTLS is obtained from the trail file.

2019-09-26 19:48:25  INFO    OGG-06511  Using following columns in default map by name: TRANS_DATE_D, ORDER_REF_NO_V, SERVICE_REQ_ID_V.

2019-09-26 19:48:25  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_ORDER_REQUEST_DTLS: TRANS_DATE_D, ORDER_REF_NO_V, SERVICE_REQ_ID_V.


2019-09-26 19:48:25  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_SUBSCRIBER_MASTER): MAP "CBS_CORE"."CB_SUBSCRIBER_MASTER",target cbsogg.CB_SUBSCRIBER_MASTER.

2019-09-26 19:48:25  INFO    OGG-02756  The definition for table CBS_CORE.CB_SUBSCRIBER_MASTER is obtained from the trail file.

2019-09-26 19:48:25  INFO    OGG-06511  Using following columns in default map by name: SUBSCRIBER_CODE_N, IDENTIFICATION_NUM_V, IDENTIFICATION_DATE_D, PASSPORT_NUM_V, PROFILE_TYPE_V, GROUP#SUB_GROUP_CODE_N, SUBS_CATEGORY_CODE_V, SUBS_SUB_CATEGORY_CODE_V, ID_TYPE_V, TITLE_V, FIRST_NAME_V, MIDDLE_NAME_V, LAST_NAME_V, STATUS_CODE_V, SUBSCRIBER_LEVEL_N, INTERACTING_USER_CODE_N, CPV_SCORE_N, CPV_GRADE_V, GENDER_V, MARITAL_STATUS_V, BIRTH_DATE_D, COUNTRY_CODE_V, NATIONALITY_V, OCCUPATION_CODE_V, BLOOD_GRP_V, LANGUAGE_CODE_V, REPRESENTATIVE_FLG_V, CONTACT_MOBL_NUM_V, CONTACT_HOME_NUM_V, CONTACT_OFFICE_NUM_V, FAX_NUM_V, EMAIL_ID1_V, EMAIL_ID2_V, BLACKLISTED_FLG_V, BLACKLISTED_DATE_D, ACTIVATED_BY_USER_CODE_N, REGISTRATION_DATE_D, ERASED_DATE_D, RISK_CATEGORY_V, CREDIT_RATING_N, PASSPORT_EXPIRY_D, APP_MODE_V, LOCATION_CODE_V, HEIRARCHIAL_OPTION_V, BILL_PRESENTATION_LANG_V, SUBSCRIBER_SEGMENT_V, NO_OF_EMPLOYEES_N, DIRECT_CONN_CUSTOMER_FLG_V, ESTABLISHED_DATE_D, AUTH_INDV_V, DEGREE_V, ECONOMIC_CODE_N, FATHER_NAME_V, PROSPECT_CODE_N, CONTRACT_NUMBER_N, SALES_REP_CODE_N, ACCESS_ID_N, NUM_OF_PREPAID_PROFILES_N, VIP_FLAG_V, SEND_NOTIFICATION_MAIL_FLG_V, NOTIFICATION_EMAIL_ID_V, SEND_NOTIFICATION_SMS_FLG_V, NOTIFICATION_SMS_NUMBER_V, PREF_COMM_LANG_CODE_V, PREFERRED_CURR_CODE_V, BILL_PRESENT_CURR_CODE_V, STATEMENT_APPLICABLE_OPTN_V, BILLING_REGION_V, TAX_APPLICABLE_FLG_V, TAX_POLICY_V, MIGRATED_FROM_PROSPECT_V, PREF_PAY_METHODS_V, PROF_CR_VETTING_TYPE_V, BILL_CYCL_CODE_N, BILL_CYCL_APPLICABLE_FLG_V, SUBS_ATTR_1_V, SUBS_ATTR_2_V, SUBS_ATTR_3_V, SUBS_ATTR_4_V, SUBS_ATTR_5_V, SUBS_ATTR_1_N, SUBS_ATTR_2_N, SUBS_ATTR_3_N, SUBS_ATTR_4_N, SUBS_ATTR_5_N, POSTED_FLAG_N, POSTED_DATE_D, LAST_MODIFIED_DATE_D, PROFILE_MANAGER_N, CONTACT_PERSON_FIRST_NAME_V, CONTACT_PERSON_FAMILY_NAME_V, CONTACT_PERSON_PHONE_NUMBER_V, CONTACT_PERSON_EMAIL_V, CONTACT_PERSON_FAX_V, DMS_RECEIVED_INDICATOR_V, DMS_RECIVED_DATE_D, MVPN_SEGMENT_N, FIRST_NAME_LN_V, LAST_NAME_LN_V, BUSINESS_TYPE_V, CREATE_ACC_SERV_FLAG_V, IFS_PAYMENT_FLAG_V, IFS_RECEIPT_NO_V, IFS_PAYMENT_INFO_X, ACCOUNT_MANAGER_V, CREDIT_CONTROL_V, TAX_OPTN_V, DISPATCH_NOTIFY_OPTNS_N, SET_DISPATCH_FLG_V, DISPATCH_TO_OPTN_V, STATEMENT_GROUP_CODE_N, EXT_SUBSCRIBER_CODE_V.

2019-09-26 19:48:25  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_SUBSCRIBER_MASTER: SUBSCRIBER_CODE_N.


2019-09-26 19:48:25  INFO    OGG-06505  MAP resolved (entry CBS_CORE.GSM_SERVICE_MAST): MAP "CBS_CORE"."GSM_SERVICE_MAST",TARGET CBSOGG.GSM_SERVICE_MAST.

2019-09-26 19:48:26  INFO    OGG-02756  The definition for table CBS_CORE.GSM_SERVICE_MAST is obtained from the trail file.

2019-09-26 19:48:26  INFO    OGG-06511  Using following columns in default map by name: ACCOUNT_LINK_CODE_N, ACCOUNT_CODE_N, STATUS_CODE_V, STATUS_REASON_CODE_N, INTERIM_STATUS_CODE_V, SIM_NUM_V, IMSI_NUM_N, IMSI_ACTIVE_DATE_D, MOBL_NUM_VOICE_V, MOBL_NUM_DATA_V, MOBL_NUM_FAX_V, PACKAGE_CODE_V, SUB_PACKAGE_CODE_V, PACKAGE_START_DATE_D, TARIFF_CODE_V, TARIFF_START_DATE_D, CONTRACT_TYPE_V, VALIDITY_DATE_D, VALIDITY_GRACE_DAYS_N, SERVICE_INDICATOR_V, ROAMING_TYPE_N, AIRTM_RATE_START_DATE_D, SCHEDUL_SERVICE_EXEC_DATE_D, MID_CYCL_DISC_DATE_D, ONLINE_BATCH_RATE_OPTN_V, OUTGOING_BARRD_DATE_D, SPECIAL_CATEGORY_INDICATORS_V, SPECIAL_CATEGORY_CHANGE_DATE_D, SPECIAL_TARF_CODE_V, SPECIAL_TARF_DATE_D, CHRG_EXPTN_PH_FLG_V, CEL_ID_ZONE_CODE_V, CEL_ID_START_DATE_D, CEL_ID_END_DATE_D, CUG_GRP_CODE_V, SUBS_CUG_START_DATE_D, SUBS_CUG_END_DATE_D, GRP_PHONE_START_DATE_D, GRP_PHONE_END_DATE_D, FRNDS_START_DATE_D, FRNDS_END_DATE_D, EXEC_MEDI_FLG_V, PROV_PRIORITY_N, X_DIRECTORY_LEVEL_N, BAR_ON_THRESHOLD_FLG_V, ACTIVATED_BY_USER_CODE_N, REGISTRATION_DATE_D, ACTIVATION_DATE_D, REACTIVATION_DATE_D, SUSPENDED_DATE_D, ERASED_DATE_D, MODIFIED_DATE_D, MOBILE_ACTIVATED_DATE_DT, PROFILE_CODE_V, SUBS_TITLE_V, SUBS_NAME_V, IC_NUMBER_V, CONTRACT_START_D, CONTRACT_END_D, PRE_TERMINATE_DATE_D, AMPS_FLG_V, TRANSFER_IN_SERVICE_TYPES_N, TRANSFER_FROM_ACC_LINK_CODE_N, RESTRICT_SMS_FLAG_V, ACCESS_PASSWORD_V, VIP_FLAG_V, ID_TYPE_V, PREFERRED_LANGUAGE_V, GENDER_V, FAMILY_NAME_V, EMAIL_ID_V, CONTACT_MOBL_NUM_V, CONTACT_HOME_NUM_V, CONTACT_OFFICE_NUM_V, FAX_NUM_V, ACCOUNT_MANAGER_N, SALES_REP_V, DEALER_CODE_V, DMS_RECIVED_FLAG_V, DMS_RECIVED_DATE_D, DMS_VERIFIED_FLAG_V, BUSINESS_INDIVIDUAL_V, COMPANY_NAME_V, COMPANY_REGISTRATION_NO_V, COMPANY_CONTACT_NUM_V, REGISTERED_LOCATION_V, PROFILE_TYPE_V, SUBSCRIBER_CATEGORY_V, SUBSCRIBER_SUB_CATEGORY_V, SUBSCRIBER_SEGMENT_V, HOME_FAX_NUM_V, ID_EXPIRY_DATE_D, OCCUPATION_CODE_V, EMPLOYED_FROM_DATE_D, READY_TO_GO_DATE_D, ADDRESS_RECIVED_FLAG_V, LAST_EARNED_REV_CALC_DATE_D, GHOST_PROFILE_FLAG_V, BOGOF_FLG_V, MIGRATE_TIME_N, DMS_SEEN_FLG_V, GRACE_DAYS_N, DMS_VERIFIED_DATE_D, MMS_DOC_RECIVED_FLAG_V, MMS_DOC_VERIFIED_FLAG_V, MMS_DOC_VERIFIED_DATE_D, GHOST_PROFILE_TYPE_V, FIRST_CALL_V, MMS_DOC_RECEIVED_DATE_D, DEALER_ID_CODE_V, DATE_OF_BIRTH_D, SUBSCRIPTION_FEE_N, DEGREE_V, HANDSET_SUBSIDY_FLAG_V, HANDSET_CONTRACT_FLAG_V, HANDSET_SECURITY_FLAG_V, CPD_FLAG_V, CONTRACT_DOC_RECE_DATE_D, SECURITY_DOC_RECE_DATE_D, CPD_DOC_RECE_DATE_D, POAD_DOC_FLAG_V, POAD_DOC_RECEIVED_DATE_D, SIM_CHANGE_FLAG_N, LBS_DOC_RECEIVED_FLAG_V, FATHER_NAME_V, CHURN_CATEGORY_V, GEN_TYPE_V, ADDITIONAL_IMSI_NUM_N, ADDITIONAL_SIM_FLAG_V, ADDITIONAL_SIM_NUM_V, ALLOW_MARKETING_CALLS_V, BC_TARIFF_CHANGE_TYPE_V, BILL_CYCL_CODE_N, BIRTH_DATE_D, BUNDLE_FLAG_V, BUNDLE_SERIAL_NUMBER_V, CALL_FWD_BUSY_V, CALL_FWD_IMMD_V, CALL_FWD_NOREPLY_V, COMMITMENT_AMOUNT_N, CONTACT_NUMBER1_V, CONTACT_NUMBER2_V, DATA_SPEED_N, DOC_RECVD_BY_N, DOC_RECVD_ON_D, DUAL_IMSI_NUM_N, EPBAX_SERV_FLAG_V, HANDSET_TYPE_V, HYBRID_SERVICE_STATUS_V, IMEI_NUMBER_V, IP_ADDRESS_V, LANGUAGE_CODE_V, LAST_NAME_V, LAST_POSTED_DATE_D, LAST_STATE_CHNG_DATE_D, LAST_STATE_CHNG_DONE_BY_N, LAST_STATE_CHNG_MODE_V, MODEL_CODE_V, NOTIFICATION_LANG_CODE_V, PID_NUMBER_V, POSTED_DATE_D, POSTED_FLAG_N, PREFERRED_CURR_CODE_V, PREF_DAY_CODE_N, PREF_DAY_DATE_V, ROAM_IMSI_ACT_DT_D, ROAM_IMSI_N, SALES_PERSON_CODE_V, SDP_CODE_V, SERV_ADDNL_FLD_1_D, SERV_ADDNL_FLD_1_N, SERV_ADDNL_FLD_1_V, SERV_ADDNL_FLD_2_D, SERV_ADDNL_FLD_2_N, SERV_ADDNL_FLD_2_V, SERV_ADDNL_FLD_3_D, SERV_ADDNL_FLD_3_N, SERV_ADDNL_FLD_3_V, SERV_ADDNL_FLD_4_N, SERV_ADDNL_FLD_4_V, SERV_ADDNL_FLD_5_N, SERV_ADDNL_FLD_5_V, SHORT_CODE_V, SIM_ITEM_CODE_N, SUBSCRIBER_CLASS, SUB_SERVICE_CODE_V, TIME_ZONE_CODE_N, TWIN_SIM_LINKED_ACC_N, ACTIVATED_VIA_V, BALANCE_AMOUNT_N, BLACKLISTED_DATE_D, BLACKLISTED_FLG_V, CR_CTRL_SCHDL_CODE_V, FAX_SPEED_N, HYBRID_TYPE_V, IN_LANGUAGE_CODE_N, SEVICE_IDENTIFIER_V, DOC_FLAG_V, DEFAULT_CR_CNTL_FLAG, EMAIL_NOTIF_FLAG, EMAIL_NOTIFICATION_ID, SMS_NOTIF_FLAG, SMS_NUMBER, MELLI_NUM_N, STATUS_CHANGE_DATE_D, CS_STATUS_V, MIDDLE_NAME_V, PAYMENT_AMOUNT_N, BC_COMMITMENT_POST_FLAG_V, MTN_SUBSCRIBER_V, BLACKBERRY_SERVICE_V, HIGHEST_QUALIFICATION, ECARE_V, ACCOUNT_TYPE_V, CHILDREN_FLAG_V, ADDITIONAL_LINE#SITE_FLG_V, ADDITIONAL_LINE#SITE_QTY_N, REG_FROM_V, COW_HOLDER_FLAG_V, REG_FORM_RECEIVED_FLAG_V, REG_FORM_RECEIVED_DATE_D.

2019-09-26 19:48:26  INFO    OGG-06510  Using the following key columns for target table CBSOGG.GSM_SERVICE_MAST: ACCOUNT_LINK_CODE_N.


2019-09-26 19:48:26  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_SUBS_INFORMATION_MASTER): MAP "CBS_CORE"."CB_SUBS_INFORMATION_MASTER",TARGET CBSOGG.CB_SUBS_INFORMATION_MASTER,FILTER ( @GETENV ('TRANSACTION', 'CSN') > 266550779456).

2019-09-26 19:48:26  INFO    OGG-02756  The definition for table CBS_CORE.CB_SUBS_INFORMATION_MASTER is obtained from the trail file.

2019-09-26 19:48:26  INFO    OGG-06511  Using following columns in default map by name: ACCOUNT_LINK_CODE_N, ACCOUNT_CODE_N, SERVICE_CODE_V, PRIVILEGE_CARD_NUMBER_N, VENDOR_CODE_V, SALES_REGION_N, DEPOSIT_AMT_N, ADV_SERVICE_CHRG_AMT_N, CR_LIMIT_N, LAST_FIXED_CALC_DATE_D, LAST_PRORATA_CALC_DATE_D, CREDIT_RISK_CATEGORY_V, CREDIT_RATING_N, CREDIT_CONTROL_SCHEDULE_V, MESG_MEDIA_OPTN_V, ACTION_LEVEL_N, ACTION_BY_V, NEXT_SUMRY_SEQ_NUM_N, LAST_BILL_CALC_DATE_D, UNBIL_PRORATA_WITH_TAX_N, UNBIL_FIXED_WITH_TAX_N, UNBIL_USAGE_AMT_N, UNBIL_USAGE_TAX_AMT_N, PRE_INV_AMT_N, PRE_INV_TAX_AMT_N, TRNF_PRE_INV_AMT_N, TRNF_PRE_INV_TAX_AMT_N, LINKED_PRE_INV_AMT_N, LINKED_PRE_INV_AMT_TAX_N, TRNF_INV_WITH_TAX_N, LINKED_INV_WITH_TAX_N, DISPUTE_AMT_N, BUCKET_1_AMT_N, BUCKET_2_AMT_N, BUCKET_3_AMT_N, BUCKET_4_AMT_N, LAST_PAYMENT_DATE_D, LAST_AGEING_PROCS_DATE_D, LAST_INVOICE_DATE_D, LAST_INVOICE_NUM_V, LAST_INVOICE_AMT_N, AMT_CLR_IN_LAST_INV_N, LAST_INV_DUE_DATE_D, TO_BILL_SEQ_NUM_N, NEXT_BILL_CYCL_FULL_CODE_N, ADDNL_CREDIT_LIMIT_N, LAST_PAYMENT_AMT_N, BUCKET_5_AMT_N, BUCKET_6_AMT_N, APP_MODE_V, LOCATION_CODE_V, SERVICE_LINE_SEQUENCE_N, INITIAL_CHARGE_CODE_V, EXCL_FRM_CREDIT_CNTRL, EXCL_CRDT_TILL_DATE_DT, EXCL_FRM_DUNNING, EXCL_DUNNING_TILL_DATE_DT, MAX_AMT_FLAG_V, SUSPENSION_SCHEME_N, LAST_EARNED_REV_CALC_DATE_D, LAST_INTRST_CALC_DATE_D, INSTALLMENT_FLAG_V, SECURED_CREDIT_N, UNSECURED_CREDIT_N, NOTIFICATION_EMAIL_ID_V, LAST_CALL_DT_D, NEXT_TRIGGER_THRESHOLD_N, BILLED_BALANCE_N, CLEARED_UNBILLED_AMT_N, AUCTION_CREDIT_LIMIT_N, EXCL_CRDT_TILL_AMT_N, EXCL_DUNNING_TILL_AMT_N, NOTIFICATION_SMS_NUMBER_V, CR_CTRL_APPLICABLE_FLG_V, MESG_FLG_V, MESG_CODE_N, TMP_UNBILLED_AMT_N, CR_LIMIT_TILL_DATE_D, SEND_NOTIFICATION_MAIL_FLG_V, SEND_NOTIFICATION_SMS_FLG_V, PREF_COMM_LANG_CODE_V, PENDING_ORD_CNT_N, CANCELED_ORD_CNT_N, REJECTED_ORD_CNT_N, EXECUTED_ORD_CNT_N, SALES_OUTSTANDING_AMT_N, MUL_APPLICABLE_FLG_V, MMC_ON_ACTIVATION, MMC_ON_TERMINATION, INVOICE_FLG_V, NEXT_FACILITY_REF_ID_V, SECRET_CODE_FLG_N, SECRET_CODE_V, RATING_FLG_V, PREPAID_CR_LIMIT_N, DB_CURR_BAL_FOR_PREPAID_N, LOC_UNBIL_USAGE_AMT_N, SUBS_TYPE_V, CONTRACT_PERIOD_N, CALLER_ID_NUM_V, CREDIT_LIMIT_FLAG_V, BASIC_UNIT_AREA_DIST_N, CONTRACT_PERIOD_TYPE_V, CUST_PREMISES_DIST_N, DIST_IN_BASIC_UNIT_AREA_N, LYT_CONTACT_NUMBER_V, LYT_LANGUAGE_CODE_V, LYT_NOTIFICATION_EMAIL_ID_V, LYT_NOTIFICATION_FLG_V, OBASA_SCHEME_REF_CODE_N, LYT_NOTIFICATION_APP_V, LAST_MODIFIED_DATE_D, MIG_INITIAL_SECURE_DEPOSIT_N, SPECIFIC_CRD_LMT_PER_FLG_V, SPECIFIC_CRD_LMT_PER_N, SUBSCRIBED_ADVTPBP_FLAG_V, DEF_SEG_CODE_V, DYN_SEG_CODE_V.

2019-09-26 19:48:26  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_SUBS_INFORMATION_MASTER: ACCOUNT_LINK_CODE_N.


2019-09-26 19:48:26  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_ACCOUNT_MASTER): MAP "CBS_CORE"."CB_ACCOUNT_MASTER",TARGET CBSOGG.CB_ACCOUNT_MASTER.

2019-09-26 19:48:26  INFO    OGG-02756  The definition for table CBS_CORE.CB_ACCOUNT_MASTER is obtained from the trail file.

2019-09-26 19:48:26  INFO    OGG-06511  Using following columns in default map by name: SUBSCRIBER_CODE_N, ACCOUNT_CODE_N, ACCOUNT_LINK_CODE_N, STATUS_CODE_V, ACTIVATION_DATE_D, ERASED_DATE_D, CR_DAYS_OPTN_V, CR_DAYS_N, REVENUE_GRADE_CODE_V, TAX_POLICY_V, CHRG_INTRST_OPTN_V, CHRG_INTRST_RATE_N, INVOICE_IN_BASE_CURNCY_FLG_V, CURRENCY_CODE_V, INSTALLMENT_FLAG_V, BILL_CYCL_CODE_N, BILLING_REGION_V, BILL_GROUP_N, DTLS_TO_FAX_NUM_V, EMAIL_LIST_V, PAYER_OPTN_FLG_V, PAYER_CODE_N, PAYMENTS_V, AUTO_DEBIT_FLG_V, DUNNING_SCHDL_CODE_V, NEXT_INVOICE_SEQ_NUM_N, SUBSCRIBER_CATEGORY_V, RISK_CATEGORY_V, CREDIT_RATING_N, SUBSCRIBER_SUB_CATEGORY_V, ACTIVATED_BY_N, ACCOUNT_NAME_V, ACCOUNT_TITLE_V, EXCLUDE_LPF, PRE_TERMINATION_DATE_D, BILL_PRESENTATION_LANG_V, SMS_TO_NUMBER_V, NO_OF_SERVICES_N, CONTACT_PERSON_NAME_V, ID_TYPE_V, IDENTIFICATION_NUM_V, VIRTUAL_INVOICE_ACC_FLG_V, ACCOUNT_MANAGER_N, CREDIT_CONTROLER_N, ACCOUNT_TYPE_V, MUL_APPLICABLE_FLG_V, PREFERRED_CURR_CODE_V, BILL_PRESENT_CURR_CODE_V, OLD_ACCOUNT_NUM_V, EXCLUDE_PRINT_FLG_V, EXCLUDE_TILL_DATE_D, EXCLUDED_REASON_V, EXCLUDED_BY_N, SPL_ATTRIBUTE_V, ACC_ATTR_1_V, ACC_ATTR_2_V, ACC_ATTR_3_V, ACC_ATTR_4_V, ACC_ATTR_5_V, ACC_ATTR_1_N, ACC_ATTR_2_N, ACC_ATTR_3_N, ACC_ATTR_4_N, ACC_ATTR_5_N, POSTED_FLAG_N, POSTED_DATE_D, PACKAGE_CODE_V, PROV_FLG_V, ACC_CHRONO_NUM_N, IND_SHARED_FLAG_V, CS_STATUS_V, STATUS_CHANGE_DATE_D, ENTITY_TYPE_V, ACCOUNT_NAME_LN_V, LAST_MODIFIED_DATE_D, RENTAL_SPECIFIC_V, SEND_EMAIL_NOTIFICATION_V, SEND_SMS_NOTIFICATION_V, PREF_COMMUNICATION_LANG_V, DEFAULT_DUNNING_SCHED_V, CREDIT_CONTROL_APPLIC_V, ACCOUNT_TYPE_FLAG_V, NEW_EXIST_ACCT_FLAG_V, ADD_ACC_SERV_FLAG_V, BLACKLISTED_FLG_V, PROF_CR_VETTING_TYPE_V, TAX_OPTN_V, DISPATCH_NOTIFY_OPTNS_N, SET_DISPATCH_FLG_V, EXT_ACCOUNT_CODE_V, DSPCH_EMAIL_ID_LIST_X.

2019-09-26 19:48:26  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_ACCOUNT_MASTER: ACCOUNT_CODE_N.


2019-09-26 19:48:26  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_ACCOUNT_SERVICE_LIST): MAP "CBS_CORE"."CB_ACCOUNT_SERVICE_LIST",TARGET CBSOGG.CB_ACCOUNT_SERVICE_LIST.

2019-09-26 19:48:26  INFO    OGG-02756  The definition for table CBS_CORE.CB_ACCOUNT_SERVICE_LIST is obtained from the trail file.

2019-09-26 19:48:26  INFO    OGG-06511  Using following columns in default map by name: ACCOUNT_CODE_N, ACCOUNT_LINK_CODE_N, SERVICE_CODE_V, FROM_DATE_D, TO_DATE_D, BILL_CYCL_CODE_N, SERVICE_INFO_V, STATUS_CODE_V, CONTRACT_TYPE_V, VIEW_SUBS_LEVEL_N, SERVICES_RIGHT_CODE_N, SUB_SERVICE_CODE_V, SUMMARY_CREATED_FLG_V, CS_STATUS_V, STATUS_CHANGE_DATE_D, SUBSCRIBER_TYPE_V, ACCS_ACCNT_MGNR_N, LAST_MODIFIED_DATE_D, PROXY_FLAG_V, PROXY_MSISDN_ID, PACKAGE_CODE_V, TAX_OPTN_V, TAX_PLAN_CODE_V, SUBSIDIARY_CODE_V, LEDGER_CODE_N, EXT_SUBSCRIBER_CODE_V.

2019-09-26 19:48:26  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_ACCOUNT_SERVICE_LIST: ACCOUNT_CODE_N, ACCOUNT_LINK_CODE_N.


2019-09-26 19:48:26  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_ADDRESS_XML): MAP "CBS_CORE"."CB_ADDRESS_XML", TARGET CBSOGG.CB_ADDRESS_XML.

2019-09-26 19:48:26  INFO    OGG-02756  The definition for table CBS_CORE.CB_ADDRESS_XML is obtained from the trail file.

2019-09-26 19:48:26  INFO    OGG-06511  Using following columns in default map by name: ACCOUNT_LINK_CODE_N, ADDRESS_TYPE_N, ACCOUNT_TYPE_V, ADDRESS_X.

2019-09-26 19:48:26  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_ADDRESS_XML: ACCOUNT_LINK_CODE_N, ACCOUNT_TYPE_V, ADDRESS_TYPE_N.


2019-09-26 19:48:26  INFO    OGG-06505  MAP resolved (entry CBS_CORE.cb_subs_deposits): MAP "CBS_CORE"."CB_SUBS_DEPOSITS", TARGET CBSOGG.cb_subs_deposits.

2019-09-26 19:48:26  INFO    OGG-02756  The definition for table CBS_CORE.CB_SUBS_DEPOSITS is obtained from the trail file.

2019-09-26 19:48:26  INFO    OGG-06511  Using following columns in default map by name: ACCOUNT_LINK_CODE_N, SERVICE_CODE_V, SCHEME_REF_TYPE_V, SCHEME_REF_CODE_N, DEPOSIT_TYPE_V, ARTICLE_CODE_V, DEPOSIT_AMT_N, INITIAL_DEPOSIT_N, INCREASE_CREDIT_LIMIT_BY_N, LAST_TRANS_DATE_D, BANK_CODE_V, BRANCH_CODE_V, BANK_DEPOSIT_REF_NUM_V, INTEREST_OPTN_V, INTEREST_PERCENT_N, LAST_INTEREST_CALC_DATE_D, STATUS_OPTN_V, BILL_CYCLE_FULL_CODE_N, PREV_DEPOSIT_AMT_N, FACILITY_REF_ID_V, LAST_MODIFIED_DATE_D, ACCT_DEPOSITS_TYPE_V, PEND_DEP_AMT_N, WAIVED_FLAG_V.

2019-09-26 19:48:26  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_SUBS_DEPOSITS: ACCOUNT_LINK_CODE_N, SCHEME_REF_CODE_N, SERVICE_CODE_V, ARTICLE_CODE_V, FACILITY_REF_ID_V.


2019-09-26 19:48:26  INFO    OGG-06505  MAP resolved (entry CLM_TT.TT_TICKETINFO): MAP "CLM_TT"."TT_TICKETINFO",TARGET CBSOGG.TT_TICKETINFO.

2019-09-26 19:48:26  INFO    OGG-02756  The definition for table CLM_TT.TT_TICKETINFO is obtained from the trail file.

2019-09-26 19:48:26  INFO    OGG-06511  Using following columns in default map by name: DOCKET_NUMBER_N, TICKET_REGN_DT_D, VISIBILITY_N, ENTITY_TYPE_V, ENTITY_ID_N, STATUS_V, PRIORITY_N, RESPONSE_MEDIUM_V, RESP_MEDIUM_ADDR_V, CATEGORY_ID_V, SUBCATEGORY_ID_V, TICKET_TYPE_V, REF_DOCKET_NUMBER_V, LOGGED_BY_N, TT_SOURCE_V, RESPONDED_BY_N, TICKET_RESP_DT_D, LOCATION_V, AREA_V, REOPEN_COUNT_N, TT_ADDNL_DATA, QUESTION_V, ANSWER_V, REMEDY_REF_NO_V, UPLOAD_DOC_B, FILE_NAME_V, TICKET_REGN_DT_D_1, SEGMENT_V, CHANNEL_V, RELEVE, CAUSE, COMMENTS, REASON.

2019-09-26 19:48:26  INFO    OGG-06510  Using the following key columns for target table CBSOGG.TT_TICKETINFO: DOCKET_NUMBER_N.


2019-09-26 19:48:26  INFO    OGG-06505  MAP resolved (entry CLM_TT.TT_TICKET_ADDNL_INFO): MAP "CLM_TT"."TT_TICKET_ADDNL_INFO",TARGET CBSOGG.TT_TICKET_ADDNL_INFO,keycols(DOCKET_NUMBER_N).

2019-09-26 19:48:26  WARNING OGG-06439  No unique key is defined for table TT_TICKET_ADDNL_INFO. 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:48:26  INFO    OGG-02756  The definition for table CLM_TT.TT_TICKET_ADDNL_INFO is obtained from the trail file.

2019-09-26 19:48:26  INFO    OGG-06511  Using following columns in default map by name: DOCKET_NUMBER_N, FAQ_V, SEND_SMS_V, MISTAKE_V, FEEDBACK_V, COMMENTS_V, CONTACT_CHECK_V, CONTACT_CALL_CHECK_V, LINES_MEN_FLAG_V, LINES_MEN_CODE_N, LINES_MEN_ALLOC_DATE_D, REF_DOCKET_NUMBER_V, COVERAGE_ENTRY_FLAG_V, GOVERNATE_V, AREA_V, STREET_V, TEXT1_V, TEXT2_V, TEXT3_V, LINES_MEN_DTLS_N, SMS_LANG_V, FAULT_CODE_V, REMINDER_D, REMINDER_FLAG_V.

2019-09-26 19:48:26  INFO    OGG-06510  Using the following key columns for target table CBSOGG.TT_TICKET_ADDNL_INFO: DOCKET_NUMBER_N.


2019-09-26 19:48:26  INFO    OGG-06505  MAP resolved (entry CLM_TT.TT_TICKETINCIDENT): MAP "CLM_TT"."TT_TICKETINCIDENT",TARGET CBSOGG.TT_TICKETINCIDENT.

2019-09-26 19:48:26  WARNING OGG-06439  No unique key is defined for table TT_TICKETINCIDENT. 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:48:26  INFO    OGG-02756  The definition for table CLM_TT.TT_TICKETINCIDENT is obtained from the trail file.

2019-09-26 19:48:26  INFO    OGG-06511  Using following columns in default map by name: INCIDENT_NUMBER_N, INCIDENT_TIMESTAMP_D, INCIDENT_INITIATOR_V, NOTES_V, BINARY_OBJECT_BL, USER_ID_N, TT_STATUS_V, FILENAME_V, FILETYPE_V, WORK_ID_N.

2019-09-26 19:48:26  INFO    OGG-06510  Using the following key columns for target table CBSOGG.TT_TICKETINCIDENT: INCIDENT_NUMBER_N, INCIDENT_TIMESTAMP_D, INCIDENT_INITIATOR_V, NOTES_V, USER_ID_N, TT_STATUS_V, FILENAME_V, FILETYPE_V, WORK_ID_N.


2019-09-26 19:48:26  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_ACCOUNT_RECEIVE_PAY): MAP "CBS_CORE"."CB_ACCOUNT_RECEIVE_PAY",TARGET CBSOGG.CB_ACCOUNT_RECEIVE_PAY.

2019-09-26 19:48:26  INFO    OGG-02756  The definition for table CBS_CORE.CB_ACCOUNT_RECEIVE_PAY is obtained from the trail file.

2019-09-26 19:48:26  INFO    OGG-06511  Using following columns in default map by name: ACCOUNT_LINK_CODE_N, TRANS_TYPE_V, TRANS_NUM_V, SERIAL_NUM_N, ADJUST_CLASS_N, TRANS_DATE_D, DB_CR_V, BILL_CLEARED_FLG_V, BILL_FULLY_CLEARED_FLG_V, DUE_DATE_D, CALC_INTRST_FLG_V, LAST_INTRST_CALC_DATE_D, PRINT_LEDG_FLG_V, PRINT_IN_INVOICE_FLG_V, INFO_OPTN_V, TRANS_AMT_N, TRANS_AMT_CLEARED_N, TEMP_CLR_AMT_N, TRANS_DESC_V, OLD_YR_ADJUST_AMT_N, MOV_DUNNING_FLG_V, SUB_DTLS_OPTN_V, USER_CODE_N, LOCATION_CODE_V, USER_MAC_ADDRESS_V, CASH_BOX_NUMBER_N, TRANSFERRED_AMT_N, SALE_TYPE_V, LAST_MODIFIED_DATE_D.

2019-09-26 19:48:26  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_ACCOUNT_RECEIVE_PAY: TRANS_TYPE_V, TRANS_NUM_V, SERIAL_NUM_N, ACCOUNT_LINK_CODE_N.


2019-09-26 19:48:26  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_SUB_AR_AP): MAP "CBS_CORE"."CB_SUB_AR_AP",TARGET CBSOGG.CB_SUB_AR_AP.

2019-09-26 19:48:26  INFO    OGG-02756  The definition for table CBS_CORE.CB_SUB_AR_AP is obtained from the trail file.

2019-09-26 19:48:26  INFO    OGG-06511  Using following columns in default map by name: TRANS_NUM_V, SERIAL_NUM_N, TRANS_DATE_D, ACCOUNT_LINK_CODE_N, MAIN_ACCOUNT_LINK_CODE_N, SUBSIDIARY_CODE_V, DB_CR_V, OVERALL_AMT_N, CLEARED_AMT_N, TEMP_CLR_AMT_N, OLD_YR_ADJUST_AMT_N, BILL_CLEARED_FLG_V, DUE_DATE_D, TRANSFERRED_AMT_N, SALE_TYPE_V, LAST_MODIFIED_DATE_D, DEBTORS_GL_CODE_N.

2019-09-26 19:48:26  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_SUB_AR_AP: TRANS_NUM_V, SERIAL_NUM_N, SUBSIDIARY_CODE_V, ACCOUNT_LINK_CODE_N.


2019-09-26 19:48:26  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_PAY_MODE_DTLS): MAP "CBS_CORE"."CB_PAY_MODE_DTLS",TARGET CBSOGG.CB_PAY_MODE_DTLS.

2019-09-26 19:48:26  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 19:48:26  INFO    OGG-02756  The definition for table CBS_CORE.CB_PAY_MODE_DTLS is obtained from the trail file.

2019-09-26 19:48:26  INFO    OGG-06511  Using following columns in default map by name: 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 19:48:26  INFO    OGG-06510  Using the following key columns for target table CBSOGG.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 19:48:26  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_RECEIPTS): MAP "CBS_CORE"."CB_RECEIPTS",TARGET CBSOGG.CB_RECEIPTS.

2019-09-26 19:48:26  INFO    OGG-02756  The definition for table CBS_CORE.CB_RECEIPTS is obtained from the trail file.

2019-09-26 19:48:26  INFO    OGG-06511  Using following columns in default map by name: TRANS_NUM_V, TRANS_DATE_D, TRANS_OPTN_V, TRANS_REF_NO_V, LOCATION_CODE_V, CASH_BOX_NUMBER_N, SALES_REGION_N, PAY_MODE_OPTN_V, ENTITY_TYPE_V, ACCOUNT_LINK_CODE_N, SAP_SUB_AC_CODE_N, TRANS_AMT_N, DESCRIPTION_V, USER_CODE_N, POSTED_TO_ACCOUNTS_N, POSTED_TRANS_NUM_V, UPLOADED_DATE_D, DISPLAY_REF_NO_V, CASH_BOX_COLL_TYPE_V, SALES_LINK_FLAG_V, SOURCE_CODE_V, ERLY_PYMT_TRANS_NUM_V, PREPAID_POSTPAID_FLAG_V, RECHARGE_TYPE_V, LAST_MODIFIED_DATE_D, EXTERNAL_REFERENCE_V.

2019-09-26 19:48:26  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_RECEIPTS: TRANS_NUM_V.


2019-09-26 19:48:26  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_RECEIPTS_ADJUST): MAP "CBS_CORE"."CB_RECEIPTS_ADJUST",TARGET CBSOGG.CB_RECEIPTS_ADJUST.

2019-09-26 19:48:27  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 19:48:27  INFO    OGG-02756  The definition for table CBS_CORE.CB_RECEIPTS_ADJUST is obtained from the trail file.

2019-09-26 19:48:27  INFO    OGG-06511  Using following columns in default map by name: 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 19:48:27  INFO    OGG-06510  Using the following key columns for target table CBSOGG.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 19:48:27  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_RECEIPTS_ADJUST): MAP "CBS_CORE"."CB_RECEIPTS_ADJUST",TARGET CBSOGG.CB_RECEIPTS_ADJUST.

2019-09-26 19:48:27  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 19:48:27  WARNING OGG-02081  Detected duplicate TABLE/MAP entry for source table CBS_CORE.CB_RECEIPTS_ADJUST and target table CBSOGG.CB_RECEIPTS_ADJUST. Using prior TABLE/MAP specification.

2019-09-26 19:48:27  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_INVOICE): MAP "CBS_CORE"."CB_INVOICE",TARGET CBSOGG.CB_INVOICE.

2019-09-26 19:48:27  INFO    OGG-02756  The definition for table CBS_CORE.CB_INVOICE is obtained from the trail file.

2019-09-26 19:48:27  INFO    OGG-06511  Using following columns in default map by name: TRANS_NUM_V, TRANS_DATE_D, ACCOUNT_LINK_CODE_N, SUBS_CATEGORY_CODE_V, ACCOUNT_INVOICE_NUM_N, CHRG_FROM_DATE_D, CHRG_TILL_DATE_D, BILL_CYCL_FULL_CODE_N, BILLING_REGION_V, DUE_DATE_D, INVOICE_AMT_N, INVOICE_TAX_N, INVOICE_GENERATED_ON_D, DELIVERY_PROOF_FLG_V, DELIVERED_ON_D, OVER_ALL_DISC_N, EARLY_PAY_DISC_OPTN_N, EARLY_PAYMENT_DISC_AMT_N, INV_AMT_CLEARED_N, ADJUSTMENT_AMT_N, TEMP_CLR_AMT_N, DISPUTE_AMT_N, INV_CLEARED_FLG_V, SPECIFIC_MESG_V, INVOICE_GENERATE_BY_USER_N, POSTED_TO_ACCOUNTS_N, POSTED_TRANS_NUM_V, BILL_TYPE_FLAG_N, EMISSION_DATE_D, LATE_PAYFEE_POSTED_V, SUBSCRIBER_CODE_N, TAX_POLICY_V, CURRENCY_CODE_V, SUBS_SUB_CATEGORY_CODE_V, TAX_OPTN_V.

2019-09-26 19:48:27  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_INVOICE: TRANS_NUM_V.


2019-09-26 19:48:27  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_SUB_INVOICE): MAP "CBS_CORE"."CB_SUB_INVOICE",TARGET CBSOGG.CB_SUB_INVOICE.

2019-09-26 19:48:28  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 19:48:28  INFO    OGG-02756  The definition for table CBS_CORE.CB_SUB_INVOICE is obtained from the trail file.

2019-09-26 19:48:28  INFO    OGG-06511  Using following columns in default map by name: 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 19:48:28  INFO    OGG-06510  Using the following key columns for target table CBSOGG.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 19:48:28  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_ACCS_RECEIVE_PAY_ADJUST): MAP "CBS_CORE"."CB_ACCS_RECEIVE_PAY_ADJUST",TARGET CBSOGG.CB_ACCS_RECEIVE_PAY_ADJUST.

2019-09-26 19:48:28  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 19:48:28  INFO    OGG-02756  The definition for table CBS_CORE.CB_ACCS_RECEIVE_PAY_ADJUST is obtained from the trail file.

2019-09-26 19:48:28  INFO    OGG-06511  Using following columns in default map by name: 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 19:48:28  INFO    OGG-06510  Using the following key columns for target table CBSOGG.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 19:48:28  INFO    OGG-06505  MAP resolved (entry CLM_TT.WF_TODOITEM): MAP "CLM_TT"."WF_TODOITEM",TARGET CBSOGG.WF_TODOITEM.

2019-09-26 19:48:28  INFO    OGG-02756  The definition for table CLM_TT.WF_TODOITEM is obtained from the trail file.

2019-09-26 19:48:28  INFO    OGG-06511  Using following columns in default map by name: WORK_ID_N, WRKAGENT_ID_N, NOTES_V, EXPIRY_TIME_D, STATUS_V, ASSIGNMENT_DT_D, WORK_COMPLETION_DT_D, EVENT_TYPE_N, EVENT_REFNO_V, USER_ID_N, TIMES_DIFFERED_N, ACTIVITY_NAME_V, ASSIGNMENT_DT_D_1.

2019-09-26 19:48:28  INFO    OGG-06510  Using the following key columns for target table CBSOGG.WF_TODOITEM: WORK_ID_N.


2019-09-26 19:48:28  INFO    OGG-06505  MAP resolved (entry CBS_CUST.CB_MULTI_ACCT_INVOICE_DETAILS): MAP "CBS_CUST"."CB_MULTI_ACCT_INVOICE_DETAILS",target CBSOGG.CB_MULTI_ACCT_INVOICE_DETAILS.

2019-09-26 19:48:29  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 19:48:29  INFO    OGG-02756  The definition for table CBS_CUST.CB_MULTI_ACCT_INVOICE_DETAILS is obtained from the trail file.

2019-09-26 19:48:29  INFO    OGG-06511  Using following columns in default map by name: RECEIPT_REF_NUM_N, ACCOUNT_CODE_N, INVOICE_NUM_V, PAYMENT_AMOUNT_N.

2019-09-26 19:48:29  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_MULTI_ACCT_INVOICE_DETAILS: RECEIPT_REF_NUM_N, ACCOUNT_CODE_N, INVOICE_NUM_V, PAYMENT_AMOUNT_N.


2019-09-26 19:48:29  INFO    OGG-06505  MAP resolved (entry CBS_CUST.CB_MULTI_ACCT_RECEIPT_DETAILS): MAP "CBS_CUST"."CB_MULTI_ACCT_RECEIPT_DETAILS",target CBSOGG.CB_MULTI_ACCT_RECEIPT_DETAILS.

2019-09-26 19:48:29  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 19:48:29  INFO    OGG-02756  The definition for table CBS_CUST.CB_MULTI_ACCT_RECEIPT_DETAILS is obtained from the trail file.

2019-09-26 19:48:29  INFO    OGG-06511  Using following columns in default map by name: 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 19:48:29  INFO    OGG-06510  Using the following key columns for target table CBSOGG.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 19:48:29  INFO    OGG-06505  MAP resolved (entry CLM_TT.WF_WORKFLOW): MAP "CLM_TT"."WF_WORKFLOW",TARGET CBSOGG.WF_WORKFLOW.

2019-09-26 19:48:29  INFO    OGG-02756  The definition for table CLM_TT.WF_WORKFLOW is obtained from the trail file.

2019-09-26 19:48:29  INFO    OGG-06511  Using following columns in default map by name: WRKFLW_INSTANCE_ID_N, EVENT_TYPE_N, EVENT_REFNO_V, WRKFLW_ID_N, START_DT_D, END_DT_D, STATUS_V, CREATED_BY_N, TERMINATED_BY_N, WRKFLW_DATA_X, START_DT_D_1.

2019-09-26 19:48:29  INFO    OGG-06510  Using the following key columns for target table CBSOGG.WF_WORKFLOW: WRKFLW_INSTANCE_ID_N.


2019-09-26 19:48:29  WARNING OGG-03018  Alternative format data found (code = 36). Character set conversion was not performed.

2019-09-26 19:48:29  INFO    OGG-06505  MAP resolved (entry CLM_TT.WF_TODOITEM_HISTORY): MAP "CLM_TT"."WF_TODOITEM_HISTORY",TARGET CBSOGG.WF_TODOITEM_HISTORY.

2019-09-26 19:48:29  INFO    OGG-02756  The definition for table CLM_TT.WF_TODOITEM_HISTORY is obtained from the trail file.

2019-09-26 19:48:29  INFO    OGG-06511  Using following columns in default map by name: WORK_ID_N, WRKAGENT_ID_N, NOTES_V, EXPIRY_TIME_D, STATUS_V, ASSIGNMENT_DT_D, WORK_COMPLETION_DT_D, EVENT_TYPE_N, EVENT_REFNO_V, USER_ID_N, TIMES_DIFFERED_N, ACTIVITY_NAME_V.

2019-09-26 19:48:29  INFO    OGG-06510  Using the following key columns for target table CBSOGG.WF_TODOITEM_HISTORY: STATUS_V, WORK_ID_N.


2019-09-26 19:48:29  INFO    OGG-06505  MAP resolved (entry CLM_TT.WF_WORKASSIGNMENT): MAP "CLM_TT"."WF_WORKASSIGNMENT",TARGET CBSOGG.WF_WORKASSIGNMENT.

2019-09-26 19:48:29  INFO    OGG-02756  The definition for table CLM_TT.WF_WORKASSIGNMENT is obtained from the trail file.

2019-09-26 19:48:29  INFO    OGG-06511  Using following columns in default map by name: WORK_ID_N, USER_GROUP_OPTN_V, USER_GROUP_ID_N, NOTIFY_FLG_N, ASSIGNED_BY_N.

2019-09-26 19:48:29  INFO    OGG-06510  Using the following key columns for target table CBSOGG.WF_WORKASSIGNMENT: WORK_ID_N, USER_GROUP_OPTN_V, USER_GROUP_ID_N, ASSIGNED_BY_N.


2019-09-26 19:48:29  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_SUBS_OFFER_DETAILS): MAP "CBS_CORE"."CB_SUBS_OFFER_DETAILS",TARGET CBSOGG.CB_SUBS_OFFER_DETAILS,KEYCOLS(ACCOUNT_LINK_CODE_N,FACILITY_REF_ID_V,OFFER_CODE_V).

2019-09-26 19:48:29  INFO    OGG-06441  Unique key CB_SUBS_OFFER_DTL$1 for table CB_SUBS_OFFER_DETAILS cannot be used due to the inclusion of virtual columns, or user-defined datatypes, or extended long varchar columns, or function-based index columns.

2019-09-26 19:48:29  WARNING OGG-06440  No viable unique key is defined for table CB_SUBS_OFFER_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:48:29  INFO    OGG-02756  The definition for table CBS_CORE.CB_SUBS_OFFER_DETAILS is obtained from the trail file.

2019-09-26 19:48:29  INFO    OGG-06511  Using following columns in default map by name: ACCOUNT_LINK_CODE_N, OFFER_CODE_V, START_DATE_D, END_DATE_D, CANCEL_DATE_D, USER_CODE_N, STATUS_OPTN_V, REQUESTED_DATE_D, SCHEME_REF_CODE_N, FACILITY_REF_ID_V, NARRATION_V, TARIFF_FLAG_V, MOVE_CHARGE_TO_ACC_V, ORDER_REF_NO, ADDNL_OFFER_FLG_V, EXTENDED_COUNT_N, EXTENSION_DATE_D, LAST_EXTENDED_DATE_D, QUANTITY_N, LAST_MODIFIED_DATE_D, ADDN_ATTR_V_1, ADDN_ATTR_V_2, TECH_ATRIBUTE_V, EXPIRY_DATE_D, SERIAL_NUM_V, AUTO_RENEW_V, CONTRACT_END_DT_D.

2019-09-26 19:48:29  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_SUBS_OFFER_DETAILS: ACCOUNT_LINK_CODE_N, FACILITY_REF_ID_V, OFFER_CODE_V.


2019-09-26 19:48:29  INFO    OGG-06505  MAP resolved (entry CLM_TT.WF_WORKASSIGNMENT_HISTORY): MAP "CLM_TT"."WF_WORKASSIGNMENT_HISTORY",TARGET CBSOGG.WF_WORKASSIGNMENT_HISTORY.

2019-09-26 19:48: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 19:48:30  INFO    OGG-02756  The definition for table CLM_TT.WF_WORKASSIGNMENT_HISTORY is obtained from the trail file.

2019-09-26 19:48:30  INFO    OGG-06511  Using following columns in default map by name: WORK_ID_N, USER_GROUP_OPTN_V, USER_GROUP_ID_N, ASSIGNED_BY_N, ASSIGMENT_DATE_D, ASSIGN_FLAG_V.

2019-09-26 19:48:30  INFO    OGG-06510  Using the following key columns for target table CBSOGG.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 19:48:30  INFO    OGG-06505  MAP resolved (entry CBS_CUST.CB_POS_TRANSACTIONS): MAP "CBS_CUST"."CB_POS_TRANSACTIONS",TARGET CBSOGG.CB_POS_TRANSACTIONS.

2019-09-26 19:48:30  INFO    OGG-02756  The definition for table CBS_CUST.CB_POS_TRANSACTIONS is obtained from the trail file.

2019-09-26 19:48:30  INFO    OGG-06511  Using following columns in default map by name: TRANSACTION_NUM_V, TRANS_DATE_DT, CUSTOMER_TYPE_V, PRIVELEDGE_CARD_NUMBER_V, SERVICE_NUMBER_V, ACCOUNT_LINK_CODE_N, POS_TYPE_V, PAYMENT_METHOD_V, LOCATION_CODE_V, NAME_V, ADDRESS_1_V, ADDRESS_2_V, ADDRESS_3_V, ADDRESS_4_V, ZIP_CODE_V, AMOUNT_N, DISC_AMOUNT_N, TAX_FRML_CODE_V, TAX_AMT1_N, TAX_AMT2_N, TAX_AMT3_N, TOTAL_AMOUNT_N, NARRATION_V, RECEIPT_TRANS_NUM_V, RETURN_V, RETURN_TRANS_NUM_V, USER_CODE_N, CASH_BOX_NUMBER_N, REQUISITION_NUMBER_N, CREDIT_FLAG_V, REBATE_GIVEN_V, POSTED_TO_ACCOUNTS_N, POSTED_TRANS_NUM_V, SAP_SUB_AC_CODE_N, INVENTORY_DOC_REF_V, INDENT_NUM_V, CRD_SALES_INVNO_V, ROUND_OFF_AMOUNT_N, STATUS_V, SALES_PERSON_CODE_V, TYPE_OF_SALES_V, TAX_REFUND_AMOUNT_N, PRINTS_N, LANGUAGE_CODE_V, SERV_ACCOUNT_LINK_CODE_N, EXT_CRED_SALE_REF_NO_V, HANDSET_TYPE_V, DEBIT_STATUS_V, BASE_AMOUNT_N, BASE_DISC_AMOUNT_N, BASE_TAX_AMT1_N, BASE_TAX_AMT2_N, BASE_TAX_AMT3_N, BASE_TOTAL_AMOUNT_N, BASE_CURR_CODE_V, PREFERRED_CURR_CODE_V, CHARGE_TYPE_V, CHARGE_CODE_V, NUM_OF_TRANSACTIONS_N, PAY_STATUS_V, ENTITY_TYPE_V, ADJUSTMENT_TYPE_V, ADJUSTMENT_AMOUNT_N, TRANS_DISC_FLG_V, TRANS_DISC_BY_V, TRANS_DISC_PRCNT_AMT_N, TRANS_DISC_AMT_N, BASE_TRANS_DISC_AMT_N, TAX_EXEMPT_FLAG_V, EXEMPT_TAX_AMT_N, BASE_EXEMPT_TAX_AMT_N, EMAIL_ID_V, SITE_LOCATION_V, DELIVERY_DATE_DT, STATUS_CHANGE_DATE_D, LOCATION_CODE_N, ID_NUMBER_V, VAT_REG_NO_V, RECEIPT_RESP_X, DONATION_FLAG_V, PURCHASE_NUMBER_V, ETUP_FLAG_V.

2019-09-26 19:48:30  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_POS_TRANSACTIONS: TRANSACTION_NUM_V.


2019-09-26 19:48:30  INFO    OGG-06505  MAP resolved (entry CBS_CORE.FXL_SERVICE_MAST): MAP "CBS_CORE"."FXL_SERVICE_MAST", TARGET CBSOGG.FXL_SERVICE_MAST.

2019-09-26 19:48:30  INFO    OGG-02756  The definition for table CBS_CORE.FXL_SERVICE_MAST is obtained from the trail file.

2019-09-26 19:48:30  INFO    OGG-06511  Using following columns in default map by name: SERV_ACC_LINK_CODE_N, ACCOUNT_CODE_N, SUB_SERVICE_CODE_V, STATUS_CODE_V, STATUS_REASON_CODE_N, INTERIM_STATUS_CODE_V, CONTRACT_TYPE_V, CONTRACT_START_D, CONTRACT_END_D, TELEPHONE_NUMBER_V, LOCATION_ZONE_CODE_V, ND_ACTIVATED_DATE_DT, NETWORK_ELEMENT_V, NE_ACTIVE_DATE_D, SUBS_TITLE_V, SUBS_NAME_V, IC_NUMBER_V, PACKAGE_CODE_V, PACKAGE_START_DATE_D, PROFILE_CODE_V, TARIFF_CODE_V, TARIFF_START_DATE_D, SERVICE_INDICATOR_V, RATE_START_DATE_D, SCHEDUL_SERVICE_EXEC_DATE_D, MID_CYCL_DISC_DATE_D, SPECIAL_CATEGORY_INDICATORS_V, SPECIAL_CATEGORY_CHANGE_DATE_D, SPECIAL_TARF_CODE_V, SPECIAL_TARF_DATE_D, CHRG_EXPTN_PH_FLG_V, CUG_GRP_CODE_V, SUBS_CUG_START_DATE_D, SUBS_CUG_END_DATE_D, GRP_PHONE_START_DATE_D, GRP_PHONE_END_DATE_D, FRNDS_START_DATE_D, FRNDS_END_DATE_D, EXEC_MEDI_FLG_V, PROVISIONING_PRIORITY_N, X_DIRECTORY_LEVEL_N, ACTIVATED_BY_USER_CODE_N, REGISTRATION_DATE_D, ACTIVATION_DATE_D, REACTIVATION_DATE_D, SUSPENDED_DATE_D, ERASED_DATE_D, MODIFIED_DATE_D, PRE_TERMINATE_DATE_D, ADDITIONAL_LINE#SITE_FLG_V, ADDITIONAL_LINE#SITE_QTY_N, PARENT_ACCOUNT_LINK_CODE_N, MODEL_CODE_V, IMEI_NUMBER_V, IMSI_NUM_N, IMSI_ACTIVE_DATE_D, LINK_GROUP_FLG_V, APPLICATION_NUM_V, BUNDLE_FLAG_V, BUNDLE_SERIAL_NUMBER_V, GROUP_CODE_N, ND_FAX_NUMBER_V, ND_DATA_NUMBER_V, GEO_LOC_ZONE_CODE_V, FAX_SPEED_N, DATA_SPEED_N, ALPHA_NUMERIC_ND_FLAG_V, LAST_NAME_V, PREFERRED_CURR_CODE_V, SALES_PERSON_CODE_V, BILL_CYCL_CODE_N, POSTED_FLAG_N, POSTED_DATE_D, ID_TYPE_V, ID_EXPIRY_DATE_D, SERV_ADDNL_FLD_1_V, SERV_ADDNL_FLD_2_V, SERV_ADDNL_FLD_3_V, SERV_ADDNL_FLD_4_V, SERV_ADDNL_FLD_5_V, SERV_ADDNL_FLD_6_V, SERV_ADDNL_FLD_7_V, SERV_ADDNL_FLD_8_V, SERV_ADDNL_FLD_9_V, SERV_ADDNL_FLD_10_V, SERV_ADDNL_FLD_11_V, SERV_ADDNL_FLD_12_V, SERV_ADDNL_FLD_13_V, SERV_ADDNL_FLD_14_V, SERV_ADDNL_FLD_15_V, SERV_ADDNL_FLD_16_V, SERV_ADDNL_FLD_17_V, SERV_ADDNL_FLD_18_V, SERV_ADDNL_FLD_19_V, SERV_ADDNL_FLD_20_V, SERV_ADDNL_FLD_1_N, SERV_ADDNL_FLD_2_N, SERV_ADDNL_FLD_3_N, SERV_ADDNL_FLD_4_N, SERV_ADDNL_FLD_5_N, SERV_ADDNL_FLD_6_N, SERV_ADDNL_FLD_7_N, SERV_ADDNL_FLD_8_N, SERV_ADDNL_FLD_9_N, SERV_ADDNL_FLD_10_N, NO_OF_CHANNELS_N, PABX_SEQ_N, CS_STATUS_V, STATUS_CHANGE_DATE_D, DEFAULT_CR_CNTL_FLAG_V, SUBSCRIBER_CATEGORY_V, SUBSCRIBER_SUB_CATEGORY_V, PREFERRED_LANGUAGE_V, DMS_RECEIVED_FLAG_V, DMS_VERIFIED_FLAG_V, DMS_RECEIVED_DATE_D, IP_CENTREX_ID_N, CONTRACT_RENEWED_V.

2019-09-26 19:48:30  INFO    OGG-06510  Using the following key columns for target table CBSOGG.FXL_SERVICE_MAST: SERV_ACC_LINK_CODE_N.


2019-09-26 19:48:30  INFO    OGG-06505  MAP resolved (entry CBS_CORE.inv_stock_summary): MAP "CBS_CORE"."INV_STOCK_SUMMARY", TARGET CBSOGG.inv_stock_summary.

2019-09-26 19:48:30  INFO    OGG-02756  The definition for table CBS_CORE.INV_STOCK_SUMMARY is obtained from the trail file.

2019-09-26 19:48:30  INFO    OGG-06511  Using following columns in default map by name: DATE_D, LOCATION_CODE_N, ITEM_CODE_N, OPENING_QTY_N, STOCK_IN_QTY_N, STOCK_OUT_QTY_N, STOCK_RETURN_QTY_N, STOCK_ACCEPTED_QTY_N, STOCK_WRITE_OFF_QTY_N, BUNDLED_STOCK_QTY_N, SUBS_SALES_QTY_N, PROS_SALES_QTY_N, DLR_SALES_QTY_N, STAFF_SALES_QTY_N, GIFT_SALES_QTY_N, SALES_EXCHANGE_QTY_N, CLOSING_STOCK_QTY_N, SALES_RETURN_QTY_N, ACTIVATION_SALES_QTY_N, DECOUPLED_STOCK_QTY_N, REQUISITION_STK_QTY_N, RELEASED_STK_QTY_N, CON_ALLOCATED_QTY_N, CON_RETURN_QTY_N, CON_SALES_QTY_N, CON_RELEASE_STK_QTY_N, BUND_DEC_QTY_N, BUNDLED_ITEM_QTY_N, SAL_CANCEL_QTY_N, DAMAGED_QTY_N, ADJ_QTY_MORE_N, ADJ_QTY_LESS_N, UPLOAD_QTY_N, PND_SALES_QTY_N, ACTUAL_SALES_QTY_N, REL_PND_SALES_QTY_N, BLOCK_QTY_N, REL_BLOCK_QTY_N, EXT_BLOCK_QTY_N, EXT_REL_BLOCK_QTY_N, INCREASED_EQUIP_RET_N, DECREASED_EQUIP_RET_N.

2019-09-26 19:48:30  INFO    OGG-06510  Using the following key columns for target table CBSOGG.INV_STOCK_SUMMARY: DATE_D, LOCATION_CODE_N, ITEM_CODE_N.


2019-09-26 19:48:30  INFO    OGG-06505  MAP resolved (entry CBS_CORE.FXL_CYCLE_SUMMARY_DETAILS): MAP "CBS_CORE"."FXL_CYCLE_SUMMARY_DETAILS",TARGET CBSOGG.FXL_CYCLE_SUMMARY_DETAILS.

2019-09-26 19:48:32  INFO    OGG-02756  The definition for table CBS_CORE.FXL_CYCLE_SUMMARY_DETAILS is obtained from the trail file.

2019-09-26 19:48:32  INFO    OGG-06511  Using following columns in default map by name: ACCOUNT_LINK_CODE_N, SUMMARY_SEQ_NO_N, ARTICLE_CODE_V, CHARGE_AMOUNT_N, NUM_UNITS_N, DURATION_N, NUM_CALLS_N, LOC_CHARGE_AMOUNT_N, DB_CR_V, CHARGE_NUM_OF_CALLS_N, DISC_AMT_N, DISC_DURN_N, LOC_DISC_AMT_N, ACCOUNT_CODE_N, BILL_CYCL_FULL_CODE_N, TAX_AMOUNT_N, CYCLE_START_DATE_D, VOLUME_N, FREE_DISC_AMT_N.

2019-09-26 19:48:32  INFO    OGG-06510  Using the following key columns for target table CBSOGG.FXL_CYCLE_SUMMARY_DETAILS: ACCOUNT_LINK_CODE_N, SUMMARY_SEQ_NO_N, ARTICLE_CODE_V.


2019-09-26 19:48:34  WARNING OGG-02544  Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 233, RBA 434755573 in Integrated mode. REPLICAT will retry in Direct mode.

2019-09-26 19:48:34  WARNING OGG-02544  Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 233, RBA 445464338 in Integrated mode. REPLICAT will retry in Direct mode.

2019-09-26 19:48:34  WARNING OGG-02544  Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 233, RBA 445946804 in Integrated mode. REPLICAT will retry in Direct mode.

2019-09-26 19:48:34  WARNING OGG-02544  Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 233, RBA 453782177 in Integrated mode. REPLICAT will retry in Direct mode.

2019-09-26 19:48:57  WARNING OGG-02544  Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 233, RBA 454656610 in Integrated mode. REPLICAT will retry in Direct mode.

2019-09-26 19:49:08  INFO    OGG-06505  MAP resolved (entry CBS_CUST.CB_POS_TRANS_DTLS): MAP "CBS_CUST"."CB_POS_TRANS_DTLS",TARGET CBSOGG.CB_POS_TRANS_DTLS.

2019-09-26 19:49:08  INFO    OGG-02756  The definition for table CBS_CUST.CB_POS_TRANS_DTLS is obtained from the trail file.

2019-09-26 19:49:08  INFO    OGG-06511  Using following columns in default map by name: TRANSACTION_NUM_V, SEQ_NUM_N, TRANS_DATE_D, SUBSIDIARY_CODE_V, ITEM_CODE_N, GL_CODE_N, START_NO_V, END_NO_V, PRICE_N, PAYMENT_METHOD_V, QUANTITY_N, DISC_AMOUNT_N, AMOUNT_WT_N, TAX_FRML_CODE_V, TAX_AMT1_N, TAX_AMT2_N, TAX_AMT3_N, LOYALITY_POINTS_N, STATUS_V, COMMISSION_CODE_V, COMMENTS_V, RETURN_QUANTITY_N, CREDIT#Y_N, PROFIT_CENTER_V, COMMISSION_ARTICLE_CODE_V, COMMSN_COST_CENTER_V, ACTUAL_START_NO_V, ACTUAL_END_NO_V, SUB_ITEM_CODE_V, SAP_INV_NUM_V, TRANS_DISC_AMT_N, TAX_REFUND_AMOUNT_N, INDIV_BULK_FLG_V, BASE_EXEMPT_TAX_AMT_N, EXEMPT_TAX_AMT_N, BASE_TRANS_DISC_AMT_N, ARTICLE_CODE_V, DISC_PERCENTAGE_N, DISC_MODIFY_FLG_V, PRICE_MODIFY_FLG_V, BASE_TAX_AMT1_N, BASE_TAX_AMT2_N, BASE_TAX_AMT3_N, BASE_AMOUNT_WT_N, BASE_DISC_AMOUNT_N, EXTERNAL_WAREHOUSE_V, COST_CENTRE_CODE_V, WARRANTY_DATE_D, SEND_EMAIL_FLAG_V, FOREIGN_CURRENCY_CODE_V, FOREIGN_CURRENCY_PRICE_N, REFID_N.

2019-09-26 19:49:08  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_POS_TRANS_DTLS: TRANSACTION_NUM_V, SEQ_NUM_N.


2019-09-26 19:49:41  WARNING OGG-02544  Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 233, RBA 454726575 in Integrated mode. REPLICAT will retry in Direct mode.

2019-09-26 19:50:28  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_USERS): MAP "CBS_CORE"."CB_USERS", TARGET CBSOGG.CB_USERS.

2019-09-26 19:50:28  INFO    OGG-02756  The definition for table CBS_CORE.CB_USERS is obtained from the trail file.

2019-09-26 19:50:28  INFO    OGG-06511  Using following columns in default map by name: USER_CODE_N, USER_NAME_V, LOGIN_NAME_V, PASSWORD_V, SUBSIDIARY_CODE_V, DEPARTMENT_CODE_V, SECTION_CODE_V, LEVEL_NUM_N, LOCATION_CODE_V, CONTACT_NUMBER_V, USER_MAC_ADDRESS_V, CHECK_MAC_ADDRESS_V, SERVICE_RIGHTS_CODE_N, VIEW_SUBS_LEVEL_N, TICKER_OPTN_V, IMAGE_CODE_N, GROUP_CODE_N, ADDITIONAL_RIGHTS_FLAG_V, LAST_ACCESSED_BY, LAST_ACCESSED_DATE_D, START_DATE_D, END_DATE_D, STATUS_V, CASH_BOX_PASSWORD_V, SYSTEM_GENERATED_V, PASSWORD_CHNG_DATE_DT, SYSTEM_GEN_PASSWORD_V, LAST_PASS_CHNG_DATE_D, CHANGE_LOCATION_MAC_BASED_V, ACCESS_ID_N, NO_OF_INVALID_ATTEMPTS_N, NO_OF_ALLOWED_ATTEMPTS_N, ADMINISTRATOR_FLAG_V, EMAIL_ID_V, EMAIL_SENT_V, LINKED_DEALER_CODE_V, LAST_LOGIN_DATE_D, LONG_LOGIN_NAME_V, LAST_LOCKED_DATE_D, LOCATION_CODE_N, USER_DESIG_V, COPY_RIGHTS_FROM, DEFAULT_LOCATION_V, USER_NAME_LN_V, LAST_NAME_V, LAST_NAME_LN_V, NOTFICATION_MEDIA_V, APPLICATION_ID_N, FIRST_NAME_V, LANGUAGE_CODE_V, API_CODE_AUTH_V.

2019-09-26 19:50:28  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_USERS: USER_CODE_N.


2019-09-26 19:52:22  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_SUBS_PAID_ADV_DTLS): MAP "CBS_CORE"."CB_SUBS_PAID_ADV_DTLS",TARGET CBSOGG.CB_SUBS_PAID_ADV_DTLS.

2019-09-26 19:52:22  INFO    OGG-02756  The definition for table CBS_CORE.CB_SUBS_PAID_ADV_DTLS is obtained from the trail file.

2019-09-26 19:52:22  INFO    OGG-06511  Using following columns in default map by name: RECEIPT_NO_V, TRANS_DATE_D, ACCOUNT_CODE_N, ADJUST_OPTN_V, LOCAL_CURRENCY_FLG_V, CURRENCY_CODE_V, EXCHANGE_RATE_N, INV_ACC_ADV_AMT_N, SET_OFF_AMT_N, STATUS_OPTN_V, ADV_INTERNAL_REF_N, USER_CODE_N, INV_SRV_OPTN_V, MAIN_ACCOUNT_LINK_CODE_N, SERV_ACC_LINK_CODE_N, LOCATION_CODE_V, CASH_BOX_NUMBER_N.

2019-09-26 19:52:22  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_SUBS_PAID_ADV_DTLS: RECEIPT_NO_V, MAIN_ACCOUNT_LINK_CODE_N, SERV_ACC_LINK_CODE_N.


2019-09-26 19:52:41  WARNING OGG-02544  Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 233, RBA 470491720 in Integrated mode. REPLICAT will retry in Direct mode.

2019-09-26 19:53:03  INFO    OGG-06505  MAP resolved (entry CBS_CORE.cb_batch_process_metrics): MAP "CBS_CORE"."CB_BATCH_PROCESS_METRICS", TARGET CBSOGG.cb_batch_process_metrics.

2019-09-26 19:53:03  INFO    OGG-02756  The definition for table CBS_CORE.CB_BATCH_PROCESS_METRICS is obtained from the trail file.

2019-09-26 19:53:03  INFO    OGG-06511  Using following columns in default map by name: BATCH_ID_V, PROCESSING_STAGE_V, PROCESSING_ORDER_N, TOTAL_SUB_BATCH_PUSHED_N, TOTAL_SUB_BATCH_IN_PROGRESS_N, TOTAL_SUB_BATCH_PROCESSED_N, COMPLETED_ACCOUNTS_N, ERRORED_ACCOUNTS_N, EXIT_CRITERIA_OPTN_FOR_STAGE_N, START_DATE_D, END_DATE_D, STATUS_V, ELAPSED_TIME_N.

2019-09-26 19:53:03  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_BATCH_PROCESS_METRICS: BATCH_ID_V, PROCESSING_STAGE_V.


2019-09-26 19:54:10  WARNING OGG-02544  Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 233, RBA 481748749 in Integrated mode. REPLICAT will retry in Direct mode.

2019-09-26 19:54:21  WARNING OGG-02544  Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 233, RBA 481766421 in Integrated mode. REPLICAT will retry in Direct mode.

2019-09-26 19:55:49  INFO    OGG-02232  Switching to next trail file /ogg/ora12c/dirdat/cd000000234 at 2019-09-26 19:55:49.716313 due to EOF. with current RBA 499,999,133.

2019-09-26 19:58:19  WARNING OGG-02544  Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 234, RBA 50450448 in Integrated mode. REPLICAT will retry in Direct mode.

2019-09-26 19:58:30  WARNING OGG-02544  Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 234, RBA 56208286 in Integrated mode. REPLICAT will retry in Direct mode.

2019-09-26 19:59:42  WARNING OGG-02544  Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 234, RBA 63750250 in Integrated mode. REPLICAT will retry in Direct mode.

2019-09-26 20:03:13  WARNING OGG-02544  Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 234, RBA 65864402 in Integrated mode. REPLICAT will retry in Direct mode.

2019-09-26 20:09:24  WARNING OGG-02544  Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 234, RBA 80223764 in Integrated mode. REPLICAT will retry in Direct mode.

2019-09-26 20:10:07  WARNING OGG-02544  Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 234, RBA 80266076 in Integrated mode. REPLICAT will retry in Direct mode.

2019-09-26 20:13:08  WARNING OGG-02544  Unhandled error (ORA-01031: insufficient privileges) while processing the record at SEQNO 234, RBA 97920106 in Integrated mode. REPLICAT will retry in Direct mode.
