[PO] R12: Sales Order Reference in PR Interface Table

Drop Shipment, a booked Sales Order will trigger interface records into PO_REQUISITIONS_INTERFACE_ALL table.

How to trace back the original SO number from this table?

Get GROUP_CODE, which is reference back to the Sales Order header_id.

[PO] What Are The Steps Required To Setup An Internal Requisition In Purchasing?

Excellant note. A simple and easy-to-understanding guide from Oracle Support, Note:406312.1.

A quick glance and I leant something new, Receiving for IR can be automated if we set the Receipt Routing to "Direct" in Shipping Networks .

[PO] Position Hierarchy Used for PR/PO Approval

A PR/PO was submitted for approval, how to check which Position Hierarchy user used? From Apps front end, it is impossible. Check it out from backend tables.

Sample codes:

SELECT approval_path_id FROM apps.PO_ACTION_HISTORY WHERE object_id in (SELECT requisition_header_id FROM apps.PO_REQUISITION_HEADERS_ALL WHERE segment1='myPRNumber')

Link approval_path_id to HR.PER_POSITION_STRUCTURES table to get hierarchy name used.

[PO] Receiving for PO with Status "Requires Reapproval"

Standard Purchase Order with 3 lines. I changed line 1 quantity. Header status changed to "Requires Reapproval". In normal scenario, I cannot do anymore Receiving activity as the status is not Approved. If my changes involved price and currency, receiving activity will generate accounting entries with wrong amount. A control is needed.

However, for a particular PO, I am able to perform receiving. The PO with "Requires Reapproval" appeared in the LOV when i tried to perform receiving. I can proceed further to next screen. However, the line i changed (line 1) is not appearing. Only the lines that i did not change appeared and allow me to do receiving. Why?

The reason being the PO is an consigned PO, which has consigned item (doubled check it from Shipment). System allows receiving for the unchanged line because receiving activity for consigned PO will NOT generate any accounting entries, no impacts. Furthermore, transaction price does not refer to PO, but BPA.

[PO] Exchange Rate for A New Line

I have a PO create months back, exchange rate was captured at the header level. If i add a new po line now, previous captured rate will be applied to the line, shipment and distribution, not today's rate.

Double check the exchange rate on Distributions line, under "More" tab.

[PO] Owner Can Approve

Whether a preparer can approve the document, e.g. PR/PO depends on setup in Setup -> Purchasing -> Document Types, if "Owner Can Approve" flag is check, preparer can approve by himself. Means, preparer just need to click "Approve... " and "OK" button, the document will be approved (assume approval limit is satisfied).

However, if preparer wants to use hierarchy other than default hierarchy, he/she needs to specified the "Forward To" person to himself. PO will be first changed to " Pre-Approved" status before it get approved eventually.

[PO] Position with Status Blank

Create a new position, leave the Status field blank, save. Oracle considers it as Valid or Invalid. Ans: Valid

[PO] Item Not Found During Purchase Requisition (PR) Creation

In a Operation Unit (OU), I have 2 inventory organization (inventory child type), e.g. OrgA & OrgB. I need to raise a PR to purchase ItemC under OrgB. In Item setup, ItemC is created in Inventory Master org, and assigned to OrgB. Purchasable flag has been checked in both Inventory Master and OrgB. When i keyed in the item during PR creation, item not found, why?

The reason being the OrgA was assigned in Financial Options setup (Setup -> Organizations -> Financial Options), Supplier - Purchasing, Inventory Organization field. If OrgA is assigned, only item assigned to OrgA can be found in the LOV.

We can setup Inventory Master org in each OU, then assign the Inventory Master org in the Financial Options. From there, we can choose any items that was created under the Inventory Master org.

[PO] Backend Field for PR

We know that we can view Purchase Requisition (PR) number from PO distribution screen (Line -> Shipment -> Distributions, for standard PO). Which field in the backend table is used to link to PR tables?

Ans: LINE_LOCATION_ID field in APPS.PO_LINE_LOCATIONS_ALL table that links to APPS.PO_REQUISITION_LINES_ALL table

[PO] Organization And Location At Requisitions Form, Where Can We Set The Default Value For Those?

Both values are default from the Employee setup. In Purchasing responsibility, navigate Setup -> Personnel -> Employees, click "More ..." button, move to "Assignment" tab, enter it at Location field.

[PO] Matching Setting in Purchase Order Shipment Line

Invoice matching can be set in five different areas of Oracle Purchasing:
In the list below, a setting at any level will override the settings above it.

1. Oracle Purchasing Options
a. Navigate to: Setup > Organizations > Purchasing Options
b. Select Default Alternative Region

