Release 12.1.1

New Tables Added --> View new-1211-tables-xls

New Cols Added --> View new-1211-cols-to-existing-tables-xls

Oracle Purchasing

Receiving Process
ASN 856 -->
RCV_TRANSACTIONS_INTERFACE (PROCESSING_STATUS_CODE := 'PENDING'; TRANSACTION_STATUS_CODE := 'PENDING')
--> Receiving Transaction Processor

Receiving Open Interface is used for processing receipt data & ASNs.Load the receipt data into the RCV_HEADERS_INTERFACE and RCV_TRANSACTIONS_INTERFACE tables. Launch Receiving Open Interface program. The pre-processor selects unprocessed rows in the RCV_HEADERS_INTERFACE table with a PROCESSING_STATUS_CODE of ’PENDING’ and a VALIDATION_FLAG of ’Y’.

APIs in Purchasing

PO_DOCUMENT_CONTROL_PUB - for the cancellation of a PO

PO_DOCUMENT_CONTROL_PUB.CONTROL_DOCUMENT
(p_api_version => 1.0
p_init_msg_list => FND_API.G_TRUE
p_commit => FND_API.G_TRUE
x_return_status OUT NOCOPY VARCHAR2,
p_doc_type => 'PO'
p_doc_subtype => 'STANDARD'
p_doc_id => po_header_id
p_doc_num => PO_HEADERS_ALL.segment1
p_release_id => null
p_release_num => null
p_doc_line_id => PO_LINES_ALL.po_line_id or null
p_doc_line_num => PO_LINES_ALL.line_num or null
p_doc_line_loc_id => PO_LINE_LOCATIONS_ALL.line_location_id or null
p_doc_shipment_num => PO_LINE_LOCATIONS_ALL.shipment_num or null
p_action => 'CANCEL'
p_action_date => sysdate
p_cancel_reason => 'cancelling'
p_cancel_reqs_flag => 'Y'
p_print_flag => NULL
p_note_to_vendor => NULL
p_use_gldate => 'P'
p_org_id => ln_org_id
);

KNOWN ISSUES:

1. Issue
   If during the insertion of the receipt records into the interface tables, a scheduled Receiving Transaction Processor (RTP) concurrent program is running this will cause some receipts to fail.
   What happens is that the RTP will split the shipment, causing the second split to return the error of “Column Receipt_num is a mandatory field for this transaction.”
   
   Solution
   When inserting the ASN receipts records into the RCV_HEADERS_INTERFACE and RCV_TRANSACTIONS_INTERFACE tables, set the processing_status_code and transaction_status_code to PREPENDING. By setting the status to PREPENDING instead of PENDING this means regardless if the scheduled Receiving Transaction Processor is running, the records won’t be selected. Once all records are inserted, perform an update to set the values to PENDING. This way all records are processed within the one batch.
   

Tables Info - Purchasing

PO_HEADERS_ALL
PO_LINES_ALL
PO_LINE_LOCATIONS_ALL
PO_DISTRIBUTIONS_ARCHIVE_ALL

PO_RELEASES_ALL

PO_CHANGE_REQUESTS

• Document_Header_ID (PO_Header_ID)

PO_HEADERS_ARCHIVE_ALL
PO_LINES_ARCHIVE_ALL
PO_LINE_LOCATIONS_ARCHIVE_ALL
PO_DISTRIBUTIONS_ARCHIVE_ALL
PO_RELEASES_ARCHIVE_ALL

PO_VENDORS

• Segment1 - Vendor number is unique

PO_VENDOR_CONTACTS

PO_VENDOR_SITES_ALL

PO_UNIQUE_IDENTIFIER_CONTROL

• Current_Max_Unique_Identifier
• Table_Name

RCV_SHIPMENT_HEADERS
RCV_TRANSACTIONS_INTERFACE

Interview Questions - Order Management

Q. What are primary and secondary price lists?
Every order is associated to a price list as each item on the order must have a price. A price list contains basic list information and one or more pricing lines, pricing attributes, qualifiers, and secondary price lists. The price list that is primarily associated to an order is termed as Primary price list. The pricing engine uses a Secondary Price list if it cannot determine the price of the item ordered in the Primary price list.
__________________________________________________________________________

Q. What are picking rules?
Picking rules define the sources and prioritization of sub inventories, lots, revisions and locators when the item is pick released by order management. They are user defined set of rules to define the priorities order management must use when picking items from finished goods inventory to ship to a customer.
__________________________________________________________________________

