My Oracle Support Banner

BILLOPEN Batch - Temp Space Issue (Doc ID 2525941.1)

Last updated on DECEMBER 04, 2019

Applies to:

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

Symptoms

On : 2.6.0.1.0 version, BT - Batch

ACTUAL BEHAVIOR
---------------
BILLOPEN batch - temp space issue

We have tested running BILLOPEN batch in two environments and is eventually leading to temp space issue. Please find below the steps followed in each environments.

IUT environment:

Running the BILLOPEN with all the invoice accounts(around 80K) having bill cycle code as MO01, along with that
Around 175 accounts were updated with invoice accounts as MO01, while running the BILLOPEN batch the batch
would go in error, the instance would take long time to create and batch would ultimately go into error with
TEMP space error. Base query which checks the construct accounts seems to take lot of processing time.

UAT environment:

BILLOPEN batch was run on UAT environment which is smaller as compared to IUT environment.
The number of records with MO01 was around 30-40, and only 10 billable charges to be executed.
The batch never completes and giving similar issue with TEMP space and long running query.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.