My Oracle Support Banner

Error And Poor Performance Of NF Cancellation Process (Doc ID 2405823.1)

Last updated on JUNE 06, 2018

Applies to:

Oracle Retail Fiscal Management - Version 14.1.2 to 14.1.3.2 [Release 14.1]
Information in this document applies to any platform.

Symptoms

When there are multiple invoices, following error is noted during NF Cancellation process:

PACKAGE_ERROR@1ORA-06511: PL/SQL: cursor already open@2FM_STOCK_REVERSAL_SQL.PROCESS_REVERSAL

Also, it is taking about 5 hours for the processing, and performance needs to be improved.

Changes

 

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!


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