PO Interface Tables

PO_HEADERS_INTERFACE is used to import Purchase Order's Header Level Information

PO_LINES_INTERFACE is used to import Purchase order's line level information.

PO_DISTRIBUTIONS_INTERFACE is used to import Distribution Level Information

PO_REQUISITIONS_INTERFACE_ALL used to import requisition's information from other applications/Modules.

PO_REQ_DIST_INTERFACE_ALL: used to import requisition's Distribution  information from other applications/Modules.

RCV_HEADERS_INTERFACE is the interface table that stores receiving header information.

RCV_LOTS_INTERFACE : this table stores temporary lot number transaction records for a parent record in the RCV_TRANSACTIONS_INTERFACE table.

RCV_TRANSACTIONS_INTERFACE : stores information about receiving transactions that are waiting to be processed by the receiving transaction processor.

Thanks
Mandeep

Read More»

Frequently Asked Questions for Autocreate Purchase Orders

Does Autocreate copy descriptive flexfield attributes from the requisition to the created document?

No - if you have Descriptive Flexfields (DFF) set up against the Requisition at Header, Line and
Distribution level, after running Autocreate you will find that only the Distribution DFF Attributes are copied across to the PO Distribution.

This is expected behaviour, because the Distribution is the first level at which a one-to-one relationship between the Requisition and Purchase Order data can be guaranteed.  (Multiple Requisition Headers and Lines can be summarized into one PO Header and one PO Line).

Please be aware also that the Distribution DFF Attributes are simply copied from the Requisition to the PO - that is to say, the Flexfield API code is not invoked.  This means that if an Attribute on the Requisition side is empty but the corresponding Attribute on the PO side is defined as 'Mandatory',  after Autocreate the mandatory Attribute on the PO Distribution will be empty, but no error or warning will have been reported.

Does Autocreate copy Notes from the requisition to the document you are creating?

Yes, Notes are copied from the requisition lines and the corresponding requisition header.

What are the columns on which Autocreate combines multiple requisition lines into a single document line?

For purchase order, Purchasing combines the quantities of all requisition lines that have the same item, item revision, line type, transaction reason, and unit of measure onto a single document line. For RFQs, quantities of all requisition lines that have the same item, revision, and line type are combined.

What price becomes the actual price in the case where multiple requisition lines with different prices are combined to a single PO line?

The lowest unit price from the combined requisition lines becomes the actual price of the purchase order line.

What are the columns based on which Shipping information is combined by Autocreate?

For purchase orders and releases, Purchasing combines shipment information only if the requisition lines have the same need-by date, ship-to location, organization, Accrual type (period-end or on-line) and shipment type .

Does Autocreate add to an existing PO shipment that has been encumbered?

Purchasing does not add to an existing purchase order shipment if that shipment has been encumbered even though all the grouping columns necessary to combine shipping information are there.

What can be done to open the created document directly once Autocreate is done successfully?

Set the profile option PO: Display the autocreated Document to Yes, Purchasing displays the Purchase Orders, Releases, or RFQ window, as appropriate, after creating your document lines.

Can requisition line with item number and without item number [one time item] be combined to single document line in Autocreate?

If you want to combine two requisition lines for the same item, one with an item number and one without, you have to manually autocreate the document and use Modify on the Tools menu to add the predefined item to the requisition line for the one-time item.
Note: You cannot use Modify with outside processing items or if you are using encumbrance or budgetary control.

Can you autocreate a release if the description of the requisition created in PO is different of the description of the Blanket?

No, If we do not choose an item, that is if the requisition and blanket are created with one time/expense items the autocreate process tries to match the descriptions as item id's are null. The only differentiating factor in one time items (item id null) is the description.

How do you prevent Autocreate from seeing requisitions from another organization?

Requisitions and Purchase Orders are not organization specific. If you do not want to be able to see or access requisitions across different organizations, then you need to set up different operating units with different responsibilities tied to each one.

Can you autocreate from a quotation and tie the PO to the associated quotation and requisition?

Yes, you can autocreate from a Quotation.

