Wednesday, June 24, 2015

ADOP Error: The table APPLSYS.TXK_TCC_RESULTS does not exist The EBS Technology Codelevel Checker needs to be run on the following node(s)


Download Patch 17537119 from My Oracle Support  and apply on DB Tier.If any Pre-req patches are missed from the out put please apply those patches.

2. Read the Instructions to run the Database checker utility (checkDBpatch.sh or checkDBpatch.cmd for Windows) from the patch's readme.

3. Follow the steps below :
- Login as the RDBMS ORACLE_HOME owner on the DB tier.
- Unzip the patch
- Confirm the following files are present after unzipping.
    checkDBpatch.sh
    checkDBpatch.cmd
    txk_R1220_DB_base_bugs.xml
    README.txt
- Run the script and Supply the values the script prompts for.
- The script provides a list of one-offs that are either missing, or need to be rolled back.
- Take the appropriate actions based on the results provided by the script.

 +===============================================================+
 |    Copyright (c) 2005, 2014 Oracle and/or its affiliates.     |
 |                     All rights reserved.                      |
 |               EBS Technology Codelevel Checker                |
 +===============================================================+

Executing Technology Codelevel Checker version: 120.24
Enter the full path to the DB Context file :/oracle/xxxx/oradata/VISDB/11.2.

Bugfix XML file version: 120.0.12020000.23

Proceeding with the checks...

Getting the database release ...
Setting database release to 11.2.0.3

 DB connectivity successful.

Created the table to store Technology Codelevel Checker results.

STARTED Pre-req Patch Testing : Wed Jun 24 09:52:12 EDT 2015

Log file for this session : ./checkDBpatch_2527.log

Got the list of bug fixes to be applied and the ones to be rolled back.
Checking against the DB ORACLE_HOME...

Opatch is at the required version.

Found patch records in the inventory.

All the required one-offs are not present in the given ORACLE_HOME
List of missing bug fixes:
14046443
17912217
18260550
18419770
18614015
18685209
18689530
18828868
19393542
19472320
19791273
19896336
19949371
20294666

** Please refer to MOS Doc ID "1594274.1:Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes" to find the corresponding patch that delivers the bug fix. If an overlay patch is needed for any particular patch listed, the footnote for that patch also applies to the overlay patch.**

Stored Technology Codelevel Checker results in the database successfully.

Apply the missing bug fixes and run the script again to confirm.

FINISHED Pre-req Patch Testing : Wed Jun 24 09:52:14 EDT 2015

=========================================================

Applied all the list of patches.17912217 is superseeded of 20294666 Patch.

How To Run The 12.2 EBS Technology Code Level Checker (ETCC) ? (Doc ID 2008451.1)

2 comments:

  1. hello,

    i run the checkDBpatch as above but when I run adop it still says

    [ERROR] ETCC not run in the database node erppreprod
    The EBS Technology Codelevel Checker needs to be run on the database node.
    It is available as Patch 17537119.

    Encountered the above errors when performing database validations.
    Resolve the above errors and restart adop.

    ReplyDelete
    Replies
    1. Did u check xml file executed and see in opatch lsniventory is that patch applied or not if it isnot listed try to apply it again

      Delete