R51800 Permance Issue - Long Time to Complete (Doc ID 2054187.1)

Last updated on NOVEMBER 23, 2015

Applies to:

JD Edwards EnterpriseOne Project Costing - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Job Cost General

ACTUAL BEHAVIOR
---------------
The client is submitting the R51800 (Profit Recognition Build). The client says that when they run the build in their old (8.12) environment, the system takes 30 minutes to process.When they submit that same report with the same data selections, in their 9.1 environment, the system runs for over 24 hours before the client kills the job.

EXPECTED BEHAVIOR
-----------------------
The R51800 should run at least as fast as the 8.12 environment.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Set up identical versions of the R51800 in both JD Edwards EnterpriseOne 8.12 and in JD Edwards EnterpriseOne 9.1.
2. Submit versions for processing
3. Note the processing time taken.

BUSINESS IMPACT
-----------------------
The issue has the following business impact: Client cannot successfully complete the profit recognition process. Client is going live on 9.1 on May 1, 2015

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