orangewise (nerdy stuff)

September 30, 2005

OA Framework Tutorial

Filed under: oracle applications — orangewise @ 4:02 PM

Tried to setup the development environment following the turorial’s chapter 1: Setting Up Your Development Environment. This went fine until running test_fwktutorial.jsp. The following error pops up:

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: SYSTEM-ERROR. Tokens: MESSAGE = No suitable driver;

Sandeep’s
message in forum helped me out here. Appears I hit bug 4069224.

Environment seems to be working now, on to my first page. Steps in the process:

Step 1. Create a New OA Workspace and Empty OA Project with the New… Dialog

Choose General > Workspace Configured for Oracle Applications from the New… dialog. The .dbc connection file can be found in:

<jdev_user_home>myhtmlOA_HTMLsecure

Step 2. Set Run Options in OA Project Settings

Select the Common > Oracle Applications > Run Options settings page. Select OADeveloperMode and OADiagnostic, and move them to the On Options List. OADeveloperMode provides extra code checking and standards checking at runtime. OADiagnostic enables the Diagnostics button in the global buttons at the top of the page, overriding any corresponding profile option set for the application. You should always have these two modes turned on during development.

The responsibility key (FWK_TBX_TUTORIAL) you use should match the responsibility assigned to your username!

Step 3. Create the OA Components Page File

Your package file name (which determines the location of the XML page file in the directory structure) should be set to oracle.apps….webui (to comply with Oracle Applications directory structure standards), where the application shortname is lowercase and is an existing Oracle Applications product shortname, such as INV. Note that pages migrated from old AK pages may use a different directory structure (pages instead of webui).

Step 4. Modify the Page Layout (Top-level) Region

The scope of shared regions (LOVs) should be set to public:

Step 5. Create the Second Region (Main Content Region)

Now you should be able to run the page…

Step 6. Create the First Item (Empty Field)

Step 7. Create a Container Region for the Go Button

Step 8. Create the Second Item (Go Button)

Step 9. Save Your Work ;-)

Step 10. Run Your Page Using the Run Option

Step 11. Add a Controller

Add a controller to display a message when the user clicks on the Go button.

Step 12. Edit Your Controller

Edit your controller code as follows:

Add the following line as the last line of the import section to make the OA Framework OAException routines available:

import oracle.apps.fnd.framework.OAException;

Code the processFormRequest() method to match the following (making sure to match the item IDs you chose):

public void processFormRequest(
OAPageContext pageContext
, OAWebBean webBean
)
{
  super.processFormRequest(pageContext, webBean);
  if (pageContext.getParameter("Go") != null)
  {
    String userContent = pageContext.getParameter("HelloName");
    String message = "Hello, " + userContent + "!";
    throw new OAException(message, OAException.INFORMATION);
  }
}

Step 13. Build Your Controller

Step 14. Test Your Work Using the Run Option

Your Ad Here




Good Checklist for TNS/SQL*Net Problems

Filed under: oracle — orangewise @ 8:18 AM

Amis published a handy checklist for connections problems resulting from SQL*Net

Your Ad Here




External Password Store (10g R2)

Filed under: oracle — orangewise @ 8:11 AM

New feature for storing passwords that can be used in batch jobs. Until now we have been using a utility called passit, this might become obsolete now.

Your Ad Here




September 29, 2005

DBMS_EPG – The Embedded PL/SQL Gateway in Oracle 10g Database R2

Filed under: oracle, plsql — orangewise @ 8:59 PM

This is really interesting. Read about this new feature in 10g R2:

Since the introduction of XML DB in Oracle 9i Release 2, the Oracle server has contained an embedded HTTP server in addition to the Apache HTTP server. In Oracle 10g Release 2 this HTTP server can be used as an embedded PL/SQL gateway to run PL/SQL applications via mod_plsql. The administration of Database Access Descriptors (DADs) for the XML DB HTTP server is performed using the DBMS_EPG package. This article presents a simple example of its use.

More information can be found here.

Your Ad Here




Oracle and Java Stored Procedures

Filed under: java, oracle, plsql — orangewise @ 6:56 PM

Here you can find a good read on Oracle and Java:

Beginning with version 8i, the Oracle database includes a fully functional Java Virtual Machine, Oracle JVM. Out of this close relationship between Oracle and Java emerges an important technology for Oracle developers: Java stored procedures. With Java stored procedures, developers have the ability to harness the power of Java when building database applications. This article provides an overview of this increasingly popular technology. Its intended audience is Java developers new to Oracle, and Oracle PL/SQL developers with a basic understanding of Java. After highlighting the benefits of Java stored procedures, I will demonstrate how to create and use them in your applications.

Your Ad Here




Books: Effective Oracle by Design

Filed under: books, oracle, plsql — orangewise @ 11:09 AM

I can recommend this book to every Oracle developer, read it 2 years ago and still use it frequently. Enjoyed almost every page of it!

Your Ad Here




September 22, 2005

WMS Opportunistic Crossdocking

Filed under: oracle applications, wms — orangewise @ 3:19 PM

In the manual we read: WMS supports opportunistic crossdocking, if it is enabled, for the organization. This means that whenever there is backorder material and new supply arrives, from either a WIP completion or a PO receipt, the operator will be directed to stage the material for the appropriate order rather than put the material away to inventory.

I tested this and found that goods are directed to the staging lane to supply an order in backlog. Somehow the crossdocked LPN was not added to the delivery that was created when the rest of the order was released. Not sure how this is made visible to the warehouse.

Your Ad Here




September 20, 2005

Categories in Blogger

Filed under: misc — orangewise @ 2:39 PM

Using blogsearch it is pretty easy to have simple categories on your blogspot. Check my categories on the right to see what I’ve done. Search your own URL + any other keyword(s). No need for tagging your blog or re-tagging ;-)

Your Ad Here




Competition for TOAD?

Filed under: oracle, plsql — orangewise @ 10:26 AM

Oracle is working on new developer tool called Raptor. Will this be an alternative for TOAD? Will it also be free like JDeveloper? Can’t wait to try it out, HTMLDB is created by the same group of developers so that surely sounds promising! Some more screen shots have been posted by Bryan.

Just found some more discussion here.

Your Ad Here




September 19, 2005

WMS Put Away Tweak

Filed under: oracle, oracle applications, wms — orangewise @ 9:06 AM

Our goal is to receive full containers at once in the first step of the receipt. Example, receive one container of 60 pallets in one transactions in stead of doing 60 transactions. Fork lifts can then pick up the pallets from the receiving docks scanning labels and put them away into inventory.

  • Create put away rule that meets your requirements
  • Receive goods (first step)
  • Run Pre-generate Put away suggestion. Link the LPN label to this pre-generate business flow.
  • LPN labels are created. While this is happening, generate a new LPN for each label that is created and add this new LPN to the label before it gets printed. You can link this code into the process by using procedure SYNC_PRINT_REQUEST in package INV_SYNC_PRINT_REQUEST. Stick the labels on the incoming pallets.
  • Second step of receiving can now be done using from/to LPNs printed on the label.

Dispatching the generated put aways to designated fork lifts doesn’t seem to be available in release 11.5.10.

Your Ad Here




Older Posts »

Powered by WordPress