Export Compliance Flow in Oracle Order Management.

This is a short post about Export Compliance Functionality available in Oracle Order Management via Oracle Order Line workflow.

As shown in the above workflow, export compliance process executed as soon as we book our sales Order.
Export Compliance Workflow Sub process Name - Export Compliance Screening - Line

How to Create Refund against Customer Credit in R11i.

In this post I will explain about "How to Create Refund against Customer Credit in R11i" ( How to create refund against on ON-Account Credit ).

In R11i we have option to create refunds for on Account Credit Memo, but before we do that we need to setup limits for each user/currency combination who create the Credit refund , this is to avoid any fraud.

In R11i , we create a Negative amount miscellaneous receipt for Refund.
Below are the Steps for Creating the refund.
1.Create a New Receivable Activity with the Type of "Electronic Refund" and mark it as Active.

ISO and IR new Integration

With new functionality in R12 (IR and ISO integration) , if we change the ordered qty or schedule ship date in Internal Sales Order , system will automatically update the corresponding Internal Requisition ( ofcourse IR should be open)


- Posted using BlogPress

XML Processing in Oracle XMLDB(database)

Oracle XML DB –

This blog would explains in details about XML DB.I will explain what are the feature and advantages of using Oracle XML DB.

Oracle XML database is a high performance XML storage and retrieval technology.It is a feature of Oracle Database that provides a powerful tool for managing XML content, including storage, manipulation, and retrieval. It offers different storage options to meet the unique requirements of different

How to design BPEL flow to Approve the Notification and update the database.

How to design BPEL flow to Approve the Notification and update the database.

