Who's On?

	Membership:
	Latest: navav4
	Past 24 Hours: 2
	Prev. 24 Hours: 0
	Overall: 5208

	People Online:
	Visitors: 204
	Members: 0
	Total: 204

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

drill-around on company field take up 15 second

4 Replies

0 Subscribed to this topic

43 Subscribed to this forum

Sort:

Author

Messages

Xin Li

Veteran Member

Posts: 134

New Poster

Engaged Reader

Avid Reader

3/12/2009 8:05 PM

On program Ap20, po20, gl90, etc if drill-around on company field, it takes up 15 second to display. Anyone has similar issue? Any suggestion to improve it?

We are on AIX 5.3 LSF 9.0.04 and Apps 8.1.0. Oracle 10g

John Henley

Posts: 3362

New Poster

Engaged Reader

Avid Reader

3/12/2009 9:03 PM

Is this the only drill around that is slow?

Xin Li

Veteran Member

Posts: 134

New Poster

Engaged Reader

Avid Reader

3/13/2009 12:49 PM

Yes. This is only drill-around slow.

Xin Li

Veteran Member

Posts: 134

New Poster

Engaged Reader

Avid Reader

3/13/2009 12:51 PM

Yes. Drill-around company field is the only slow slow. Other field come back fast.

John Henley

Posts: 3362

New Poster

Engaged Reader

Avid Reader

3/13/2009 4:45 PM

How many companies do you have? Accounting Units? GLTRANS records?
Have you run verifyoraXX against IF & GL to verify that indexes are OK?