Tuesday, August 20, 2019

Oracle E-Business Suite Release 12.2 Technology Stack Documentation Roadmap (Doc ID 1934915.1)

To BottomTo Bottom
Mar 7, 2019BULLETIN
Rate this documentEmail link to this documentOpen document in new windowPrintable Page
This document acts as a central list of books and My Oracle Support knowledge documents that describe the recommended use and deployment of various optional and required components of the technology stack that underpins the overall Oracle E-Business Suite Release 12.2 architecture.
Note: This roadmap is for use with Oracle E-Business Suite Release 12.2.
If you are looking for knowledge documents created for 12.x releases prior to 12.2, refer to:
  • Document 380482.1, Oracle E-Business Suite Release 12 Technology Stack Documentation Roadmap
If you are looking for Release 11i knowledge documents, refer to:
  • Document 207159.1, Oracle E-Business Suite Release 11i Technology Stack Documentation Roadmap
You should periodically check this Document 1934915.1 on My Oracle Support for the addition of new knowledge documents, which will be listed when they become available. There is a Change Log at the end of this document.
Note: If you want to be notified when any of the My Oracle Support documents listed herein are updated, follow these steps.
  1. Log in to My Oracle Support and navigate to the document of interest.
  2. Mark the document as a Favorite (by clicking the yellow star to the left of the document title).
  3. From the More dropdown, choose Settings.
  4. On the left, under Personalization, choose Hot Topics E-Mail and select options as needed.
  5. Click the Apply button to save your changes.
For more information, refer to My Oracle Support How to Series: How to use Hot Topics Email notification to subscribe to Support Product News, SRs, Bugs, etc. and events so that you Never Miss an Important Update - [VIDEO] (Doc ID Document 793436.2).
The documents listed do not replace the standard books in the Oracle Technology Network Documentation Web Library, but should be read in conjunction with the latest version of the relevant books: for example, a document may refer the reader to a book for background information, and a book may point to a document as the best source of up-to-date information on a new or rapidly-changing topic.
The most relevant books are listed in a note box at the top of applicable sections, above the supporting My Oracle Support knowledge documents.
Note: Using the Web Library ensures you are seeing the latest version of the books, which include any updates that have been made since publication of the versions supplied with your installation media.

In This Document

The various books and knowledge documents listed here are written and maintained by Oracle E-Business Suite Development, and divided into the following main categories:

Section 1: Release Notes, Readmes, and Related Documents

Note: The primary documentation library book for this area is:
  • Oracle E-Business Suite Concepts

1.1 All 12.2 Releases

1.2 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.3 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.4 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.5 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.6 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.7 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

1.8 AD-TXK Updates

1.8.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.8.2 Release Notes

  • 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 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 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 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.9 Applications Technology Product Family Updates

Section 2: Installation and Configuration

Note: The primary documentation library books for this area are:
  • Oracle E-Business Suite Installation Guide: Using Rapid Install
  • Oracle E-Business Suite Setup Guide
  • Oracle E-Business Suite Flexfields Guide
  • Oracle Workflow Client Installation Guide
  • Oracle iSetup User's Guide
  • Oracle Application Management Pack for Oracle E-Business Suite Guide
  • Oracle E-Business Suite Mobile Apps Administrator's Guide
  • Oracle E-Business Suite Multiple Organizations Implementation Guide

2.1 General

  • Document 1585857.1, Oracle E-Business Suite Release 12.2: Technical Planning, Getting Started, and Go-Live Checklist (Doc ID 1585857.1)
  • 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 807393.1, Hijrah and Thai Calendar Support in Oracle E-Business Suite R12.1 and 12.2
  • 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 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 2066260.1, Getting Started with Oracle E-Business Suite on Oracle Cloud
  • Document 2045552.1, Getting Started with Oracle Application Management Pack (AMP) for Oracle E-Business Suite Release 13.1.1.1.0

2.2 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