This is Short video about How to design BPEL flow to Approve the Notification and update the database. In My example , BPEL flow will receive customer data from an EVENT (EDN) .If credit rating of customer is less then 450 , it required Manual Approcal (for that I have implemented Human taskflow.And if user Manually Approve the customer ,system will update database table ( for that I have implemented database adapter.

How to Copy Sales Order Line level sets in Order Management (R12i Feature) - Part 1

In R12 Oracle has introduced a new feature, where you can copy the Line Sets (fulfillment/Ship/Arrival) while copying the sales order, this will be great help to customers where they have very large sales order with Line sets. Till now user has no option , but to copy the sales order without sets and then manually added line to the sets in new-copied sales order , this process is very tedious and time consuming if the # of lines Order are large and these lines belongs to multiple Sets. But with new functionality their job is really very easy.

This new feature to copy the Sets , has nothing to do with the existing feature of fulfillment set at the order header level , but it do results in some issues/error is not take care properly.

For this new feature Oracle has provided 2 additional checkbox in the Copy Order Form.
1. Fulfillment Set
2. Ship /arrival Set
By default these will be unchecked and also if user is not copying the Order line then these 2 check boxes will be disabled.

Copy to Create New Order
Now when user creates a new sales order by copying the existing sales order, New order will have all the sets copied from the original order and these sets will have same name in the new order as that in the Source Order.

Copy lines (with sets) in already existing Sales Order

Line is already Shipped/Fulfilled

If lines are part of Ship Set or Arrival Set , and if one of the line in the set  is already shipped then system will not let you change the Schedule Ship Date  or Arrival date , unless we remove the shipped line from the set.

Reason - there is processing constraint to validate , and if you try to change the Schedule Ship Date or Arrival date system will raise an error.

AIA Data flow between 2 heterogeneous applications.

AIA Data flow between 2 heterogeneous applications.

AIA PIP for Order to Cash (e-Business to Siebel Integration).

Order to Cash PIP between Oracle e-Business and Siebel.

This Post is brief summary of various feature available in Application Integration Architecture , Pre-Integration Packs(PIP) for Order to Cash flow between Oracle e-Business and Siebel.

What is PIP (Process Integration Packs)

Process Integration Packs (PIPs), mostly used to integrate Oracle Applications, PIPs are composed of pre-built Oracle Applications process integrations, out of the box,  for quick implementation of business processes (i.e. Siebel CRM to Oracle E-Business Suite)

Below are some of features offered in Order to Cash PIP (Integration between Oracle e-Business Suite and Siebel) -

Order to Cash (Integration between Oracle e-Business Suite and Siebel) PIP supports.

1. 1Customer Synchronization.
2. 2Product Synchronization.
3. 3Price List Synchronization  -
4. 4BOM Relationship Synchronization – This is feed from e-Business to Siebel only and it should be requested from Siebel side.
5. 5Create Order /Quote/RMA  Synchronization from Siebel to e-Business
6. 6Revise Order Synchronization from Siebel to e-Business
7. 7Cancel Sales Order Synchronization from Siebel to e-Business
8. 8Update Sales Order Synchronization from e-Business to Siebel

Apart from above Siebel can make a Call to e-Business for

• ATP Check
• Credit Check
• Call to Calculate Shipping Charges.

For more details about this Order to Cash PIP , feel free to contact me.

NOTE - Please Note above is my understanding,  for in-depth details refer AIA documentations).

Oracle Application Integration Architecture - Is it a Application ?

AIA application cannot be recognised in the traditional sense of an application such as General Ledger, Payroll, and Sourcing with its own, self-contained business processes. An AIA application only adds value by combining and leveraging components from existing applications. These application components are consumed and provided by AIA as SOA technology based (web) services.

Some differences between traditional standard applications and AIA:

Oracle Application Integration Architecture - What is it?

What is AIA?

Oracle´s Application Integration Architecture is an open standards based solution that allows customers to create loosely coupled end to end business processes across their applications, which can be continually modified and optimized over time.  The key thing here is that it works between Oracle applications as well as non-Oracle apps.

AIA helps reduce some of the major SOA implementation challenges associated with the complexity of the architecture, building business connections, messaging and exception services, metadata fragmentation, designing canonical data models and data transformation.

AIA Implementations come in two flavors:

•         Foundation Pack – mostly used to integrate non-Oracle applications, the Foundation Pack

Order Sequence of Action Type AME

Recently I have Question about AME

Question - 

We have defined the Rule with added Conditions and Actions saved.Coming back and query for the same rule, we found the order of Actions have been changed.Again modified in required order and saved but still the issue is same.Any Idea in what are all the cased it could happen?

Answer - 

Action Type under Action is sorted alphabetically(please Note there is no Order # associated with it) .

Also  it's order sequence  has no Impact on the final outcome ,Because once a rule executed by AME engine ,it will process all the action types defined for Action.

Data flow for (P2P) Requisition to Payment Cycle in Oracle Applications

This is  short YouTube Presentation about Data flow from Oracle Purchasing Requisition to Payment in Oracle Payables

Approved Supplier List (ASL) in Oracle Purchasing

This Post is about Oracle Apps Purchasing and ASL ( Approved Supplier List) and I will explain how to define the APPROVE SUPPLIER list in Oracle Purchasing

In the last REQ TO PO RECEIPT cycle post we have noticed that I have define an Item(Test001) with “Use Approval Supplier Checked “ and when I try to approve the PO Release for this item system prompt with error message

“Item is restricted and Supplier is not Approve Supplier”. To Progress the Releases /PO with the item that are mark as “Use Approve Supplier” , we need to define the Item in the Approve Supplier List.
Note - In Approve Supplier List (ASL)we define all the Supplier that are Approved to Supply a particular Item.

RFQ to PO Receipt Cycle

This Post is about Oracle applications RFQ to Receipt Cycle.In this Post I will explain the Cycle from RFQ to PO Receipt with screen shots.

High -Lights of this Cycle is
Create

• RFQ
• Quote
• Purchase Order
• Receive against PO.

Once RFQ is created , Submit concurrent job “Request to Print the RFQ” for a supplier. On completion this job will increment print count for that supplier as shown below.

In below  Oracle Apps UIs we can see

Steps to design Interface for Oracle Applications

In this YouTube demo ,I have put the steps that are required to build a typical Interface for any Oracle Applications Module.

Create a BPEL flow with Human task Flow

This is short YouTube video about how to Create BPEL flow with Human Task flow.I have covered following topics in this demo.
1.BPEL process
2.Human task Flow (how to design and configure it).
3.One complete Running example.

>

Rules Priorities in Oracle Approval management

In AME(Oracle Approval management) we have have rules , based on Condition/Action Type/Action and attribute, these rules on execution generate Chain of Authority.Oracle Approval management provide us option yo add priorities to Rules.Priorities give precedence to certain rules over other rules during run time.

At run time based in the Rule priority Mode AME will remove low priorities rules from the list.

Priority is numeric value (threshold) associated with the rule within a transaction type. High Priority rules have low threshold  values as compared to low priority rules.

In AME we have 3 Rule Priority Modes