My Oracle Support Banner

Performance Issue While Saving Online PO Receipts (Doc ID 2070310.1)

Last updated on AUGUST 24, 2020

Applies to:

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

Symptoms

Saving a PO Receipt takes approximately 1-2 minutes.

Expect performance should be less than 20 seconds.

Issue does not occur when RCV: Processing Mode is Immediate or Batch

Explain plan:

SELECT * FROM RCV_HEADERS_INTERFACE RHI WHERE ASN_TYPE IN ('ASN', 'ASBN') AND PROCESSING_REQUEST_ID = :B2

AND (GROUP_ID = :B1 OR :B1 = 0)

AND (PROCESSING_STATUS_CODE = 'ERROR' OR EXISTS (SELECT 1 FROM RCV_TRANSACTIONS_INTERFACE RTI

WHERE RTI.HEADER_INTERFACE_ID = RHI.HEADER_INTERFACE_ID

AND RTI.PROCESSING_STATUS_CODE = 'ERROR'))

Plan hash value: 2982279373

| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | | 0 | SELECT STATEMENT | | | | 10279 (100)| | |* 1 | FILTER | | | | | | |* 2 | TABLE ACCESS FULL | RCV_HEADERS_INTERFACE | 1 | 129 | 10279 (3)| 00:02:04 | |* 3 |

TABLE ACCESS BY INDEX ROWID| RCV_TRANSACTIONS_INTERFACE | 101 | 2020 | 1 (0)| 00:00:01 | |* 4 | INDEX RANGE SCAN | RCV_TRANSACTIONS_INTERFACE_N6 | 1 | | 1 (0)| 00:00:01 |

The table RCV_HEADERS_INTERFACE is TABLE ACCESS FULL SQL>

SELECT processing_status_code,count(0) from apps.RCV_HEADERS_INTERFACE RHI 2 group by processing_status_code 3 / PROCESSING_STATUS_CODE COUNT(0) 

RUNNING 3 SUCCESS 1505181 ERROR 1062 Could you help to log a bug to tunning the sql or create the index for PROCESSING_REQUEST_ID

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.