Title
Increase columns in B2B_CTLNUM tables to accomodate larger transaction control numbers

Date
2008-01-30

Summary
The columns in B2B_CTLNUM_IN and B2B_CTLNUM_OUT tables are limited to 14 characters, but transaction control numbers may exceed that. It is possible to safely increase the lengths of these columns to 30 characters to accomodate larger transaction control numbers. 

SQL> DESC b2b.b2b_ctlnum_out
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
 TPID                                      NOT NULL NVARCHAR2(100)
 INTERCHANGE                                        VARCHAR2(14)
 FUNCTIONALGROUP                                    VARCHAR2(14)
 TRANSACTION                                        VARCHAR2(14)


SQL> DESC b2b.b2b_ctlnum_in
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
 TPID                                      NOT NULL NVARCHAR2(100)
 INTERCHANGE                                        VARCHAR2(14)
 FUNCTIONALGROUP                                    VARCHAR2(14)
 TRANSACTION                                        VARCHAR2(14)

Details
1. Log on to the database as user b2b and issue the following commands: 
ALTER TABLE b2b_ctlnum_out MODIFY (transaction VARCHAR2(30), interchange varchar2(30),  functionalgroup varchar2(30));

ALTER TABLE b2b_ctlnum_in MODIFY (transaction VARCHAR2(30), interchange varchar2(30), functionalgroup varchar2(30));

Applicable Versions
Oracle B2B 10g (10.1.2)
Ahmed Aboulnaga
.com .com