Create_journal.Pl Fails in Create_temp_journals Mode (Doc ID 757195.1)

Last updated on DECEMBER 19, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.1.0.0 [Release 7.3.0 to 7.3.1]
Oracle Solaris on x86 (32-bit)
Sun Solaris x86 (32-bit)
Checked for relevance on 19-Dec-2016.

Symptoms

Upgrading from Infranet 6.7FP1 to BRM 7.3.1. When executing create_journal.pl in create_temp_journals mode (with verbose enabled), the output includes error messages:

Info: Using default configuration file 'create_journal.config'
Info: Parameters for create_journal are as below
Mode: create_temp_journals
End date: Thu Dec 31 00:00:00 2009
End time in seconds: 1262217600
Currency only: No
Database user: pin
Database alias: pindb
Journal start date: Tue Jul 1 00:00:00 2008
Journal start time in seconds: 1214870400
Partition days: 30

****** Calling sqlplus as follows:
sqlplus -silent pin/pin@pindb <temp_commands.sql
****** Output of sqlplus follows:
CALL journal.create_tmp_journals(1214870400, 1262217600, 0)
*
ERROR at line 1:
ORA-20027: Error while creating temporary journal table : ORA-00907: missing right parenthesis
ORA-06512: at "PIN.JOURNAL", line 821
ORA-06512: at line 1

Changes

 

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