5 Post-Upgrade Tasks

Review the upgrade changes in warehouse schema and data and perform the suggested changes.

If you are upgrading from Oracle BI Applications 11.1.1.10.3PS3 to 11.1.1.10.3PS4, no DDL changes are required. You just need to make sure that the PB4 (Patch Bundle 4) is applied before you perform the in-place upgrade.

If you are upgrading from Oracle BI Applications 11.1.1.10.3/11.1.1.10.3PS2 to 11.1.1.10.3PS4, it's recommended that you check and execute the listed DDL changes and apply the PB2 (Patch Bundle 2) before proceeding with the in-place upgrade.

Grant DBMS_CRYPTO privilege to Warehouse schema user; 
Grant execute on DBMS_CRYPTO to %_DW; 

Execute the following commands on the Warehouse schema:

ALTER TABLE W_ORA_INVPROD_DS_TMP MODIFY PRODUCT_NUM VARCHAR2(40 CHAR); 
ALTER TABLE W_INVENTORY_PRODUCT_DS MODIFY PRODUCT_NUM VARCHAR2(40 CHAR); 
ALTER TABLE W_INVENTORY_PRODUCT_D MODIFY PRODUCT_NUM VARCHAR2(40 CHAR); 
ALTER TABLE W_PURCH_RCPT_FS MODIFY RECEIPT_TEXT VARCHAR2(4000 CHAR); 
ALTER TABLE W_PURCH_RCPT_F MODIFY RECEIPT_TEXT VARCHAR2(4000 CHAR); 
ALTER TABLE W_PURCH_RCPT_TMP MODIFY RECEIPT_TEXT VARCHAR2(4000 CHAR);