User cannot perform set operations on this line.

"User cannot perform set operations on this line", this is very common throw by Oracle Application when you try to add a Sales Order line to existing Fulfillment/Ship/Arrival Set. There are many reasons for this Error, but in this post I will discuss one such Case.

Steps -1.
Create Sales Order and Add a Model Line as well as Standard line in the Order .

Steps -2.
Expand the Model and navigate to the Class Line.

Steps -3.
Try to add the Class Line in a New or Existing Fulfillment Set and Boom , you get the error message "User cannot perform set operations on this line".

Reason - Why on Earth you want to add the Class to a Fulfillment Set (Note -Model are always in an Implicit Fulfillment Set ) , but if you want to add the Model and Non Model line in a Fulfillment set then Add the Model line and Non Model line , but do not try to add a Non - Model line and Child of Model ( Class/Option) to the Fulfillment Set as that is not Supported behavior and that also has no business need.

Please Note that When we add a model line to a Set , Set will propagate to all the childs of the Model , but this is not the case if you add a CLASS beneath a MODEL in the Fulfillment set.

Create Sales Order with Model  

 Add a Non-Model Line to Order ( I mean Standard line)

 Try to Add  Item of type Class (of Model) to Fulfillment Set

Error Message

ADF Mobile Browser Application to Get Sales Order Line data from Oracle Apps

This is a short Presentation about How to create Mobile Browser JSF Pages to retrieve sales Order lines details based in Flow Status Code( Line Status).

Customer Requirement -
Customer has requirement to desgin Mobile Application to Browse the Sales Order line based on the Line Status.
Solution -
To Fulfill the requiremengt we have design the Mobile Application with ADF Mobile Browser Technologies with JSF Page by using MyFaceTrinidad Components.
REQUIREMENT -
was to Display
Sales Order Number
Customer Name
Customer Number
Order Qty
Item Name
Shipped Qty
based in the Flow Status Code passed as parameter ,
for all the Orders Created in last 90 days.

APPROCH -
To Fulfill the requirement we have design the JSF Page
with Trinidad Navigation List.In the Navigation List we query
for Field flow Status code and based in it values in the Navigation List Control prints
all the required values in the Detail block of the Navigation
List Trinidad control.
For Demo Please refer the Below You Tube Link(With Sound )

Mobile Apps with Ora le ADF

Enclosed are screen shots of some of mobile pages that I have desgined for one of our client.
Requirement here is, customer want to see the status of order and order line while on the move in prod plan.
This is just a sample page.

Query to get UNPAID Invoices (Oracle Payables)

Below is Simple Query to get Query to get UNPAID Invoices (Oracle Payables). I have alos build condition to exclude ZERO Dollar Invoices.

select i.invoice_num,v.vendor_name,i.invoice_date,ps.due_date,
i.invoice_amount,i.amount_paid,ps.amount_remaining, SUM(i.invoice_amount),sum(ps.amount_remaining)
FROM    ap_payment_schedules_all ps,
        ap_invoices_all i,
        po_vendors v,
        po_vendor_sites_all vs
WHERE   i.invoice_id = ps.invoice_id
AND     i.vendor_id = v.vendor_id
AND     i.vendor_site_id = vs.vendor_site_id
AND     i.payment_status_flag ='N'
AND     (nvl(ps.amount_remaining, 0) * nvl(i.exchange_rate,1))  != 0
AND    i.cancelled_date is not null
group by v.vendor_name,i.invoice_num,i.invoice_date,ps.due_date,i.invoice_amount,i.amount_paid,
ps.amount_remaining
Order by v.vendor_name,i.invoice_num


----
Special Thanks to Kunal for suggesting "i.cancelled_date is not null" , with this new condition Query will not reterive Cancelled Invoices" from database.
-----

RMA with out Credit Memo

This is a Short Post about How to Create a RMA againt a Sales Order and at the time don't create any Credit Memo. This post is an answer to question posted in Processing Constraint Post.
Requirement -
User has created/Booked and Shipped the Sales Order , but line is not yet invoiced and now customer want to cancel the Order Line.Now If user want to cancel the line then Standard Processing constraint will not allow user to cancel the Order line as line is already shipped

Solution -

1. Create an RMA
2. Refer RMA line to Sales Order line that you want to cancel.( we can even add RMA line to Original Order too ( If Permitted)).
3. Assign the return workflow to RMA line.Please note that Oracle Offer following RMA workflows.

• RMA line with Receipt and Credit Memo
• RMA line with Credit an No receipt.
• RMA line with Recipt and No Credit Memo.

Since Original is not yet invoiced , options 3 is good candidate here .I am not sure if this workflow is available in 11i, but it is for sure available in R12i via patch.In case you don't have RMA flow with No CMemo  , you can do it by yourself by customizing the Standard RMA workflow (RMA flow with Receipt and Credit) as shown below