2.3 Virtualization

  • Document 1633952.1, Oracle VM Templates for Oracle E-Business Suite for Exalogic Deployment Guide, Release 12.2.3
  • Document 1620448.1, Oracle VM Virtual Appliances for Oracle E-Business Suite Deployment Guide, Release 12.2.3
  • Document 1928303.1, Oracle VM Virtual Appliances for Oracle E-Business Suite Deployment Guide, Release 12.2.4
  • Document 1954255.1, Oracle VM Templates for Oracle E-Business Suite for Exalogic Deployment Guide, Release 2.2.4
  • Document 2254565.1, Oracle VM Virtual Appliance for Oracle E-Business Suite Deployment Guide, Release 12.2.6
  • Document 1904928.1, Application Management Suite: Quick Provisioning of Oracle E-Business Suite Using Virtual Assemblies
  • Document 2328923.1, Oracle VM Virtual Appliance for Oracle E-Business Suite Deployment Guide, Release 12.2.7
  • Document 2462176.1, Oracle VM Virtual Appliance for Oracle E-Business Suite Deployment Guide, Release 12.2.8

2.4 Secure Enterprise Search

  • Document 462377.1, Installing Oracle E-Business Suite Secure Enterprise Search, Release 12
  • Document 726239.1, Oracle E-Business Suite Secure Enterprise Search Troubleshooting Guidelines, Release 12

2.5 Development and Customizations

Note: The primary documentation library books for this area are:
  • Oracle E-Business Suite Developer's Guide
  • Oracle E-Business Suite UI Standards for Forms-Based Products
  • Oracle Application Framework Personalization Guide
  • Oracle E-Business Suite Desktop Integration Framework Developer's Guide
  • Oracle iSetup Developer's Guide
  • Oracle Integrated SOA Gateway Developer's Guide
  • Oracle Workflow Developer's Guide
  • Oracle Workflow API Reference
  • Oracle E-Business Suite Mobile Foundation Developer's Guide
  • Document 1306563.1, Extending Oracle E-Business Suite Release 12.1.3 and Above Using Oracle Application Express (APEX).
  • Document 1577707.1, Creating a Custom Application in Oracle E-Business Suite Release 12.2
  • Document 1577661.1, Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2
  • Document 1485444.1, Using the Latest UIX Update with Oracle E-Business Suite Release 12.2
  • Document 1315485.1, Oracle Application Framework Developer's Guide
  • Document 1315505.1, OA Extension Component Reference
  • Document 1315510.1, Oracle Application Framework Profile Options
  • Document 1455931.1, Oracle Application Framework Development FAQ (Frequently Asked Questions)
  • Document 1512113.1, Oracle Application Framework Troubleshooting Guide
  • Document 1927975.1, Oracle E-Business Suite Release 12.2 Considerations for OA Framework-based Applications
  • Document 1108093.1, Oracle E-Business Suite Java Caching Framework Developer's Guide
  • Document 395441.1, Oracle Application Framework Support Guidelines for Customers
  • Document 974422.1, Embedding Analytics in Oracle E-Business Suite
  • Document 416708.1, OA Framework - How to find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12.x
  • Document 1296491.1, FAQ for Integration of Oracle E-Business Suite and Oracle Application Development Framework (ADF) Applications
  • Document 1916149.1, Guidance for Integrating Custom and Third-Party Products With Oracle E-Business Suite Release 12.2

2.6 Oracle E-Business Suite Information Discovery

Note: The primary documentation library book for this area is:
  • Oracle E-Business Suite Information Discovery Integration and System Administration Guide
  • Document 1574273.1, Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.2 V4
  • Document 1574275.1, Oracle E-Business Suite Extensions for Oracle Endeca Globalization Guide, Release 12.2 V4
  • Document 1614014.1, Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.2 V5
  • Document 1613997.1, Oracle E-Business Suite Extensions for Oracle Endeca Globalization Guide, Release 12.2 V5
  • Document 1574274.1, Oracle E-Business Suite Extensions for Oracle Endeca Clustering Guide, Release 12.2 V4 and V5
  • Document 1575921.1, DMZ and SSL Configuration Guide for Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.2 V4 and V5
  • Document 1970071.1, Installing Oracle E-Business Suite Information Discovery, Release 12.2 V6
  • Document 2021220.1, Oracle E-Business Suite Information Discovery Clustering Guide, Release 12.2 V6
  • Document 1970072.1, Oracle E-Business Suite Information Discovery Globalization Guide, Release 12.2 V6
  • Document 2038186.1, DMZ and SSL Configuration Guide for Oracle E-Business Suite Information Discovery, Release 12.2 V6
  • Document 2097196.1, Installing Oracle E-Business Suite Information Discovery, Release 12.2 V7
  • Document 2097204.1, Oracle E-Business Suite Information Discovery Globalization Guide, Release 12.2 V7
  • Document 2097205.1, Oracle E-Business Suite Information Discovery Clustering Guide, Release 12.2 V7
  • Document 2169333.1, DMZ and TLS Configuration Guide for Oracle E-Business Suite Information Discovery, Release 12.2 V7
  • Document 2214431.1, Installing Oracle E-Business Suite Information Discovery, Release 12.2 V8
  • Document 2214432.1, Oracle E-Business Suite Information Discovery Globalization Guide, Release 12.2 V8
  • Document 2214433.1, Oracle E-Business Suite Information Discovery Clustering Guide, Release 12.2 V8
  • Document 2277347.1, DMZ and TLS Configuration Guide for Oracle E-Business Suite Information Discovery, Release 12.2 V8
  • Document 2344818.1, Installing Oracle E-Business Suite Information Discovery, Release 12.2 V9
  • Document 2344840.1, Oracle E-Business Suite Information Discovery Clustering Guide, Release 12.2 V9
  • Document 2344819.1, Oracle E-Business Suite Information Discovery Globalization Guide, Release 12.2 V9

