Thursday, March 22, 2012

ORDER MANAGEMENT Interview Questions

ORDER MANAGEMENT Interview Questions
Q: What are the Process Constraints?
A: Processing Constraints allow Order Management users the ability to control changes to sales orders, at all stages of its order or line workflows to avoid data inconsistencies and audit problems.
Q: What is a Pick Slip Report?
A: Pick slip is a shipping document that the pickers use to locate items in the warehouse/ inventory to ship for an order.
Q: At what stage an order cannot be cancelled?
A: If the order is Pick Confirmed, it cannot be cancelled.
Q: When the order import program is run it validates and the errors occurred can be seen in?
A: Order Management Responsibility >Orders, Returns : Import Orders> Corrections
Q: What is the difference between purchase order (PO) and sales order?
A: Purchase Order: The document which is created and sent to supplier when we need to purchase something. (Buying)

Sales Order: The document which is created when customer places an order to buy something. (Selling)
Q: What are primary and secondary price lists?
A: Price list contains information on items and its prices. The pricing engine uses secondary price lists when it cannot determine the price for an item using the price list assigned to an order.
Q: Name some tables in shipping/order/move order/inventory?
A: WSH_DELIVERY_DETAILS,WSH_NEW_DELIVERIES, OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, MTL_SYTEM_ITEMS_B, MTL_MATERIAL_TRANSACTIONS
Q: How is move order generated?
A: When the order is pick released.
Q: What is ONT stands for?
A: ORDER MANAGEMENT
Q: What does Back ordered mean in OM?
A: An unfulfilled customer order due to non-existence of the ordered items in the Inventory.
Q: What are picking rules?
A: A user-defined set of criteria to define the priorities Order Management uses when picking items out of finished goods inventory to ship to a customer. Picking rules are defined in Oracle Inventory.

Q: What is drop ship in OM?
A: A method of fulfilling sales orders by selling products without handling, stocking,or delivering them. The selling company buys a product from a supplier and has the supplier ship the product directly to customers.
Q: What are Defaulting Rules?
A: While creating the order,you can define defaulting rules so that the default values of the fields pop up automatically instead of typing all information.
Q: What are validation templates?
A: A validation template names a condition and defines the semantics of how to validate that condition. Validation templates can be used in the processing constraints framework to specify the constraining conditions for a given constraint.
Q: What are different Order Types?
A: Order Only, Mixed, RMA

Q: Explain the Order Cycle?
A: Book the order
Pick Release
Pick Confirm
Ship Confirm
Close the order
Q: What is packing slip?
A: An external shipping document that is sent along with a shipment itemizing in detail the contents of that shipment.
Q: When an order cannot be deleted?
A: Order cannot be delted if the Order is Pick Confirmed.
Q: What is pick slip?
A: Pick slip is a shipping document that the pickers use to locate items in the warehouse/ inventory to ship for an order.

Q: What is Drop shipment?
A: Drop Shipment is a process where the customer places a purchase order on a company and this company instructs its supplier to directly ship the items to the customer.

AR Invoices with Rules

Invoices with Rules

Invoicing and accounting rules let you create invoices that span several accounting periods. Accounting rules determine the accounting period or periods in which the revenue distributions for an invoice line are recorded. Invoicing rules determine the accounting period in which the receivable amount is recorded. You can assign invoicing and accounting rules to transactions that you import into Receivables using AutoInvoice and to invoices that you create manually in the Transactions window.

Accounting Rules

Use accounting rules to determine revenue recognition schedules for your invoice lines. You can assign a different accounting rule to each invoice line. Accounting rules let you specify the number of periods and the percentage of the total revenue to recognize in each period. You can also specify whether the accounting rules are of Fixed or Variable Duration. Accounting rules of Fixed Duration span a predefined number of periods. Accouning rules of Variable Duration let you define the number of periods during invoice entry.

Invoicing Rules

Use invoicing rules to determine when to recognize your receivable for invoices that span more than one accounting period. You can only assign one invoicing rule to an invoice. Receivables provides the following invoicing rules:

    • Bill In Advance: Use this rule to recognize your receivable immediately (see Figure 1 - 19 below).
    • Bill In Arrears: Use this rule if you want to record the receivable at the end of the revenue recognition schedule (see Figure 1 - 20 below).
Attention: With Cash Basis Accounting, you only recognize revenue when payment is received. Invoices with rules are therefore not applicable for this method of accounting, as they are designed to distribute revenue over several periods before receipt of payment. If you import invoices into a cash basis accounting system, lines with associated invoicing and accounting rules will be rejected by AutoInvoice.

Account Sets

Account sets are templates used to create revenue and offset accounting distributions for individual invoice lines with accounting rules. These account sets enable you to split revenue for a line over one or more revenue or offset accounts. You can change account sets from period to period to meet your business requirements. For example, you have an invoice with revenue that you want to recognize over a twelve month period, and the cost center of one of the accounts changes during the twelve months. You can update the account sets to the new cost center account for all of the revenue distributions still to be created. AutoAccounting creates the initial revenue and offset account sets for your invoice.


Revenue Recognition

The Revenue Recognition program identifies all transactions with rules within a given period or range of GL dates and creates the revenue distributions for those transactions. The distributions are created for the current period only, using the rules associated with the transactions.

Tuesday, March 20, 2012

Order Management Basic Setup steps during Implementation

Step 1 Flexfields. (Required)
Step 2 Multiple Organizations. MOAC (Required)
Step 3 Locations (Required)
Step 4 Inventory Organizations. (Required)
Step 5 Location Associate with Inventory Organization (Required)
Step 6 Shipping Parameters. (Required)
Step 7 OM System Values – Item Validation Organization (Required)
Step 8 Invoicing Source. (Required)
Step 9 Order Management Transaction Types (Order and Line Types) (Required)
Step 10 Document Sequences (Order Numbering) (Required)
Step 11 Document Assignment (Order Numbering) (Required)
Step 12 Salespersons. (Required)
Step 13 Tax, Tax Categories. (Optional)
Step 14 Quick Codes. (Required)
Step 15 Workflow. (Required)
Step 16 Define Customer Profile Class (Required)
Step 17 Define Customer (Required)
Step 18 Define Customer Site (Required)
Step 19 Units of Measure. (Required)
Step 20 Item Information. (Required)
Step 21 Define Items & Assign to Organization. (Required)
Step 21 Pricing – Price list (Required) 
Step 22 Modifier. (Optional) 
Step 23 Qualifier. (Optional) 
Step 24 Document set. (Optional) 
Step 25 Formula – Dynamic / Static. (Optional) 
Step 26 Processing Constraints (Required)
Step 27 Defaulting Rules (Required)
Step 28 Credit Check Rule (Optional)
Step 29 Credit Holds / Release (Optional)
Step 30 Attachments (Optional)
Step 31 Freight Charges and Carriers (Required)
Step 32 Start Workflow Background Process (Optional)
Step 33 Grands and Role (Required)
Step 34 Shipping Network (Required)
Step 35 Item Cross References (Optional)
Step 36 Sourcing (Optional)
Step 37 Request set OM - AR Porting
Step 38 Configurations. (Required)
Step 39 Order Import Sources. (Required)
Step 40 Profile Options. (Required)