Oracle Applications

BPEL Tree SQL query

2010-08-17T15:48:00.000-07:00

How to query the BPEL tree in the dehyderation database directly?Tree finder using SQL query.select lpad(' ', (level - 1) * 2) || title as padded_name, process_id, modify_date-creation_date, creation_date, modify_date, statefrom cube_instance ci1connect by prior cikey = parent_idstart with cikey = :parent_process;TreeFinder jsp is the most resource hungry webpage in the BPEL console. This query

GL Interface Tables

2009-04-29T10:08:00.000-07:00

GL_BUDGET_INTERFACE Used to upload budget data into your Oracle General Ledger applicationGL_DAILY_RATES_INTERFACEUsed to insert, update, or delete daily rates in the GL_DAILY_RATES table.GL_IEA_INTERFACEUsed to create intercompany transaction data.GL_INTERFACEUsed to create journal entries, Transfers source information into a target set of books, Creates accounting for Intercompany Transactions

Implementation Documentation

2009-04-29T09:59:00.000-07:00

Following are the list of standard documentation that needs to be prepared for Oracle Applications Implementation.You can download the documentation templates from http://download-east.oracle.com/partners/265498.EXE. After installation you can find the templates in C:\Method\OM30\AIM30\AIM30FND\Wordlib path.Among this list most important documentation for Oracle Apps implementation are MD030,

Oracle Open Interface

2009-04-29T09:13:00.000-07:00

What is Oracle open interfaces?Open interfaces used to integrate Oracle Applications with the non-oracle systems.such as1. Import data from your custom applications or legacy systems.2. Migrate the old custom application data to the Oracle applications.3. Import data from the banks, partners, suppliers, customers etc.What is conversion?Conversion is a one time Interface to migrate data from

Call pl/sql in ADF

2009-04-29T07:05:00.000-07:00