2.7 Oracle Enterprise Command Center Framework

  • Document 2409163.1, Installing Oracle Enterprise Command Center Framework, Release 12.2
  • Document 2441262.1, Enabling TLS for Oracle Enterprise Command Center Framework, Release 12.2

Section 3: Patching

Note: The primary documentation library books for this area are:
  • Oracle E-Business Suite Concepts
  • Oracle E-Business Suite Maintenance Guide
  • Document 1147107.1, Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite
  • Document 1531121.1, Using the Online Patching Readiness Report 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

Section 4: Database Tier

Note: The primary documentation library book for this area is:
  • Oracle E-Business Suite Concepts

4.1 General

  • Document 396009.1, Database Initialization Parameters for Oracle E-Business Suite Release 12
  • Document 1349240.1, Database Preparation Guidelines for an E-Business Suite Release 12.2 Upgrade
  • Document 1570554.1, Adding and Deleting Oracle RAC Nodes for Oracle E-Business Suite Release 12.2.x on Oracle Database 11gR2
  • Document 1513976.1, Using Oracle 11g Release 2 Automatic Storage Management with Oracle E-Business Suite Release 12.2
  • Document 1453213.1, Using Oracle 11g Release 2 Real Application Clusters with Oracle E-Business Suite Release 12.2
  • Document 1944539.1, Using Active Data Guard Reporting with Oracle E-Business Suite Release 12.2 and an Oracle 11g or 12c Database

4.2 Interoperability Notes

  • Document 1623879.1, Interoperability Notes Oracle E-Business Suite Release 12.2 with Oracle Database 11g Release 2 (11.2.0)
  • Document 1926201.1, Interoperability Notes Oracle E-Business Suite Release 12.2 with Oracle Database 12c Release 1 (12.1.0)

Section 5: Application Tier

Note: The primary documentation library books for this area are:
  • Oracle E-Business Suite Concepts
  • Oracle E-Business Suite Integrated SOA Gateway Implementation Guide
  • Oracle E-Business Suite Integrated SOA Gateway User's Guide
  • Oracle e-Commerce Gateway Implementation Guide
  • Oracle e-Commerce Gateway User's Guide
  • Oracle XML Gateway User's Guide
  • Oracle E-Business Suite Mobile Foundation Developer's Guide

5.1 General

  • Document 1355068.1, Oracle E-Business Suite 12.2 Patching Technology Components Guide
  • Document 1459546.1, Using JDK 6.0 Latest Update with Oracle E-Business Suite Release 12.2
  • Document 1530033.1, Using JDK 7.0 Latest Update with Oracle E-Business Suite Release 12.2
  • Document 1366187.1, Oracle E-Business Suite 12.2 Fusion Middleware Log Files: Locate,View, and Control
  • Document 1590356.1, Upgrading Oracle Fusion Middleware Technology Stack of Oracle E-Business Suite Release 12.2 to 11.1.1.7 (11gR1 PS6)
  • Document 1905593.1, Managing Configuration of Oracle HTTP Server and Oacore, Oafm, Forms and Forms-c4ws Applications in Oracle E-Business Suite Release 12.2
  • Document 1940996.1, Oracle E-Business Suite Release 12.2 Data Source Connection Pool Diagnostics

