Not Able to Run Post Steps for Oracle Revenue Management and Billing Upgrade 2.4.0.0.0 (Doc ID 2278187.1)

Last updated on JUNE 26, 2017

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.4.0.0.0 version, IP - Installation Upgrade Proc


Not able to run 2.7 Migrating Data steps for upgrade 2.4.0.0.0. Receive the following error while running step 3 from Oracle_Revenue_Management_and_Billing_Upgrade_Guide.pdf. 


UPDATE CI_BCHG_HSTG SET FILE_NAME = "", UPLD_FLTY_CD = "" WHERE BILLTYPE_SW = 'RLB' AND FLGRP_CD = 'FGP_RLB'
Error at line 1
ORA-01741: illegal zero-length identifier

Script Terminated on line 17.
DELETE FROM CI_BCHG_HSTG WHERE BILLTYPE_SW = 'RLB' AND BCHG_HSTG_ID NOT IN SELECT MIN(BCHG_HSTG_ID) FROM CI_BCHG_HSTG WHERE BILLTYPE_SW = 'RLB' AND FLGRP_CD = 'FGP_RLB')
Error at line 1
ORA-00936: missing expression

Script Terminated on line 13.
UPDATE CI_BCHG_STG
SET BCHG_HSTG_ID = (SELECT BCHG_HSTG_ID FROM CI_BCHG_HSTG WHERE BILLTYPE_SW = 'RLB'
AND FLGRP_CD = 'FGP_RLB' AND ROWNUM = 1 ORDER BY BCHG_HSTG_ID DESC)
WHERE BCHG_HSTG_ID IN (SELECT BCHG_HSTG_ID FROM CI_BCHG_HSTG WHERE BILLTYPE_SW = 'RLB')
Error at line 1
ORA-00907: missing right parenthesis

Script Terminated on line 1.





STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run step 3 from Oracle_Revenue_Management_and_Billing_Upgrade_Guide.pdf.

Cause

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