What is Oracle AIMs

AIM (Application Implementation Methodology) is all about the
documentation which are to be maintained in the due course of total life
cycle in oracle applications.

There are about more then 500 templates which are provided in AIM.
AIM is something similar to an editor which provides you all the templates.
Only thing is that you have to know which template has to be used when.
Like if you want to prepare the functional design, solution documentation
and so on.
Which in AIM you find templates like MDxxx, BRxxx. MD stand for Modular Designing and BR is Business Requirement.

APP-FND-01542 : This Application Server is not authorized to access this system

If we are getting the following message “APP-FND-01542 : This Application Server is not authorized to access this system. Please contact your System Administrator. ” Then please set the variable value in $APPL_TOP/admin/SID_hostname.xml context file
variable: s_appserverid_authentication to be OFF. And then, for any change in context file you need to run autoconfig and bounce the apps instance to see the changes to instance.

$ cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME
$ sh adautocfg.sh

Now, you can test the application login.

Oracle SQL from Java

In this section, i’ll try to share example of Java SQL.
We’ll create class that have a method return current date of database.

For trying this, all we have to do is
1. Load a Java source file into the database
CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED “test_java_sql” AS
import java.sql.*;
import oracle.jdbc.*;

What is Pragma?

The PRAGMA keyword is used to signify that the remainder of the PL/SQL statement is a pragma or directive to the compiler. Pragmas are processed at compile time; they do not execute during run-time.
A pragma is a special instruction to the compiler. Also called a pseudoinstruction, the pragma doesn’t change the meaning of a program. It simply passes information to the compiler. It is very similar, in fact, to the tuning hints you can embed in a SQL statement inside a block comment.

PL/SQL offers the following pragmas. These are the EXCEPTION_INIT, RESTRICT_REFERENCES, and (new with Oracle8i) AUTONOMOUS_TRANSACTION and SERIALLY_REUSABLE pragma.
(source : Knowledge Xpert for PL/SQL)

Pragma RESTRICT_REFERENCES

One of the requirements for calling functions in SQL is pragma RESTRICT_REFERENCES.

Before constructing a function for using in SQL, we must be sure that the following actions taked :

• The stored function may not modify database tables.
• A stored function can update the values of package variables only if that function is called in a select list, or a VALUES or SET clause. If the stored function is called in a WHERE or GROUP BY clause, it cannot write package variables.
• The stored function may not call another module (stored procedure or function) that breaks any of the preceding rules. A function is only as pure as the most impure module that it calls.
• The stored function may not reference a view that breaks any of the preceding rules. A view is a stored SELECT statement; that view’s SELECT may use stored functions.

Calling Form from Form in Oracle Applications

For runing a form from another form by some trigger or button, and also we can send a parameter at the same time. Do this:

• Make sure caller form and called form was registered in oracle apps, ex. the function name of called form is F_TEST
• Make sure the paramater was installed in called form, ex. P_TEST
• Add trigger to caller form like this :
  fnd_function.execute(FUNCTION_NAME, OPEN_FLAG=’Y', SESSION_FLAG=’Y', PARAMETER);
  ex: fnd_function.execute(‘F_TEST’, OPEN_FLAG=’Y', SESSION_FLAG=’Y', ‘P_TEST = 1234′);

Try it, i hope you can do it.

PRAGMA AUTONOMOUS_TRANSACTION in PL/SQL

To understand this, do the pl/sql below

Copy File to/from Remote Server using PL/SQL

http://www.oracle-base.com/articles/9i/FTPFromPLSQL9i.php

Query of Report Trial Balance – Detail

Amount Type = PTD (Period to Date), Currency Type = B (Base currency)
Natural Account on Segment4

OCP Certification Tips

The requirements for each certification exam will be different, but here is a summary of the above tips that should help you prepare for any certification test:

* Prepare well in advance of the test.
* Join local study groups if available.
* Subscribe to certification study group forums.
* Concentrate first on your weakest subjects.
* Touch more the practical areas of the topics then the theoretical.
* Carefully read each question, taking your time.
* Do as many practice questions as possible.
* Focus on saving time in the beginning, rather getting panicked in the end due to lack of time and answer the questions wrong which you know the right answers.
* In test questions, identify key words (such as “not,” “most” and “least.”)