Q. Explain the Order Cycle?
1) Enter the Sales Order
2) Book the Sales Order(SO will not be processed until booked(Inventory confirmation))
3) Launch Pick Release & Generate Pickslip Report and print.
4) Allocate and transaction Move Order (creates reservations, determines the source and transfers the inventory into the staging areas)
5) Ship Confirm (with Shipping and Bill of Ladding documents) and interface the Invoice to AR & decrement Inventory.
6) Close stops and trips on confirmation of receipt at Customer’s location.
7) Run workflow background process for order cycle completion.
__________________________________________________________________________

Q. What are trips and stops?
A trip is carrier specific and represent a unique instance of that carrier leaving the warehouse with deliveries having atleast two stops and carrying atleast a BOL document for every delivery. A stop is a point along the route of a trip that is due for pick-up or drop off.
__________________________________________________________________________

Q. What is a delivery leg?
A delivery leg consists of two stops where the delivery is picked up and finally dropped off. A delivery leg will have a bill of lading receipt which lists the goods that were signed over to the carrier.
__________________________________________________________________________

Q. When will the delivery details be back ordered?
If there is no material in Inventory during the Pick Confirm process when Pick Release is launched, the delivery details will be back ordered. Further during the ship confirm process, part quantities can be staged and or back ordered based on the carrier condition.
__________________________________________________________________________

Q. What are ship sets and arrival sets?
Ship sets are a group of lines which our customer has requested to be shipped together on the same date & time from the same warehouse. Arrival sets are a group of lines which our customer wishes to arrive at their ship-to location at the same time.
__________________________________________________________________________

Q. What activities are performed during scheduling the order ?
1) Sales order lines ship and arrival dates are scheduled.
2) Reservation is placed if with in the res. Time fence.
3) Passes the demand to Inventory for consumption of the forecast.
4) Calculates the delivery lead time ship method set up by Inter location transit times.
__________________________________________________________________________

Q. Which item attributes will facilitate back to back ordering?
If Build in WIP and Assemble to Order attributes are enabled, the sales order will become eligible for create supplies, facilitating a back-to-back order.
__________________________________________________________________________

Q. What activity are completed when the Order entry line has a status “Awaiting Shipping”?
Awaiting shipping means that the sales order has undergone the workflow activities – Scheduling the line and create supplies and it is ready for release in shipping execution.
__________________________________________________________________________

Q. Which rules will be invoked when Pick Release is launched ?
Pick Release process will invoke Release rule, Release sequence rule and Pick Slip grouping rule. It will then allocate the material in Inventory using the Picking rule and generate pick slip grouping report for transaction of the material to the staging sub Inventory.
__________________________________________________________________________

Q. What will happen if we defer interface during ship confirm process ?
Inventory will not be interfaced and it will not get decremented. We have to explicitly run a trip stop SRS concurrent for interfacing to inventory, relieve the reservation and to update the order line status.
__________________________________________________________________________

Q. What activities are performed during ship confirm process ?) Inventory gets decremented & Reservation is relieved.
2) Non-pick confirmed items gets back ordered.
3) Depending upon carrier condition, part items may get shipped, back ordered, staged or transferred to Cycle count in a combination of any or all these activities.
4) If shippable is checked, ship confirm is a pre-requisite for Invoicing.
__________________________________________________________________________

Q. Can we associate delivery lines to a existing delivery ?
It is economical to associate delivery lines to the existing deliveries for utilizing the unused space ( weight ) of the carrier, provided all these lines have the trip stops as in an existing delivery.
__________________________________________________________________________

Q. Can we manually modify the price of a sales order line ?
No. The pricing engine apply suitable modifiers associated with qualifiers to a sales order line during the pricing phase activities of entering & booking and repricing.
__________________________________________________________________________

Q. When will the modifiers have incompatibility issues ?
For a given phase and for a given level of incompatibility, the pricing engine will encounter incompatibility of multiple modifiers. It will allow only one modifier for the above combination and the exclusion is processed in the below mentioned order, till the incompatibility is resolved.
1) One exclusive group is allowed for a given phase of pricing.
2) The best price offered by any of the incompatible modifier will be chosen.
3) Modifier having the lowest precedence number rules supremacy over the other.
__________________________________________________________________________

Q. Can we apply discounts and surcharges for a same sales order line?
Yes.
__________________________________________________________________________

Q. Is it mandatory to use defaulting rules ?
Defaulting rules simplify data entry and speed up order processing. It is not mandatory.
__________________________________________________________________________

Q. Can we book an order without entering any sales order lines ?
Sales order line entry is not mandatory for booking an order. It can be accomplished with no entry in the lines tabbed region.
__________________________________________________________________________

Q. Can we part cancel a sales order line quantity after interfacing to shipping ?
We can cancel a part of the sales order quantity by reducing the qty. in the lines region (with reason) before confirm shipment. The changes will reflect in the detail and its associated delivery in shipping. These changes will also be reflected in Purchasing and WIP if “Create Supplies” were effected during order entry process.
__________________________________________________________________________

