Sunday, October 25, 2020

1.3 Oracle E-Business Suite Release 12.2 Technology Stack Documentation Roadmap

 In This Document


​
The various books and My Oracle Support knowledge documents listed herein are written and maintained by EBS Development, and categorized as follows.

Section 1: Release Notes, Readmes, and Related Documents

1.1 All 12.2 Releases

1.2 AD-TXK Updates

1.2.1 Application Instructions

  • Document 1583092.1, Oracle E-Business Suite Release 12.2: Suite-Wide Rollup and AD/TXK                                              Delta Information
  • Document 1617461.1, Applying the Latest AD and TXK Release Update Packs to Oracle E-                                                Business Suite Release 12.2
  • Document 1903052.1, Applying A Non-Current Version of the AD and TXK Release Update Packs                                        to Oracle E-Business Suite Release 12.2
1.2.2 Release Notes

  • Document 2649885.1, Oracle E-Business Suite Applications DBA and Technology Stack Release                                        Notes for R12.AD.C.Delta.12 and R12.TXK.C.Delta.12
  • Document 2527995.1, Oracle E-Business Suite Applications DBA and Technology Stack Release                                        Notes for R12.AD.C.Delta.11 and R12.TXK.C.Delta.11
  • Document 2295390.1, Oracle E-Business Suite Applications DBA and Technology Stack Release                                        Notes for R12.AD.C.Delta.10 and R12.TXK.C.Delta.10
  • Document 2233485.1, Oracle E-Business Suite Applications DBA and Technology Stack Release                                        Notes for R12.AD.C.Delta.9 and R12.TXK.C.Delta.9
  • Document 2159750.1, Oracle E-Business Suite Applications DBA and Technology Stack Release                                        Notes for R12.AD.C.Delta.8 and R12.TXK.C.Delta.8
  • Document 2033780.1, Oracle E-Business Suite Applications DBA and Technology Stack Release                                        Notes for R12.AD.C.Delta.7 and R12.TXK.C.Delta.7
  • Document 1983782.1, Oracle E-Business Suite Applications DBA and Technology Stack Release                                        Notes for R12.AD.C.Delta.6 and R12.TXK.C.Delta.6
  • Document 1934471.1, Oracle E-Business Suite Release 12.2: Now Available - Essential Bundle F                                     Fixes for AD Delta 5 and TXK Delta 5
  • Document 1644660.1, Oracle E-Business Suite Technology Stack and Applications DBA Release                                        Notes for R12.TXK.C.Delta.5 and R12.AD.C.Delta.5
  • Document 1674784.1, Oracle E-Business Suite Release 12.2: Now Available - Essential                                                      Consolidated Rollup Patches for AD Delta 4 and TXK Delta 4
  • Document 1624423.1, Oracle E-Business Suite Technology Stack and Applications DBA Release                                        Notes for R12.TXK.C.Delta.4 and R12.AD.C.Delta.4

1.3 Applications Technology Product Family Updates

1.4 Release 12.2.10
  • Document 2666934.1, Oracle E-Business Suite Release 12.2.10 Readme
  • Document 2693485.1, Oracle E-Business Suite Applications DBA and Technology Stack Release                                        Notes for Release 12.2.10
1.5 Release 12.2.9

  • Document 2495027.1, Oracle E-Business Suite Release 12.2.9 Readme
  • Document 2559770.1, Oracle E-Business Suite Applications DBA and Technology Stack Release                                        Notes for Release 12.2.9
1.6 Release 12.2.8

  • Document 2393248.1, Oracle E-Business Suite Release 12.2.8 Readme
  • Document 2292750.1, Oracle E-Business Suite Applications DBA and Technology Stack Release                                        Notes for Release 12.2.7 and 12.2.8
1.7 Release 12.2.7

  • Document 2230783.1, Oracle E-Business Suite Release 12.2.7 Readme
  • Document 2292750.1, Oracle E-Business Suite Applications DBA and Technology Stack Release                                        Notes for Release 12.2.7 and 12.2.8
