Oracle BPEL Pick Activity

The pick activity provides two branches, each one with a condition. The branch that has its condition satisfied first is executed.


This activity waits for the occurrence of one event in a set of events and performs the activity associated with that event. The occurrence of the events is often mutually exclusive (the process either receives an acceptance

Status of Order Management Quotes

Below are the all the possible statuses of Order Management Quote before it got converted in Sales Order.

Quotes 

1. DRAFT
2. Pending Internal Approval (PENDING_INTERNAL_APPROVAL)
3. Draft - Internal Rejected(DRAFT_INTERNAL_REJECTED)
4. Pending Customer Acceptance(PENDING_CUSTOMER_ACCEPTANCE)
5. Draft - Customer Rejected (DRAFT_CUSTOMER_REJECTED)

Defer Scheduling when adding line to Set with OM: Auto Schedule Sets

In R12.1 Oracle has introduced a new feature in Order Management . Now with R12.1 we can add lines to an existing ShipSet / Arrival Set without getting scheduled. 


This is very important feature as many a time when order lines that are part of the set and are in ENTERED status , and if we add new lines to these set , system  scheduled these lines , that scheduling in turns consume the available quantity ( being part of the line in ENTERED status , and still consuming the available quantity does not make any sense),but as per the current functionality, lines cannot be part of a set, if they are not scheduled and similarly lines cannot be unscheduled, if they are part of a set


But this is taken care in R12.1 , in this release Oracle has introduced a new system parameter “OM: Auto Schedule Sets”. The value of the system parameter will decide whether lines, which are getting added to a set, should be automatically scheduled or not, at the time of set creation. If the system parameter value is set to ‘No’, lines will not be scheduled automatically, when they are added to a new set. Though  user can schedule the lines manually whenever it is required. If, on the other hand, the value of the this system parameter is set to "Yes" then the lines will be scheduled as and when they are added to a set, i.e. the existing behavior.

Queries to get Supply and Demand data for Oracle Apps

below are 3 queries that might helpful to get Supply and demand details -



select m.demand_source_header_id,m.supply_source_header_id,m.demand_source_line_id,
p.supply_source_line_id
from
mtl_reservations m, po_line_locations_all p
where m.supply_source_line_id = p.line_location_id
and p.po_line_id = &enter_po_line_id

select m.demand_source_header_id,m.supply_source_header_id,m.demand_source_line_id
from
mtl_reservations m, oe_order_lines_all l
where m.demand_source_line_id = l.line_id
and l.line_id = &enter_order_line_id

select ms.supply_type_code,ms.supply_source_id ,ms.po_header_id,ms.po_line_id
from mtl_supply ms , po_lines_all p
where ms.po_line_id = p.po_line_id
and ms.po_header_id = p.po_header_id

Apart from this their is one interesting view  MTL_RESERVATIONS_ALL_V , we can use that too, to get all these details

2 Interesting Oracle Workflow APIs

Abort Process

BEGIN
 wf_engine.abortprocess
               (itemtype =>l_item_type,
                itemkey=>l_item_key );
  exception
            when others then
                update wf_items
                   set end_date = sysdate
                 where item_type = l_item_type
                   and item_key = l_item_key;
 END ;

TCA Queries for R12

Below are 2 TCA queries to get Party and Account data for R12.

---
Set the Context
----
exec mo_global.set_policy_context('S',&enter_org_id);


select stca.cust_account_id customer, u.cust_acct_site_id address,
stcsu.site_use_id site, stpsu.location_id party_location
from  hz_cust_site_uses u,
hz_cust_accounts stca,
hz_party_sites   stpsu,
hz_cust_acct_sites stps,
hz_cust_site_uses stcsu
where STCA.cust_account_id = l_cust_acct_id