- 4 Posts
- 134 Views
PO_POROLLVW performance
ae "PO_POROLLVW" taking long time to run. Has anyone added index to PO_ROLL_EXCEP or any other table(s) that helped improve processing time ?
Already added four that oracle suggested, but process still running and we've had to stop it. CREATE INDEX PSFVOUCHER ON PS_VOUCHER (ENTRY_STATUS,BUDGET_HDR_STATUS,BUDGET_MISC_STATUS); CREATE INDEX PSBDISTRIB_LINE ON PS_DISTRIB_LINE(BUSINESS_UNIT_RECV,RECEIVER_ID,RECV_LN_NBR,RECV_SHIP_SEQ_NBR,RECV_DIST_LINE_NUM); VOUCHER_LINE, Fields BUSINESS_UNIT_PO, PO_ID, LINE_NBR, SCHED_NBR; DISTRIB_LINE, fields BUSINESS_UNIT_PO, PO_ID, BUSINESS_UNIT, VOUCHER_ID.
I see Bug 29180297 was reported but incident closed with 'Could Not Reproduce'. User there was looking for a primary/unique Index for PO_ROLL_EXCEP.
Does anyone have that ??
Any suggestions or thoughts greatly appreciated! thanks
@Kathryn (Koenig) Dostal
ended up opening an SR with Oracle, they provided patch-fix, BUG 30586536
@Raj Gaggar
that is for the workbench performance, not in reference to the po-roll process itself.
In past, business user said this ran in 20-30 Minutes. Since the po-roll itself has to be run on 01-JAN, it cannot take a long time
thanks
@Kathryn (Koenig) Dostal Run it for a smaller set of PO by creating multiple search ID. Each search ID should not have more than 1,000 rows.
PO Rollover Exception Report Limitation (Doc ID 2574238.1)
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=413701334501313&id=2574238.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=kb4qmq5z7_86#FIX
Note: It is recommended that you create data sets that are no greater than 1000 rows. Any larger and the processing times on the purchase order rollover workbench can be substantial.