E1: 43: Performance Issues in Landed Cost Process for PO Receipts (P4312) Passing Blank Key Values To F43121 (Doc ID 3001297.1)

Last updated on JANUARY 30, 2024

Applies to:

Symptoms

We are experiencing both performance issues and database locks when processing PO Receipts (P4312) and calling Landed Cost (P43291). In the application P4312 - PO Receipts, the NER having the issue is N4300970. Blank key values are being passed to the PO Receipts table F43121.Fetch Single. The database is choosing the incorrect index and causing these performance issue.

It appears that when Bug 25094636 was fixed, Oracle relocated the code but relocated it partially and left F43121.Fetch Single as it is. This BF parameters value are not passed from the calling application and neither is there any cache retrieval. Due to which the BF parameters are passed blanks to the F43121.Fetch Single and causing performance issue at the DB level.

The issue can be reproduced at will with the following steps:

1. Create several lines on a purchase order using currency USD, J line type (P4310).
2. Go to PO Receipts (P4312) and find the order just entered.
3. Select 2 of the lines in the grid and manually add a two different landed cost rules.
4. When selecting the green check mark, their system experiences database locks etc. 

Cause

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