Review Supplier Creation Error

Suppliers : Request Information Vs Request To Resubmit

Supplier External Registration

Oracle R12 Purchasing Introduction - 1

For Online Training on 
R12 SCM Functional
Fusion Procurement
Fusion SCM
Fusion Procure To Pay
Please Contact -
Gmail # rishitechnologies9@gmail.com
Cell # 9071883639

How to Find Requisition is Catalog or Non-Catalog

By using table po_requisition_lines_all we can find out Whether Requisition is Catalog or Non-Catalog

Field CATALOG_TYPE in po_requisition_lines_all should display the value CATALOG or NONCATALOG, By Using this we can decide the Requisition type - Catalog / Noncatalog

***************************************************************
For Online And Classroom Training on 
R12 SCM Functional
Fusion Procurement
Fusion SCM
Fusion Procure To Pay
Please Contact -
Gmail # rishitechnologies9@gmail.com
Cell # 9071883639

Flow Of Default Values in Purchasing

Oracle Procure to Pay Process

Oracle Procure to Pay Process

Demand

The procurement process generates and manages requests for the purchase of goods.  The demand for purchase items may be a one-time event or may recur in either predictable or random time intervals.

Source

The procurement sourcing process covers the business activities related to the search, qualification, and selection of suitable suppliers for requested goods and services.

Order

The procurement ordering process includes purchase order placement by the buying organization and purchase order execution by the supplying organization.

Receive

The receipt process acknowledges that a purchase order has been duly executed.  For orders of physical goods, it will typically include the receipt, inspection and delivery of the goods to inventory or to another designated location.  For orders of services, it will typically consist of a notification from the requester or the approving person that the service has been performed as agreed.

Invoice

The invoice process includes entering supplier and employee invoices.

Pay

The payment process consists of those activities involved in the payment for ordered goods and services.

Advance Shipment Notices (ASNs)

An Advance Shipment Notice (ASN) is transmitted via Electronic Data Interchange (EDI) from a supplier to let the receiving organization know that a shipment is coming. The ASN contains details including shipment date, time, and identification number; packing slip data; freight information; item detail including cumulative received quantities; purchase order number; and returnable container information.

ASN Process

The ASN process, shown in the next figure, includes the following:

• A shipment authorization is made to the supplier in the form of a Purchase Order, Planning Schedule, or Shipping Schedule.

• The supplier sends the ASN to the receiving organization at the time of shipment.

• The ASN is verified in the Receiving Open Interface. Intransit and purchasing supplies are updated for ASN lines that are successfully validated. For each accepted line on the ASN, intransit supply is increased and purchasing supply is reduced. If the data isn't accepted or if there is an error or discrepancy in the data, an Application Advice, containing the most likely cause of the error, is sent to the supplier. The supplier can then send a corrected (New) ASN.

• The goods arrive. You can use the ASN in the Receipts window to create receipts.

• Shipment-vs.-receipt quantities are compared during the receipt transaction process. (As an optional step, CUM quantities can be compared if Oracle Supplier Scheduling is installed.) If discrepancies are detected in shipment-vs.-receipt or CUM quantity comparisons, an Application Advice is sent to the supplier.

ASN Receiving Options

There are two receiving options related to ASNs:

• ASN Control option in the Receiving Options window - With this option, you can choose whether or not you receive an error message--or are prevented by Purchasing--when you attempt to receive against a purchase order shipment for which an ASN already exists.

• RCV: Fail All ASN Lines if One Line Fails - With this profile option, you can choose to reject an entire ASN if any ASN line fails validation or processing, or to accept an ASN if at least one ASN line is successful.

Types of ASNs

There are three types of ASNs:

• A New ASN is the initial ASN.

An ASN can also contain substitute item information. To accurately handle substitutions, the supplier must indicate both the buyer's original item number and the buyer's substitute item number on the ASN. With both identifiers available, substitutes can be validated as allowed, and a valid substitute item is referenced against valid purchasing document information.

• A Cancellation ASN, once validated, cancels the original (New) ASN if the original (New) ASN has not yet had a receipt created against it. The shipment number on the Cancellation ASN is matched to the shipment number on the validated, original (New) ASN.

• A Test ASN is sent by the supplier usually to make sure the ASN transmission works between you and your supplier. A Test ASN is verified as if it were a New ASN and generates an outbound Application Advice if necessary. A Test ASN is not available for creating a receipt against it and is not visible as inbound supply. 

ASNs and Supply

For each accepted line on the accepted ASN, intransit supply quantity is automatically increased and purchasing supply quantity is automatically reduced by the shipment quantity specified in the ASN.

The table below shows, for each action you perform with an ASN, the movement of the quantity on the ASN between the various categories of supply.

ASNs and Supply
Accept ASN	Purchasing Supply	Intransit Supply	Inventory
Accept the New ASN	Reduced for accepted lines only	Increased for accepted lines only
Accept the Cancellation ASN	Increased for all accepted lines on New ASN	Reduced for all accepted lines on New ASN
Receive Items	Purchasing Supply	Intransit Supply	Inventory
Receive item when the item is indicated on an ASN line		Reduced	Increased
Receive item when the item is not indicated on an ASN line	Reduced		Increased
Change Receipt Quantities	Purchasing Supply	Intransit Supply	Inventory
Increase receipt quantity before the ASN is closed		Reduced	Increased
Increase receipt quantity after the ASN is closed	Reduced		Increased
Decrease receipt quantity before the ASN is closed		Increased	Reduced
Decrease receipt quantity after the ASN is closed	Increased		Reduced
Return Items	Purchasing Supply	Intransit Supply	Inventory
Return item(s) to the supplier before the ASN is closed		Increased	Reduced
Return item(s) to the supplier after the ASN is closed	Increased		Reduced
Close Corresponding Purchase Order	Purchasing Supply	Intransit Supply	Inventory
Close the Purchase Order while an ASN for that purchase order is open	Reduced	Reduced

Link Between Purchase Order and Requisition

SELECT prh.segment1 req_number
      ,prh.authorization_status
      ,prl.line_num req_line_num
      ,prl.item_description req_item_description
      ,prl.unit_price req_unit_price
      ,prl.quantity req_quantity
      ,pd.req_header_reference_num
      ,pd.req_line_reference_num
      ,pl.line_num
      ,pl.item_description
      ,pl.quantity
      ,pl.amount
      ,ph.segment1 po_number
      ,prd.distribution_id
      ,pd.req_distribution_id
  FROM po_requisition_headers_all prh
      ,po_requisition_lines_all   prl
      ,po_req_distributions_all   prd
      ,po_distributions_all       pd
      ,po_line_locations_all      pll
      ,po_lines_all           pl
      ,po_headers_all             ph
 WHERE prh.requisition_header_id = prl.requisition_header_id
   and prh.org_id = prl.org_id
   and prl.requisition_line_id = prd.requisition_line_id
   and prl.org_id = prd.org_id
   and prd.distribution_id = pd.req_distribution_id(+)
   and prd.org_id = pd.org_id(+)
   and pd.line_location_id = pll.line_location_id(+)
   and pd.org_id = pll.org_id(+)
   and pll.po_line_id = pl.po_line_id(+)
   and pll.org_id = pl.org_id(+)
   and pl.po_header_id = ph.po_header_id(+)
   and pl.org_id = ph.org_id(+)