Skip to main content


Showing posts from 2014

How to Remove/Disable OA Framework Personalizations

However, after creating the personalization, the page is no longer accessible and you need to back-out or remove this personalization to allow access to the page. There are a few methods to remove the 'faulty' personalization from the OA Framework page. Introduction: Before starting to delete personalizations it's useful to understand some background how these are stored in Applications. All page definitions for OAF pages are stored as (XML) document in the MDS repository (located in the database). The reference to this is a document name with following format: /oracle/apps/<product>/<subcategories>/<pagename> For example the Home Page document name is: /oracle/apps/fnd/framework/navigate/webui/HomePG When creating personalizations in the OAF page the above mentioned document is not changed. Instead a separate document is created in the MDS repository containing the personalization(s) done. For each 'level' of personalizatio

How to Create Purchase Orders

How to Create Purchase Orders Purchasing provides the Purchase Orders window that you can use to enter Standard and Planned purchase orders as well as Blanket and Contract purchase agreements. You must be defined as a buyer to use this window. 1.   Navigate to the Purchase Orders window from the menu: by selecting the New PO button in the Find Purchase Orders window or any of its results windows by selecting the Open button in any of the Find Purchase Order results windows by selecting the Open button and then double-clicking the Open Documents icon in the Notifications Summary window when the current line is a purchase order if the PO: Display the AutoCreated Document profile option is set to Yes, Purchasing opens the Purchase Orders window when you have completed AutoCreation of a purchase order. See: Profile Options in Purchasing.       The upper part of the Purchase Orders window has the following display-only fields: Created - The system date is displayed a

How to Default Descriptive Flexfield Data From Requisition Header To Requisition Line?

Issue :  If we have set up additional information in a Descriptive Flexfield at the Requisition Header level, is it possible to automatically default these values down to the Line level, for example to the PO_REQ_DISTRIBUTIONS table? Solution: As the Requisitions form has blocks which simultaneously contain the current Requisition Header, Line and Distribution information, it is possible to reference Desc Flex Field columns across different blocks. Please try the following method in a test instance: 1. Query the Requisition Header DFF definition.     In this example we will assume that the data to be populated in the child row is      in the ATTRIBUTE12 DFF column. 2. Responsibility: Purchasing Super User     Navigation: Setup > Flexfields > Descriptive > Segments       Click F11 and populate the Title field with "Requisition Distributions"       Ctr+F11 to execute query       Click Segments and get the relevant Segment, say ATT

Under-utilized features of Email Communication for Purchase Orders

Communicating Purchase Orders to suppliers as PDF documents via email has been around for quite some time but there are some features that I find are under-utilized and are often not presented to customers.   For example, did you know that you can have every PO copied to a generic email address?  What about attaching documents to the email such as Terms and Conditions or any other files? Create a backup copy of PO Communication email Oracle has the capability to send a copy of the email communicating the PO to supplier by sending a copy of the email to an internal email address.  This provides you the ability to forward a copy of the email if the supplier did not receive the original copy.  The backup copy of the email can also be used for internal reference. Use the profile option PO: Secondary Email Address to identify the email address to which the copy of the purchase order should be sent.  Typically organizations set up a generic address such as purchasi

How to Communicate a PO to Multiple Supplier Email Adresses

Before 11.5.10, the E-mail Notification supports multiple E-mail addresses as long as the combined addresses list is no longer than 60 characters. The E-mail addresses need to be separated by commas. As a workaround the supplier may setup a distribution list address, including all the single E-mail addresses that would receive the E-mail. We were able to use  only a single e-mail address when using the feature to mail during the approval process .   The use of commas to separate multiple addresses is no longer supported in 11.5.10 or Release 12. Refer to Note: 333719.1 11.5.10: Not Able To Send Multiple E-Mails Upon Approval Of Purchase Order for details.   When attempting to set an email address for a supplier site to multiple email addresses the following error occurs:       Error     Row 1 Email - Please enter a valid Email Address.    As of now, the following workarounds are available :  1. Using Professional Buyer Work Center in R12, where you can ment