1.Order Flow :1) Enter the Sales Order: This part includes Entering the Header first.To enter the header we need the customer and it locations details. The order type and the sales rep details. In the others tab enter the tax code and Warehouse.Now in the lines tab - Enter the item Qty & Schedule ship date.2) Book Order: Untill the order is booked the order cant be progressed. Booking Kicks off the workflow associated with the Order type and shipping process can be started now.3) Pick Release: In the Release window we release the order to make sure it is ready for shippment. one Delivery document created in this process. This process performs a move order transaction in inventory and the items are moved to Stagging from sub inventory.4) Ship Confirm: This part is moving the items from stagging to the customer. Three major program runs in this process a) Interface trip stop b) Bill of Lading c) Commercial invoice.5) Auto Invoice: Generate the invoice 2. What is the purpose of interface trip stop?Interface Trip Stop - Interface Trip stop plays very critical part in Oracle Order management application.It is concurrent program that you can triggered from Interface > Submit Request . Interface Trip Stop.Or you can also trigger this concurrent program at the time of ship confirm by uncheck the ?Defer Interface? checkbox. By Default this check box is uncheck only.Interface trip stop has 2 parts1.It process the data related to Order Management.2.It Process data related to Inventory.(and we have separate CP for this too ?Inventory Interface?).In First part it make update on oe_order_lines_all table as well as wsh-delivery_details and once this part executed successfully only then SECOND phase of ITS has triggered. If FIRST part error out for some reason then 2nd part will not be triggered, and even if you try to submit ?Inventory Interface?, it will not pick up you data. Reason ? it will validate and check if oe_interfaced_flag in wsh_delivery_details table is Y or not. If it is N or X ?inventory Interface? will not pick that record for processing.I have observed that in most of time user submit the interface trip stop while doing the ship confirm, but there are considerable cases when customer preferred to run this as a scheduled process without specifying the delivery# or Trip #, because their volume of order processing is very high and they want to run this process during some particular time of the day.Please make a note that unless this process execute, workflow for Order line is remain at SHIP_LINE Notified and will not progress to Fulfill and finally Invoicing .So while deciding when to trigger this program you have to make sure that when you want to Invoice customer.One piece of advice that I will give here is, Never try to stop execution of this program, unless you have a very valid reason. Any halt in ITS will result in piling of data in SHIP_LLINE notified workflow status and once you start executing again after a stop it will take a deep dive in terms of your performance.3. drop shipment:Drop shipment is the process by which an organizatoin takes orders from their customer and gets it fulfilled by a 3rd party. The selling organizatoin places a purchase order to teh 3rd party (supplier) who ships the ordered products to the end customer directly. There are a large number of tables that contain data related to drop ship orders. For example:oe_order_headers_all and lines_all (order info)po_requisition_lines_all, headers_all etc.( req. info)po_headers_all, lines_all (po info)oe_drop_ship_sources_all (check exact name- this table contains the link between the req, po and the original order)Drop shipments occur when our supplier ships the product directly to the customer Order Management sends information to the Purchasing Application to create a Purchase Order, and then, when that Purchase Order is received (to indicate shipment from the supplier to our customer), the order line is automatically updated to indicate that it was fulfilled.In this process, the company running Order Management is modeled as the company to whom the end customer places the original order. We call this process Vendor Drop Shipment, to indicate that we are defining the process from this point of view.The Source Type attribute on the order line, controls whether a line will be fulfilledInternally or drop shipped. A source type of External indicates Drop Ship. Only standard items may be drop shipped. Kits and models cannot be drop shipped at this time. You can define an order type that specifies all of its lines be sourced externally.Drop shipping is a product delivery method in which the seller (retailer) accepts payment for an order, but the customer receives the product(s) directly from the manufacturer. In a drop shipping arrangement, the retailer acts as a middleman between the manufacturer and the customer. His profit in the transaction is the difference between the wholesale and retail price of the items sold.Drop shipping is very beneficial to smaller retail shops, internet-only storefronts and those who primarily use catalogs for sales. Customers of these outlets don't always expect to walk out with their purchases, so a slight delay between ordering and drop shipping is not a drawback. A representative item may be displayed on the store's shelves or pictured in its catalog, but the actual product purchased may be sitting in a factory's warehouse 3000 miles away.Drop shipping functionality enables you to take an order from your customer and fulfill it directly from your supplier's site. Order Management enables you to enter drop ship sales orders and lines for standard, model and kit, and configured items, although you currently cannot perform a drop shipment for Ship Model Complete (SMC) PTO’s.You can receive orders for items that you do not stock or for which you lack sufficient inventory, and have a supplier provide the items directly to your customer. The benefits of drop shipping include:•No inventory is required.•Reduced order fulfillment processing costs.•Reduced flow times.•Elimination of losses on non-sellable goods.•Elimination of packing and shipping costs.•Reduced inventory space requirements.•Reduced shipping time to your customer.•Enables you to offer a variety of products to your customers.When processing drop shipments for orders, you can: Optionally receive and electronically process Advanced Shipping Notices (ASN).•Automatically perform logical receipts upon notification of shipment.•Perform Drop Ship for both make and buy items, and automatically default the source type of External for order lines which need to be drop shipped.4. Invoice table and order table join?oe_order_lines_all.line_id = ra_customer_trx_lines_all.interface_line_attribute6oe_order_headers_all.order_number = ra_customer_trx_all.interface_header_attribute1and oe_transaction_types_tl.name = ra_customer_trx_all.interface_header_attribute25. Order Management Tables updated in Order to cash cycle:Enteredoe_order_headers_all 1 record created in header tableoe_order_lines_all Lines for particular recordsoe_price_adjustments When discount gets appliedoe_order_price_attribs If line has price attributes then populatedoe_order_holds_all If any hold applied for order like credit check etc.Bookedoe_order_headers_all Booked_flag=Y Order booked.wsh_delivery_details Released_status Ready to releasePick Released wsh_delivery_details Released_status=Y Released to Warehouse (Line has been released to Inventory for processing)wsh_picking_batches After batch is created for pick release. mtl_reservations This is only soft reservations. No physical movement of stockFull Transactionmtl_material_transactions No records in mtl_material_transactionsmtl_txn_request_headersmtl_txn_request_lineswsh_delivery_details Released to warehouse.wsh_new_deliveries if Auto-Create is Yes then data populated.wsh_delivery_assignments deliveries get assignedPick Confirmedwsh_delivery_details Released_status=Y Hard Reservations. Picked the stock. Physical movement of stockShip Confirmedwsh_delivery_details Released_status=C Y To C:Shipped ;Delivery Note get printed Delivery assigned to trip stop quantity will be decreased from stagedmtl_material_transactions On the ship confirm form, check Ship all boxwsh_new_deliveries If Defer Interface is checked I.e its deferred then OM & inventory not updated. If Defer Interface is not checked.: Shippedoe_order_lines_all Shipped_quantity get populated.wsh_delivery_legs 1 leg is called as 1 trip.1 Pickup & drop up stop for each trip.oe_order_headers_all If all the lines get shipped then only flag NAutoinvoicewsh_delivery_details Released_status=I Need to run workflow background process.ra_interface_lines_all Data will be populated after wkfw process.ra_customer_trx_all After running Autoinvoice Master Program forra_customer_trx_lines_all specific batch transaction tables get populatedPrice Detailsqp_list_headers_b To Get Item Price Details.qp_list_linesItems On Hand Qtymtl_onhand_quantities TO check On Hand Qty Items.Payment Termsra_terms Payment termsAutoMatic Numbering Systemar_system_parametes_all you can chk Automactic Numbering is enabled/disabled.Customer Informationhz_parties Get Customer information include name,contacts,Address and Phonehz_party_siteshz_locationshz_cust_accountshz_cust_account_sites_allhz_cust_site_uses_allra_customersDocument Sequencefnd_document_sequences Document Sequence Numbersfnd_doc_sequence_categoriesfnd_doc_sequence_assignmentsDefault rules for Price Listoe_def_attr_def_rules Price List Default Rulesoe_def_attr_condnsak_object_attributesEnd User Details csi_t_party_details To capture End user DetailsSales Credit Sales Credit Information(How much credit can get)oe_sales_creditsAttaching Documents fnd_attached_documents Attched Documents and Text informationfnd_documents_tlfnd_documents_short_textBlanket Sales Orderoe_blanket_headers_all Blanket Sales Order Information.oe_blanket_lines_allProcessing Constraintsoe_pc_assignments Sales order Shipment schedule Processing Constratinsoe_pc_exclusionsSales Order Holdsoe_hold_definitions Order Hold and Managing Details.oe_hold_authorizationsoe_hold_sources_alloe_order_holds_allHold Relaeseoe_hold_releases_all Hold released Sales Order.Credit Chk Detailsoe_credit_check_rules To get the Credit Check Againt Customer.Cancel Ordersoe_order_lines_all Cancel Order Details.6. ERP Defintion with example?Suppose you are running a small grocery shop named “Janata Groceryâ€?, so the typical operation as a shop owner is you basically buy groceries from some big seller and stock it in your shop. Now people come to your shop for day-to-day needs and buy stuff from your shop at a slightly higher price than what you originally bought and stocked it in your shop.Ocassionally you may not be carrying items or run out of stock that people ask for so you make a note of it and promise the person to come back tomorrow and they will get their item. So far so good, now lets name some entities before we proceed and things get complicated. The big seller from whom you buy stock is called as Vendor, the people who come to your shop to buy things are known as customers, the stock in your shop is known as inventory.So far we have identified few entities that play an active role in your day-to-day operations. As time goes by, your business expands and now you take orders over the phone and provide service to deliver the items to your customers, so you hire people to help you out in maintaining the inventory, do the delivery part and all the necessary stuff to keep the business running smoothly. The people you hire are known as employees.So in this small shop, you typically manage the bookkeeping activities by hand using a notepad or something similar. Now imagine the same setup on a larger scale where you have more than 10,000 customers, have more than 1000 vendors, have more than 1000 employees and have a huge warehouse to maintain your inventory. Do you think you can manage all that information using pen and paper? Absolutely no way! Your business will come to a sudden stop sign.To facilitate big businesses, companies like Oracle Corporation have created huge software known in the category of ERP (Enterprise Resource Planning) as Oracle Applications. Now coming to think of it, Oracle Apps is not one huge software, instead it is a collection of software known as modules that are integrated and talk to each other.Now what is meant by integrated? First let us identify the modules by entities. For e.g Purchasing and Account Payables deal with the vendors since you typically purchase from vendors and eventually have to pay the dues. Oracle Purchasing handles all the requisitions and purchase orders to the vendors whereas Oracle Accounts Payables handles all the payments to the vendors.Similarly Oracle Inventory deals with the items you maintain in stock, warehouse etc. Dealing with customers is handled collectively with the help of Oracle Receivables and Oracle Order Management. Order Management helps you collect all the information that your customer is ordering over the phone or webstore etc whereas Receivables help you collect the money for the orders that are delivered to the customers.Now who maintains the paychecks, benefits of the 1000 employees? right! it is managed by Oracle Human Resources. So you get the idea by now that for each logical function there is a separate module that helps to execute and maintain that function.So all the individual functions are being taken care but how do I know if I am making profit or loss? That’s where integration comes into play. There is another module known as Oracle General Ledger. This module receives information from all the different transaction modules and summarizes them in order to help you create profit and loss statements, reports for paying Taxes etc.7. What are Oracle Alerts?AnswerOracle Alerts are used to monitor unusual or critical activity within a designated database. The flexibility of ALERTS allows a database administrator the ability to monitor activities from tablespace sizing to activities associated with particular applications (i.e. AP, GL, FA). Alerts can be created to monitor a process in the database and to notify a specific individual of the status of the process.8. . What types of Oracle Alerts are there?AnswerThere are 2 types of alerts: Event Alerts and Periodic Alertsa) EVENT ALERTS are triggered when an event or change is made to a table in the database.b) PERIODIC ALERTS are activated on a scheduled basis to monitor database activities or changes.9. shipping process:Shipping date / ship confirm date is stored in the table oe_order_lines_all.actual_ship_date Once the material is shipped and after running the interface trip stop SRS the above field get updated with the ship confirm date.10. What is the Page Protect in Reports?It indicates that whether you want to keep a object and its entire contents on the same logical page. Setting its property to 'yes' if the object and its entire contents cannot fit in the page it will be moved to next logical page.11. What is the Anchoring in Reports? What is the difference between Frame and Repeating Frame?Anchors are used to determine the vertical and horizontal positioning of a child object relative to its parent. The end of the anchor with a symbol on it is attached to the parent object.Since the size of some layout objects may change when the report runs (and data is actually fetched) we need anchors to define where we want objects to appear relative to one another. An anchor defines the relative position of an object to the object to which it is anchored. Positioning is based on the size of the objects after the data has been fetched rather than on their size in the editor. It should also be noted that the position of the object in the Layout editor effects the final position in the report output. Any physical offset in the layout is incorporated into the percentage position specified in the Anchor property sheet.12. How do you debug an Oracle application report developed using Reports 6i?using SRW.Message13. In oracle application how do you debug or trace errors?Help/diagnostics/trace/regular trace14. What is profile and what is level of profile option and it's hierarchy?Profile is the set of change able options in which your oracle application Run . Hierarchy of profile in 11.5.10.2 SiteApplicationReponsibilityServer(B)OrganizationUserUser is the highest level of the hierarchy, followed byResponsibility, Application and at the lowest level, Site. Higher–leveloption values override lower–level option values.15. what is Flex mode and Confine mode?Confine mode On: child objects cannot be moved outside theirenclosing parent objects.Off: child objects can be moved outside their enclosingparent objects.Flex mode:On: parent borders "stretch" when child objects are movedagainst them.Off: parent borders remain fixed when child objects aremoved against them.16. How to send the e-mail notification in XML Pub Report?# 1You can email the report output by using SMTP or maix command with uencode, use request id to get the output.17. what is the purpose of standard cost update?In Cost Management, Oracle takes the item costs only if theyare frozen. To make the Item costs frozen, one needs toupdate the standard cost when entered in the standard costs. Same is not the functionality in Average Cost Update.18. WHAT IS THE FORWARDREFERENCE IN PL/SQL?If a stored procedure(Function or Procedure) need to be called inside another stored procedure in the same package then the called procedure should be declared before the calling procedure. This declartion is called Forward Reference. 19. Tell me the scenarios of between pages in reports?If u have 10 pages, between pages fires 9 times, it doesnt fires for the first page20. Item master org?Item Master organization is the organation where items will be defined by default and then only it is possible to assign that item to child organizations.Item maser org contains all master list of items defined in the system irrespective of whether you want to assign to one inv org or multiple inv orgs.Item master orgnization is virtual organitions where no transaction will be carried out.Used only to define items.Yes it is possible to have multiple IMOs but not recommended.It may lead to confusions.One item master org can be used across multiple OUs.21. define the difference between cycle counting and physical inventory?(1)Cycle counting is the periodic counting of individual Items throughout the course of the year to ensure the accuracy of item.Physical Inv. counts all the inventory once a year Physical Inv. takes a snapshot of inv.'s on-hand quantity at the Beginning of the process. All adjustments are made against snapshot quantity.(2)In cycle counting fewer items are counted each day so less disruption to normal production or distributionIn PI all items are conted once a year so alot of disruption (3)In CC you need to use a miscellenious transaction to report 'found material.In PI unique tag generation is done for recording counts Cycle Count : Periodic counting of inventory items atregular intervalsPhysical Inventory : Counting is done once / twice a yearCycle Count : We can schedule the countPhysical Inventory : We cannot schedule this.Cycle Count : We can view the qty in the systemPhysical Inventory : We can not view the qty in systemCycle Count : Recount is possiblePhysical Inventory : Recount is not possible.22. (N) -> Order Management Super User-> Order Returns -> Sales OrderCreate a Sales Ordera. Order Header -> Main TabB .Order Header -> Others TabVerify that the default values will be populated automatically at the Order Header Levelc. Click on the Lines Tabd. Enter the following details:Ordered Item: AS54888Quantity: 14The price and other details will be populated automatically. Click on each tab to verify the default values that are populated.e. Book the Order. (B) -> Book Orderf. Note the Order# at the Order Header level.At this stage Order has been created with one line and the order is in Booked state. The header information is stored in OE_ORDER_HEADERS_ALL and line information is stored in OE_ORDER_LINES_ALL table.g. Examine the order to get the header id as per the screen shot belowh. Use the following query to get Order details:SELECT ooha.*FROM oe_order_headers_all oohaoe_order_lines_all oolaWHERE 1 1AND ooha.header_id oola.header_id AND ooha.header_id 94219I. (N)->Shipping->TransactionsEnter the Order number and click on Find ButtonJ. You will find the line status as Ready to Release that means that the next step is to release the sales orderAs the order is booked the order record is also stored in WSH_DELIVERY_DETAILS table. The above screen shot uses this table. Use the following query SELECT *FROM wsh_delivery_detailsWHERE source_header_id 94219L. Now we are ready to release the order(N)-> Shipping->Release Sales Orders-> Release Sales OrdersEnter the Order# that you want to release as shown the screen shot belowBased on the picking rule the Auto Create Delivery Auto Pick confirm would be set.(T)-> Shipping(T)-> Inventory The inventory org from which the Quantity will be shippedClick on (B) -> Concurrent to invoke the Pick Release program. It will submit a new request as shown in the screen shot below.View the output of the Pick Slip report. It gives all the details about the subinventory i.e. from FG to Staging etc.Pick Slip OutputOnce the order has been released it populates the WSH_PICKING_BATCHES table. Also verify the order status on the shipping transactions form.(N)->Shipping-> TransactionsThe above screen shot shows there are two delivery lines. The reason is if you look at the pick slip report it has picked up the quantity from two subinventories. Since there are two delivery lines you will find two records in WSH_DELIVERY_DETAILS table. Note that the screen shot shows that the next step is to ship confirm the order. That means the order is now ready to ship.Click on Delivery Tab and select ship confirm from Actions combo boxAnd hit the (B) Go Button.Check the Create Bill of Lading check box and click on Ok Button to ship confirm.The above message indicates that the product has been delivered successfully. After that you will find the status as Closed .At this moment you find records in the following tables:WSH_TRIPSWSH_TRIP_STOPSWSH_DELIVERY_ASSIGNMENTSWSH_DELIVERY_LEGSWSH_NEW_DELIVERIESQuery on the Order number on the shipping transactions form to find the order status:It shows the status as Interfaced . Now Navigate to (N)->Orders Returns -> Sales Orders and query the order. Go to Tools menu and open the workflow status menuClick on View Diagram button to view the order statusRun the workflow background process to move the order records from OM to AR interface tables. (N)->System Administrator ->Requests->RunSelect Workflow Background Process and submit the request with the following parametersOnce the request completes normal then all the order records will be moved to RA_INTERFACE_LINES_ALL table.There is a column called sales_order in this table. Query with your sales order number to find the records in this table.To create AR invoice we need to pull the records from RA_INTERFACE_LINES_ALL table to AR invoice base tables. Run the Auto Invoice Master program from Receivables Vision Operations (USA) responsibility.(N)->Receivables Vision Operations (USA) ->Interfaces-> AutoInvoiceThis in turn invokes the Auto Invoice Import Program to create AR invoice. Verify the AR invoice has been created against this order.(N)->Transactions->TransactionsEnter the Order number in the reference field as shown in the screen shot below:Invoice Header:Invoice line:Verify the Invoice amount freight charges Tax charges etc. This total should match with the amount that was populated on Order Header. The AR invoice information is available inRA_CUSTOMER_TRX_ALLRA_CUSTOMER_TRX_LINES_ALL This completes the Order to Cash cycle. This is the Oracle standard process from booking to invoicing. This document doesn t cover in detail about the setups involved picking rules etc. The purpose of this document is to give an overview of the order cycle. See the workflow status of the order now.