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.
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:
Post a Comment