Navigation:
1. Create and approve a requisition.
2. Go to the AutoCreate Screen, chose the requisition form the pool of approved requisitions.
3. Change the Document Type field to RFQ and click the automatic button.
4. The RFQ is created and appears on the screen.
5. Enter the required fields on the RFQ (quote affectivity), click on the Supplier button and choose the list of suppliers.
Change status to active and save.
6. To enter the vendor responses a Quote must be created.
Go to the RFQ screen and query up the RFQ you just created.
Click Special on the Tool bar and choose Copy Document.
This will create your quotation.
7. Go to the Quotation screen and query up the new quotation and enter
the price break information. Change the description (if PO attribute is set to allow the description to be changed).
8. Approve the quotation.
9. AutoCreate the PO from the requisition.
Delete the description if the quote has a description different than the requisition
Click on the catalog button - Receive message
Your can update only the price for the saved record.
Open the Catalog to select price only
Click YES
10. Select the quote.
11. You will now have both the requisition and quote tied to the PO.

Where does the 'note to buyer' show on an autocreated PO?

On the AutoCreate form, go to the Folder menu and choose Show Field. Select Note to Buyer and click OK. The field will now be displayed.
If you would like this field to be displayed every time you use autocreate, go to Folder -> Save As... Give the folder a name and check the Open as Default box.

Does the supplier name from a requisition get carried over to an autocreated purchase order?

The standard functionality is that if the requisition has a the "suggested supplier name" field populated, it would carry over to the autocreated PO. The "suggested supplier name" field will only carry to the autocreated PO if it was selected from the list of values on the requisition. If it is typed in manually, it will not carry over.

What causes the APP-14090 error when autocreating a requisition?

There are several things that must be performed to address this issue:

* Profile Option in MRP must be set as follows:
- MRP: Sourcing Rule Category Set value must be set to Purchasing in the Purchasing application.

* AutoCreate Blanket PO
- Revisions do not default for Items when autocreating Blanket PO and the Item Revision # must be entered.
- The Item Revision number on the requisition must match the Item Revision number on the PO.

* Navigate: Setup -->Organization -->Financial Options; and in the Alternate Region ENCUMBRANCE, verify if the REQUISITION ENCUMBRANCE checkbox is checked.

* In the Sys Admin Responsibility navigate to:
Profiles=> query for the Profile Option PO: AUTOCREATE GL DATE.

If using the Encumbrance for Requisitions, then this Profile Option can be set to either AUTOCREATE DATE or REQUISITION GL DATE. If not using Encumbrance, then you may set it to NULL. This will solve the problem.
The Profile Option PO: AUTOCREATE GL DATE is applicable only if you are using Encumbrance for Requisitions.

How do you autocreate a requisition with a document type as blanket release when requisitions were imported from a 3rd party system?

Ensure the line types selected for Requisitions are appropriate. You need to have Requisition Line types and PO Line types correctly associated. Rerun the process and verify that the system does not error out.
Submit the request for requisition import and use the AutoCreate window to create document with type as Blanket Release against the requisition.

Navigation:
Purchasing -> Reports -> Submit a request for Requisition Import
Purchasing -> AutoCreate

How do you autocreate MRP generated requisitions to a blanket purchase order?

First initiate the Release Purchase Requisitions from the Planners Workbench.

Navigation:
Material Planning -> MRP -> Workbench

Second, in the Purchasing Responsibility, AutoCreate the requisition to a Blanket PO.
Navigation: AutoCreate

For Autocreate to find these requisition lines from MRP, the Blanket PO line type must be set to Goods because the MRP Purchase Requisition is always created with a line type of Goods. The reason that MRP uses the line type of Goods is because Goods is seeded data and because the MRP Planner Workbench uses MRPPRELB.pls to insert a record into the PO_REQUISITION_INTERFACE table.

Can you autocreate more than one standard PO in one autocreate session?

Yes,

1. Find the requisition lines to be autocreated.
2. Choose a line.
3. Autocreate the purchases order using the automatic button.
4. Do not leave the requisition lines screen.
5. Choose a different line.
6. Try to autocreate another standard purchase order by clicking the automatic button.
7. The system gives the message: app-14090: no requisition lines were autocreated.

