[MRP] What is MDS?

A good article from Metalink Note:200574.1

"A schedule developed from firm orders or from forecasts of demand. The MPS is a key input into a material requirements planning (MRP) system. The MPS identifies how many of each end product need to be produced and when they need to be produced by within each planning period. This data forms one of three keyinputs enabling an MRP system to produce detailed timings for component manufacture and material purchases. It summarizes what the business plans to make and drives the operation in terms of what is assembled, what is made, and what is bought in. In addition it forms the basis for planning the utilization of labour and equipment and determines the requirements for materials and cash."

MDS serves as input for MPS, MPS serves as input for MRP. However, in simple MRP implementation, MPS some times been skipped.

[INV] Locator Control

Excerpt from Metalink Note: 228984.1

Dynamic entry - Define locators when you use them, either as you receive or ship items.
No control - Locator control not established.
Prespecified - Define locators before you use them.

Note: For Oracle Order Management, if an item is Reservable, you can manually reserve a specific locator at order entry or let pick release use Inventory picking rules to suggest the locator when the order is picked. If the item is not Reservable, Inventory picking rules will suggest the locator when the order is picked.

Note: Locator control for an organization or for a subinventory overrides locator control for an item.

Attention: You cannot change locator control when an item has quantity on hand.

Related Topic:
http://oraclea2z.blogspot.com/2008/10/inv-locator-control-in-subinventories.html

[PO] You are not setup as a buyer. To access this form you need to be a buyer.

Applies to the following forms:
Purchase Order Entry Form
Releases
AutoCreate

Related Topic:
http://oraclea2z.blogspot.com/2008/04/po-default-buyer-after-autocreate.html

[PO] Returns

Accounting Entries for Returns transaction.


Return to Receiving - Reversal of "Deliver" double entries.
Dr Clearing Account
Cr Charge Account


Return to Supplier - Reversal of "Receive" double entries.
Dr Accrual Account
Cr Clearing Account


Note that the Destination Type for Return to Receiving is "Expense" as it was from "Expense". Destination Type for Return to Supplier is "Receiving" as it came from "Receiving". But if these 2 transactions were performed separately, both transactions show
"Receiving". Not logical, right?


Related Topic:
http://oraclea2z.blogspot.com/2008/09/po-2-legs-entries-in-receiving.html

[SYS] To View Concurrent Requests From Backend Tables

SELECT REQUEST_ID,
REQUEST_DATE,
PHASE_CODE,
STATUS_CODE,ARGUMENT_TEXT
FROM apps.fnd_concurrent_requests WHERE concurrent_program_id=
ORDER BY request_date DESC

Thanks for Dennis's contribution.

[SYS] Vendor Contacts

select pv.vendor_name,pvsa.vendor_site_code,pvc.last_name,pvc.middle_name,pvc.first_name,

pvc.mail_stop mail,pvc.area_code,pvc.phone 

from 

apps.PO_VENDOR_SITES_ALL pvsa, apps.PO_VENDORS pv,

apps.PO_VENDOR_CONTACTS pvc

where

pv.vendor_id=pvsa.vendor_id

and pvsa.vendor_site_id=pvc.vendor_site_id

and pv.end_date_active is null

and pvc.inactive_date is null

and pvsa.org_id=

order by pv.vendor_name,pvsa.vendor_site_code,pvc.last_name,pvc.middle_name,pvc.first_name

Note that in PO_VENDORS table does not have org_id reference, means that Vendor header does not link to organization, but the Vendor Site does that, PO_VENDOR_SITES_ALL.

[WF] [WFMLR_DOCUMENT_ERROR]' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'.

[WF_ERROR] ERROR_MESSAGE=3835: Error '-20002 - ORA-20002: [WFMLR_DOCUMENT_ERROR]' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'. ERROR_STACK=

WF_MAIL.GetDocLOBContent(ATTACH_FILE)

WF_XML.GetAttachment(2346222, text/html)

WF_XML.GetAttachments(2346222, http://abc.com:8888/pls/abc, 12345)

WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 2346222)

WF_XML.Generate(oracle.apps.wf.notification.send, 2346222)

WF_XML.Generate(oracle.apps.wf.notification.send, 2346222)

Wf_Event.setMessage(oracle.apps.wf.notification.send, 2346222, WF_XML.Generate)

Wf_Event.dispatch_internal()

A possible error that you will encountered if you are trying to send email with attachment in your custom workflow program.

Searched Metalink, returned 5 results.

2 actions can be taken after I summarized the findings from Metalink:

(1) Restart Workflow Mailer

