CCB: Batches C1-WAMAS and C1-WAMEX Not Able To Upload Data In WAM Customer And Asset Tables

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

Applies to:

Goal

Solution

Sign In with your My Oracle Support account

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