Patch Application Error: Applying Patch 7533081:R12.AR.A Failed: File Artrx.Odf On Worker (Doc ID 794759.1)

Last updated on JUNE 08, 2016

Applies to:

Oracle Receivables - Version 12.0.5 and later
Information in this document applies to any platform.

Goal

During the application of AR March 2009 CPC <Patch 7533081>:R12.AR.A, the following errors occur:


ATTENTION: All workers either have failed or are waiting:
FAILED: file artrx.odf on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.



The worker log shows:

===== Table AR_PAYMENT_SCHEDULES_ALL all columns match.

The freelists value for table AR_PAYMENT_SCHEDULES_ALL is too small.
[Alter Table freelists from 0 to 4 ]

Alter the table with the statement:
ALTER TABLE AR.AR_PAYMENT_SCHEDULES_ALL STORAGE (FREELISTS 4)

AD Worker error:
The following ORACLE error:

ORA-00054: resource busy and acquire with NOWAIT specified

occurred while executing the SQL statement:

ALTER TABLE AR.AR_PAYMENT_SCHEDULES_ALL STORAGE (FREELISTS 4)

AD Worker error:
Unable to compare or correct tables or indexes or keys
because of the error above

What can be done to fix or bypass this error?

Solution

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 hundreds of Community platforms