My Oracle Support Banner

R12: FV: Due Date Calculation Is Taking Over 12 Hours And Is Completing In Error (Doc ID 2380596.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Payables - Version 12.2.4 and later
Information in this document applies to any platform.
Due Date Calculation is taking over 12 hours and is completing in error.

Symptoms


Due Date Calculation is taking over 12 hours and is completing in error.

SQL ID: 9ddq9zva2ups8 Plan Hash: 2019855301

SELECT DISTINCT TRANSACTION_ID, TRANSACTION_DATE
FROM
RCV_TRANSACTIONS WHERE PO_HEADER_ID=:B1 AND TRANSACTION_TYPE='RECEIVE' START
WITH TRANSACTION_TYPE='ACCEPT' CONNECT BY TRANSACTION_ID = PRIOR
PARENT_TRANSACTION_ID ORDER BY TRANSACTION_DATE DESC




Changes

 NONE

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
Changes
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.