(2) Make sure the file path is correct.

Tried first one, it did not work out. And I am sure my path is correct. By the way, that path I used is newly created and assigned with 777.

I changed my attachment output file to another path, it works!

[INV] Manufacturers' Part Number

Define New Manufacturer
Items -> Manufacturers' Part Numbers -> By Manufacturers

Assign Manufacturer Part Number
Items -> Manufacturers' Part Numbers -> By Items

System does not allow duplicate Manufacturer Name defined, it is controlled at form level. Manufacturer Part Numbers are defined in Master level, it does not link to the Inventory Child organization.

Table: APPS.MTL_MANUFACTURERS, APPS.MTL_MFG_PART_NUMBERS_ALL_V

Some Constraints:
- For the same Manufacturer and Item, we cannot define same Manufacturer Part again. But if the same Manufacturer Part was defined for another Manufacturer for the same Item, it allows. E.g.
Manufacturer Part Item
A P1 I1
A P1 I1 => NOT ALLOWED
B P1 I1 => ALLOWED

- Manufacturer Name (30 chr) does not link to Vendor Name (240 chr).

[MRP] Planning Active

Excerpt from Oarcle Online Help for Define Sourcing Rules:
7. Enter an allocation percentage for each shipping organization. Allocation percentage includes the number of planned orders issued to the part for the entire the planning horizon. Your total allocation may not exceed 100.

If the allocation percentage for all the shipping organizations included within a range of effectivity dates equals 100, Planning Active is checked. If the sourcing rule is not planning active, the planning process will not use the rule to assign planned orders.

Note: You cannot set the allocation percentage to less than or greater than 100 for sourcing rules that are already assigned in assignment sets.

The Planning Active field is not editable by design. FYI, I tested the last note "Note: You cannot set...", it is not true.

[INV] Locator Control in Subinventories is Disabled

Locator Control in Subinventories form is disabled. However, selection still can be done, any change of value will prompts "FRM-40200: Field is protected against update".

To enable that, we need to set the Organization Parameters, Inventory Information to have Locator Control equals "Determined at Subinventory level".

[PO] Auto Create Purchase Order

Question: How to do set up for automatic creation of PO from approved purchase requisition. I don't want to do through Autocreate option.

Answer: You can trigger workflow PO_AUTOCREATE_DOC.start_WF_process to create PO from your approved PR. If you want this to happen immediately after PR got approved, modify the PO Requisition Approval workflow. Go to Main Requisition Approval process (Internal Name: MAIN_REQAPPRV_PROCESS), add a function at the end of the workflow.

[PO] Zero in Price

Does system allow to have "0"(zero) in item price? Ans: Yes

[PO] Adding PR to Existing PO Line with Different Price

New price will not take effect if you add in to existing PO line.

[SYS] Build Concurrent Request Queue View

This program will be submitted automatically (under Standard Manager) after your assign new rule to the concurrent manager.

Navigate Concurrent -> Manager -> Define, click Specialization Rules button.

[QUALITY] To Enter Colletion Plan Info During Inspection (Receiving Transaction)

At Receiving Transactions form, click "Inspect" button. The next form should display the columns defined in the Collection Plan.

To setup this:
- Define a collection plan with Transaction Description as Inspection Transactions (Oracle -Purchasing).

- Set the profile option QA:PO Inspection to from Oracle Purchasing to Oracle Quality at site level.

Refer to Metalink Note: 317542.1 for more details.

[PO] Change Receiving Control in Purchase Order, Need Reapproval? Generate New Revision?

Ans: No

[SYS] Sales Order and Move Order Approval

Hi Stanley,Please throw me some idea on how to do set for 1) Sales Order approval and 2) Move Order Approval.Regards,Saravanan.

Quick Tips:
- Sales Order approval, setup in transaction type.
- Move Order approval, Planner at Item form is the default approval. Need to enable a profile before you use.

[PO] "2 Legs" Entries in Receiving Transactions

For Direct Delivery routing, only 2 transaction types: Receive, Deliver

Double Entries for Receive:
Dr Clearing Account (defaulted from Receiving Option)
Cr Accrual Account (defaulted from Purchasing Option)

Double Entries for Deliver:
Dr Charge Account (Inventory or Expense accounts)
Cr Clearing Account

[PO] View Accounting

How to view accounting entries for a standard receiving transactions?

Ans: Go to Receiving Transactions Summary in Purchasing responsibility (Receiving -> Receiving Transactions Summary). Query records by Transactions. For Direct Delivery routing, only 2 transaction types: Receive, Deliver.

Click on any line, go Tools -> View Accounting