My Oracle Support Banner

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:

JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.2 and later
Information in this document applies to any platform.


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. 


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

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