Try to autocreate, but the system hangs, how to cancel the requisition that are locked?

Check if there is a lock on the PO related tables.

Select object_id, session_id, oracle_username, os_user_name,Process, locked_mode

From sys.v_$locked_object;

Select a.object_name, b.oracle_username

From all_objects a, v$locked_object b

Where a.object_id = b.object_id

And a.object_name like 'po%';

If you have any records returned, you have a lock. To disable the lock, kill the session. Regenerating the form and bouncing the database will unlock all the objects.

What is the package or procedure that stores the autocreate process?

POXBWP1B.pls - autocreate po package body.
Description: this package contains all the functions to create purchase orders, releases and rfq's from data stored in the po_headers_interface, po_lines_interface and po_distributions_interface tables. When a user selects a line to be autocreated, it loads the above interface tables. At that point the functions which are part of this package are called and move to create the req line into a release or purchase order.

What does the grouping method 'Default' indicate in the autocreate form?

With the grouping method 'default' requisition lines for the same item, revision, line type, unit of measure, and transaction reason are combined into individual purchase order lines; and requisition lines for the same item, revision, and line type are combined into individual rfq lines.

There are two new profiles added to control the requisition line grouping using autocreate. :-

PO: Use Need-by Date for Default Autocreate grouping
PO:  Use Ship-To Organization and Locationfor Default Autocreate grouping 

Requisition lines with different need by dates or ship to information will be autocreated into two PO lines with one shipment each if the corresponding profile is set to 'Yes' or if it is unset.

If the profile is set to 'No', Requisition lines with different need by dates or ship to information will be autocreated into a single line with multiple shipments and if there is any source document on the PO line the pricing will be determined using the ship to and need by information from the first shipment.

I autocreated a PO with two lines. When I go to the purchase order entry screen and query the PO, instead of showing the lines created, it only shows a new line with number 3. Why?

Make sure Inventory organization field is populated in Financial Options.

Source : Oracle Metalink R11i/12: PO: FAQ: Autocreate Purchase Orders (Doc ID 223919.1)

Read More»

Requisition Import FAQs

What profile options affect the requisition import process?

If importing requisitions from Inventory, input a value for the profile option INV: Minmax Reorder Approval. This profile option will indicate the status of requisitions created by the Minmax planning report. Inventory predefines a value of Approved for this profile option. If you choose Incomplete, you can load requisitions as unapproved and use the document approval functionality in Oracle Purchasing. This profile option is updateable at all levels.

The profile 'INV: Purchasing by Revision' profile is used by Inventory to determine if the item revision needs to be populated while loading the Requisition Interface Tables. When using sourcing, the releases will not be created if the blanket purchase order has the item revision and the item in the interface table does not have it populated. If you set the profile option to Yes, the latest revision information from item revisions appears in the purchase order requisition for revision controlled and non- revision controlled items. If you set the profile option to No, the revision field in purchase order requisition is blank. This profile option is updateable at the site level only.

If importing requisitions from MRP, input a value for the profile option MRP: Purchasing By Revision. This profile option is important if you are using multiple revisions per item and using sourcing rules to create purchase orders or releases. This profile option indicates whether or not to pass on the item revision to the purchase requisition.

Set the profile PO: Release During ReqImport to create releases each time you run the Requisition Import process. For example, when you implement planned orders as requisitions in the MRP Planner Workbench, you can automatically create the releases at the same time you create the requisitions. The choices for this profile are Yes or No. If the profile is set to Yes and all sourcing rule information is properly set up, then blanket releases will be created via the Create Releases process. If the profile is set to No, the Create Releases process will not run at the completion of Requisition Import and all releases will have to be created manually via Auto Create.

Error Records

What methods are available in the application to resolve errored records in the PO_INTERFACE_ERRORS table?

Oracle Purchasing provides the Requisition Import Exceptions Report, which can be used to diagnose problems with the records, which have currently errored out in the PO_REQUISITIONS_INTERFACE_ALL table. To run the report, follow these steps:

