How to Create Drop Ship Sales Order Across Operating Units in Oracle Order Management (R12i)

This is detailed post along with Presentation about How to Create Drop Ship Sales Order Across Operating Unit.

Topics that I have included here are

1. What is Drop Ship Sales Order 
2. How to Create/Progress Drop Ship SO in Order Management 
3. Steps to Create Requisition and PO  for Drop Ship SO in Oracle Order Management 
4. Steps to Create Receiving against PO n Oracle Order Management .
5. AP/AR Invoice Creation
6. Intercompany Invoice Creation.

Please refer the below presentation for More details.

Drop Ship Sales Order Across Operating Units

View more presentations from eoracle apps.

Oracle Cloud Computing Strategy

Found very Interesting Presentation on "Oracle Cloud Computing Strategy".
(this is not my presentation)

Oracle Cloud Computing Strategy

View more presentations from Rex Wang.

Data flow Between Oracle Order Management and Oracle Receivables

This and Post are about data flow between Oracle order Management and Oracle Receivable.

This post is very focus on the Invoices in AR from the Order Management and not about the invoices in AR from any other source.
Oracle Order Management is Workflow driven and almost all the workflow in Order management has Invoicing Activity, and while executing the code in the Invoicing activity, OM dump the data in RA_INTERFACE_LINES_ALL and other related Interface tables, and eventually when we run the Auto Invoice it created Invoices in AR.

As I have stated almost all workflow in the Order Management has Invoicing activity , though some exceptions like Ship Only workflow ,these workflow don’t have Invoicing activity.

Invoice Interface activity in Oracle Order Management workflow collects order, return, freight charges, discounts and sales credits information from Oracle Order Management tables, and transfer the information to Oracle Receivables and creates

1.  Invoices
2.  Credit Memo
3.  Debit Memo

 Interface tables that Oracle Order management Populated in Receivables

Receiving option "Validate Serial Numbers on RMA Receipts" for Serial Control Items in Oracle Applications

This is short Post about Significance of the Receiving Option "Validate Serial Numbers on RMA  Receipts" for Serial Control Items  In Oracle Applications ( Receiving Module)

Today while exploring some receiving Stuff I learn something New about Receiving option "Validate Serial Numbers on RMA  Receipts".This is a check box control
I have observed that I we have this value UNCHECKED  then If we Create an RMA (Linked to a Sales Order) , then while doing Receiving against the RMA , in the Receiving Transaction Form , List of Values on field
1.Start Serial Number
2.End Serial Number
should display only the Serial no. that we have shipped on the referenced?liked  Sales Order Number , but to my surprise , displays all the Serial Numbers of the Item that got Shipped on different outgoing sales Order line for a particular warehouse ( in which you are doing transaction).

But if you set the value for this Receiving Option as CHECKED , then while doing the Receiving against an RMA then it will show you only serial numbers that got shipped on the Linked/referenced Sales Orders for that RMA.

Good learning for me , may be for you too.

Continous Price Breaks in R12 Advance Pricing.

In this post I will discuss about the “Continuous Price Brake introduced in Oracle R12 Advance Pricing”.
In R12 Oracle has introduced new feature “Continuous Price Break” to support the continuous price breaks.
Now in R12 Price Breaks will be evaluates as >(Greater Than) FromValue and <=(Less than or Equal) to ToValue.
This will support MORE accurate calculation and will effective on Price Breaks for
1.    Price List
2.    Modifiers
3.    Agreements.

Let’s take an example of exists Price Break and New Enhancements.

Purge Order Management Workflow R12 New Feature

In this post I will just talk briefly about the new concurrent Program “Purge Order Management Workflow” offered in R12 of Oracle application Order Management Suite.

As all of us know , by default Order Header workflow will not close till all the lines are closed , but even if all the order lines are closed Order Header will open till the month end ( seeded behavior) unless there is some customization , but in last 10 years I notice that most of customer are ok with the seeded workflow.

But the problem with this is unless Order Header close, order line workflow is not eligible to close even lines are close. lets take an example .
Suppose you have 1000 order in system with each as 10 lines and let’s says all lines are close. In such case we have 10000 lines whose workflow is not required any more but system will not able to purge them. Now imagine how much data workflow data piled up if you have customer whose  input is 300,000 lines every day.

