Unable To Load Fully Customized Storable Class Through Pin_rel (Doc ID 1965775.1)

Last updated on JANUARY 26, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.
***Checked for relevance on 26-January-2017***

Goal

We have requirement not to load the rated EDR into OOTB event and balance tables. For tuniexp event(event/delayed/session/telco/tuniexp), no event details and no balance impact are required and only Associated Record details needs to be loaded into custom base class(/vc_tuniexp).

In Infranet.Properties we add like below.

Here <> = infranet.rel.storable_class.event_delayed_session_telco_tuniexp

# /event/delayed/session/telco/tuniexp
<>.interim_directory = /opt/sp/brm/pin01/7.5/ifw/custom/pin_rel_07/in
<>.supported_creation_processes = RATING_PIPELINE, RERATING_PIPELINE, PIN_REL_TRANSFORM_CDR,SUSPENSE_CREATE,SUSPENSE_UPDATE,BACKOUT_PIPELINE
<>.failure_script = ./pin_rel_handle_interim_files.pl
<>.failure_flags = 1
<>.preprocess_script = ./pin_rel_preprocess_tuni_cdr.pl
<>.preprocess_flags = 0
<>.number_of_tables = 1
<>.table.1.name = vc_tuni_t
<>.table.1.load_util = ./load_vc_tuni_t.sh
<>.table.1.control_file = vc_tuni_t.ctl
<>.preupdater_sproc = pin_rel_tuni_pre_updater_sp
<>.preupdater_batch_size = 5
<>.preupdater_flags = 0
<>.updater_sproc = pin_rel_tuni_updater_sp
<>.updater_batch_size = 5
<>.updater_flags = 0
<>.success_script = ./pin_rel_handle_interim_files.pl
<>.success_flags = 1


Dummy preupdater_sproc and updater_sproc are also created in procedures as given below:

 

create or replace
PROCEDURE PIN_REL_TUNI_UPDATER_SP AS
BEGIN
NULL;
END PIN_REL_TUNI_UPDATER_SP;


create or replace
PROCEDURE PIN_REL_TUNI_PRE_UPDATER_SP AS
BEGIN
NULL;
END PIN_REL_TUNI_PRE_UPDATER_SP;

 But its not helping, would be possible to provide the list and type of parameters passed to the pin_rel_pre_updater_sp stored procedure and pin_rel_updater_sp stored proceudre, so that we can try creating the dummy procedure with same list of parameters and see if it works. ?

Solution

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