solve this Issue plz

[bnvsudhakar]

Hi,
guys,
give the solution for this issue.

The Vendor on Payment hold report when run for one org. completes quickly and returns around 270 records(it takes around 2 minutes) but
for other org it runs over 37 mins and was then terminated (ran for 'All' site types).
For 'Expense' site type it completes in 35 mins.

Unable to understand why it should take so long (35 mins) as the number of records fetched is only 70.

[anu_uma]

Hi,

Check the Log file, if you are not able to identify the issue, please raise an SR with Oracle

Regards

[SIVAKUMAR_G]

Hi

For any performance issue, You need to do the following things before you log an SR with Oracle

a) Check for any invalid Objects that pertains to your specific Module or package it uses
Run the following script to identify the Invlid objects from SQL prompt
select object_type,object_name
from dba_objects
where status = 'INVALID';
If you find invlaid objects, recompile those invalid objects
b) Run Gather schema statistics concurrent program from system administrator
c) Take a DB trace and identify the SQL query which takes the maximum time
d) Log an SR with Oracle after performing the above with the information

Regards
Sivakumar