SQL to find all OAF Substitutions

The query below is a union between finding all natural BC4J object substitutions (OAF) and the second half which finds Controller (CO) substitutions which are in the form of page Personalizations, and brings them together to display them all as a single list of substitutions. –all substitutions select jdr_mds_internal.getDocumentName(ja.att_comp_docid) SUBSTITUTION_DOC, case when ja2.att_name = ‘customizes’ […]

Customizations & Custom Application in Oracle E-Business Suite Release 12.2 | OracleApps Epicenter

In EBS R12.2 installation now includes two editions (versions) of the application code and seed data. The file system contains two complete copies of the Oracle Source: Customizations & Custom Application in Oracle E-Business Suite Release 12.2 | OracleApps Epicenter In EBS R12.2 installation now includes two editions (versions) of the application code and seed […]

Custom Top/Application Creation R12 | OracleAPPSDBA & Oracle DBA Blog

SCHEMA NAME : XXERP TOP NAME : XXERP_TOP Application : XXERP Custom Application Data Group : Standard Request Group : XXERP Request Group Menu : XXERP_CUSTOM_MENU Responsibility : XXERP Custom &nbs… Source: Custom Top/Application Creation R12 | OracleAPPSDBA & Oracle DBA Blog Twitter Pinterest Reddit Google+

OEL Linux: Setting timezone and synchronizing time with NTP | Abdussamad.com

Learn how to set the correct timezone and synchronize time with NTP servers on your CentOS box. Setting the timezone Setting the timezone on CentOS or Redhat Enterprise Linux (RHEL) is easy. Login as root either locally or remotely via SSH. See what the current timezone is: date You should see output like this: Wed […]

Atom, using atom-beautify with sqlformat (default for SQL file types) getting error indicating that the system can’t find sqlformat executable

The problem is that the sqlformat executable expected by default for this atom package has not been installed. It is found on github here. The solution was to download and install the code found here. python-sqlparse – Parse SQL statements sqlparse is a non-validating SQL parser module for Python. Install Run: python setup.py install to […]

Atom-package-oracle-build using SQL*Plus from instantClient_11_2 against an Oracle R12.2.4 Vision instance, Resolving ORA-12705: Cannot access NLS data files or invalid environment specified

In attempting to connect to sqlplus via Atom with package oracle-build (based on atom-build), the following error was received when attempting to run sqlplus to compile a sql object: Resolving ORA-12705: Cannot access NLS data files or invalid environment specified This was resolved by adding NLS_LANG to the environment variables set in the .bash_profile file […]

PL/SQL String slicer (chunker)

Found this little highly re-used piece to chunk out a long string into an array of shorter strings.  Thanks to the original article found here.   SQL> set serveroutput on SQL> SQL> DECLARE 2 TYPE typStringTab IS TABLE OF VARCHAR2(200) INDEX BY BINARY_INTEGER; 3 vglText VARCHAR2(2000); 4 5 6 — #### ————————————————————– 7 8 9 […]

When Attempting to Open the Framework Tutorial in JDeveloper the Following Error Occurs “You Cannot run a Page Which is not SelfSecured When the MAC Fails” (Doc ID 1313526.1)

This error occurs when the OC4J settings have been changed in JDeveloper to use machine name rather than local IP.   View pdf of this MOS doc here. Source: Document Display Twitter Pinterest Reddit Google+

How to fix java.lang.unsupportedclassversionerror unsupported major.minor version 49.0 50.0 51.0 in Java

When attempting to build an existing project in Oracle JDeveloper, sometimes this error appears during compilation, especially if you have already copied existing oracle $JAVA_TOP OAF code into the myclasses folder.  In general the cause for this is that some of the “pre-compiled” code included in the myclasses folder (pay special attention to /oracle/apps/fnd/…) was […]

A Keep-Alive Program You Can Run Anywhere as long as you can compile java on that or a compatible system

/* @(#) KeepAlive.java Trivial keep-alive program. Tries at 5-second intervals * to find addresses for hosts with generated names. This * ensures that messages are sent to nameserver(s). * Copyright (c) 2002 Graham Jenkins <grahjenk@au1.ibm.com> * All rights reserved. Version 1.06, August 15, 2002. */ import java.io.*; import java.net.*; import java.awt.*; import java.awt.event.*; import java.util.Date; […]