Service with a Smile..

-
Oracle Utilities Framework 2.2.0 SP6 (Patch number 9042811) and Customer Care & Billing 2.2.0 SP6 (Patch number 9042819) are now available for download from My Oracle Support. 

Comments

Post a Comment

Popular posts from this blog

Embedding web-based external applications within the framework.

-
Image
My current project contained a requirement to embed an external application within the the CC&B framework and initiate calls to this application supplying a number of context elements to ensure that the correct information is displayed. The client also requested that the application be 'skinned' to maintain the CC&B look-and-feel. This is how we implemented it.. Defined a number of Business Object to manage retrieval of data from some of the base CC&B objects in a flattened format (ie. Characteristics mapped to descriptive elements, unused fields not defined, etc). Defined a UI map which forms the canvas for 'painting' the application within our framework. A Query Zone to ensure that the required data associated with the Context Zones are retrieved (using Zone type F1-DE-QUERY). A Business Service to wrap the call to the Query Zone into a usable service. A Script to initiate the call to the Business Service with the associated Context Identifiers (fr...
Read more

Threading...

-
A common question that I get asked is.. how do we force multi-threaded conversion jobs to split the key ranges evenly across each thread instance? Unfortunately I don't have an easy answer. The base conversion jobs seem to take a simplistic approach of using the low and high override values (if supplied, otherwise they use values of 0000000000 and 9999999999) and then divide these by the number of threads to determine the ranges for each instance. But.. We have found that we can force a predefined range of values and simulate threading but having separate batch controls defined for each thread, with predefined high/low values and these can then be run concurrently through standard batch submission processes.. e.g.. if we want to run VAL-ACCT in 4 threads and ensure that a known range of source keys between 0000000001 and 0000100000 is split between the 4 threads, we clone the existing batch control into VAL-ACCT1, with OVRD-LOW-ID = 0000000001 and OVRD-HIGH-ID = 0000025000 V...
Read more

Inserting values > 4000 characters into CXC_* tables

-
Question Recieved: We are encountering the following Error: Error encountered when trying to build a particular SQL statement. The output of the error message is as follows: SQLException in com.oracle.ugbu.cc.run.builder.SqlBuildStatementRow Message: ORA-01461: can bind a LONG value only for insert into a LONG column SQLState: 72000 ErrorCode: 1461 Statement causing error: INSERT INTO CXC_SQL_BUILD_STMT ( CXC_SQL_BUILD_ID ,CXC_STEP_SEQ ,CXC_TOP_DOWN_SEQ ,CXC_STATEMENT_SEQ ,STMT_EXEC_CLASS ,CXC_SQL_TEXT ,ROW_VERSION ) VALUES (?,?,?,?,?,?,?) Answer: This error occurs if the SQL value being inserted into CXC_SQL_BUILD_STMT exceeds 4000 characters, consider using pre-compiled PL/SQL functions or Temporary staging tables to ensure that individual SQL statements are not overly complex.
Read more