Price Book a new R12 Advance Pricing Feature.

Price Book is another new feature offered in R12 Advance pricing Module of Oracle Application, it allows customer to generate and publish lists of products with their related prices.
These prices are generated for a full or delta price book. Multiple publishing options are available.  This powerful tool will help provide greater insight to help, manage and maintain overall pricing strategy.

Price Book is a new Pricing report that displays item list and net prices (for a specific customer) based on a specific pricing date.
Within the price book, you can view details of the
    1.List price,
    2.Discounts,
    3.Surcharges,
    4.Price breaks, and
    5.Freight and special charges.
The Price book accepts various inputs for the price calculation.  These inputs include
    1.Pricing effective date.
    2.Pricing attributes.
    3.Qualifiers.

Attribute Management in Oracle Advance Pricing

Oracle Advance Pricing offer one very powerful feature of Attribute Management.In this blog Post I will talk about how to setup a Custom qualifier with attribute management for a Modifier or Price List.

In this example we will setup a custom qualifier "Customer Relationship Type".
Following are the steps.
Step1: Select the Qualifier Context that we want to setup (e.g Order , Customer, MODLIST etc).
Step2: Define the New Custom qualifier under the Qualifier context.
Step3: Setup Attribute Linking and Mapping.
Step4: Create and Compile the Custom PL/SQL package.

you cannot close this line because uncrossing receiving transaction exists

This is a short post about how to resolve the Error -  "you cannot close this line because uncrossing receiving transaction exists".

 In my User case ,user has Drop ship sales order, Requisition and Approved PO has already created for this drop ship Sales Order and Partial receiving has done for the PO. Now user has requirement to Increased the quantity. Options that are available to  user are to Add new line to SO with the rest of the qty and create new Requisition and PO.

But user wants to cancel the PO and then would like to modify the Drop Ship Sales Order by increasing the QTY and then would like to recreate the PO.

But whenever they tried to cancel the PO they are getting error “you cannot close this line because uncrossing receiving transaction exists". Reason- PO is partially received. Now Only way o resolve this issue in the matter user want is - Reverse the partial receiving by means of returning the good back to supplier , by means of  executing following transactions

   1. Return to Receiving
   2. Return to Supplier

Once these transactions got executed successfully , customer can Cancel the PO and then Modify the qty on SO and Progress the Req/PO and receiving.


Hope that helps.

error in handle_nonbulk_mode ORA-01403: no data found( Related to Order Line Sets)

error in handle_nonbulk_mode ORA-01403: no data found

This error is very common error and result of pure data-corruption. There are various reasons for data-corruption.
1. Custom Code
2. Triggers
3. Back end triggers etc
These days I am working on Sets, so I will talk about this error in context of sets. The way Oracle is designed the Sets concept (Ship/Arrival) is, when we associate Ship/Arrival Sets with the Order lines it store this information in

• SHIP_SET_ID
• ARRIVAL_SET_ID

Columns of OE_ORDER_LINES_ALL, as well as INSERT data into OE_SETS table. And once we book the sales order system insert sets data into Shipping WSH_DELIVERY_DETAILS tables in column (SHIP_SET_ID, ARRIVAL_SET_ID). Please note that system doesn’t store fulfillment Set information in WSH_DELIVERY_DETAILS /OE_ORDER_LINES_ALL table, fulfillment set information captured in OE_SETS and OE_LINE_SETS table.

 

Order Header workflow stuck at FULFILLMENT_WAIT_FOR_L ("Fulfill- Wait for Line")

There is a forum question , where user has stated that they have an RMA Order with Header level Invoicing and Order header workflow is stuck at the FULFILLMENT_WAIT_FOR_L( "Fulfill- Wait for Line") workflow activity.

Before I go to solution , I would like to add that when we use header level invoicing , Order header will progress to Invoicing and finally close only when all the order line are Fulfilled .To make sure that this flow work fine, Oracle has set up a Master Detail sort of relation ship between Order Header and Order Lines flow by means of some workflow activity.

