R12:AP:AutoRate Program Run For Days And Complete With Error (Doc ID 2082181.1)

Last updated on MARCH 25, 2016

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Accounting Issues in AP

Period close problem- AutoRate program run for days and complete with error

AutoRate run for more than 24 hours. Complete with error without populating the exchange rate in the payments.

When running the AutoRate for particular  org id it complete with ERROR
When running the AutoRate for another org id it complete normal after 30 seconds.
There are exchange rate in the daily rate table for the requested dates.

Due to this error,
There are error 95359 and 95333 in the create accounting

Need ASAP datafix for populating the exchange rate in the payment so we can close the period.
Also need to fix the problem with AutoRate program
 

ERROR
-----------------------
ORA-03113: end-of-file on communication channel
ORA-03113: end-of-file on communication channel
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-03113: end-of-file on communication channel
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: MSG-00100: AutoRating Invoice Records.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run AutoRate program
2. Error appear.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot Close period.

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