1. Using Purchasing responsibility, navigate to Reports->Run
2. Select the Requisition Import Exceptions Report

There is a parameter titled 'Delete Exceptions'. If this is populated with 'Yes', then all records in the PO_REQUISITIONS_INTERFACE_ALL table with a status of 'ERROR' and the corresponding records in the PO_INTERFACE_ERRORS will be deleted when the report is executed. You can also restrict the deleted records by selecting the Batch_id and the Interface Source code.

If the parameter is set to No, then you will see the errors from the report and be able to manually fix the data in the table, if so desired; then, upon completion of the data correction, run Requisition Import again to process the modified rows in the interface table.

Grouping

What are the grouping options for imported requisitions?

The requisition import process has a group by parameter. Use this feature to determine how requisition lines are grouped on the requisitions you create. The default in this field is set in the Purchasing Options window. Choose one of the following options:

• All: Group all requisition lines on one requisition
• Buyer: Group requisition lines for each buyer name on a separate requisition
• Category: Group requisition lines for each purchasing category on a separate requisition
• Item: Group requisition lines for each item on a separate requisition
• Location: Group requisition lines for each location on a separate requisition
• Supplier: Group requisition lines for each supplier name on a separate Requisition

To define a default in the Purchasing Options form, follow these steps:

1. Using Purchasing responsibility, navigate to Setup-> Organizations-> Purchasing Options
2. Enter a default value for the 'Requisition Import Group-By' field (under Document Defaults)
3. Save changes

The Requisition Import process will first look at the group by parameter selected when the process is submitted; should this parameter be left blank, the system will then look to the group by field residing in the Purchasing Options form.

How does Requisition Import determine the grouping method for incoming pieces of data?

The process groups requisitions following this order:

1. Assign values to REQUISITION_LINE_ID and REQ_DISTRIBUTION_ID
2. Group requisitions based on the REQ_NUMBER_SEGMENT1 column. All requisitions with the same NOT NULL REQ_NUMBER_SEGMENT1 are assigned the same REQUISITION_HEADER_ID
3. Group requisitions based on the GROUP_CODE column. All requisitions with the same value in the GROUP_CODE column are assigned the same REQUISITION_HEADER_ID.
4. Group requisitions based on the GROUP_BY parameter, which takes on the value of DEFAULT_GROUP_BY if not provided. GROUP_BY could be one of the following: BUYER, CATEGORY, ITEM, VENDOR, LOCATION or ALL.

How can I achieve creating 10 requisitions for 10 lines populated into the interface table, instead of 1 req. with 10 lines?

Requisitions are grouped according to the selection chosen by the initiator of the process, based on the parameter of group by. When you select the value 'All', all requisition lines will be on the same requisition. Any other value will group the lines on requisitions based on the value selected.

How can I achieve grouping by vendors?

First check to see if any records in PO_REQUISITIONS_INTERFACE_ALL have a value for the GROUP_CODE or REQ_NUMBER_SEGMENT1 columns. If there is no value in either of these two columns, then the Requisition Import Program uses the group by that you selected (i.e Supplier) when you ran the process.

Incomplete vs Approved Requisitions

Is it possible to have all requisitions created from MRP to be imported with a status of INCOMPLETE?

It is not possible to have Requisitions created from MRP imported into the Oracle Purchasing application with a status of INCOMPLETE. The MRP Application inserts all data into the PO_REQUISITIONS_INTERFACE_ALL table with an AUTHORIZATION_STATUS of APPROVED. Therefore, when the Requisition Import program runs, all requisition lines from MRP are created with a Status of APPROVED. An enhancement request Bug 1354590 is logged requesting the ability to import incomplete requisitions coming from MRP.

Is it possible to have all requisitions created from Inventory - Min-Max Planning to be imported with a status of INCOMPLETE?

Yes, it is possible to have all requisitions created from Min-Max Planning with a status of Incomplete. If the desired outcome is Min-Max requisitions showing a status of Incomplete, it is necessary to set the profile option: INV: MinMax Reorder Approval to Incomplete. Conversely, if this profile option is set to Approved, all requisitions imported from Min-Max Planning will be imported with an approval status based on the approval authority of the user initiating the Requisition Import process.

