Item not available in the Price List

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.

Order Header is in Closed Status , even when all the Order lines are cancelled

Order Header is in Closed Status , even when all the Order lines are cancelled

Many a times we have notice that Order Header has value FLOW_STATUS_CODE = 'Closed', open_flag ='N', where as all the lines associated with the Order Header in status Cancelled. FLOW_STATUS_CODE ='Cancelled', Open_flag = 'N' and Cancelled_flag ='Y', well that's what we expect from the system. Though that is the expectations , but many a time user debate that since all the orders lines are cancelled , order header should be in Cancelled status and NOT in Closed status.
Please Note that if we cancelled the order header , in that case cancellation process will cancel all the open lines and then cancel the order header and set the Header flow status code = cancelled and cancelled flag = Y and open_flag = N.

But the case that we are discussing here is not the cancel order process, here we have not cancelled the Order Header rather we have cancel all the line.Please note that when we cancel a order line , it cancels(if possible) the order line and associated delivery details (if possible) and then execute the "CLOSE LINE" workflow process to set the cancel flag = Y and flow_status_code = Y, and at the same time it let the Order header workflow knows that this line is cancelled and open_flag = N.
Thus  the moment last order line got cancelled and inform order header that openflag for it is N , order header workflow evaluate that if there are no more open lines , it progress towards the Close Order process and close the Order ( if you have setup close the order header when all the lines has open_flag = N) .That is the reason when you query such order you can see the Order STATUS as CLOSED and NOT the CANCELLED. Please note that cancelling all lines are different from the Cancel Order .
In Cancel order we explicitly tell the system to cancel the order , but if you cancel all the order lines individually , system will not considered that action same as that of Close Header.

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

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.

The critical components of ERP include:

• A strategic plan describing what will be done.
• A set of process designs that state how the work will be accomplished.
• A set of integrated IT project plans that will support the processes.
• A body of standards to which the data, databases, applications, networks and hardware must conform
• Management support and human resources education.

What will ERP fix in my business?
There are five major reasons why companies undertake ERP.
Integrate financial information—As the CEO tries to understand the company's overall performance, he may find many different versions of the truth. Finance has its own set of revenue numbers, sales has another version, and the different business units may each have their own version of how much they contributed to revenues. ERP creates a single version of the truth that cannot be questioned because everyone is using the same system.

Integrate customer order information—ERP systems can become the place where the customer order lives from the time a customer service representative receives it until the loading dock ships the merchandise and finance sends an invoice. By having this information in one software system, rather than scattered among many different systems that can't communicate with one another, companies can keep track of orders more easily, and coordinate manufacturing, inventory and shipping among many different locations at the same time.

Standardize and speed up manufacturing processes—Manufacturing companies—especially those with an appetite for mergers and acquisitions—often find that multiple business units across the company make the same widget using different methods and computer systems. ERP systems come with standard methods for automating some of the steps of a manufacturing process. Standardizing those processes and using a single, integrated computer system can save time, increase productivity and reduce head count.

Reduce inventory—ERP helps the manufacturing process flow more smoothly, and it improves visibility of the order fulfillment process inside the company. That can lead to reduced inventories of the stuff used to make products (work-in-progress inventory), and it can help users better plan deliveries to customers, reducing the finished good inventory at the warehouses and shipping docks. To really improve the flow of your supply chain, you need supply chain software, but ERP helps too.

Standardize HR information—Especially in companies with multiple business units, HR may not have a unified, simple method for tracking employees' time and communicating with them about benefits and services. ERP can fix that.

In the race to fix these problems, companies often lose sight of the fact that ERP packages are nothing more than generic representations of the ways a typical company does business. While most packages are exhaustively comprehensive, each industry has its quirks that make it unique. Most ERP systems were designed to be used by discrete manufacturing companies (that make physical things that can be counted), which immediately left all the process manufacturers (oil, chemical and utility companies that measure their products by flow rather than individual units) out in the cold. Each of these industries has struggled with the different ERP vendors to modify core ERP programs to their needs.
NOTE - For above Blog I collected the information from various site and compiled here.

Oracle 11g Database (Complete Story)

Oracle 11g Database (Complete Story)

Found Interesting presentation on Oracle 11g database.

CLICK THE BELOW LINK
Oracle Upgrade11gr1 Workshop1

Steps Required to Close Inventory Period in Oracle Application

Steps Required to Close Inventory Period in Oracle Application

This is post about the Steps that we should follow while closing Inventory Period in Oracle Application. Below power point presentation explain

1. Steps that we should follows.
2. Exception reports that we should run before we try to close the Period.

NOTE - Please Note that Period Close in irreversible Process.

How to Close Period in Oracle Apps Inventory
 Click the above link it shows the slides

Query to check all the Picked Delivery Deatils where Reservation not exists

Query to check all the Picked Delivery Deatils where Reservation not exists

 Select ool.line_id,
 wdd.delivery_detail_id,wdd.source_line_id,wdd.ship_from_location_id,wdd.organi
 zation_id,wdd.src_requested_quantity,
  wdd.shipped_quantity,wdd.move_order_line_id,wdd.customer_item_id,wdd.split_fro
 m_delivery_detail_id,
   wdd.source_header_number,wdd.source_line_number,wdd.picked_quantity
  from wsh_delivery_details wdd , oe_order_lines_all ool
  where wdd.source_line_id  = ool.line_id
        and ool.open_flag ='Y'
        and wdd.source_code ='OE'
        and Picked_quantity > 0
        and released_status= 'Y'
        and ool.header_id = &enter_Sales_Order_Header_id
        and not exists
        (
        select 1 from mtl_reservations mr
         where mr.demand_source_line_id = wdd.source_line_id
            and mr.inventory_item_id = wdd.inventory_item_id) 

Above sample script is with Order_Header_id as a Parameter. If you want to check for all the Orders , then remove the parameter Condition.

Query to display Sales Order Line Number

Query to display Sales Order Line Number

Below is Simple Query to display Sales Order Line Number in Oracle Order Management

select to_char(l.line_number) ||
           decode(l.shipment_number, null, null, '.' ||
 to_char(l.shipment_number))||
           decode(l.option_number, null, null, '.' ||
 to_char(l.option_number)) ||
           decode(l.component_number, null, null,
                  decode(l.option_number, null, '.',null)||
                  '.'||to_char(l.component_number))||
           decode(l.service_number,null,null,
                  decode(l.component_number, null, '.' , null) ||
                         decode(l.option_number, null, '.', null ) ||
                         '.'|| to_char(l.service_number))||','||
h.order_number
from
oe_order_headers_all h
, oe_order_lines_all l
where
h.header_id = l.header_id
and l.open_flag='Y'