R12 thru R12.1: FAXPICMP AND FAXPIINV: Physical Inventory Query In Faxpidef Form Takes Ages To Retrieve Records (Doc ID 1285049.1)

Last updated on MARCH 07, 2017

Applies to:

Oracle Assets - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
Faxpidef
Physical Inventory Form

Symptoms


Performance issue in the Physical inventory forms when retrieving records.


Physical Inventory Query in FAXPIDEF form ( Form Version : 12.0.1.12010000.4 ) takes ages to retrieve records. It takes approximately 10 minutes to retrieve inventory information (query by inventory_name) and it takes again time when you want to check this inventory records. Finally, it opens it and data in it is correct.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open the physical Inventory form.
2. Query the records
3. It takes a long time to retrieve the data

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