How can automatically approve the requisitions I am creating?

There are two ways of doing this:

1. You can populate records in the Interface table with status as Approved. In this case the Approval process is not called after creating the requisition.
2. If you want the requisitions created to go through the approval process then you have to set Requisition Import Parameter 'Initiate Approval after Reqimport' to 'Yes' when Launching the Requisition Import Concurrent Program.

• Yes: The PO Requisition Approval workflow is launched automatically for requisitions imported with a status of Pre-Approved or Incomplete.
• No: The PO Requisition Approval workflow is not automatically launched for Pre-Approved or Incomplete requisitions. You can submit these to the approval process later, when you select the Approve button on the requisition.

For the Requisition to be automatically Approved, the APPROVER_ID value from PO_REQUISITIONS_INTERFACE_ALL must have authority to approve the requisition. If that user does not have approval authority, then the requisition will be in status = In Process and forwarded up that user's Approval Hierarchy.

General

How is the list of values derived for the Import Source column within the requisition import report parameters window?

The list of values for the Import Source parameter drives off of the records, which currently reside in the PO_REQUISITIONS_INTERFACE_ALL table. Within this table is the column, INTERFACE_SOURCE_CODE, which contains the source from where the data was created and in turn is the same value that shows in the list of values. Example: Say that there are currently 20 rows In PO_REQUISITIONS_INTERFACE_ALL.Ten of the rows have an INTERFACE_SOURCE_CODE of 'INV', and the other ten rows have an INTERFACE_SOURCE_CODE value of 'WIP'. When the user then goes to view the list of values, it will show 'INV' and 'WIP' in the list, as those are the only sources currently loaded and unprocessed in the interface table.

Why is the requisition import concurrent request status set to normal even if the number of interface lines in error is greater than zero?

This is the current functionality of the application. An enhancement request Bug 201358 is logged requesting the program to end with warning when at least one record fails.

Can requisition import handle multiple currencies?

Requisition Import is capable of handling multiple currencies, provided that all rate types and currency conversions have been defined.

Can requisition import handle multiple distributions?

Requisition Import can handle multiple distributions.

Is requisition import organization-specific?

Requisition Import is operating unit-specific. Within the PO_REQUISITIONS_INTERFACE_ALL table lies the column ORG_ID.Upon Initiating the Requisition Import program, the profile 'MO: Operating Unit' is queried to derive the value of ORG_ID tied to the login running the program. Then the Requisition Import program executes, all records in the interface table which are the same as the organization listed in the 'MO: Operating Unit' profile will be processed. If you don't see any valid Import source when you launch Reqimport but if you had already populated the Interface table then you have to check the org_id Column you populated. this org_id will be your operating unit tied to your Applications log-in responsibility. If the org_id is NULL then you can see you record in the Import Source.

Here is a script to assist:

select hr.name
from hr_all_organization_units hr,
po_requisitions_interface_all pri
where
hr.organization_id = pri.org_id and
pri.interface_source_code = '&source'
order by pri.creation_date desc;

When using encumbrance, is there any validation on the GL Date, ensuring the appropriate periods are open?

The Requisition Import program will perform date integrity checks against the date value in the PO_REQUISITIONS_INTERFACE_ALL.GL_DATE field. This field GL_DATE, is reserved for systems operating under Encumbrance Accounting constraints. It is necessary to ensure that the encumbrance year is opened for the GL_DATE being specified.

How does requisition import process generate accounts?

It can be either one of two methods for accounts to be generated:
1. By a valid CCID or
2. By a valid combination of account segments.
Requisition import does not use the account generator process. The process validates the charge_account_id or the combination of account segments which are populated in the interface table. This is the existing functionality. An enhancement request Bug 2245333 is logged to request the ability for the requisition import to use the same logic used in the requisition form.

When I load the Requisition Interface and create Requisitions it always does sourcing. How can I stop sourcing from happening? 

You have to set the autosource_flag in the Requisition interface to 'N' to avoid vendor Sourcing 

How can I avoid sourcing from overriding my vendor information?