1.8 Release 12.2.6

  • Document 2114016.1, Oracle E-Business Suite Release 12.2.6 Readme
  • Document 2149555.1, Oracle E-Business Suite Applications DBA and Technology Stack Release                                        Notes for Release 12.2.6
1.9 Release 12.2.5

  • Document 1983050.1, Oracle E-Business Suite Release 12.2.5 Readme
  • Document 2050998.1, Oracle E-Business Suite Applications DBA and Technology Stack Release                                        Notes for Release 12.2.5
1.10 Release 12.2.4

  • Document 1617458.1, Oracle E-Business Suite Release 12.2.4 Readme
  • Document 1911660.1, Oracle E-Business Suite Technology Stack and Applications DBA Release                                        Notes for Release 12.2.4
1.11 Release 12.2.3

  • Document 1586214.1, Oracle E-Business Suite Release 12.2.3 Readme
  • Document 1606170.1, Oracle E-Business Suite Technology Stack and Applications DBA Release                                        Notes for Release 12.2.3

Section 2: Installation and Configuration

2.1 Administration and Management

  • Document 1378579.1, Troubleshooting Rapid Install for E-Business Suite Release 12.2
  • Document 1375769.1, Sharing The Application Tier File System in Oracle E-Business Suite                                                  Release 12.2
  • Document 1375686.1, Using Load-Balancers with Oracle E-Business Suite Release 12.2
  • Document 393861.1,   Globalization Guide for Oracle E-Business Suite Release 12.0 to 12.2
  • Document 393320.1,   Internationalization Update Notes for Release 12.2
  • Document 437878.1,   Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite                                          Release 12
  • Document 807393.1,   Hijrah and Thai Calendar Support in Oracle E-Business Suite R12.1 and 12.2
  • Document 1581549.1, Best Practices for Minimizing Oracle E-Business Suite Release 12.2.n                                                Upgrade Downtime
  • Document 1583752.1  Express Diagnosis of Oracle E-Business Suite Release 12.2.n Upgrade                                              Performance Issues
  • Document 1597531.1, Oracle Applications Release 12.2: Upgrade Sizing and Best Practices
  • Document 1906545.1, Resolving Domain Deployment Issues When Installing Oracle E-Business                                        Suite Release                                        12.2
  • Document 567015.1,   Using IPv6 with Oracle E-Business Suite Releases 11i and 12
  • Document 1077709.1, Using Lightweight MLS With Oracle E-Business Suite Release 12.1.3 and                                          Higher
  • Document 563019.1,   Complying with Daylight Saving Time (DST) and Time Zone Rule Changes                                        in  E-Business  Suite Release 12
  • Document 384241.1,   Using Forms Socket Mode with Oracle E-Business Suite Release 12
  • Document 414992.1,   Using Cygwin to Maintain Oracle E-Business Suite Release 12 on Windows
  • Document 1460742.1, Deploying Oracle E-Business Suite on Oracle Exalogic Elastic Cloud and                                          Oracle Exadata Database Machine
  • Document 2025309.1, Using Oracle Database In-Memory with Oracle E-Business Suite
  • Document 2045552.1,  Getting Started with Oracle Application Management Pack (AMP) for                                               Oracle E-Business Suite Release 13.1.1.1.0
  • Document 2676355.1,  Getting Started with Oracle Application Management Pack for Oracle E-                                         Business Suite (AMP), Release 13.4.1.0.0
  • Document 2528000.1,  Oracle E-Business Suite Performance Best Practices
  • Document 2736939.1,  Oracle E-Business Suite Electronic Technical Reference Manual (eTRM),                                             Release 12.1 and 12.2
  • Document 2749775.1,  EBS 12.2 Upgrade Readiness Checker - Database Tier (EURC-DT)


2.2 Installation and Upgrade

  • Document 1330701.1, Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2)                                      for Linux x86-64
  • Document 1330702.1, Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2)                                      for Oracle Solaris on SPARC (64-bit)

    • This document applies to on-premises environments only
  • Document 1330703.1, Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) f                                    or IBM AIX on Power Systems (64-bit)

    • This document applies to on-premises environments only
  • Document 1330704.1, Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2)                                    or HP-UX Itanium

    • This document applies to on-premises environments only
  • Document 1330706.1, Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) f                                   or Microsoft Windows x64 (64-bit)
    • This document applies to on-premises environments only