How to Call pl/sql from ADF?You can use the following code to call a pl/sql block from the ADF bc Application module.public void executePlsqlProcedure(){CallableStatement updateStmt = null;try {// Put your PL/SQL block in a String variable.String Stmt = "begin delete test_table where header_id = :1; "+" :2 = xxx_pkg.yyy_function(); end;";OADBTransaction txn = getDBTransaction();// Pass the PL/SQL

AQ creation script

2009-04-15T09:55:00.000-07:00

Advanced queue is highly used in SOA to forward messages between different services through database. We will discuss AQ in detail in the future. Now we will see how to create AQ in database.create or replace type AQSEC.CT_MESSAGE_TYPE as OBJECT ( PAYLOAD CLOB ) / begin DBMS_AQADM.CREATE_QUEUE_TABLE (queue_table => '"Username"."HR_Q"',

XPATH quick reference

2009-04-15T09:11:00.001-07:00

under construction

Logging in Apps

2009-04-15T07:42:00.000-07:00

How to do logging in the OAF controller?You can do logging in OAF page using following statementpageContext.writeDiagnostics(this,"building is :"+s_building,OAFwkConstants.STATEMENT);Syntax:void writeDiagnostics(Object module, String messageText, int logLevel)Writes an entry to the diagnostics log according to a specific log level.Parameters:module - current module

debug bc4j objects

2009-04-08T09:14:00.000-07:00

How to debug the VO, LOV, poplist queries?You can see the executed queries and its bind values in the jdeveloper console or messages window.By default, this option is not available in jdeveloper.To enable the debug console option in 10g1. Right click on project and select project properties2. Select Run/Debug3. Ensure Default in selected in Run configurations4. Select Edit button.5. You can see

System.out.println

2009-04-02T04:43:00.000-07:00

System.out.printlnThis is the most commonly asked question in web applications development in jdeveloper including OA Framework, ADF, ejb, web services etc.Can I leave System.out.println or System.err.println in the production code?System.out.println comes handy when debugging the application because you can see the messages pretty much easily in the jdeveloper console. And it takes relatively

Manipulating OA Footer

2009-04-02T04:08:00.000-07:00

Manipulating OA footer regionHow to render copyright information and privacy statement for custom page?To render standard footer just Set the Auto Footer property in the pageLayout region to 'True'. This will render the Footer with default copyright information and privacy statement.To render different privacy statement and copyright information1. Set the Auto Footer property in the pageLayout

SQL Trace

2009-01-05T11:22:00.000-08:00

How to do SQL Trace on the Oracle Applications 11i? In this article, I am going to explain what to get trace for various technology components of the Oracle applications. Hence we are going to see What is sql trace? How to take sql trace for a session? How to do sql trace for a Form? How to do sql trace for a Report? How to do sql trace for a OAF Page? What is sql trace? SQL Trace is a

Hide a mandatory field

2008-11-26T06:04:00.000-08:00

How to hide a mandatory field in OAF PageIf the business wants to hide a field in the seeded page, you can do it by personalizing the page and set Rendered property to false.But this solution will not help you if the field is marked as mandatory by the seeded page.The reasons are Mandatory Validations are usually done at the EO level. Hence even if you hide the mandatory field, the validation

New to OAF

2008-11-26T06:00:00.000-08:00

New to OA FrameworkFollowing are the most frequently asked questions in the OAF forums by new OAF Developers What is OAF? What are the prerequisites for learning OAF? I am a forms developer and I want to learn a web technology, should I go for OAF or ADF? Where to get the jdeveloper for OA Framework? How to learn OAF and where to find step by step tutorial? Can I practice OAF in home? In this

Callable Statement

2008-11-04T08:04:00.001-08:00

How to Call a PL/SQL block from OA frameworkYou can call PL/SQL block from the OA Framework using callable statement. Use the following code from application module.import java.sql.CallableStatement;import oracle.apps.fnd.common.VersionInfo; import java.sql.SQLException; CallableStatement updateStmt = null; try { // Put your PL/SQL block in a String

Call Concurrent Program from OA Framework

2008-11-04T07:38:00.000-08:00

How to Call a Concurrent Program from OA frameworkOA Framework provides the ConcurrentRequest class to call the concurrent program from the page. The submitRequest() method in the ConcurrentRequest class takes 6 parameters and returns request id of the submitted concurrent request:public int submitRequest( String ProgramApplication , String ProgramName , String ProgramDescription , String

OAF vs ADF 10g

2008-06-19T09:53:00.000-07:00

OAF vs ADF 10g Hi all,With the emergence of next generation Fusion technology middleware stack there is confusion between the technologies OA framework and ADF among Oracle developers especially for the people who are developing extensions for Oracle Applications 11i/R12. Both are Oracle technologies for developing web based User Interface with Jdeveloper. Hence I decided to bring out the

Oracle Applications

2008-03-08T04:19:00.000-08:00

Oracle ApplicationsHi All,I have created this blog to share my knowledge in Oracle Applications. Please post your comments and suggestions.Articles in OA Framework How to start with OAF Development?How to Deploy OA Framework FilesHow to Call a Concurrent Program from OA frameworkHow to Call a PL/SQL block from OA frameworkWhat is the difference between ADF and OAF?How to hide mandatory a field

Deploy OA Framework

2008-02-20T10:05:00.000-08:00

How to Deploy OA framework in the Instance Deployment of OA framework consists of 5 steps. Deploying Class files and VO/EO/AM xml files Deploying PG/RN xml files Deploying jpr files for Substitution Setup AOL to access the page Restart the server Let's look at these one by one.Deploying Class filesThe files such as Controllers *CO.class Application modules *AM.class View Objects *VOImpl.class, *

Managed Bean

2008-02-05T07:00:00.001-08:00

Managed Bean Managed beans are Java classes that you register with the. The managed beans are initialized when they are referenced in the application for the first time. It helps to handle UI events or write data manipulation code. TIP: Use managed beans to store only logic that is related to the UI rendering.