Item not available in the Price List

Recently one of our Technical guy reported that , they have setup a complete New operating Unit , Inventory Org ( Master / Transaction) , New items etc. Everything work fines , but Item is not visible in the Pricelist. For the sake of testing he set ALL_ITEMS in the Price list and able to Book/Ship/close order line with a default price.

Initially I don't see any issue with the Item or any other Setup , but WHY on earth Item still not visible to Price list.But latter I found that it is because of a Silly mistake.We have one Profile option
QP:Item Validation Organization and It should have a value of your Master Validation Inventory Org  , but in this particular case he left it blank and because of it Items were not Visible in the Price List.

Oracle Application Adapter (Oracle AS Adapter) in BPEL ( JDeveloper) Part -1

This post is about Oracle Application Adapter (Oracle AS Adapter) available in BPEL.Oracle Applications is also informally known as Oracle E-Business Suite Adapter.

Oracle Applications is a set of integrated business applications that runs entirely on the Internet.It is a unified information architecture that consolidates data from Oracle and non-Oracle applications and enables a consistent definition of customers, suppliers, partners, and employees across the entire enterprise.

Oracle application Adapter for Oracle Applications provides comprehensive, bidirectional, multimodal, synchronous, and asynchronous connectivity to Oracle Applications. Theses Adapter supports for all modules of Oracle Applications in Release 12 and Release 11i.

Advantages of Oracle Application Adapter are customer  can use there existing Oracle Application Infrastructure and expose Integration Interface/APIs as Webservices by means of Leveraging Oracle Integration repository and,  that is one more Step to Oracle Fusion.
SOA is all about providing /Consuming Services and abstracting Interfaces(by means of exposing them as Web Services).

Service Oriented Architecture of Adapter

EBS Adapter Architecture

Service Data Objects (SDOs) and How to Invoke SDO in BPEL Composite (Part-3)

With reference to Part-1 / Part-2 , we know that we can use SDO based webservices to perofrm the data manipulation operation on the data that needs to be persisted to the database.
In my example I have designed 2 webservice to manipulate customer and Stock data.we will use these 2 services in BPEL to get the customer/Stock details from the database by passing it the appropriate data and expect the customer and stock details in the response.

Please Note that this is just an example about how to design and use the SDO based webserives .We usually use SDO based webservices in BPEL services only when there is requirement to operate on data that needs to be persisted to the database.

In Oracle SOA Suite 11g, a new feature has been introduced called Entity Variables.An entity variable is a special type of variable that can be used in a BPEL process for  accessing and manipulating data from database and  underlying data form for an Entity Variable is an SDO.

NOTE - Entity variable only holds the reference to the data. The underlying data provider takes care of retrieving and holding the data. To retrieve a row from the database, you need to assign a value for the primary key. The action of assigning the value, called binding, initiates the retrieval of the corresponding row.

In my Example -
Below is Youtube Demo about how to call SDO based Web Services from BPEL

Service Data Objects (SDOs) and How to Invoke SDO in BPEL Composite (Part-2)

This post is part 2 of the 4 part series about Service Data Objects (SDO) and how to Invoke SDOs in BPEL/SOA Composite.Please refer Part 1 and What is SDO for more details.

