My Oracle Support Banner

Performance issue with Send Notifications For Purchasing Documents, never completes (Doc ID 2706455.1)

Last updated on AUGUST 31, 2020

Applies to:

Oracle Purchasing - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

Send Notifications for Purchasing Documents (which usually runs in seconds) starts running long and never completing.

This is caused by infinite loop in standard Oracle code for object PO_APPROVAL_REMINDER_SV.Process_unapprove_pos(Line#337).

In above code EXIT WHEN CURSOR%NOTFOUND is at the end of loop instead of immediately after FETCH statement, and there is a CONTINUE statement with in loop which makes it possible to skip reaching EXIT WHEN%NOTFOUND for particular iteration. That CONTINUE will be reached in when AME_APPROVAL_ID value is null for that iterations record. It will go into infinite loop when
such record occur as last record in the cursor result set.

It does not make sense not to have EXIT WHEN CURSOR%NOTFOUND immediately after FETCH.

Cause

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
Symptoms
Cause
Solution
References


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