SYSTEM-UNABLE TO SET NLS SORT

After clone i am not able to run active user concurrent program. facing below issue. Please find log file.
Application Object Library: Version : 12.1

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDSCURS: Active Users
+---------------------------------------------------------------------------+

Current system time is 13-JAN-2020 12:36:09
+---------------------------------------------------------------------------+
+-----------------------------
| Starting concurrent program execution...
+-----------------------------

SYSTEM-UNABLE TO SET NLS SORT
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 23849699.

Review your concurrent request log and/or report output file for more detailed information.

+---------------------------------------------------------------------------+
Executing request completion options...

Output file size:

Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 13-JAN-2019 12:36:10


Solution :-


Solution is to apply Patch 24675262:R12.FND.B: SCHEDULED REQUEST ERROR SYSTEM-UNABLE TO SET NLS SORT DUE TO NEW NLS_SORT COLUMN, but this patch contains a version of afpcrm.oc that can cause potential data corruption - see bug 23021248.

Ref: BUG 23021248 - CONC REQUEST RUNNING TWICE CREATING BALANCE CORRUPTION

Apply Patch 23021248:R12.FND.B: CONC REQUEST RUNNING TWICE CREATING BALANCE CORRUPTION



ACTION PLAN
=============



On a test environment where the issue occurs, download and apply patch 23021248.

1. Download patch 23021248.
2. Enable 'Maintenance Mode.
3. execute adpatch.
4. Disable 'Maintenance Mode'


SQL> select bug_number,creation_date from ad_bugs where bug_number='23021248';

BUG_NUMBER                     CREATION_
------------------------------ ---------

23021248                       15-JAN-20


 Retest issue. I hope issue got resolved.


No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...