Event Delivery Networks(EDN) in SOA

This is a Short Post with a Youtube Clip about EDN. In this I have explained about EDN , and how to design a simple composite application  with Events.
This is all about events (EDN) ( Note - Same thing can be done though Messages, but here we just talk about EDNs).EDN is

1. Declarative way to work with publish-subscribe events (Generate and Consume events), that make it  Drag and Drop.
2. It is fully declarative and developer need not to worry about the Infrastructure.He is just need to look into Raise /Publish /Subscription of the Events.
3. It is EDL based and purely business Oriented ( I feel best application of EDN is between ADF-SOA).
4. EDN are Asynchronous in Nature.
5. Another feature of EDN is the ability to publish and subscribe to these events from a variety of programming environments such as Java, PL/SQL, SOA Composites, and ADF-BC applications.

I feel Business applications can utilize these EDNs to fulfill various requirements.Let's say we have requirements where when ever Sales Order line amount > 1000 , we would like to have Manual Approval of line. (Assumption - I am assuming that we have ADF based UI and business flow has designed in SOA composite (BPEL)

Back to Back Sales Order line Split

In Latest Release of R12 , Oracle has introduced a new feature for Back to Back Sales Order . With this feature now system will let you Split the Order line(back to back) , if item is received and fully reserved against Inventory.
But if line is fully or partially reserved against the Purchase Order or Requisition system will not let you Split the Sales Order line.

Oracle OAF setup for Oracle Application

This Post is about How to Setup JDeveoper for Oracle Application Development..Below are Simple Steps ( with Screen Shot) , about How to Install and Configure OAF

1.Down Load from http://www.oracle.com/ ( Best is go to metalink and download the version suitable for your Oracle Application Release).
2.Go to Control Panel > System> System properties > Advance tab > Envirnoment Variables button > Define your JDev Home by means of defining Variable JDEV_USER_HOME and assign your Path like .
3.Open/Create OAF Project ( you need to define workspace for OA(Oracle Application) and then a Project inside that.
4.Once Project is Created/open , Right click on the Project and Select Project Properties and

• Assign DBC File  -Don't make any chnage in it unless instructed by DBA( or someone who has provided you this file)
• Enter Oracle Apps User Name/Password
• Enter Application Short Name /Responsibility Key.Please Note that User in the above Step should have access to Responsibility you are selecting in this Step

( Please Refer the Below Screen Short for Further Details).

Commands to Open Oracle Report6i and Form6i in UNIX envirnoment

These days working on some 11510 projects and I had hard time to look for the commands to open Oracle reports6i/forms6i in UNIX.
Listing these commands for reference.

 To Open/Run Oracle Reports6i in Unix use

rwbld60     To Open
rwrun60                            To Run

To Open/Run Oracle Forms6i in Unix use

f60desm                             To Open
f60genm                           To generate and compile.

GL Sets of book Error in Oracle Order Management

If you came across GL Sets of books error as soon as you try to navigate from Order Header to Order Lines , make sure that you have configured the System > System Options in Oracle Receivable for your Operating Unit.

Last week I was involved in Complete Order to GL Setup in a Blank R12 Instance and had hard time to resolve this Error. During debugging I notice that whenever you navigate from Order Header to Order Lines Block , System try to validate if for a operating unit if data is available in AR_SYSTEM_PARAMETERS  table or not . If there is no data exists in this table for the operating Unit where you are trying to define the Sales order system was throwing Error  'GL Sets of Books" not found  ( user-defined error ) , even though General Ledger set up proper
To resolve the issue I navigate to Receivable >  Setup > System > System options and define the System options for the Operating Units.

Thanks

XML Report with Bind parameters in Oracle JDeveloper

This Post is with continuation of my previous Post about how to design the XML Reports from SQL Query with XQuery in Oracle JDeveloper.
Last post was about how to do a Simple report , this Post is about how to design a report with Bind Parameters.
I have uploaed all Screen Shot on my Picasa Album , Click on below Screen Shot and it will Navigate you to my Picasa Album


Below are Steps to Create report in XML Format as shown in Above Demo

XML reports with Oracle JDeveloper

While exploring Oracle JDeveloper for ADF , I found an Interesting feature of JDeveloper , XSQL .
This feature allow you generate the XML from a SQL Query with in minutes with Oracle JDeveloper XQuery function. you need not to be an expert in XML , only skill you need is SQL and just Drag and Drop.

I have uploaed all Screen Shot on my Picasa Album , Click on below Screen Shot and it will Navigate you to my Picasa Album.

Below are Steps to Create report in XML Format as shown in Above Demo.

Invoices and Receipt Creation with AR_INVOICE_API_PUB and AR_RECEIPT_API_PUB + Workflow

I was working on a prototype for customer to to create the Invoices in AR and then create the CASH receipt.
End requirements are to create the Invoices and then Create the Cash receipt based on the customer number. My Customer was not interested in applying the Receipt to particular invoices, as they just want to see how much cash they have received from the customer.This requirement is related to the CHARITY Industry , and customer want to see weather people honor their commitments are Not.

In my prototype I have created a small workflow to call the Invoice  API  AR_INVOICE_API_PUB.create_invoice , Once Invoice created successfully , workflow progress to Next activity to create receipt by calling  Oracle AR_RECEIPT_API_PUB.create_cash .I have included notification to inform the user if the Invoice or receipt API fails with Expected or Unexpected error.For My testing I have also included notification for successful invoice creation.

Order to General Ledger Flow ( Oracle Applications)

Last couple of weeks are really crazy for me , getting involved in Financials again and again.Last few weeks we are working on a POC for a customer where they want to auotmate the Order to General ledger process for Non Service Item on Oracle E-business Suite R12.

Requirement - Customer will get hundered of Orders/hour from the Source system and they want to Created/Book/Invoice (AR) these orders in Oracle EBS and then Created Receipt against the Invoice in Oracle receivable and Finally customer want to see the Journal enteries in Oracle General Ledger.

Since this is Service Item we don't Need Shipping or Inventory and for Order Creation we suggested Bill Only Flow

For all Order payment Types will be Credit card .

To Automate the complete process we have set