In this Post I will explain with a You Tube Video(Presentation) about how to Test the Web Service ( that I have design and Deploy in (Part-1) from the Enterprise Manager.

Service Data Objects (SDOs) and How to Invoke SDO in BPEL Composite (Part-1)

This Post is with reference to Service Data Objects (SDO) and how to Invoke SDOs in BPEL/SOA Composite.I recommened please refer my Post Service Data Objects (SDOs) in Oracle ADF and How to Integrates SDOs with BPEL for MORE Details on SDO.

This Complete Presentation is 4 Part Serives , here I will illustrate the usage of SDOs and will explain with example about how to use Service Data Objects(SDO) in an SOA Composite for accessing and manipulating data.

Part -1
we will use ADF-BC to create view objects that are made available as SDOs through an ADF-BC service.

Part -2
We then use this service to retrieve data from the database using the primary key of the table and then subsequently update the retrieved row.

Part -3
call SDOs in SOA composite(BPELFlow) by means of Bind variables.This Part will cover

1. How to define Bind variable in BPEL .
2. How to Associate Bind variable with Entity Variables
3. How to Invole Web Servies(SDO based) in BPEL

Part -4 - End to end testing.

Part -1
Here I will explain with a Short Youtube presenation about  create a service that exposes data objects as SDOs. Please Pause the Video as and wehn required ( I am still working the Audio part).
 

Service Data Objects (SDOs) in Oracle ADF and How to Integrates SDOs with BPEL

A Service Data Object, or an SDO, is a standard defined by the Open Service Oriented Architecture consortium for providing access to business data, regardless of how it is physically accessed.The SDO specification adds a programming language-agnostic abstraction layer on top of technologies such as JDBC.SDO Unified access to heterogeneous data sources.

The SDO architecture is based on disconnected Data Graphs. Data graphs are tree structures of Data Objects retrieved from data sources, which are then accessed and modified by the client as part of its data processing logic. These changes are then persisted to the underlying data source in a consistent manner ensuring that data
in the data source that is being updated is not stale. These changes are detected and automatically applied by the SDO without the client having to invoke an update operation explicitly.

SDOs by themselves do not provide a mechanism to access a data store. This functionality is provided by a DAS, or Data Access Service. A Data Access Service queries data from data sources, builds the data graphs of the data objects retrieved,and applies the changes to the data back to the data source.

Multiple Layout in Single rtf for BI Publisher reports

Some time back one of the reader asked me about how to display multiple report Template in single layout for XML P report.
Well simple example is conditional formatting.Like design the layout as shown below

Layout1

Layout2

and then add conditional Formating for both the layout, in Conditional Formatting you check the condition and make these layout Visiable /Hide.

Found one very Good example on Web about it .

Multiple Layout in Single rtf for BI Publisher reports

Oracle Open World 2010

Share Experience/knowledge/links/anything  about Oracle Open World 2010

How to Create PTO Model and Partial Shipment in Oracle Applications

This is Short Youtube Presentation about
1.How to Create PTO Model in Oracle Applications

• Creation of PTO Model
• PTO Model Class
• PTO Options
• Creation of Bill of Material
• Stock Creation for PTO Options

2.How to create Sales Order with PTO Model.

• Order Creation
• Delivery Detail Split and Pick Release
• Ship Confirm
• Partial Shipment of PTO Model. ( Non Proportional ).
• ITS

Oracle Sales Order to General Ledger Flow (Oracle Application).

This is short You Tube Video about data flow from Oracle Order Management to Oracle General Ledger.

Back to Back order creates New requisition if Reservation got deleted.

There was question about back-to-back Order. Customer has created the B2B Sales Order/Requisition and Purchase Order (not yet received), but somehow they deleted the reservation and order line once again back to “Supply Eligible Status” and on progress, order line once again creates a New requisition  in system and flow Status code for Order line is 'External requisition requested'

This creation of requisition is is very much expected behavior because In B2B flow Supply order (Purchase Orders) always hard pegged (hard-reservation) to the sales order, so that any other demand source for same item  should not take that Item.(reserved for this sales Order). But this link between Order management and Purchasing has broken because of the deletion of reservation. And order line back to status of “Supply Eligible” ad any attempt to progress order line once again created a new requisition/new PO etc.

But customer requirement here are, to avoid the creation of New requisition .Because requisition /Purchase has already created earlier , and only way to achieve this is ,If customer has item already available in the stock( received against the PO created before they deleted the reservation, or received from some other source) then they can manually reserved the item against the Inventory and not against "Requisition" , in such case Order line will progress to "Awaiting Shipping' and eligible for Pick release etc, thus they can avoid creation of new requisition.

NOTE - Please Note that when sub inventory information is changed for an B2B Order line ( already reserved and requisition has created) , reservation information for this order line got deleted and line moves back to Supply Eligible state.

How to Encrypt Password for Concurrent Program with Executable Mathod "HOST".

This is a short Post about How to Encrypt Password while desiging the Concurrent Program with Executable Method "HOST".
In the Concurrent Program Definition , when you Select a executable with a Method as "HOST" the Option text box will be Enable(read-write) as shown below Screen Shot , enter the value "encrypt" in that .Now if you run your Concurrent program the Password used in the Host Program will be encrypted automatically.

KIT Item Stuck at AWAITINg SHIIPING rest every thing is CLOSED.

Customer reported that their KIT item got stuck at the Awaiting Shipping status , and at the same time INCLUDED item lines got Ship Confirmed and finally Closed. Intended behavior for a KIT is , as soon as we book the Sales Order ,KIT line workflow go all the way to DEFERRED-FULFILL and once we run  workflow background process , it progress to FULFILL-NOTIDED status and flow status code on Sales Order line will be AWAITING_FULFILLMENT, and KIT line will remains on that status till INCLUDED Item lines FULFILL-NOTIFIED status.Once Included items in Fulfill-Notifed status they will progress the KIT line too for Invoicing/Close.

During analysis of the problem I have notice that customer has setup KIT as shippable lines and because of that KIT also interfaces to WDD (WSH_DELIVERY_DETAILS) table and eligible for Pick Release/Ship confirm ,During Pick release  KIT line got BACK ORDER , as their was no stock ever created for KIT , on the other hand INCLUDED items successfully shipped and invoiced and closed,and all that leads to Remnancy in the KIT , and Model Remnant Flag for all the lines = Y.Please Note Once this flag = Y system will process every line as a Standard line and progress the Individual line, and that was what had happened in that case .Since the Complete KIT become Remenant , system has progress the INCLUDED lines to Close , while KIT Item was back order and stuck as AWAITING SHIPPING status.

Best Solution is - Don't define the KIT as Shippable , but if you have some business requirement to define KIT as Shippable , then make sure you have stock for KIT.

Hope that helps


- Posted using BlogPress

Want to ship KIT Item too?

Today we have requirement where customer want to ship the KIT item too.Common practice for the KIT items are, We defined the KIT as Not Shippable Item with mandatory INCLUDED Items.

We ship only INCLUDED items of the KIT and invoiced the KIT item , but at the same time we do populate the shipped quantity for the KIT item.
In case you have a requirement like this where you want to ship the KIT too, go to the respective inv org and set the shippable flag = yes.
Try to create the orders and you will notice that KIT item too interfaces to WDD(WSH_DELIVERY_DETAILS) table and now eligible for PICK RELEASE and ship confirm.Please make sure that you created stock for KIT too ( as you want to Ship this Item).

Events , Human Task and Display Form for Human Task(Oracle SOA)

Just uploaded a short Youtube Demo about how to incorporate Events(EDN) in the Composite. In my previous demo  Design and Deploy HumanTask and Display Form for Human Task I have explained How to design. Human Task and Display form(Input to the Process was cust.xsd).

Youtbe Video for this example available at  - Events , Human Task and Display Form for Human Task

To explain how to add events in a Composite I have modified my previous example (Design and Deploy HumanTask and Display Form for Human Task) and added

1. Events Definition to create Event.
2. Added Event to the event Definition.
3. Added Mediator Process in the Composite and Subscribed to the event (created in Step#1 and Step#2).
4. While creating the Event in Step#2 ,I have assign the cust.xsd as payload for the event(because I want to use the same BPEL/Human task flow that I have created in previous example).
5. Step#1 and Step#2 created .edl and .xsd file in my Project.
6. .edl is the Events definition file and .xsd is the Schema file for my Message.
7. Wired the Mediator and the BPEL Process.
8. Now BPEL process is wired with Web-Services as well as well as Events and can be called from both ( Please Note that , Input from the webservice created in last example as well as the payload for event is based on cust.xsd). 

Hope that helps

Design and Deploy HumanTask and Display Form for Human Task (Oracle SOA)

Just Posted a short and fast Youtube Video about How to design Human Task flow and Display Form for Human Task flow.( This is Pretty details one with step by step guide about how to Design and Deploy Human task and Display Form).

Most Important Part in the Video is How to Deploy the Display Form for Human Task flow in Server. (Please Note that you can design the Display Form by means of Auto Generate too) .
I tried to Load 20 minutes demo , but I guess we have some limitation in You Tube.( Please Slow down the video if that appears very fast tp you).

Youtube Video is available at
Design And Deploy Human Tak and Display Form for Human Task