2.3 Cloning

  • Document 1383621.1, Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone
  • Document 1614793.1, Cloning Oracle E-Business Suite Release 12.2 Environments Integrated with Oracle Access Manager 11gR2 (11.1.2) and Oracle E-Business Suite AccessGate
  • Document 1679270.1, Cloning Oracle E-Business Suite Release 12.2 RAC Enabled Systems with Rapid Clone
  • Document 2047809.1, Cloning Oracle E-Business Suite Release 12.2 (AD-TXK Delta 6 or Lower Codelevel) with Rapid Clone
  • Document 2552208.1. Cloning Oracle E-Business Suite Release 12.2 with Multitenant Database using Rapid Clone


Section 3: Patching

3.1 Administration and Management

  • Document 1267768.1, Oracle E-Business Suite Releases 11i and 12.x: Required Updates for Patch Wizard
  • Document 1531121.1, Using the Online Patching Readiness Report in Oracle E-Business Suite Release 12.2
  • Document 1677498.1, How to Restore An Abandoned Node in Oracle E-Business Suite Release 12.2
  • Document 244040.1, Oracle E-Business Suite Recommended Performance Patches
  • Document 1583902.1, Oracle E-Business Suite Release 12.2: Online Patching FAQ
  • Document 1584097.1, Oracle E-Business Suite Release 12.2: Backup and Recovery Guidelines For Online Patching Cutover
  • Document 1594274.1, Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes
  • Document 1678355.1, Oracle E-Business Suite Release 12.2: Validations Performed By the adop Online Patching Utility
  • Document 1901242.1, Script to Diagnose adop and Other AD-TXK Issues in Oracle E-Business Suite Release 12.2
  • Document 2749774.1, EBS Technology Patch Automation Tool for Application Tier (ETPAT-AT)
- No comments:

Thursday, October 22, 2020

adident -AD Identification

 We can know the version and translation level of Oracle Application file in Three ways,


   1. AD utility - adident.
   2.Strings Utility.
   3.By using SQL query.


 1.AD utility - adident.

   Executable -adident .
              To find out a file version, oracle have provided ‘ADIDENT’ utility (AD Identification). This is  an oracle  apps based utility.

    Executable Location : $AD_TOP/bin

      Action :
           
         $ adident Header <Filename> 
          Ex: adident Header adconfig.sh


2.Strings Utility.

       Strings is a UNIX based utility which is used to  print the strings of printable characters in files. We can use this utility to extract header information from the string content of a file.

Action:

   strings -a <file_name>|grep Header
     Eg:- strings -a OEXWFASG.rdf|grep Header

These two methods can be used to find out file versions for oracle seeded files like rfd, fmx, fmb, xml, txt, pls, etc.

Note:- Letter ‘H’ must be capital in key word ‘Header’


 
3.By using SQL query.

You can also use the following SQL query which shows the file version number and also the patch number which brought the file to the current version


select sub.filename, sub.version , sub.last_update_date, sub.app_short_name, sub.subdir
from (
select adf.filename filename,
afv.version version,afv.LAST_UPDATE_DATE,adf.app_short_name, adf.subdir, 
rank()over(partition by adf.filename
order by afv.version_segment1 desc,
afv.version_segment2 desc,afv.version_segment3 desc,
afv.version_segment4 desc,afv.version_segment5 desc,
afv.version_segment6 desc,afv.version_segment7 desc,
afv.version_segment8 desc,afv.version_segment9 desc,
afv.version_segment10 desc,
afv.translation_level desc) as rank1 
from ad_file_versions afv,
(
select filename, app_short_name, subdir, file_id
from ad_files
where upper(filename) like upper('%&filename%')
) adf
where adf.file_id = afv.file_id
) sub
where rank1 = 1
order by 1;

- No comments:
Subscribe to: Posts (Atom)

ORACLE DATABASE CONTENT

ORACLE DATABASE 11gR2 & 12C  CONTENT Pre-Requisite: UNIX, SQL Basics Introduction to Oracle Database §   Introduction of Database ...