5.2 External Integrations

  • Document 1388152.1, Overview of Single Sign-On Integration Options for Oracle E-Business Suite
  • Document 1576425.1, Integrating Oracle E-Business Suite Release 12.2 with Oracle Access Manager 11gR2 (11.1.2) using Oracle E-Business Suite AccessGate
  • Document 1963114.1, Oracle E-Business Suite (12.2) AccessGate Sizing and Performance Guidelines
  • Document 1371932.1, Integrating Oracle E-Business Suite Release 12.2 with Oracle Internet Directory 11gR1
  • Document 2003483.1, Integrating Oracle E-Business Suite Release 12.2 with Oracle Unified Directory 11gR2
  • Document 1380591.1, Using Discoverer 11.1.1 with Oracle E-Business Suite Release 12.2
  • Document 1584883.1, Integrating Oracle E-Business Suite 12.2 with BPEL in SOA Suite 11g
  • Document 1311068.1, Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2
  • Document 1317697.1, Oracle E-Business Suite Integrated SOA Gateway Troubleshooting Guide, Release 12.2
  • Document 1332262.1, Setting Up SAML Token Security for Oracle E-Business Suite Integrated SOA Gateway, Release 12.2
  • Document 1332645.1, Using Oracle WebCenter 11.1.1 with Oracle E-Business Suite Release 12.2
  • Document 1640073.1, Notes for Using Oracle Business Intelligence Publisher 10g in Oracle E-Business Suite Release 12.2
  • Document 2077434.1, Configuring an Oracle Workflow Notification Mailer with Cloud E-Mail Servers
  • Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1
  • Document 2339348.1, Integrating Oracle E-Business Suite Release 12.2 with Oracle Access Manager 12c (12.2.1.3.0) using Oracle E-Business Suite AccessGate
  • Document 2339362.1, Integrating Oracle E-Business Suite Release 12.2 with Oracle Internet Directory 12c (12.2.1.3.0)

Section 6: Client Tier

Note: The primary documentation library books for this area are:
  • Oracle E-Business Suite User's Guide
  • Oracle Workflow User's Guide

Section 7: Security

Note: The primary documentation library books for this area are:
  • Oracle E-Business Suite Concepts
  • Oracle E-Business Suite Security Guide
  • Document 1334930.1, Sensitive Administrative Pages in Oracle E-Business Suite
  • Document 1375670.1, Oracle E-Business Suite Release 12.2 Configuration in a DMZ
  • Document 1581584.1, Enabling the Oracle Database 11g Case-Sensitive Password Feature for Oracle E-Business Suite Release 12.1.1+
  • Document 2063486.1, FAQ: Oracle E-Business Suite Security
  • Document 2076834.1, Using Oracle E-Business Suite Data Masking Pack Release 12.2 with Oracle Enterprise Manager Cloud Control 13c
  • Document 1367293.1, Enabling TLS in Oracle E-Business Suite Release 12.2
  • Document 2143101.1, Enabling SSL or TLS in Oracle E-Business Suite Release 12.2
  • Document 1585296.1, Using TDE Tablespace Encryption with Oracle E-Business Suite Release 12.2
  • Document 1926686.1, Using TDE Tablespace Encryption with Oracle E-Business Suite Release 12.2 on Database 12c Release 1 (12.1.0)
  • Document 2322920.1, Using Fast Offline Conversion to Enable Transparent Data Encryption (TDE) for Oracle E-Business Suite
  • Document 2131435.1, Integrating Oracle E-Business Suite Release 12.2 with Oracle Database Vault 12c

Appendix A: Additional Books

The following books are also relevant to Oracle E-Business Suite Release 12.2 system administration:
  • Oracle Diagnostics Framework User's Guide
  • Oracle E-Business Suite CRM System Administrator's Guide
  • Oracle Report Manager User's Guide
  • Oracle Web Applications Desktop Integrator Implementation and Administration Guide
  • Oracle Workflow Administrator's Guide
  • Oracle Alert User's Guide
at 1 comment:

Monday, August 19, 2019

Useful Scripts for E-Business Suite Applications Analysts (Doc ID 887438.1)

In this Document
Purpose
Questions and Answers
 IMPORTANT:
 
 1. How to find versions of files in packages?
 2. How to check if a patch is applied?
 3. How to find the patch set level for an application?
 4. How to find instance name, host name, apps and RDBMS versions of the instance user is logged into?
 5. How to find the latest version of a file on a given instance?
 6. How to check the installation status and patch set level for a product?
 7. How to backup a table before users use SQL to update the APPS  tables?
 9. How to check for invalid objects in a particular module?
 10. How to check for invalid objects in all the modules?
 13. How to check the indexes on a table?
 14. How to check for custom triggers on seeded tables?
 Still Have Questions?