Q. What should be done when sales order lines are closed but header is still in Booked status?
Verify the Sales order header workflow. It should be waiting at sales order line close.now navigate to Sysadmin>>workflow>>administer workflow>>status monitor on the new webpage enter the item type as OEOH and item key as the header workflow
__________________________________________________________________________

Q. What are the steps to define an order type and what are the mandatory requirements?
A:
__________________________________________________________________________

Q. What is the use of a picking rule?
When you pick release a sales order in Order Management module , Order Shipping Execution module (which is a part of Order Management) submits requests to Oracle Inventory module which uses the information given in picking rule to give priority to pick units of an items and then it generates pick lists for sales orders
__________________________________________________________________________

Q. From where is the sales order number pulled?
A:
__________________________________________________________________________

Q. What are possible reason for Interface trip stop to complete in Error?
A:
__________________________________________________________________________

Q. When scheduling the line got error "ATP Error Scheduling failed". How will you resolve?
A:
__________________________________________________________________________

Q. What to do when you get error message "Order header level sales credit must be equal to 100%"?
A:
__________________________________________________________________________

Q. How and where the components are added to a model item?
A:
__________________________________________________________________________

Q. When a line is at fulfilled step and the workflow is at apply Prepaymet. How can we progress the line to close?
A:
__________________________________________________________________________

Q. What happens when a sales order is booked. Explain the process
A:
__________________________________________________________________________

Q. What are the APIs used in Order Management?
OE_ORDER_PUB is the main API in OM. Using this API all data manipulation (Inserts, updates, deletes can be performed on a Sales Order and it's attributes. Besides these, certain other action requests such as applying holds, attachments, booking etc. can
__________________________________________________________________________

Q. After which stage can not cancel the order?
A:
__________________________________________________________________________

Oracle General Ledger

Things to Ponder:

• If you try to enter an unbalanced journal, Oracle GL will either reject the transaction or force the transaction to balance by posting the difference to a suspense account.
  

Oracle PIM

Oracle Product Information Management (also called Advanced Product Catalog) has three main product components:

1. PIM Data Hub
2. PIM Data Librarian
3. Product Data Synchronization for GDSN and UCCnet Services

Oracle PIM Data Hub , an enterprise data management solution that enables customers to centralize all product information from heterogeneous systems, creating a single product repository that can be leveraged across all functional departments.

PIM Data Librarian is a new product released in May'05, offers an easy-to-use HTML/Windows interfaces for creating, managing, consolidating, enriching and standardizing product information. Provides secure way to share product info within enterprise and with partners.

All business rules in PIM are based on one important concept - Primary Hierarchy which classify products in Primary Item Master Catalog.

Attributes & Attribute Groups

You can define upto 70 attributes per attribute group but there can be unlimited attribute groups.

Concurrent Programs in PIM:

• Bulkload Program For Spread Sheet Upload
• Item/Item Revision Implement Pending Changes Concurrent Program
• Import Catalog Items - Java Concurrent Program to Bulkload items from the interface table.
• Item Org Import - Item Organization Assignment Import
• Item People Import
• Purge Item People Interface Lines - Purge Program for Item People Interface Lines
• Item/Item Revision User-Defined Attributes Concurrent Program - For importing User Attributes for Items and Item Revisions
• EGO Item Import Batch Matching Concurrent Program - EGO Bulk matching engine of the item import process
• Purge Item Massupdate Temporary Tables - Mass update Temporary table purge program
• Optimize Item Catalog Text Index
• EGO Spreadsheet Java Concurrent Program - EGO Java Loader to Bulkload Item, BOM Attrs, User-Defined Attrs, UCCnet Attrs
• Item Catalog Text Index Build - Create/Rebuild Item Catalog Text Index
• EGO Setup Default Organization for User
• Catalog Categories Assignment Open Interface - Import Catalog Categories Assignments from the Open Interface table
• User-Defined Attribute Groups View (AGV) Compilation Executable

PL/SQL Errors

In PL/SQL, a warning or error condition is called an exception.

Some Predefined Exceptions

• VALUE_ERROR Exception is raised whenever PL/SQL runtime engine tries to execute a numeric FOR loop and either the low or high expression in the loop’s header evaluates to NULL. Use the COUNT method to ensure that the FOR loop is executed only when there is something in the collection. Here is the sample code:
  IF names_in.COUNT > 0 THEN
  FOR indx IN names_in.FIRST .. names_in.LAST
  
• ZERO_DIVIDE Exception - Program attempts to divide a number by zero.
  
• DUP_VAL_ON_INDEX Exception - Program attempts to store duplicate values in a database column that is constrained by a unique index.