You have to set the autosource_flag to 'P' for partial sourcing.

Does the requisition import allow note to vendor to be imported on requisitions?

The requisition import does not support the note to vendor field at this time.

How to Import the Requisition ordered by Line Number ?

Per standard functionality the line number is a sequence number starting from 1 for records having the same requisition header id order by item_description and quantity. In other words, the po_requisition_lines table is ordered by item_description and quantity for the same header_id and then the line_num is updated with a counter that increments by 1. It is not possible to populate line number in the interface table. The following enhancement requests are logged requesting the ability to sort the lines: Enhancement Request < Bug 3906591> and Enhancement Request Bug 4205941.

Source : Oracle Metalink : Frequently Asked Questions: Requisition Import (Doc ID 224025.1)

Read More»

Order Management Data Flow

Order Management Data Flow

Thanks

Mandeep

------------------------------------------------------------------------------------------------------------------------------------------------------------------

Please share this knowledge with your friends and subscribe at our blog for more updates. If you have any queries, please participate in our Forum or by leaving your comments below.
------------------------------------------------------------------------------------------------------------------------------------------------------------------

Read More»

Order Management Interview Questions

Following questions I have came across on various blogs and sites and posted for your reference here also

Q: What are the Process Constraints?

A: Processing Constraints allow Order Management users the ability to allow or disallow changes to various Order Management documents like Sales order, Sales agreement etc to avoid data inconsistencies and audit problems. You can access it at OM>setup>Rules>security>Processing Constraints

Q: What is a Pick Slip Report?
A: Pick slip report is generated after release sales order and it is used by warehouse personnel to pick item from various inventories for shipping them to a customer.

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, it generate a move order to to pick material from various subinventories. You can transact it manually or automatically based on setting in Release orders.

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 which Order Management uses when picking items out of finished goods inventory to ship to a customer. Picking rules are defined in Oracle Inventory. If WMS installed then you can define user generated Picking rules and strategies.

Q: What is drop ship in OM?
A: Its a method of directly shipping product from your supplier to your 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: If the Order is Pick Confirmed.


Thanks
Mandeep
------------------------------------------------------------------------------------------------------------------------------------------------------------------
Please share this knowledge with your friends and subscribe at our blog for more updates. If you have any queries, please participate in our Forum or by leaving your comments below.
------------------------------------------------------------------------------------------------------------------------------------------------------------------

Read More»

Order Management and Shipping Concepts and interview Questions

What is a Delivery?

A delivery consist of delivery lines that are scheduled to be shipped to customer ship to location. You can manually or automatically create a delivery and group lines. A delivery can have delivery lines from multiple sales order.

You can control Auto create Delivery in Shipping Parameters Pick Release tab and Delivery Grouping criteria in delivery tab.

What is a Pick Release?

A Pick Release is to release eligible delivery lines for picking material to full a customer order. When you pick release, system find eligible delivery lines to be released for picking based on release rules and create a pick slip report which then handed over to operator for picking

Picking rules: Specify which material to be picked based on picking rules defined i n oracle inventory. This is used to help system determines Pick from Sub inventory/Locator.

Release sequence Rules: This specify the order in which eligible delivery lines are released on shop floor. This is based on the following:

• Order number
• Outstanding invoice value
• Scheduled date
• Departure date
• Shipment priority

What are the methods of Pick Release?

• Online Mode: It pick Release immediately without waiting for the order to process through the concurrent manager. You can see this option when releasing sales order from release sales order form. 
• Concurrent : This enable you to run pick release in background along with other request.
• Standard Report Submission: SRS you call it. You can schedule this program and it runs  in the background several time in a day.
• Shipping Transaction Window: You can use action button in shipping transaction form to pick release.

What are Trips? (refer : OracleUG)

A trip is an instance of a specific freight carrier departing from a particular location containing deliveries.

A trip is carrier specific and contains at least two stops such as a stop to pick up goods and another stop to drop off goods, and may include intermediate stops. Trips can be created automatically or manually.

Automatic

If your shipping process does not require advanced planning, you may prefer to automatically create trips:

Auto-creating a trip for a delivery: You can find the delivery you want to ship, and auto-create a trip and related trip stops.

Auto-creating a trip for containers and lines: You can find the lines and containers you want to ship and auto-create a trip which creates a trip, related deliveries, and trip stops.

Manual

During transportation planning, you can manually create a trip and later assign delivery lines or find the delivery lines and create a trip. For example, for a regular trip scheduled to depart every Friday, you can manually set up a trip ahead of time and then assign delivery lines. When you manually create a trip, you can manually assign stops, deliveries, and delivery lines to that trip.

What is Item Cross Reference?

Item cross reference is used to link our item with supplier or customer item. 

What is a Modifier and what are different types of Modifiers?

A modifier is used to adjust the price on sales order lines. It includes adjustments, benefits, Freight and special charges. Examples : Discount List, Freight and Special Charges, Promotion surcharge.

What are defaulting Rules?

Defaulting rules helps us to automatically default some information from various sources there by reducing the effort in entering some of the information in order management. For example when you enter a Customer on sales order Ship to, Bill To, Price list etch automatically defaults form customer level setting. Deafuling rules navigation is OM>setup>Rules>Defaulting

Customer sites are controlled at what level?

Customer sites are controlled at operating unit level where as customer are at Business Group Level

What is ATP and why we use it?

ATP Stands for Available to Promise. Its is a business function which can be used to find out the available quantity when customer give a request.

ATP=On Hand + Supply - Demand

On hand: Netable on Hand quantity

Supply : Planned Order, Scheduled Receipts, Discrete Jobs

Demand : Sales Orders, Discrete Jobs

You can refer below link. there is excellent slide by apps learn http://applearn.blogspot.in/2009/03/available-to-promise-atp-in-oracle.html

What is an RMA?

RMA stands for Return Material Authorization. It used to receive material back from customer if ther eis any defect. You can configure approvals for RMA.

Whats is a credit check functionality in Oracle Order Management?

Please refer http://mandeeporacle.blogspot.com/2014/03/credit-check-functionality-in-order.html

Whats is Over Picking?

Over picking is used to pick more than what is ordered and you can define over pick tolerances at item level in order management tab or in profile option OM: Over Shipment Tolerance

How to Ship in fastest way?

Check the Autodetail option in Pick Release.  Set the profile INV: Detail Serial Numbers to ‘Yes’. Inventory will then suggest serial numbers during the Detailing process.  Do not check the Pick Confirmation Required flag in the Organization Parameters form. there by avoiding picking conformation step

Can you update the Sales Order once it is Booked?

It depends on processing constraints set up in Order Management. Some of them are seeded and can not be modified but some you can configure on your own.

What are the prerequisites of the Sales Order?

You need to define Customers, Price List and Transaction Types.

What are different order types?

• Order
• Return
• Mixed

Additional reading - > 6 benefits of automating procurement

https://www.fairmarkit.com/blog/6-benefits-of-automating-procurement

Thanks

Mandeep

------------------------------------------------------------------------------------------------------------------------------------------------------------------
Please share this knowledge with your friends and subscribe at our blog for more updates. If you have any queries, please participate in our Forum or by leaving your comments below.
------------------------------------------------------------------------------------------------------------------------------------------------------------------

Read More»

Oracle Purchasing Interview Question

Oracle Purchasing Interview Question (Source http://www.brainbeez.com/)

---------------------------------------------------

  

1) What are the different purchase order types in Oracle Purchasing?

There are 4 type of PO. Standard, Planned, Blanket and Contract. Below is the difference between them

Source : Metalink

2) Can a requisition be encumbered?

Yes, enable requisition encumbrance from PO>setup>organization> Financial options

3) What is the difference between a scheduled release and blanket release?

A schedule release is created against Planned PO and Blanket release against the Blanket PO

4) On a contract purchase agreement qty can be specified?

No, You cannot enter lines of Contract PO

5) On a blanket purchase agreement qty can be specified?

No, Quantity field is grey out.

6) Quotation analysis is an automated process in oracle purchasing?

7) Vendor analysis can be performed in oracle purchasing?