References

APPLIES TO:

Oracle Report Manager - Version 11.5 to 12.1.3 [Release 11.5 to 12.1]
Oracle Purchasing - Version 11.5.1 to 12.1.3 [Release 11.5 to 12.1]
Oracle Project Costing - Version 11.5.1 to 12.1.3 [Release 11.5 to 12.1]
Oracle Applications Desktop Integrator - Version 11.5 to 12.1.3 [Release 11.5 to 12.1]
Oracle Receivables - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
ad_bugs

PURPOSE

These scripts are meant to provide the most commonly requested information.
Functional analysts with SQL and Unix access should be able to run these scripts and provide the information to Oracle Support.
User need to log into SQL plus to run the SQL scripts.

QUESTIONS AND ANSWERS

IMPORTANT:

Most of the information provided by the scripts below may be obtained from the RDA diagnostics, which is simple to perform and provides more complete information about the installed software. This should be the privileged set of information provided to Support.
You may find the RDA test for your APPS version in one of the following:

NOTE: In the images/examples above or below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

1. How to find versions of files in packages?

select text from dba_source
where name like '%&PKG_NAME%'
and line = 2;
Example:
select text from dba_source
where name = 'GLRX_JOURNAL_PKG'
and line = 2;

2. How to check if a patch is applied?

select * from ad_bugs
where bug_number = &bug_number;

select * from ad_applied_patches
where patch_name = &bug_number;

SELECT DISTINCT a.bug_number, e.patch_name, c.end_date, b.applied_flag
FROM ad_bugs a,
  ad_patch_run_bugs b,
  ad_patch_runs c,
  ad_patch_drivers d,
  ad_applied_patches e
WHERE a.bug_id = b.bug_id
AND b.patch_run_id = c.patch_run_id
AND c.patch_driver_id = d.patch_driver_id
AND d.applied_patch_id = e.applied_patch_id
AND a.bug_number LIKE '&bug_number'
ORDER BY 1 DESC ;
The above scripts works in R11i and R12.1.x versions.
In EBS 12.2 you may not simply query the AD_BUGS table. This table may have entries for patches that were applied but later the patching cycle was aborted (not really applied).