• Copy the Standard RMA flow.
• Rename it and
• Just remove the Invoicing activity .
• Verify the flow and save in database.
• I have enclosed the screen shots for above 3 steps. 

RMA with no CM

Oracle SOA and BPM

Oracle SOA Suite 11g Meets Oracle Business Process Management 11g

View more presentations from Lucas Jellema

Not able to Unreserve Config Item ("ORA-01403: no data found")

"This is a very Short post about the - Not able to Unreserve Config Item.


Please Note that for a  CONFIG items, unreservation ACTION is allowed only when the workflow for Sales Order line is at activity SHIP LINE.
If workflow for Order line is not at workflow activity SHIP_LINE and you try to unreserve the order line system will not let you cancel the Order line and it Unreserve action might result in Error "ORA-01403: no data found

Impact of Cancellation of PO assocaited with B2B Sales Order.

Impact of Cancellation of PO assocaited with B2B Sales Order.

In Order management, for a B2B Sales Order we have Requisition and Purchase Order Associated with order line.In Order management there is no field that store the line between OM and PO. Only link between B2B order line and requisition or PO is via MTL-RESERVATION table.
Below are Steps to Create and progress B2B Order line.

1. Create/Book B2B Order line, Booking will progress the order line to workflow activity “Create Supply Order – Eligible”.
2. Select the line and right click and from pop-up mean Selct “progress order”.
3. Action in setp-2 Insert the data into Requisition Interface table as well as progress order line workflow to SHIP_LINE activity.

Drop Ship receiving ORA-01422: exact fetch returns more than requested number of rows(Part-2)

Many a Times we noticed duplicate data in oe_drop_ship_sources , or we try to perform virtual receiving in the system and receiving Transaction processor error out with following error message  “ORA-01422: exact fetch  returns more than requested number of rows
Second  reason ( Please refer Part 1 for more info for this error ) for this error could be
Data already exists in oe_drop_ship_sources table and then user "RETRY" Sales Order Line workflow activity "purchase release", doing so will insert duplicate data in oe_drop_ship_sources.

So be careful if you want to Retry this activity ( My suggestion don't do that unless you are pretty much sure about it).

Drop Ship receiving ORA-01422: exact fetch returns more than requested number of rows(Part-1)

Many a Times we noticed duplicate data in oe_drop_ship_sources , or we try to perform virtual receiving in the system and receiving Transaction processor error out with following error message  “ORA-01422: exact fetch  returns more than requested number of rows
I did few test case and notice that once we
1.Enter and Book drop ship Sales Order.
2.Run Workflow Background process.

System inserts the data in Requisition Interface tables and oe_drop_ship_sources. At this time requisition and PO related columns in oe_drop_ship_sources are NULL.BUT Once we have requisition and PO got created these columns in oe_drop_ship_sources populated with respective values.
Now if we cancel an Approved PO, ideally system should erase the data from po_header_id,po_line_id, line_location_id  columns of oe_drop_ship_sources , and once we creates a new PO from requisition via autocreate , system will update the old oe_drop_ship_sources record for PO related columns.

fnd_global.apps_initialize (in Oracle 11i)

Below is sample script to set the context (in order to use the views like or_order_lines, oe_order_headers,po_lines,pl_headers etc), and then Verify if the context is set properly or not.

 declare
l_security_group_id  NUMBER:=NULL;
l_server_id            NUMBER:=NULL;
a varchar2(1000);
begin
apps.fnd_global.apps_initialize (
 user_id => 1318,
 resp_id => 21623,
 resp_appl_id => 660,
 security_group_id => l_security_group_id,
 server_id => l_server_id);
Select SUBSTRB(SYS_CONTEXT('USERENV','CLIENT_INFO'),1,10)
into a
from dual;

Vertex L Series data implementation with Oracle Applications

Vertex L series implementation , this posts is about implementation of vertex L series of data in an instance where Oracle Application is already Running.

It is highly advisable that we should decide what type of TAX engine we want in our ERP system at the time of implementation .Though Changing a Tax Engine once our Oracle application is already live is not very complex , but we are always running risk of some missing or corrupted data, if  we try to play around the Tax related data once Oracle Application is already live.
Reason - with system is already live tax related info like location/rates/exemption rules already stored in Oracle Order Management and Oracle Receivables Transactions.So my advise is decide about all your components before you implement Oracle Applications ( but that is just a advise and not hard fast rule , many a time we have to make tough decision to improve business processes).

I recently has opportunity to work on Project where customer would like to Implement Tax Rates Data from the Vertex and not Oracle Standard rates. This was easy as we were  just implementing/changing the Tax Rates and not changing the complete Tax Engine and Setup.

In such a project , following are the required task ( Broad level view).