In Order Header workflow for header level invoicing ,after Booking Order header workflow progress to Invoicing Subprocess , in Invoicing Subprocess there is activity "Fulfill-Wait for line", this activity will wait here till all the lines that are associated with the Order header workflow execute the workflow activity "FULFILLMENT_CONT_H" ( Fulfill-Continue header).Once Order /RMA line process execute "FULFILLMENT_CONT_H" ( Fulfill-Continue header) , lines informs the Order header about the progress , and once Order header receive this signal from all the lines associated with it progress to next activity (invoicing).

Oracle Order Management Line Sets

This is a detailed post with Presentation about Oracle Line sets ( Ship/Arrival/Fulfillment). I have explained in this Presentation about

1. Functionality of Ship/Arrival and Fulfillment Set.
2. How to Create Different Types of Sets
3. What are different Statuses of sets.
4. Implicit and Explicit Sets.
5. System and User Created Sets.
6. Advantages of defining Sets.

Order Line Sets in Oracle Order Management

View more presentations from eoracle apps.

Copy Sales Order Line Level Sets in Order Management (R12i Feature) - Part 5

This is short Post about How to copy Line level Sets(Ship/Arrival/Fulfillment) on New and Existing Sales order while doing Copying Operations from Order Order Management Sales Order Workbench(UI). This feature introduce in Release 12i of Oracle Application


For More Details Please Refer
Part-1
Part-2
Part-3
part-4
and below Demo(how to Copy Line level Sets on RMA)

Line setonreturn

View more presentations from eoracleapps.

Copy Sales Order Line Level Sets in Order Management (R12i Feature) - Part 4

This is short Post about How to copy Line level Sets(Ship/Arrival/Fulfillment) on New and Existing Sales order while doing Copying Operations from Order Order Management Sales Order Workbench(UI). This feature introduce in Release 12i of Oracle Application


For More Details Please Refer


Part-1
Part-2
Part-3
and below Demo (Copy Line level Sets Between Existing Orders).

Copy setsbetweenexistingorders

View more presentations from eoracleapps.

Copy Sales Order Line Level Sets in Order Management (R12i Feature) - Part 3

This is short Post about How to copy Line level Sets(Ship/Arrival/Fulfillment) on New and Existing Sales order while doing Copying Operations from Order Order Management Sales Order Workbench(UI). This feature introduce in Release 12i of Oracle Application


For More Details Please Refer
Part-1
Part-2
and below Demo

Copy All Line Sets

View more presentations from eoracleapps.

Copy Sales Order Line Level Sets in Order Management (R12i Feature) - Part 2

This is short Post about How to copy Line level Sets(Ship/Arrival/Fulfillment) on New and Existing Sales order while doing Copying Operations from Order Order Management Sales Order Workbench(UI). This feature introduce in Release 12i of Oracle Application

Please Refer Part-1  below Demo for More Details

Copy Line Set in R12 Order Management

View more presentations from eoracleapps.

What is ERP? What will ERP fix in my business?

ERP Stands for Enterprise resource Planning system.These systems are comprehensive organizational strategies, implemented at both the technical and operational levels. At its most fundamental level, ERP is a methodology for effectively applying resources—people, processes and technology—to the mission and operational goals of an organization. This methodology encompasses three phases: understanding the goals and strategies of the business; describing how best to implement those objectives; and mapping individual IT projects to the appropriate processes.



ERP is not a pure technical undertaking; it integrates business process reengineering (BPR) with proven IT methodologies. The following principles are intrinsic to achieving best business practices through ERP:

1. A process orientation—Automating workflow ensures that activities are accomplished smoothly and with consistently high quality. This can generate savings in time, money and personnel, and improve the quality of services.
2. A common data model—To share and utilize meaningful information across an enterprise, data definitions and formats and communications protocols must be standardized. Additionally, a common relational database (RDB) can simplify querying, reporting and data analysis.
3. Integrated systems development—Systems within an ERP solution must be conversant. Ideally, each module would use the same components; minimally, they must meet the same technical specifications.
4. A simple architecture—A careful assessment of the existing IT architecture against ERP business requirements will produce many opportunities to reduce costs improve performance and expand services by simplifying the architecture to reduce redundancies and inefficiencies in systems and processes.

Happy Diwali

Wish All my Readers

Very Happy and Prosperous Diwali ( Festival of Lights).

More on DIWALI