The way to check whether a patch is really applied is to use the AD_PATCH.IS_PATCH_APPLIED PL/SQL function.
Usage:
select AD_PATCH.IS_PATCH_APPLIED(\'$release\',\'$appltop_id\',\'$patch_no\',\'$language\') from dual;
example sql:
SELECT adb.bug_number,ad_patch.is_patch_applied('11i', 1045, adb.bug_number)
FROM ad_bugs adb
WHERE adb.bug_number in ('12345',6789');

or for single app tier installations:
select ad_patch.is_patch_applied('R12',-1,'123456') from dual;

expected results:
EXPLICIT = applied
NOT APPLIED = not applied / aborted

3. How to find the patch set level for an application?

select substr(aa.application_short_name,1,20) "Product",
a.patch_level "Patch Level"
from fnd_product_installations a, fnd_application aa
where a.application_id = aa.application_id
and aa.application_short_name like '%&short_name%';
Example:
select substr(aa.application_short_name,1,20) "Product",
a.patch_level "Patch Level"
from fnd_product_installations a, fnd_application aa
where a.application_id = aa.application_id
and aa.application_short_name like '%AP%';

4. How to find instance name, host name, apps and RDBMS versions of the instance user is logged into?

select i.instance_name, i.host_name, f.release_name release, i.version
from v$instance i, fnd_product_groups f
where upper(substr(i.instance_name,1,4)) = upper(substr(f.applications_system_name,1,4));

5. How to find the latest version of a file on a given instance?

select sub.filename, sub.version
from (
   select adf.filename filename,
   afv.version version,
   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
You may enter partial file names. The search is not case sensitive.
For example, you may search on "glxjeent" for the form "GLXJEENT.fmb" or "frmsheet1" for java file "FrmSheet1VBA.class".
Note: This script works for the following file types:
- .class, .drvx, .fmb, .htm, .lct, .ldt, .o, .odf, .pkb, .pkh, .pls, .rdf, .rtf, .sql, .xml.
It does not work for file types: .lpc, .lc , etc.

6. How to check the installation status and patch set level for a product?

Example 1
select patch_level, status from fnd_product_installations
where patch_level like '%FND%';
Example 2
select patch_level, status from fnd_product_installations
where patch_level like '%XDO%';

7. How to backup a table before users use SQL to update the APPS  tables?

Example 1:
Create table ap_invoices_all_bkp as select * from ap_invoices_all;
Example 2:
Create table gl_interface_bkp as select * from gl_interface;

Note: SQL updates are not allowed unless directed to do so by Oracle Support or Development
 8. How to find the table(s) name with the column name?
User knows the column_name but not sure what table(s) the column name is in.
Example:
select * from dba_tab_columns
where column_name like '%SET_OF_BOOKS_ID%';
This will provide the names of all the tables that has column_name SET_OF_BOOKS_ID.

9. How to check for invalid objects in a particular module?

select OWNER, OBJECT_NAME, OBJECT_TYPE
from DBA_OBJECTS
where OBJECT_NAME like 'FND_%'
and STATUS = 'INVALID';
select OWNER, OBJECT_NAME, OBJECT_TYPE
from DBA_OBJECTS
where OBJECT_NAME like 'AP_%'
and STATUS = 'INVALID';

10. How to check for invalid objects in all the modules?

select owner, object_name, object_type from dba_objects
where status = 'INVALID'
order by object_name, object_type;
 11. How to find the applications in the system that are either installed shared?
select fat.application_id, FAT.APPLICATION_NAME, fdi.status, fdi.patch_level
FROM FND_APPLICATION_TL FAT, fnd_product_installations FDI
WHERE FDI.APPLICATION_ID = FAT.APPLICATION_ID
and fdi.status in ('I', 'S');
Note: Status 'I' meaning installed and status 'S' meaning shared.
 12. How to determine database character set?
select value from nls_database_parameters
where parameter = 'NLS_CHARACTERSET';
The following scripts will provide NLS parameter and value for database, instance and session.
select * from nls_database_parameters;
select * from nls_instance_parameters;
select * from nls_session_parameters;

13. How to check the indexes on a table?

Example:
select index_owner owner, table_name tab, index_name ind, column_name colu, column_position position
from DBA_IND_COLUMNS
where table_name = 'GL_CODE_COMBINATIONS';

14. How to check for custom triggers on seeded tables?

Example:
select trigger_name, owner
from dba_triggers
where table_name = 'GL_BALANCES';
 15. How to get the header file versions for an executable in Unix?
Example 1
Log into UNIX.
> cd $AP_TOP/bin
> strings -a APXXTR |grep Header
Example 2
> cd $RG_TOP/bin
> Strings -a RGRARG |grep Header

The above will provide the versions of all the header files in those executables. 
Note: the command adident (in UNIX, windows and other operating systems) may also be used to provide the file versions.

Still Have Questions?


To discuss this information further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the My Oracle Support Communities.

To provide feedback on this note, click on the Rate this document link.

REFERENCES

NOTE:134430.1 - How to Check The Indexes on the Main General Ledger Tables?
NOTE:183274.1 - 11i : Applications DBA RDA Data Collection Test
NOTE:420427.1 - R12.0.[3-4] : All RDA Data Collection Test
NOTE:732091.1 - R12: All RDA Data Collection Test
at No comments:

Actions to Verify When Running Into ORA-01017 While Creating Datasource (Doc ID 1556742.1)




Copyright (c) 2019, Oracle. All rights reserved. Oracle Confidential.
Click to remove from FavoritesTo BottomTo Bottom
May 2, 2014TROUBLESHOOTING
Rate this documentEmail link to this documentOpen document in new windowPrintable Page
In this Document
Purpose
Troubleshooting Steps
 1. Verify the FND user defined in the Datasource
 2. Verify relevant profile options
 3. Small test class to verify the connection
References

APPLIES TO:

Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

PURPOSE

The Note:974949.1 "Oracle E-Business Suite Software Development Kit for Java (includes AppsDataSource, Java Authentication and Authorization Service, session management)" explains the steps to create a Datasource for external applications to connect to the E-Business Suite database.
An error often reported here is the ORA-01017: invalid username/password; logon denied which normally indicates that a database user passed incorrect credentials. However when it comes to creating Datasource the ORA-01017 is raised as soon as there is an issue with the connection and the actual ORA message is not reporting the actual error.
This document will provide a number of things to verify which may assist in troubleshooting the ORA-01017 when raised in context of Datasource.

TROUBLESHOOTING STEPS

IMPORTANT: The Datasource uses a FND user for the connection. This may either be the seeded ASADMIN user or a own created user. For simplicity the examples in this document refer to ASADMIN, however this should be replaced by your own user when appropriate.

1. Verify the FND user defined in the Datasource

The user in the Datasource should be a valid FND user created in E-Business Suite. For security reasons it's recommended this user does not have any responsibilities assigned, but only has the required role: Apps Schema Connect [internal name UMX|APPS_SCHEMA_CONNECT].
When using the credentials in the AppsLocalLogin.jsp this should allow to login successfully. Another quick method to check the credentials are correct is to run the following SQL
SQL> select fnd_web_sec.validate_login('ASADMIN', '<replace with password>' ) from dual;
Result:
Y = Credentials are correct
N = Credentials are not correct. Verify the credentials passed and also take into account case-sensitivity. Resolve this problem before continuing with the steps

Also confirm the role UMX|APPS_SCHEMA_CONNECT is assigned and not expired
SQL> select user_name, role_name, start_date, expiration_date from wf_user_roles where user_name='ASADMIN';
Result:
Expected is to have 2 records. The first with the ROLE_NAME = USER_NAME and the second with ROLE_NAME = UMX|APPS_SCHEMA_CONNECT. Ensure that START_DATE is in the past and EXPIRATION_DATE is null or (far) in the future.
If the UMX|APPS_SCHEMA_CONNECT role is not assigned have this role added via User Management > Users function

2. Verify relevant profile options

There are some profile options in the E-Business Suite used to ensure connections come from trusted node
  • FND: Desktop Nodes allowed [FND_SERVER_DESKTOP_USER]
Set a USER level and has a comma separated list of trusted nodes allowed to connect. The node names here should be in uppercase and exactly match the value for NODE_NAME column in FND_NODES table. If FND_NODES has NODE_NAME = MYSERVER the value to be used is MYSERVER (and not MYSERVER.MYDOMAIN or myserver). Query the FND_NODES table to confirm the exact name to be used here.
Run the following SQL to check relevant information from the FND_NODES table
SQL> select node_name, description, server_address, server_id from FND_NODES;
  • FND: Validate IP address [FND_SERVER_IP_SEC]
Set at SITE level to one of the following
  • N - None
  • D - Desktop Only 
  • DS - Desktop and Server 
  • S - Server Only
  • FND: Validate User Type [FND_SERVER_SEC]
Set at SITE level to one of the following 
  • N - None
  • D - Desktop Only 
  • DS - Desktop and Server 
  • S - Server Only
The default value for the last 2 profile options is 'Desktop Only' which verifies the connections when coming from a Desktop node. To verify if the ORA-01017 is caused by this validation it may be useful to temporarily change the value to 'None' so the validation is disabled for one or both profile options. This should however only be considered a diagnostics action and is not a definite solution since it impacts security.
The following SQL can be used to review the current values for these profile options
SQL> select p.profile_option_name SHORT_NAME,
n.user_profile_option_name NAME,
decode(v.level_id,
      10001, 'Site',
      10002, 'Application',
      10003, 'Responsibility',
      10004, 'User',
      10005, 'Server',
      10006, 'Organization',
      10007, 'Server Resp',
      '<UnDefined>') LEVEL_SET,
      decode(v.level_id,
      10001, ' ',
      10002, app.application_short_name,
      10003, rsp.responsibility_key,
      10004, usr.user_name,
      10005, svr.node_name,
      10006, org.name,
      10007, svr2.node_name ||' / '|| rsp.responsibility_key,
      '<UnDefined>') CONTEXT,
      nvl(v.profile_option_value,' ') VALUE
from fnd_profile_options p,
     fnd_profile_option_values v,
     fnd_profile_options_tl n,
     fnd_user usr,
     fnd_application app,
     fnd_responsibility rsp,
     fnd_nodes svr,
     fnd_nodes svr2,
     hr_operating_units org
where  p.profile_option_id = v.profile_option_id (+)
and    p.profile_option_name = n.profile_option_name
and    p.profile_option_name in ('FND_SERVER_SEC','FND_SERVER_IP_SEC','FND_SERVER_DESKTOP_USER')
and    usr.user_id (+) = v.level_value
and    rsp.application_id (+) = v.level_value_application_id
and    rsp.responsibility_id (+) = v.level_value
and    app.application_id (+) = v.level_value
and    svr.node_id (+) = v.level_value
and    svr2.node_id (+) = v.level_value2
and    org.organization_id (+) = v.level_value
and    language='US'
order by short_name, level_id;

3. Small test class to verify the connection

The below java code provides a simple Datasource to test connection using the credentials and DBC file created for the desktop node. This allows to verify that DBC file and credentials are correct without the need to setup the Datasource in WLS console. The code should be run from the desktop node.
The steps to create and run the class are:
  • Create a file named Connect2.java and copy following contents
import oracle.apps.fnd.security.*;
import java.sql.Connection;
import javax.naming.Referenceable;
import javax.sql.*;
import oracle.jdbc.OracleCallableStatement;
import oracle.jdbc.pool.OracleDataSource;
import oracle.jdbc.pool.OracleDataSourceFactory;

public class Connect2
{

//apps user with umx| APPS_SCHEMA_CONNECT priviliges (default asadmin)
public static String user = "<username, e.g. ASADMIN>";
public static String pwd = "<password, e.g. ASADMIN>";
public static String dbcFile = "<location of the DBC file to be used by the Datasource>";

public static void testConnection (String dbcFile)
throws Exception
{
System.out.println("Running testConnection DBC version...");
AppsDataSource v2 = new AppsDataSource();
v2.setUser(user);
v2.setPassword(pwd);
v2.setDbcFile(dbcFile);

Object ods = new OracleDataSourceFactory().getObjectInstance(v2.getReference(), null, null, null);
DataSource ds = (DataSource) ods;
testSql(ds.getConnection());
}
public static void testSql (Connection conn)
throws Exception
{
String sql = "BEGIN fnd_profile.get(:1,:2); END;";
OracleCallableStatement cStmt = (OracleCallableStatement) conn.prepareCall(sql);
cStmt.setString(1, "APPS_WEB_AGENT");
cStmt.setString(2, null);
cStmt.registerOutParameter(2, java.sql.Types.VARCHAR, 0, 100);
cStmt.execute();
String profVal = cStmt.getString(2);
System.out.println(profVal);
}
public static void main (String j[])
throws Exception
{
System.out.println(new AppsDataSource() instanceof Referenceable);
testConnection(dbcFile);
} }
  • Review the following 3 lines in the source-code and replace provide the variables with the correct values for your environment.
public static String user = "<username, e.g. ASADMIN>";
public static String pwd = "<password, e.g. ASADMIN>";
public static String dbcFile = "<location of the DBC file to be used by the Datasource>";
  • On the desktop node the fndext.jar is available. Ensure the fndext.jar is incuded in the CLASSPATH environment setting
# export CLASSPATH=$CLASSPATH:<full path>/fndext.jar
  • Compile the class:
# javac Connect2.java
  • Ensure the location of Connect2.class is and the fndext.jar are available in the CLASSPATH environment variable
# export CLASSPATH=$CLASSPATH:<directory of Connect2.class>
  • Run the class:  
# java Connect2
When connection is made this will show the following output. 
true
Running testConnection DBC version...
http://<host.domain:port>/pls/<SID>
Note the URL is not relevant. The value of APPS_WEB_AGENT is just used as example SQL to test the connection.
When there is a problem the following will be rendered
true
Running testConnection DBC version...
Exception in thread "main" java.lang.RuntimeException: ORA-20001:
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_SECURITY_PKG", line 533
ORA-06512: at line 1

        at oracle.apps.fnd.security.AppsDataSource.setDbcFile(AppsDataSource.java:156)
        at Connect2.testConnection(Connect2.java:24)
        at Connect2.main(Connect2.java:46)
In this case closely review the credentials passed for the user, the profile options mentioned and DBC file used to see which is setup wrong.

REFERENCES

NOTE:974949.1 - Oracle E-Business Suite Software Development Kit for Java (includes AppsDataSource, Java Authentication and Authorization Service, session management) Readme - Patch 13882058
NOTE:1321776.1 - Integrating Oracle E-Business Suite Release 12 with Oracle BPEL in Oracle SOA Suite 11g

at No comments:
Subscribe to: Posts (Atom)

Using File Storage Parallel Tools | Parallel Unix Commands

The Parallel File Tools suite provides parallel versions of  tar ,  rm , and  cp . These tools can run requests on large file systems in par...