2. Supplier Information
a. Navigate to: Supply Base > Suppliers
b. Query on specific supplier
c. Click on Open
d. Select Receiving Alternative Region

3. Line Types
a. Navigate to: Setup > Purchasing > Line Types
b. In the Receipt Required field: Yes = 3-way, No = 2-way

4. Items
a. Navigate to: Items > Master Items
b. Query on specific item
c. Select Purchasing Alternative Region
d. In the Invoice Matching section: Yes = 3-way, No = 2-way

5. Purchase Order Shipments
a. Navigate to: Purchase Orders > Purchase Orders
b. Enter (header and) line information
c. Click on Shipments button
d. Select More Alternative Region

Above notes are reproduced from Oracle Support Note:225630.1.

[PO] Where to Setup Invoice Matching Option?

Setup -> Financial Option, Supply - Entry tab, Invoice Matching Option field.

Supply -> Sites, Control tab, Invoice Matching Option field.

(A Setting At Any Level Will Override The Settings Above It)

2 type of options available, Purchase Order / Receipt

[PO] R12 Purchasing Options

Setup -> Organizations -> Purchasing Options

In R11i, it is devided into 5 sections, "Receipt Accounting", "Control", "Default", "Internal Requisition", "Numbering" and "Tax Defaults".

In R12, (this form was converted to JSP format), only 4 sections available (some of the fields been merged), "Document Control", "Document Defaults ", "Receipt Accounting" and "Document Numbering".

New fields in R12:

Document Control

Security Hierarchy

Maximum Attachment Size

Email Attachment Filename

Enforce Supplier Hold

RFQ Required (from "Default" tab in R11i)

Document Defaults

Internal Requisition Order Type (from "Internal Requisition" tab in R11i)

Internal Requisition Order Source (from "Internal Requisition" tab in R11i)

Tax Defaults was removed from Purchasing Options. Need to confirm if it has been permanently removed or moved to other form.

[PO] Self-Billing Flag in PO table

How to know if a Purchase Order (PO) was created under supplier site with Self-Billing?

Not from front end. But check the PAY_ON_CODE field in PO.PO_HEADERS_ALL table. It should reflect "RECEIPT" value.

[PO] APP-PO-14376: Please enter a GL Date within an open purchasing period

You were trying to do Receiving. Once you navigate out of the Receipt Header form, the above message prompted. You have to open Purchasing Periodsunder Setup -> Control Purchasing Periods.

[PO] Can I Setup Only Document Total Rule in Approval Group

Yes. But in the Approval Assignment, you can only assign Blanket Purchase Agreement document type to that particular Approval Group. If you intend to assign other document type, e.g. Standard Purchase Order, you need at least another rule setup in Approval Group, which is Account Range.

[PO] Source Field in Purchase Requisition (PR) Screen Does Not Show "Supplier"

Make sure item is purchasable in the selected inventory organization.

[PO] BPA Price Break - Discount (%) field

It is a field to display percentage of discount applied to the new price compare to the very first price.

For example,

Break Price for line 1 = $100, line 2 = $80, line 3 = $70

Value for Discount (%) field fo line 1 = 0, line 3 = 20, line 3 = 30

[PO] Missing Purchase Order (PO) Distribution After RTV - FIXED

With reference back to my problem logged to Metalink TAR, it was fixed after applied patch 4463796.

This patch upgrade the version of PAPOUTLB.pls to 115.3.90.4. Eventhough Project Accounting is not used, but this patch works.

How to check PAPOUTLB.pls version?

SELECT fi.file_id
,filename
,version
FROM apps.ad_files fi, apps.ad_file_versions ve
WHERE filename LIKE 'PAPOUTLB.%'
AND ve.file_id = fi.file_id
AND REPLACE(version, '.','') =
(SELECT MAX(TO_NUMBER(REPLACE(version, '.', '')))
FROM apps.ad_file_versions ven
WHERE ven.file_id = fi.file_id);

[PO] APP-PO-14566: Category is invalid, or category is invalid for the item

When you creating a new PR, after entered the category code in Category field, the above message shown. An additional error message also appeared, "APP-FND-01388: Cannot read value for profile option FND_INDICATOR_COLORS in routine &ROUTINE. "

The category code is valid, what can be the cause?

Get the default Category Set from Setup -> Items -> Categories -> Default Category Sets

Query Category Sets in Setup -> Items -> Categories -> Category Sets, check "Enforce List of Valid Categories" checkbox. If the checkbox is checked, the category you need to enter must be exist in the list.