8) How many types of purchase requisitions are there?

2 Types : Purchase and Internal

9) Rfq's can be created based on unapproved purchase requisition?

  

Yes you can auto create a RFQ from an unapproved requisition

10)During autocreate process from req to rfq supplier list specification is mandatory?

NO 

11)Requisitions can be imported into the system from legacy softwares?

Yes, you can import them in PO_REQUISITIONS_INTERFACE_ALL

12)What is the requisition interface table name?

PO_REQUISITIONS_INTERFACE_ALL

13)Is workflow integrated  with oracle purchasing?

Yes

14)What workflow process is executed whenever the purchasing documents are approved?

PO Approval Top Process

15)Can you import purchase orders ? if yes what is the program name?

Yes, Import Standard Purchase Orders program

16)Purchase orders can be created without base quotation documents?

Yes, you can manually enter PO

17)How many types of quotations are there?

Three Types. Standard, Bid and Catalog

18)Can a standard purchase order be associated with contract purchase agreement ?

Yes, against Contract Po you make Standard PO 

19)Scheduled releases are issued against contract purchase agreements?

No, Standard PO issued against Contract Agreement. 

20)Blanket releases are recorded against planned purchase orders?

No Scheduled releases recorded against Planned PO

21)Multiple shipment lines can be existing for a single purchase order line?

Yes, Very True 

22)Quantity received against po is updated in the po document?

Yes, you can see it from PO summary form

23)Cancellation of po cancels the requisition?

Depends on Option selected in Purchasing options.

24)Releases can be encumebred?

I don't Know. You tell me? Post a comment below

25)Where do you set the encumbrance options in oracle purchasing system?

Financial Options

26)Oracle purchasing system can be run without setting up the purchasing options?

No, that is the First thing you should to setup when setting up purchasing

27)A purchase order can be based on multiple quotations?

Yes

28)A rfq can be based on multiple requisition lines?

Yes

29)A purchase order distribution can be based on multiple shipment lines?

Each shipment line has its own distribution 

30)Receiving controls can be specified in requisition document?

No 

31)How many types of receipt routings are available?

Three. Standard, Direct and inspection Required

32)Goods receipt information is recorded in oracle purchasing system?

Inventory and purchasing both

33)Through workflow purchase orders can be created?

Yes 

34)Purchased order revisions can be recorded?

Yes

35)What are the tables involved in for storing the po information?

PO_headers_all

PO_lines_all

PO_line_locations_all

PO_distributions_all

PO_releases_all

36)Supplier lists must be mandatorily setup for purchasing system?

37)Purchasing documents can be updated once they are approved?

Yes, Revision will be created after that

38)Supplier database is owned by oracle payables?

Yes, True in R12

39)Is it possible to reverse a purchase order line ?

No. You can cancel it

40)What is ASL?

Approved Supplier list 

41)What is ASN?

 Advance Shipment Notice

42)What is the copy document feature?

Used to create a new doc by duplicating/copy from another doc

43)What are the different statuses for the purchasing periods?

Open/Close/Permanently Close 

44)What are the tables for supplier database?

AP_SUPPLIERS                 Replaced PO_VENDORS table.

AP_SUPPLIER_SITES_ALL

IBY_EXTERNAL_PAYEES_ALL Stores Payee(supplier) information.

HZ_PARTIES                         Stores Party data of suppliers.

HZ_PARTY_SITES         Stores Party site data of supplier sites.

45)Oracle purchasing owns the job and position flexfields?

HRMS owns following key flex fields 

Grade flexfield, Job flexfield, Position flexfield, People Group flexfield

46)Employees information is maintained in oracle purchasing system?

No, Its maintained in HRMS

47)To approve a purchase order the user must be a buyer?

Not Necessary

47)Employees must be assigned to application user definitions in system administration?

Yes

48)Supplier number generation by default is auotmatic?

You can set it in Payables.

49)Where do you set the emloyee numbering options?

While defining Business Group Information 

50)Inventory organisation must be setup to run purchasing module?

Yes

Thanks

Mandeep Kumar

Do Visit Our Quiz section

Read More»