CCB: Batches C1-WAMAS and C1-WAMEX Not Able To Upload Data In WAM Customer And Asset Tables (Doc ID 1301722.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Utilities Customer Care and Billing - Version: 2.3.0 and later   [Release: 2.3 and later ]
Information in this document applies to any platform.

Goal

On : CCB 2.3.0 version, oracle 11.2.0.1 and WAM 1.9

The batches C1-WAMAS and C1-WAMEX are not able to upload data in to WAM tables. The following errors are raised in the logs:

ERROR in C1-WAMAS logs:
12:36:27,109 [Thread-76:WorkProcessor$WorkRunner(WorkProcessor$WorkRunner:9b52ae0b-9e2d-4cc5-b8d7-2943e987d342)] ERROR (com.splwg.base.support.sql.PreparedStatementImpl) Error executing execute for rawSQL:
INSERT INTO IN_WAM_WAIF_ASSET (PLANT, ASSET_ID, ASSET_TYPE, ASSET_DESC, ASSET_STATUS, PARENT_ASSET_ID, STREET_NAME, CROSS_STREET, CITY, STATE_PROVINCE, POSTAL_CODE, CCB_SOURCE, LOCATION_BASIS, PARSE_ADDRESS, LAST_UPDATE_DATE, CREATION_DATE , LAST_UPDATE_USER, CREATED_BY) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
with date createdDate and value '2011-01-24' bound to indice(s): 16
with string lastUpdateUser and value 'CCB_INTEGRATION' bound to indice(s): 17
with string assetStatus and value 'ACTIVE' bound to indice(s): 5
with string ccbSource and value 'SERVICE POINT' bound to indice(s): 12
with string locationBasis and value 'ADDRESS' bound to indice(s): 13
with string createdBy and value 'CCB_INTEGRATION' bound to indice(s): 18
with string parseAddress and value 'Y' bound to indice(s): 14
with string streetName and value '1' bound to indice(s): 7
with string assetDescription and value 'Electric Metered-LT(2 to 4.99999999KW)/1, noida, UP, 500062 ' bound to indice(s): 4
with string assetId and value '8751145561' bound to indice(s): 2
with string assetType and value 'METLTU5' bound to indice(s): 3
with string state and value 'UP' bound to indice(s): 10
with date lastUpdateDate and value '2011-01-24' bound to indice(s): 15
with string plant and value '231' bound to indice(s): 1
with string parentAssetId and value '8751145505' bound to indice(s): 6
with string crossStreet and value ' ' bound to indice(s): 8
with string city and value 'noida' bound to indice(s): 9
with string postal and value '500062' bound to indice(s): 11

java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)


ERROR in C1-WAMEX logs:

12:20:11,772 [Thread-76:WorkProcessor$WorkRunner(WorkProcessor$WorkRunner:7d0712f6-7469-4d75-b1e7-fcff0678a325)] ERROR (com.splwg.base.support.sql.PreparedStatementImpl) Error executing execute for rawSQL:
INSERT INTO IN_WAM_WAIF_CUSTOMER (RECORD_TYPE, PLANT, CUSTOMER_ID, CUSTOMER_STATUS, CCB_ACCT_SETUP_DATE, CCB_ACCT_BILL_CYCLE, CCB_ACCT_MAIN_PERSON_ID, CCB_ACCT_ADDRESS_SOURCE, COMPANY, CUSTOMER_FIRST_NAME, CUSTOMER_MIDDLE_NAME, CUSTOMER_LAST_NAME, LAST_UPDATE_DATE, CREATED_DATE , LAST_UPDATE_USER, CREATED_BY) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
with date createdDate and value '2011-01-24' bound to indice(s): 14
with string lastUpdateUser and value 'CCB_INTEGRATION' bound to indice(s): 15
with date accountSetupDate and value '2010-04-01' bound to indice(s): 5
with string billCycle and value '' bound to indice(s): 6
with string createdBy and value 'CCB_INTEGRATION' bound to indice(s): 16
with string addressSource and value 'Mailing Premise on Account' bound to indice(s): 8
with string companyName and value '' bound to indice(s): 9
with string firstName and value 'g' bound to indice(s): 10
with id customerId and value 'Account_Id(6777947069)' bound to indice(s): 3
with string lastName and value 'chandu' bound to indice(s): 12
with id mainPersonId and value 'Person_Id(0547765035)' bound to indice(s): 7
with string middleName and value ' ' bound to indice(s): 11
with date lastUpdateDate and value '2011-01-24' bound to indice(s): 13
with string recordType and value 'H' bound to indice(s): 1
with string plant and value '231' bound to indice(s): 2
with string customerStatus and value 'ACTIVE' bound to indice(s): 4

java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)


Steps to replicate the issue:
1) Create WAM DB link
2) Run C1-WAMAS, C1-WAMEX bathes
3) No errors but no data populated in WAM


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms