Oracle Purchasing implementation is a prerequisite.
For more information, see the Setting Up section in the Oracle Purchasing User's Guide.
Note: If you are upgrading from a previous release, you should review Oracle iProcurment Documentation Resources, Release 12 for the most current information, available on My Oracle Support.
The following table shows the Oracle Purchasing setup steps that are specific to implementing optional features in Oracle iProcurement. You might have already completed these steps if you have already implemented Oracle Purchasing.
Note: This table does not show all of the setup steps for Oracle iProcurement. It shows only the setup steps in Oracle Purchasing that Oracle iProcurement optionally uses.
Step | Required or Optional | Information Source |
---|---|---|
Define Requisition Templates for Oracle iProcurement Public Lists | Optional | Oracle Purchasing User's Guide |
Define Information Templates | Optional | Define Information Templates |
Define Global Blanket Purchase Agreements | Required for Local Content | Oracle Purchasing User's Guide |
Define Contract Purchase Agreements | Optional | Oracle Purchasing User's Guide |
Define Shipping Networks and Customer Locations for Internal Requisitions | Required for Internal Requisition Creation | Oracle Order Management User's Guide, Oracle Purchasing User's Guide, Oracle Inventory User's Guide Internal Requisitions |
Set Up P-Cards | Optional | Oracle Purchasing User's Guide Employee P-Cards Supplier P-Cards PO Extract for P-Card Reconciliation |
Set Up Content Security | Optional | Content Security |
Create Commodity-Based Expense Account Rules | Optional | Expense Charge Account Rules |
Set Up Smart Forms | Optional | Smart Forms |
Set Up E-Commerce Gateway Mapping | Required for Punchout | Oracle Procurement Buyer's Guide to Punchout and Transparent Punchout |
The following table shows the setup steps specific to implementing features of other Oracle Applications with Oracle iProcurement. You might have already completed these steps if you implemented Oracle Purchasing. These steps appear in a suggested, but not required, order.
Step | Required or Optional | Information Source |
---|---|---|
Encumbrance | Optional | Oracle Purchasing User's Guide, Oracle General Ledger User's Guide |
Grants Accounting | Optional | Oracle Grants Accounting User's Guide Grants Accounting Integration |
Project Accounting | Optional | Oracle Projects Implementation Guide Project Accounting Integration |
Project Manufacturing | Optional | Oracle Project Manufacturing Implementation Manual Project Accounting Integration |
Advanced Pricing | Optional | Oracle Advanced Pricing Implementation Manual Oracle Purchasing User's Guide |
Oracle Services Procurement | Optional | Oracle Services Procurement |
The following table shows the setup steps associated with administering or managing Oracle iProcurement. These include important utilities, provided with Oracle iProcurement, that can enhance the requester's experience. This chapter includes details of these steps. These steps appear in a suggested, but not required, order.
Step | Required or Optional | Information Source |
---|---|---|
Set Up Function, Menu, and Data Security | Optional | Set Up Function, Menu, and Data Security |
Personalize Oracle iProcurement Using Oracle Applications Framework | Optional | Personalize Oracle iProcurement Using Oracle Applications Framework |
Create Operating Unit-Specific Purchasing News | Optional | Create Operating Unit-Specific Purchasing News |
Customize Operating Unit-Specific Purchasing Policies | Optional | Customize Operating Unit-Specific Purchasing Policies |
Customize Workflows | Optional | Customize Workflows |
Define Descriptive Flexfields on Requisitions | Optional | Define Descriptive Flexfields on Requisitions |
Implement Custom Packages | Optional | Implement Custom Packages |
Modify Online Help | Recommended | Modify Online Help |
Set Profile Options | Required | Set Profile Options |
Function security can restrict requester access to certain functions and actions in various pages throughout Oracle iProcurement. For example, you can exclude the Express Receive buttons in Receiving to prevent this type of receipt creation. Function security could also prevent access to the Corrections pages in Receiving.
An administrator also has the option of setting menu security. Menu security attribute settings tend to be more broad in the areas they restrict than function security attribute settings. With menu security, you can prevent a requester from accessing entire menus and submenus within Oracle iProcurement. With this type of setting, you can exclude the requester from accessing all of receiving or all of Oracle iProcurement workflow, as opposed to only a specific button or link within these modules. Due to their more specific nature, there are more function security attributes than menu security attributes. You define both function and menu security attributes at the responsibility level.
Setup Steps
Perform these steps to modify the default function and menu security associated with the default-provided iProcurement Procurement responsibility.
Define responsibility:
Using the System Administrator responsibility navigate to the Responsibilities window. See: Defining a Responsibility, Oracle Applications System Administration.
Create a new responsibility related to Oracle iProcurement. This responsibility enforces function security.
Enter a Responsibility Name, Application, Responsibility Key, and Effective From Date.
Set Available From to Oracle Self Service Web Application.
Enter the Data Group fields for Name and Application.
Set the Menu field to Internet Procurement Home.
Exclude responsibility functions and menus:
On the Menu Exclusions tab of the Responsibilities window, select either the Function or Menu selection to set up either function security or menu security.
In the Name field, select the appropriate function or menu to exclude.
Assign Oracle iProcurement responsibility to a requester:
Using the System Administrator responsibility navigate to the Users window.
Search for the requester to assign to the responsibility.
Insert the new responsibility.
Note: If you are not implementing Oracle Services Procurement, consider excluding the Contractors tab menu and the Contractor Request sub-tab from the Internet Procurement Home menu. If you do not implement Oracle Services Procurement, the Contractor Request link and Contractors tab still appear in Oracle iProcurement. When requesters try to access these areas, a message indicates that they cannot access the page because Oracle Services Procurement has not been enabled. To remove these areas, create a custom responsibility that excludes the Contracts menu and Contractor Request submenu from the Internet Procurement Home menu.
Oracle iProcurement Functions
The following tables show functions that can establish function security in Oracle iProcurement. Only those functions that correspond to the main features in Oracle iProcurement appear in the following table.
Name | System Name | Description |
---|---|---|
View My Group's Requisitions | POR_VIEW_GROUP_REQS | View requisitions that employees in the requester's organization created. The definition of a group is based on the Security Level option selected during the Document Types setup in Oracle Purchasing. |
View My Group's Reqs Receive | POR_VIEW_GROUP_REQS_RECEIVE | Register requested items as received. |
View My Group's Reqs Cancel | POR_VIEW_GROUP_REQS_CANCEL | Cancel a requisition that has been submitted for approval. |
View My Group's Reqs Copy | POR_VIEW_GROUP_REQS_COPY | Create a requisition by copying an existing requisition. |
View My Group's Reqs ReSubmit | POR_VIEW_GROUP_REQS_RESUBMIT | Resubmit requisitions that have been rejected or returned. |
Name | System Name | Description |
---|---|---|
View My Reqs Cancel | POR_VIEW_MY_REQS_CANCEL | Function security for the Cancel button |
View My Reqs Copy | POR_VIEW_MY_REQS_COPY | Function security for the Copy button |
View My Reqs Receive | POR_VIEW_MY_REQS_RECEIVE | Function security for the Receive button |
View My Reqs Resubmit | POR_VIEW_MY_REQS_RESUBMIT | Function security for the Resubmit button |
View my Requisitions | POR_VIEW_MY_REQS | View requisitions that a requester owns. |
View my Reqs Change Order | POR_VIEW_MY_REQS_CHANGE_ORDER | Function security to request changes and cancellations to requisition lines on purchase orders |
View My Reqs Withdraw | POR_VIEW_MY_REQS_WITHDRAW | Function security for the Withdraw function of the Change button |
Name | System Name | Description |
---|---|---|
View All Reqs Cancel | POR_VIEW_ALL_REQS_CANCEL | Cancel a requisition that has been submitted for approval. |
View All Reqs Copy | POR_VIEW_ALL_REQS_COPY | Create a requisition by copying an existing requisition. |
View All Reqs Receive | POR_VIEW_ALL_REQS_RECEIVE | Register requested items as received. |
View All Reqs ReSubmit | POR_VIEW_ALL_REQS_RESUBMIT | Resubmit requisitions that have been rejected or returned. |
View All Requisitions | POR_VIEW_ALL_REQS | View all requisitions in the requester's organization. |
View Reqs Change Order History | POR_VIEW_REQS_CHANGE_HISTORY | Function security for the Change History link |
Name | System Name | Description |
---|---|---|
View Reqs I Approved Cancel | POR_VIEW_APPR_REQS_CANCEL | Cancel a requisition that has been submitted for approval. |
View Reqs I Approved Copy | POR_VIEW_APPR_REQS_COPY | Create a new requisition by copying an existing one. |
View Reqs I Approved Receive | POR_VIEW_APPR_REQS_RECEIVE | Register requested items as received. |
View Requisitions I Approved | POR_VIEW_APPR_REQS | View requisitions that a requester approved. |
Name | System Name | Description |
---|---|---|
View Orders to Approve | POR_VIEW_TO_APPR_REQS | View orders awaiting approval. |
View Orders to Approve Cancel | POR_VIEW_TO_APPR_CANCEL | Cancel requisitions to approve. |
View Orders to Approve Copy | POR_VIEW_TO_APPR_COPY | Copy orders to approve. |
Name | System Name | Description |
---|---|---|
Add Approver | POR_ADD_APPROVER | Change the requisition approval route based on the requester's choice of first approver. |
Change First Approver | POR_CHANGE_FIRST_APPROVER | Change first approver. |
Delete Approver | POR_DELETE_APPROVER | Delete non-mandatory approvers from a requisition's document approval routing list. |
User Default approver list | POR_USER_DEFAULT_APPROVERS | Ignore changes and revert to the original document approval routing list. |
Approve or Reject a Requisition | POR_SHOW_APPROVE_REJECT_BTN | Approve or reject a requisition. |
Name | System Name | Description |
---|---|---|
All Items to Receive | POR_ALL_ITEMS_TO_RECEIVE | Restrict a requester from receiving all items. |
Correct All Receipts | POR_SHOW_ALL_RCV_CORRECTIONS | Grant or deny access to correct all receipts. |
Correct Receipts | POR_SHOW_RCV_CORRECTIONS | Grant or deny access to correct receipts. |
Express Receive | POR_EXPRESS_RECEIVE | Create an Express Receipt. |
POR: Receive Orders | POR_RECEIVE_ORDERS | Let a requester receive orders. |
Return All Items | POR_SHOW_ALL_RCV_RETURNS | Grant or deny access to return all items. |
Return Items | POR_SHOW_RCV_RETURNS | Grant or deny access to return items. |
View All Receipts | POR_SHOW_ALL_RECEIPTS | Grant or deny access to view all receipts. |
View Receipts | POR_SHOW_VIEW_RECEIPTS | Grant or deny access to view receipts. |
Name | System Name | Description |
---|---|---|
Express Setup Tools | POR_SSP_EXP_SETUP | Enable express setup of employees and locations. |
Favorite Charge Accounts | POR_FAV_CHG_ACCT | List of Favorite Charge Accounts |
POR SSP ECManager | POR_SSP_ECMANAGER | Internet Procurement eContent Manager |
POR SSP Home | POR_SSP_HOME | Internet Procurement Home Page |
Name | System Name | Description |
---|---|---|
Displays Check Funds Button | POR_DISP_CHECKFUNDS_BUTTON | Control the display of the Check Funds button. |
Create Emergency Req | POR_CREATE_EMERG_REQ | Create an emergency requisition. |
One Time Location | POR_ONE_TIME_LOCATION | Enter a one-time address during checkout. |
Name | System Name | Description |
---|---|---|
Self-Service Purchasing Receive Orders | POR_RCV_ORDERS_WF | Receive orders from workflow. |
Self-Service Purchasing Resubmit Requisition | POR_RESUBMIT_URL | Resubmit requisition (called from workflow). |
Self-Service Purchasing Update/Cancel Requisition | POR_UPDATE_REQ | Update or cancel requisition lines (called from workflow notifications). |
Self-Service Purchasing View Requisition | POR_OPEN_REQ | View requisition (called from workflow). |
Name | System Name | Description |
---|---|---|
iProcurement: View all Contractor Performance Entries | ICX_POR_VIEW_CONTR_PERF | Control access to viewing contractor performance evaluations on the Contractors tab. |
iProcurement: Manage all Contractor Performance Entries | ICX_POR_MANAGE_CONTR_PERF | Control access to entering, editing, and managing performance evaluations on the Contractors tab. |
iProcurement: Create Contractor Performance Entries | ICX_POR_CREATE_CONTR_PERF | Control access to entering contractor performance evaluations on the Contractors tab. |
iProcurement: Suggest supplier/contractor for contr request | POR_CONTR_REQST_SUGGEST_SUPPL | Control whether the requester can specify a suggested supplier or must pick from one of the preferred suppliers. |
iProcurement: Select supplier for contractor request | POR_CONTR_REQST_SELECT_SUPPL | Control whether to select all the preferred suppliers by default while the requester is creating the contractor request. |
View my Requisitions | POR_VIEW_MY_REQS | Control access to viewing one's own contractor requests on the Contractors tab. |
View My Group's Requisitions | POR_VIEW_GROUP_REQS | Control access to viewing contractor requests in one's group on the Contractors tab. |
Name | System Name |
---|---|
Change Multiple Lines | POR_CHANGE_MULTI_LINES |
Compare Search Results | POR_COMP_SEARCH_RESULTS |
Create Emergency Requisitions | POR_EMERG_REQS |
Create New Requisition | ICX_REQS |
eContent Manager | POR_ECMANAGER |
Emergency Req Add Approver | POR_EMERG_ADD_APPROVER |
Emergency Req Change First Approver | POR_EMERG_CHANGE_FIRST_APPR |
Emergency Req Change Multiple Lines | POR_EMERG_CHANGE_MULTI_LINES |
Emergency Req Compare | POR_EMERG_COMP_SEARCH_RESULTS |
Emergency Req Delete Results | POR_EMERG_DELETE_APPROVER |
Emergency Req Sort Approvers | POR_EMERG_SORT_APPROVERS |
Emergency Req Use Default Approver List | POR_EMERG_USE_DEFAULT_APPROVER |
Emergency Req View Approvers | POR_EMERG_VIEW_APPROVERS |
Express Checkout | POR_EXPRESS_CHECKOUT |
POR: Create New Requisition | POR_NEW_REQS |
POR: Receive Items | POR_RECEIVE_ITEM |
POR Power Checkout | POR_POWER_CHECKOUT |
POR Standard Checkout | POR_STANDARD_CHECKOUT |
Receiving Home Page | POR_SHOW_RCV_HOME |
Reset Password | POR_RESET_PWD_FUNC |
SSP Notification Reassignment | POR_NOTIFY_REASSIGN |
Sort Approvers | POR_SORT_APPROVERS |
View Approvers | POR_VIEW_APPROVERS |
View All Reqs Complete | POR_VIEW_ALL_REQS_COMPLETE |
View All Reqs Delete | POR_VIEW_ALL_REQS_DELETE |
View Reqs I Approved Complete | POR_VIEW_APPR_REQS_COMPLETE |
View Reqs I Approved Delete | POR_VIEW_APPR_REQS_DELETE |
View Reqs I Approved Resubmit | POR_VIEW_APPR_REQS_RESUBMIT |
View My Group's Reqs Complete | POR_VIEW_GROUP_REQS_COMPLETE |
View My Group's Reqs Delete | POR_VIEW_GROUP_REQS_DELETE |
View My Reqs Complete | POR_VIEW_MY_REQS_COMPLETE |
View My Reqs Delete | POR_VIEW_MY_REQS_DELETE |
View Reqs Cancel Expand | POR_VIEW_REQS_EXPAND_CANCEL |
View Reqs Copy Expand | POR_VIEW_REQS_COPY_EXPAND |
View Reqs Receive Expand | POR_VIEW_REQS_EXPAND_RECEIVE |
View Reqs Resubmit Expand | POR_VIEW_REQS_EXPAND_RESUBMIT |
Oracle iProcurement Menus
The following table shows the settings for menu security. Only those menus that correspond to the main features in Oracle iProcurement appear.
Note: If you are upgrading from a previous release, you should review About Oracle iProcurement for your most recent release, available on My Oracle Support. This document discusses the features and setup that are new in this release. It also includes a list of new and changed menus in this release.
System Name | Name | Description |
---|---|---|
POR_SSP_ECMANAGER | iProcurement eContent Manager | Allows access to the Oracle iProcurement eContent Manager. |
ICX_POR_SSP_HOME | Internet Procurement Home | Allows a requester access to the Oracle iProcurement Home page. |
ICX_POR_ALL_ITEMS_TO_RECEIVE | SSP5: All Items to Receive | Determines if a requester can view all items to receive. |
ICX_POR_RECEIVE_ORDERS | SSP5: Receiving | Determines if a requester is given access to receiving. |
ICX_POR_SSP5_CREATE_REQ | Create Requisition | Allows access to Oracle iProcurement requisition creation. |
ICX_POR_SSP5_VIEW_ALL_REQS | SSP5 - View All Requisitions | Oracle iProcurement view all requisitions submenu. |
ICX_POR_SSP5_VIEW_GROUP_REQ | SSP5 - View My Group's Requisitions | View my group's query submenu defined for function security. |
ICX_POR_SSP5_VIEW_MY_REQ | SSP5 - View My Requisitions | Oracle iProcurement view my requisitions submenu. |
ICX_POR_VIEW_TO_APPR_REQ | SSP5 - View Orders to Approve | Oracle iProcurement submenu for order to approve. |
ICX_POR_SSP5_VIEW_APPR_REQ | SSP5 - View Requisitions I Approved | Oracle iProcurement submenu for orders I have approved page. |
ICX_POR_WORKFLOW | Self Service Purchasing Workflow link | Allow a requester access to Oracle iProcurement workflow link. |
Data Security
Data security uses securing attributes to allow rows (records) of data to be visible to specified requesters based on the specific data contained in the row. In Oracle iProcurement, securing attributes called realms restrict requester access to the catalog.
The following table shows securing attributes that can establish data security in Oracle iProcurement:
Attribute | Application | Description |
---|---|---|
ICX_POR_ITEM_SOURCE_ID | Oracle Self Service Web Applications | No longer used. (If you used it in a previous release, the current release still honors it.) |
RT_CATEGORY_ID | Oracle Self Service Web Applications | No longer used. (If you used it in a previous release, the current release still honors it.) |
ICX_POR_REALM_ID | Oracle Self Service Web Applications | Use this attribute to secure the responsibility for category or item source realms. |
Oracle iProcurement is built upon the Oracle Applications Framework technology. Oracle Applications Framework enables system administrators to personalize the user interface in Oracle iProcurement. Examples include showing, hiding, moving, or modifying regions (such as the My Requisitions section on the shop Home page), items (such as a button), or fields (such as showing the Rate Type field, which is hidden by default in the shopping cart).
When the personalization profile option is turned on, the system administrator can log in to Oracle iProcurement, click the Personalize Page link on any page, and customize the desired regions, items, or fields. Users see these customizations. For example, if you make the customization at the responsibility level, then the changes are visible to all users who sign on using that responsibility.
By default, Oracle iProcurement is already set up to display the optimum information to requesters. You can display one or more fields that are hidden by default.
Note: The personalization profile option must be turned on to see the Personalize Page link. For more information, see the Oracle Applications Framework Personalization Guide.
As you are implementing the features and setup steps described in this guide, use the personalization feature to see which fields are hidden by default or which page regions and items you want to modify.
For instructions on enabling and performing personalizations, see the Oracle Applications Framework Personalization Guide,
Note: Before using personalization to show or hide information, verify the function security options. You may be able to restrict access to a function instead. For more information, Setting Up Function, Menu, and Data Security.
You can create purchasing news that is specific to an operating unit. Requesters can view information that is pertinent only to their operating unit when accessing this area from the home page.
The following figure demonstrates where the Purchasing News area displays below the Shopping Cart area.
Setup Steps
Create a directory under OA_HTML/<language code>/.
For example: OA_HTML/US/operating_unit_1 where operating_unit_1 is your help path.
Copy PORPNEWS.htm from the OA_HTML/US/ directory to the directory that was created in step 1. Modify this file to include content specific to the operating unit.
Set the value for the responsibility-level profile option POR: Purchasing News Location to the location of the operating unit-specific files as specified in step 1. For more information, see Set Profile Options.
For the example from step 1, you would enter /operating_unit_1/ for the profile option.
Note: The POR: Purchasing News Location profile option requires a slash character / at the beginning and at the end of the string. OA_HTML is the path of all the Oracle iProcurement HTML files and is part of the Oracle Internet Application Server (iAS) setup.
By default, the Purchasing News area is hidden. Use Oracle Applications Framework personalization to display the Purchasing News.
For more information, see Personalize Oracle iProcurement Using Oracle Applications Framework.
Profile Options
POR: Purchasing News Location
Customers can provide purchasing policies that cover the same topic, but in terms appropriate to specific countries, regions, or operating units. To accomplish this, add an optional localization code to the end of the anchor_name in the HTML online Help files.
Setup Steps
Determine a localization code to use, for example, ou1 for operating unit 1.
Copy the original PORPOLCY.htm file to a new file with the same name. Copy the file from $ICX_TOP/help/<language code>.
Open the new file with an HTML editor.
In this Help file, find the HTML anchor with the anchor_name ppolicy:
< A NAME = "ppolicy"></A>
Append the localization code for the appropriate operating unit to this anchor name. For example:
< A NAME="ppolicy@ou1"></A>
Change the PORPOLCY.htm file to include the localized information to appear for the given operating unit.
Save your changes.
Upload the localized Help file to the database using the Oracle Applications Help System Utility. For more information about using the Help System Utility, see the Oracle E-Business Suite System Administrator's Guide.
Set the profile option Help Localization Code for the appropriate responsibility to the value defined with the anchor name in the HTML code:
Log in to Oracle Applications and choose the System Administrator responsibility.
Navigate to the System Profiles window and search for the profile Help Localization Code and the appropriate responsibility (such as Internet Procurement).
Set the profile value to the localization code that you appended to the anchor name (ou1 in this example) for the appropriate responsibility.
Since each responsibility is tied to an operating unit, requesters with that responsibility (such as Internet Procurement) in that operating unit see the Purchasing Policies Help file that is appended with the localization code (ou1 in this example).
Oracle Workflow lets you automate business processes by routing information according to customized business rules. Workflows automate several procedures in Oracle Purchasing and Oracle iProcurement.
This section presents a brief description of each workflow that Oracle iProcurement uses:
PO Requisition Approval
PO Create Documents
Account Generator
PO Send Notifications for Purchasing Documents
Confirm Receipts
PO Change Request Tolerance Check
Requester Change Order Approval
PO Change Approval for Requester
Each of these workflows consists of processes that you can view in the Oracle Workflow Builder. Each workflow process, in turn, consists of individual function activities. You can customize the processes to support your business practices.
For more information about these workflows, see the Oracle Purchasing User's Guide. For information about the procedures for setting them up, see the Oracle Workflow Guide.
Workflow File Name: poxwfrqa.wft
Note: If you are installing and implementing Oracle iProcurement for the first time, the name of this workflow is Requisition. For upgrading customers, the name is PO Requisition Approval.
This workflow manages all requisition approvals and starts when you submit a requisition in Oracle iProcurement. Approvers, upon receipt of the approval notification (through Web or e-mail), can approve, reject, forward, or reassign the requisition. If approved, the notification passes to the next approver until all approvers have acted on the requisition. Finally, when all approvers have approved the requisition, the workflow process submits the requisition to the buyer or purchasing department. If the requester has the appropriate security access, the requester can override the default approver list. For more information, see Set Up Function, Menu, and Data Security.
Customize the attributes in this workflow to fit your business needs. The key attribute that requires consideration is Send PO Autocreate to Background. This attribute determines whether a deferred process is created at the very end of the requisition approval workflow. By default, the process defers the call to the PO Create Documents workflow by placing the call in Background mode. There is also an Online mode. For more information, see the PO Requisition Approval section of the Oracle Purchasing User's Guide.
Workflow File Name: poxwfatc.wft
This workflow manages the automatic creation of purchasing documents. The PO Create Documents workflow starts in Oracle iProcurement when you submit a requisition associated with an existing blanket purchase agreement, contract purchase agreement, or catalog quotation in Oracle Purchasing.
Customize the attributes in this workflow to fit your business needs.
The following table shows the attributes that you must consider:
Attributes: Display name | Attributes: Internal name | Description |
---|---|---|
Is Automatic Creation Allowed? | AUTOCREATE_DOC | Indicator (Y for Yes or N for No) of whether this workflow is initiated for all approved requisition lines. Default value: N |
Is Automatic Approval Allowed? | AUTO_APPROVE_DOC | Indicator of whether the purchase order approval workflow is initiated automatically after this workflow. Default value: N |
Should Workflow Create The Release? | CONT_WF_FOR_AC_REL_GEN | Indicator of whether this workflow creates, releases, or leaves them to the buyer to create using AutoCreate in Oracle Purchasing. Default value: N |
Should Contract be used to autocreate Doc? | USE_CONTRACT_FLAG | Indicator of whether the workflow should autocreate standard purchase orders with contract purchase agreement references. If this attribute is set to Yes and a contract exists, then the purchase order is created with the contract reference. If a contract does not exist or cannot be found, then the buyer must use AutoCreate to create the purchase order. If this attribute is set to No, then the buyer must use AutoCreate to create the purchase order. Default value: N |
Is Contract Required on Requisition Line? | CONTRACT_REQUIRED_FLAG | Indicator of whether a contract purchase agreement must exist on the requisition line for autocreation to generate a standard purchase order. (For example, a contract purchase agreement is referenced on a requisition line by associating a contract purchase agreement with an item using bulk loading.) Default value: N |
Should non-catalog requests be autosourced from contract? | INCLUDE_NON_CATALOG_REQ_FLAG | If Should Contract be used to autocreate Doc? is set to Yes and Is Contract Required on Requisition Line? is set to No, then use this attribute to indicate whether the workflow should search for a contract purchase agreement with which to associate non-catalog requests. Default value: N |
Should temp labor request be autosourced from contracts? | INCLUDE_TEMP_LABOR_FLAG | If Should Contract be used to autocreate Doc? is set to Yes andIs Contract Required on Requisition Line? is set to No, then use this attribute to indicate whether the workflow should search for a contract purchase agreement with which to associate contractor requests. Default value: Y |
Is Grouping of Requisition Line Allowed? | GROUPING_ALLOWED_FLAG | Indicator of whether the workflow should group all lines from a single requisition to a single purchase order. If this option is set to No, then each requisition line becomes a separate purchase order. Default value: N |
Is Grouping of One Time Address Line Allowed? | GROUP_ONE_ADDR_LINE_FLAG | Indicator of whether the workflow should group all requisition lines for the same one-time address (on a single requisition) to a single purchase order. If this option is set to No, then each requisition line becomes a separate purchase order. Default value: N |
For more information about this workflow and these attributes, see the Workflow section of the Oracle Purchasing User's Guide.
Workflow File Name: poxwfpag.wft
During checkout, the Oracle Purchasing Account Generator builds a charge, budget, accrual, and variance account for each purchase order, release, and requisition distribution based on the distribution's destination type. When an account has been determined for a requisition distribution, the Account Generator populates all segments of the account.
Customize the processes in the requisitions Account Generator workflow to fit your business needs. For more information, see the Account Generator Workflow section of the Oracle Purchasing User's Guide.
Workflow File Name: poxwfarm.wft
The PO Send Notifications for Purchasing Documents workflow searches for documents that are incomplete, rejected, or in need of reapproval and sends notifications of the document's status to the appropriate users. You can view and respond to these notifications online or through e-mail.
Customize the messages in this workflow to fit your business needs. For more information, see the PO Send Notifications for Purchasing Documents Workflow section of the Oracle Purchasing User's Guide.
Workflow File Name: poxwfrcv.wft
The Confirm Receipts workflow sends notifications that are visible online or through e-mail to requesters who create requisitions through Oracle iProcurement. (Online, requesters can see the notifications on the Notifications page in Oracle iProcurement. Buyers can see the notifications in the Notifications Summary work list in Oracle Purchasing.)
The Confirm Receipts workflow sends notifications for purchase order shipments that meet the following criteria:
Destination or Deliver-To Type is Expense
Destination type is Inventory, if the POR: Select Inventory Replenishment Lines for Confirm Receipts profile option is set to Y
Receipt routing is Direct Delivery
Matching is 3-way
Need-By Date or Promised Date is prior to the current date, or invoice has been matched to PO
Customize the processes or messages in this workflow to fit your business needs. For more information, see the Confirm Receipts section of the Oracle Purchasing User's Guide.
Workflow File Name: poxrcoa.wft
The PO Change Request Tolerance Check workflow lets the administrator customize the business rules for routing of the change request through the Oracle iProcurement user's approval hierarchy. This workflow is called for changes that requesters make to a requisition after one of its requisition lines appears on an approved purchase order.
Customize the attributes in this workflow to fit your business needs. These attributes control whether the requester's approval hierarchy requires reapproval. Each attribute comes with an upper and lower tolerance limit. For example, for the unit price, you define a lower tolerance limit of 20 (percent) and an upper tolerance limit of 0 (percent). In this example, a change to the price requires reapproval whenever it is decreased by more than 20 percent or whenever it is increased.
The attributes are defined on the Requester Change Order page in Oracle Purchasing.
For instructions on opening and modifying workflows, see the Oracle Workflow Guide.
Workflow File Name: poreqcha.wft
The Requester Change Order Approval workflow handles changes that requesters make to a requisition after one of its requisition lines appears on an approved purchase order.
This workflow performs:
After the requester makes the change, the workflow examines the change order attributes in the PO Change Request Tolerance workflow to see if the requisition approval hierarchy must reapprove the change. If it does not, then the requisition is submitted directly to the buyer for approval.
If the requisition changes require reapproval, then the Requester Change Order Approval workflow routes the changed requisition through the requisition approval hierarchy. (Approvers receive a notification of the changes.)
When the requisition approval, the workflow process sends the changes to the buyer for acceptance or rejection. (The buyer receives a notification of the changes.)
When the buyer accepts the changes, the workflow completes and starts the PO Change Approval for Requester workflow.
Note: When users make changes to a requisition before any of its lines appear on an approved purchase order, the requisition is withdrawn from the approval process. The requisition approval workflow handles this withdrawal, not the Requester Change Order Approval workflow.
Workflow File Name:porpocha.wft
When the buyer accepts a change order request, this workflow starts processes in the PO Approval workflow (poxwfpoa.wft) for determining whether the buyer's approval hierarchy must approve the changed purchase order.
For more information about workflow processes for approving change orders, see the Oracle Purchasing User's Guide.
You can define descriptive flexfields on requisition headers, lines, and distributions.
The following figure shows descriptive flexfields during the checkout process. In this example, the following header-level flexfields appear in the Requisition Information section:
Region
Country Name
Country Code.
The Additional Line Information section appears only if there are line-level descriptive flexfields. The following line-level flexfields appear in an Additional Line Information section:
Service Agreement
Service Period
Service Products.
Line-level descriptive flexfields can also appears in the shopping cart and in the final checkout page (before you click Submit). To see descriptive flexfields at the distribution level, click Edit Lines, Accounts, and then the Split icon. Distribution flexfields can also appear in the final checkout page (before you click Submit).
Note: When set up, flexfields appear only if you use Oracle Applications Framework to display them on the desired pages. (By default, they are hidden on all pages.)
Oracle iProcurement supports global segments and a single context field. Oracle iProcurement supports neither multiple context fields nor reference fields. Support for the single context field is possible through the context value profile options, descriptions of which follow.
For example, suppose you define the following Requisition Headers descriptive flexfields using the Descriptive Flexfield Segments window in Oracle Applications:
Region (global segment)
Country Name (global segment)
Country Code (context field)
Province (context field)
Note: The POR: Context value for Requisition header descriptive flexfield profile option setting is Country Code.
In this example, the following descriptive flexfields would appear on the requisition header:
Region and Country Name appear because they are global segments, which always appear.
Country Code appears because its selection in the POR: Context value for Requisition header descriptive flexfield profile option.
Note: Province would not appear because it is not a selected context field in the profile option.
In summary, for each part of the requisition--header, line, distribution--Oracle iProcurement displays all global segments that you define, plus the context field that is selected in the corresponding profile option.
Setup Steps
To define descriptive flexfields:
Using the System Administrator responsibility, create descriptive flexfields for any or all of the following entities:
Requisition Headers
Requisition Lines
Requisition Distributions
Oracle Applications includes definitions for each of the preceding entities. In the Descriptive Flexfields Segments window, they appear in the Title field. Query the one you want and define the desired flexfields for it. For instructions, see the Oracle E-Business Suite Flexfields Guide.
For flexfields that are context fields, select the desired flexfield in the corresponding profile option that appears in the Profile Options section.
By default, the flexfields are hidden on all pages. Use Oracle Applications Framework personalization to display the flexfields on the desired pages.
For more information, see Personalize Oracle iProcurement Using Oracle Applications Framework.
When you personalize a page, the descriptive flexfield name includes Flex, for example: Flex: (ReqHeaderDFF). One field is given for all flexfield segments. In the preceding examples, the Flex: (ReqHeaderDFF) field is given for all of the segments--Region, Country Name, and Country Code--on the Checkout: Requisition Information page. If you display Flex (ReqHeaderDFF), then you display Region, Country Name, and Country Code.
Profile Options
POR: Context value for Requisition header descriptive flexfield
POR: Context value for Requisition line descriptive flexfield
POR: Context value for Requisition distribution descriptive flexfield
Implementation Considerations
If the requisition containing the descriptive flexfields is later completed, copied, changed (by the requester or approver), or resubmitted, then Oracle iProcurement assumes the same descriptive flexfields that were on the original requisition, even if the corresponding profile option contains a different value. If descriptive flexfields are set up after the requisition's original creation, then subsequent checkout of the requisition applies the descriptive flexfields, including those that the profile options designate.
The following sections describe how to use a PL/SQL package to make requisition header and line customizations and how to use Oracle Applications Framework to make customizations to the default account generation and account validation procedures.
POR_CUSTOM_PKG provides customization hooks to perform the defaulting logic and validation of the requisition header, line, and distribution data. These procedures are invoked from CustomReqHeaderHelper, CustomReqLineHelper, and CustomReqDistHelper classes. By default, they do not affect the existing logic and validation. POR_CUSTOM_PKG is bundled in the PORCUSTB.pls file.
For instructions on modifying PL/SQL packages, see the Oracle E-Business Suite Developer's Guide.
The following table describes the different procedures in POR_CUSTOM_PKG for requisition header, line, and distribution customizations and how they are triggered.
Procedure Name | Purpose | Invocation Details |
---|---|---|
CUSTOM_DEFAULT_REQ_HEADER | You can customize this procedure to include logic to default to the header information for a given requisition. | This procedure is called from the executeCustomDefaultingLogic method in CustomReqHeaderHelper when a requisition is created. |
CUSTOM_VALIDATE_REQ_HEADER | You can customize this procedure to include logic to validate the header information for a given requisition. | This procedure is called from the validate method in CustomReqHeaderHelper before the requisition is submitted. |
CUSTOM_DEFAULT_REQ_LINE | This procedure can include logic to default to the information onto a requisition line. | This procedure is called from the executeCustomDefaultingLogic method in CustomReqLineHelper when a new line is added to the shopping cart. |
CUSTOM_VALIDATE_REQ_LINE | This procedure can include logic to validate the information on the requisition line. | This procedure is called from the validate method in CustomReqLineHelper on every page in the checkout flow. |
CUSTOM_DEFAULT_REQ_DIST | This procedure can include logic to default to the information on a requisition distribution. | This procedure is called from the executeCustomDefaultingLogic method in CustomReqDistHelper when a distribution is created upon entering the checkout flow. |
CUSTOM_VALIDATE_REQ_DIST | This procedure can include logic to validate the information on the requisition distribution. | This procedure is called from the validate method in CustomReqDistHelper on every page in the checkout flow. |
Extend the Entity Object for requisition lines or distributions.
The Entity Object contains all of the target attributes that can potentially cause account re-defaulting. Follow these steps:
Since you extend Entity Objects (EO) in the BC4J package oracle.apps.icx.por.schema.server, open this package in your project.
Select the parent EO.
For requisition lines, select oracle.apps.icx.por.schema.server.PoRequisitionLineEO.
For requisition distributions, select oracle.apps.icx.por.schema.server.PoReqDistributionEO.
For information about identifying the parent EO, see the section about modifying entity object attribute default values in the Oracle Applications Framework Developer's Guide. (For an exact reference to the correct location on My Oracle Support forum, see the Oracle E-Business Suite System Administrator's Guide.)
In the section about modifying entity object attribute default values, follow the steps for creating a new, empty BC4J package to hold your custom BC4J objects and for creating a new entity object that extends the parent EO.
In the second step of the Entity Object Wizard, click New from Table ... and select your target attributes.
These are the attributes, such as AMOUNT, that you want to trigger account re-defaulting when their values are changed.
Selecting Target Attributes
Click OK, and accept the defaults for the rest of the steps in the wizard.
In the System Navigator panel, highlight the Entity Object that you created in the preceding steps, to show all of the attributes in the Entity Object.
Highlight each target attribute in the Structures panel, right-click, and select the Edit option to edit each of your target attributes. The Attribute Editor appears.
Select Properties from the left-hand panel. For each target attribute, add a new property in the Attribute Editor.
If your target attribute is associated with a requisition line, enter AccountLineBizAttrSet in the Property Name field and Y in the Value field.
If your target attribute is associated with a requisition distribution, enter AccountDistBizAttrSet in the Property Name field and Y in the Value field.
Click Add, and then OK, to save the changes.
AccountLineBizAttrSet and AccountDistBizAttrSet include all of the attributes that trigger account re-defaulting. You have set your target attributes to trigger account re-defaulting when the attribute's value is changed.
When you have completed extending the Entity Objects, see the instructions in the section Substitute Extended BC4J Objects for Parent BC4J Objects, in the Oracle Applications Framework Developer's Guide, to substitute your extended BC4J object for the parent BC4J object.
Restart the Oracle Internet Application Server (iAS) after these changes.
The following profile options control whether to invoke the corresponding custom procedures:
Set the corresponding profile option to Yes to invoke your customized procedure. For more information, see Profile Options.
POR: Enable Req Header Customization
POR: Enable Requisition Line Customization
POR: Enable Req Distribution Customization
Performing the charge account customizations is not the same as modifying the Account Generator workflow. The customizations in this step determine what triggers account re-defaulting. When triggered, the Account Generator workflow defaults to the correct account.
Value changes to certain attributes on a requisition line or distribution can cause the charge account to change to another default value. For example, a change to the Deliver-to Location can cause the charge account number to change. You can add to the attributes that cause charge account to change.
The online Help is available as Oracle Applications Help. All the Help documents and graphic files are stored in the database. The Help documents are in HTML format. You can modify the Help content by using any HTML editor.
For detailed instructions on modifying and updating Help files, see the Oracle E-Business Suite System Administrator's Guide.
Oracle iProcurement consists of the following sets of Help files:
The first set appears when a requester clicks the Help icon in Oracle iProcurement.
The second set appears when the catalog administrator clicks the Help icon in the eContent Manager. Only users who log in with the iProcurement Catalog Administration responsibility have access to this second set of Help files.
The Oracle iProcurement online Help contains placeholder Help files for you to add instructions specific to your company's processes.
Oracle iProcurement Placeholder Help
In the Oracle iProcurement Help, the placeholder files are in an Additional Help section. The placeholder files contain temporary placeholder text. You should replace this text.
The placeholder files in the Oracle iProcurement Help are:
Purchasing Policies (PORPOLCY.htm)
Note: You might already have customized PORPOLCY.htm by operating unit in Customize Operating Unit-Specific Purchasing Policies.
Contacting the Purchasing Department (PORCPURC.htm)
Contacting Technical Support (PORCTECH.htm)
Particularly for the Oracle iProcurement Help files, which requesters see, you should modify or replace these files with files of your own, or remove them from the Additional Help section of the Oracle iProcurement main Help page (PORINDEX.htm)
Content Management Placeholder Help
The placeholder file used in the iProcurement Catalog Administration Help is Contacting Technical Support (PORCTECH.htm), in the Additional Information section.
You should modify or replace these files with files of your own, or remove them from the Additional Help section of the iProcurement Catalog Administration main Help page (PORCATIX.htm).
If you are not implementing Oracle Services Procurement, you can remove the online Help for that application.
The following figures show the Contractor Request section and Receiving Items section of the Oracle iProcurement Help. To remove access to the Contractor Request Help files, then modify the Oracle iProcurement main Help page (PORINDEX.htm) to remove the Contractor Request section and links:
Creating Contractor Requests (PORSRVCR.htm)
Assigning Contractors (PORSRVAS.htm)
Finding and Tracking Contractor Requests (PORSRVTR.htm)
Evaluating Contractors (PORSRVEV.htm)
Receiving Contractor Requests (PORSRVRV.htm)
A number of profile options govern the behavior of Oracle iProcurement. During implementation, you must set a value for each profile option to specify how Oracle iProcurement controls access to and processes data.
Note: When you update a Site-level profile option, you must restart the Oracle Internet Application Server (iAS) for the change to take effect.
For details regarding setting profile options, see: Overview of Setting User Profiles, Oracle Applications System Administration.
POR: Apply Expense Account Rules to Favorite Charge Accounts
POR: Context value for Requisition distribution descriptive flexfield
POR: Context value for Requisition header descriptive flexfield
POR: Context value for Requisition line descriptive flexfield
POR: Select Inventory Replenishment Lines For Confirm Receipts
The table below lists the profile options that impact iProcurement Configuration.
Determines the batch size used to commit records to catalog tables when bulk loading or purging data. You can change the default setting depending on the volume of purchasing data and your database configuration. For example, if the commit size is exceptionally large, errors may occur. If the value is too small, there may be performance issues. Contact your database administrator to see whether you should change the default commit size.
This profile affects the suggested buyer, global requester, and global approver features. When set to Yes:
You can assign buyers (or establish default buyers) from different business groups to a given requisition line.
Approval lists can include approvers outside the requester's business group.
The requester field can include requesters outside the user's business group.
Determines the date format mask to use. The American English default is DD-MON-RRRR, for example, 12-NOV-2002. For year 2000 compliance, all year formats are converted to RRRR, which accepts four-digit century and year entries verbatim (1950 is stored as 1950) and converts two-digit year entries:
Entries of 00 to 49 are converted to 2000 to 2049, respectively.
Entries of 50 to 99 are converted to 1950 to 1999, respectively.
For example, if a requester enters 50 for the year, the year is converted and stored as 1950. If a requester enters 49, the year is converted and stored as 2049.
Determines the date language to use. This impacts the default date format mask.
Indicates the default Discoverer Workbook owner
Indicates employee person id to be defaulted in for quotes and ordering.
This profile sets the default view operand.
Sourcing rules dictate which supplier or internal organization will supply a given requisitioned item. Sourcing rules are utilized by Oracle iProcurement so that a default source can be generated by the application. In Oracle iProcurement only those sourcing rules that have been assigned to the assignment set defined in this profile will be used when the sourcing logic is called.
Determines the batch size to commit records to catalog tables when uploading, extracting, or purging data. You can change the default setting depending on the volume of purchasing data you expect to extract or upload and your database configuration. For example, if the commit size is exceptionally large, errors may occur. If the value is too small, there may be performance issues. Contact your database administrator to see whether you should change the default commit size.
Time, in minutes, until the middle tier server performs a garbage collection.
Determines which context-sensitive descriptive flexfield Oracle iProcurement uses for requisition distributions.
Determines which context-sensitive descriptive flexfield Oracle iProcurement uses for requisition headers.
Determines which context-sensitive descriptive flexfield Oracle iProcurement uses for requisition lines.
Yes indicates that distribution level customization is enabled.
Yes indicates that header level customization is enabled.
Yes indicates that line level customization is enabled.
For multi-org environments, this is the directory where operating unit-specific purchasing news is stored. Normally, this value is the name of the operating unit
Catalog administrators can use this profile option to specify the number of days catalog loader job history is stored in the database. This setting helps minimize the amount of disk space that the loader tables use. When the catalog loader is started, it retrieves this profile option setting and purges any data older than the value in the profile option.
The tables from which the data are purged include: ICX_POR_BATCH_JOBS, ICX_POR_FAILED_LINE_MESSAGES, ICX_POR_FAILED_LINES, and ICX_POR_CONTRACT_REFERENCES.
Use the POR: Bulk Loader/Extractor Commit Size profile option to determine how many records are purged at a time.
Set this profile option if you are setting up a transparent punchout content zone. Enter the time, in seconds, after which you want transparent punchout catalogs to time out if the search takes longer than this time to complete. For example, if you enter 30 and a transparent punchout catalog takes longer than 30 seconds to return results, Oracle iProcurement displays a message after 30 seconds that the Web site is not responding. The timeout does not affect other catalog search results if other catalogs are in the store. It affects only the transparent punchout catalog or catalogs in the store that take longer than this timeout to return results.
The table below lists the profile options that impact iProcurement Content Management.
Profile Option | Default | User Access | System Administration: Site | System Administration: Application | System Administration: Responsibility | System Administration: User |
---|---|---|---|---|---|---|
FND: Native Client Encoding | WE8MSWIN1252 | Update | Update | Update | Update | Update |
ICX: Default Requisition Template | Update | Update | Update | Update | Update | |
ICX: Discoverer Default End User Layer Schema Prefix | Update | Update | Update | Update | Update | |
ICX: Discoverer EBS End User Layer Schema Prefix | Update | Update | Update | Update | Update | |
ICX: Discoverer EDW End User Layer Schema Prefix | Update | Update | Update | Update | Update | |
ICX: Discoverer End User Layer Language Override | Update | Update | Update | Update | Update | |
ICX: Discoverer Launcher | Update | Update | Update | Update | Update | |
POR: Autocreate Shopping Category and Mapping | No | Update | ||||
POR: Auto Load Category Descriptors | No | Update | ||||
POR: Auto Load Root Descriptors | No | Update | ||||
POR: Auto Load Shopping Categories | No | Update |
Encoding that you want to default into the spreadsheet that you download from the Download Instructions and Templates page in the eContent Manager (accessible through the iProcurement Catalog Administration responsibility). For example, if you select the Cp1252 encoding for this profile option (also displays the technical name WE8MSWIN1252), the #ENCODING field in the spreadsheet template defaults to Cp1252.
Indicates the default Requisition Template for iProcurement requisitions.
Indicates the Discoverer default end user layer schema prefix.
Indicates the Discoverer EBS end user layer schema prefix.
Indicates the Discoverer EDW end user layer schema prefix.
Indicates the Discoverer end user layer language override.
This profile identifies the URL directed to the Discoverer server.
If set to Yes, create shopping category and mapping automatically when Purchasing category is created.
If set to Yes, creates a Category Descriptor if the descriptor found in the upload file does not exist in iProcurement.
If set to Yes, creates a Root Descriptor if the descriptor found in the upload file does not exist in iProcurement.
If set to Yes, creates the Shopping Category if the category found in the upload file does not exist in iProcurement.
The table below lists the profile options that impact iProcurement deployment.
Profile Option | Default | User Access | System Administration: Site | System Administration: Application | System Administration: Responsibility | System Administration: User |
---|---|---|---|---|---|---|
Application Framework Agent | WE8MSWIN1252 | Update | Update | Update | Update | Update |
Apps Servlet Agent | Update | Update | Update | Update | Update | |
ECX: Log File Path | Update | |||||
Help Localization Code | No | Update | Update | Update | ||
ICX: Client IANA Encoding | Western European (ISO-8859-1) | Update | ||||
ICX: Discoverer OLTP End User Layer Schema Prefix | Update | Update | Update | Update | Update | |
ICX: Discoverer Parameters | Update | Update | Update | Update | Update | |
ICX: Discoverer Release | Update | Update | Update | Update | Update | |
ICX: Discoverer use Viewer | Update | Update | Update | Update | Update | |
ICX: Discoverer Viewer Launcher | Update | Update | Update | Update | Update | |
ICX: Forms Launcher | Update | Update | Update | Update | Update | |
ICX: HTML directory | Default | Update | ||||
ICX: Language | Update | Update | Update | |||
ICX: Limit connect | 1000 | Update | Update | Update | ||
ICX: Limit time | 4 | Update | Update | Update | ||
ICX: Match case LOV | Update | Update | Update | Update | Update | |
ICX: Match case View | Update | Update | Update | Update | Update | |
ICX: Media directory | Default | Update | ||||
ICX: NLS Sort | Update | Update | Update | Update | Update | |
ICX: Numeric characters | Update | Update | ||||
PO: Enable Services Procurement | No | Update | ||||
PO: Validate Need-by Time For Requisition Submit | Yes | Update | Update | Update | ||
POR : Amount Based Services Line Type | Update | |||||
POR : CA Certificate File Name | Update | |||||
POR: Contractor Expense Line Type | Update | Update | Update | Update | ||
POR: Default Currency Conversion Rate Type | Update | Update | Update | Update | Update | |
POR : Goods Line Type | Update | |||||
POR: Hosted Images Directory | Update | |||||
POR : Proxy Server Name | Update | |||||
POR : Proxy Server Port | Update | |||||
POR : Rate Based Services Line Type | Update | |||||
POR : Use Sequence for Requisition Numbering | No | Update |
HTTP server that the Oracle Self-Service Framework application uses. The system administrator who configured Oracle Self-Service Framework should already have set this profile option. If requesters experience errors on the Search Results page after first adding an item to the cart, you may need to remove the trailing slash from this profile option value.
The URL, including the hostname and port number, from where the Oracle iProcurement server is running.
Directory where the Oracle XML Gateway engine writes its log files. The directory must be one of the valid directories specified in the UTL_FILE_DIR parameter in the init<SID>.ora file in your Oracle Applications instance. This must be an absolute path and cannot contain a symbolic link or other operating system specific parameters.
Indicates the localization code for localized help files. For more information, see the Oracle E-Business Suite System Administrator's Guide.
Character set encoding (such as UTF-8) that the application server uses to generate HTML for the browser. This encoding determines the way to send data to the browser and render the data.
Indicates the Discoverer OLTP end user layer schema prefix.
Use Discoverer Viewer instead of Web Discoverer.
This profile contains the URL to launch Discoverer Viewer.
Determines the default session language.
Determines the maximum number of page visits for each session.
Determines the maximum number of hours a requester can log in for each session.
Indicates the media directory.
Collating sequence for the ORDER BY CLAUSE
Enter the preferred decimal and group separators you want to display for numbers. For example, if you specify .. as the value for this profile option, you indicate that the decimal separator is a period and the group separator is a comma. In this example, if you enter these values at the site level, all requesters in Oracle iProcurement for the specified site see the number three thousand as 3,000.00. If the value is entered as ,. for the profile option, three thousand would appear as 3.000,00
When set to blank, the decimal and group separators are obtained from the nls_numeric_parameters setting in the database.
This is a separately licensed Oracle Applications product. You must have licensed and implemented this product to use this profile and any of the features that the profile enables.
When set to Yes, the Contractor Request links and tabs display the contractor entry information. When set to No, clicking these links and tabs displays the message: You cannot access this page because Oracle Services Procurement is not enabled. Contact your system administrator for help.
Option to bypass validation of time component of need-by date during requisition submit process. Value of Yes means valiate both time and date components.
Determines the line type for amount-based non-catalog requests. An amount-based request is expressed in monetary terms - for example, 500 USD worth of service.
The value selected should be distinct from the values selected for POR: Goods Line Type and POR: Rate Based Services Line Type.
You can select only line types with a Purchase Basis of Services and a Value Basis of Amount for this profile option. If Oracle Services Procurement is licensed and implemented, then you can select a Value Basis of Fixed Price or Amount.
This profile option that punchout and transparent punchout content zones use when those catalogs reside on a secure site. ( It specifies the file name that includes the certificates your company's server accepts. This file should be readable and should be accessible from the middle tier. If you have multiple JVMs, then this directory should be accessible from all the JVMs. By default, use the file $APACHE_TOP/Apache/conf/ssl.crt/ca-bundle.crt, where $APACHE_TOP is the root directory where the Oracle Internet Application Server (iAS) is installed. The ca-bundle.crt file includes certificates from various signing authorities. For more information, see the Oracle Procurement Buyer's Guide to Punchout and Transparent Punchout.
Indicates the line type that should be used for expense lines on contractor requests.
Use this profile option to specify the default exchange rate type. This rate applies when:
Creating non-catalog requests.
Converting an uploaded item's transactional price into a requester's functional price.
Converting a punchout or transparent punchout item's transactional price into the functional price.
Exchange rates cannot be found during contractor assignment.
If you are converting prices of punchout or transparent punchout items, you must set this profile option to either Corporate or Spot (not User). Otherwise, the requester receives an error message during checkout that no exchange rate exists and cannot check out the item.
Indicates the line type to use for all uploaded items and quantity-based non-catalog requests.
The value selected should be distinct from the values selected for POR: Amount Based Services Line Type and POR: Rate Based Services Line Type.
Select only line types with a Purchase Basis of Goods and a Value Basis of Quantity for this profile option.
Specifies the directory where image files are stored. To associate an item with a picture, the image file must be copied to this directory to appear in Oracle iProcurement. This path usually corresponds to the /OA_MEDIA/ directory.
Used for punchout and transparent punchout catalogs. It specifies the proxy server (Web Server) name if your Oracle iProcurement implementation has a proxy setup. The proxy server is typically the same as the proxy server that is set up in users' browsers in your company--for example, www-proxy.company.com. For more information, see the Oracle Procurement Buyer's Guide to Punchout and Transparent Punchout.
Any time you change this profile option, you must restart the Oracle Internet Application Server (iAS) for the change to take effect.
Used for punchout and transparent punchout catalogs. It specifies the port on which the proxy server listens if your Oracle iProcurement implementation has a proxy setup. The port is typically the same as the port that is set up in users' browsers in your company--for example, 80. For more information, see the Oracle Procurement Buyer's Guide to Punchout and Transparent Punchout.
Any time you change this profile option, you must restart the Oracle Internet Application Server (iAS) for the change to take effect.
Specifies the line type for rate-based non-catalog requests. A rate-based request is expressed as a monetary charge for each time period.
The value selected should be distinct from the values selected for POR: Goods Line Type and POR: Amount Based Services Line Type.
Select only line types with a Purchase Basis of Goods and a Value Basis of Quantity for this profile option.
Use this profile option to indicate whether requisitions created in Oracle iProcurement should follow the same numbering schema as Oracle Purchasing, or if requisition numbers should be generated using the database sequence, which may provide an increase in performance.
When set to Yes, requisition numbers are shared across operating units.
The table below lists the profile options that impact iProcurement Internal Requisition.
Profile Option | Default | User Access | System Administration: Site | System Administration: Application | System Administration: Responsibility | System Administration: User |
---|---|---|---|---|---|---|
PO: Legal Requisition Type | Update | Update | Update | |||
POR:Allow Manual Selection of Source | No | Update | Update | Update | Update | |
POR: Select Internal Requisition for Confirm Receipt | Yes | Update | Update | |||
POR: Sync up Need by date on IR with OM | No | Update | ||||
POR: Urgent flag maps to shipping Priority | No | Update |
The table below lists the profile options that impact iProcurement Receiving.
Profile Option | Default | User Access | System Administration: Site | System Administration: Application | System Administration: Responsibility | System Administration: User |
---|---|---|---|---|---|---|
POR: Enable Automatic Debit Memo Creation for Returns | No | Update | Update | Update | Update | Update |
POR: Require Blind Receiving | No | Update | Update | |||
POR: Select Internal Requisition for Confirm Receipt | Yes | Update | Update | |||
POR: Select Inventory Replenishment Lines For Confirm Receipts | Update | |||||
POR: Support review for Express Receive | Yes | Update | Update | Update |
Yes enables automatic creation of debit memos for all return to supplier transactions.
Yes turns on Blind Receiving support in Oracle iProcurement. Blind receiving support requires corresponding setup in Oracle Purchasing. .
If set to Yes, internal requisitions will be included in the confirm receipt notifications sent to the requester. If set to No, internal requisitions will not be included with the confirm receipt notifications sent to the requester.
For Confirm Receipts set this profile option to Yes if you want the Confirm Receipts workflow process to select purchase order shipments with destination type Inventory in addition to purchase order shipments with destination type Expense.
If set to Yes, the Review and Submit page will be shown during express receiving. Otherwise, the requester will be directed to the Confirmation page directly.
The table below lists the profile options that impact iProcurement Requisition Accounting.
Profile Option | Default | User Access | System Administration: Site | System Administration: Application | System Administration: Responsibility | System Administration: User |
---|---|---|---|---|---|---|
PA: Allow Override of PA Distribution in AP/PO | Update | Update | Update | |||
POR: Allow pcard use with encumbrance | Update | Update | ||||
POR: Apply Expense Account Rules to Favorite Charge Accounts | No | Update | Update | Update | Update | Update |
POR: Enable Check Funds | No | Update | Update | Update | Update | Update |
POR: Generate and Display Account at Checkout | No | Update | Update | Update | Update | Update |
POR : Override Supplier P-Card | No | Update | Update | |||
POR : Preferences - Award | Update | Update | Update | Update | Update | |
POR: Preferences - Expenditure Item Date Offset | Update | Update | Update | Update | Update | |
POR: Preferences - Expenditure Org | Update | Update | Update | Update | Update | |
POR : Preferences - Expenditure Type | Update | Update | Update | Update | Update | |
POR : Preferences - Project | Update | Update | Update | Update | Update | |
POR : Preferences - Selected Items Default to Inventory | Update | Update | Update | Update | Update | |
POR : Preferences - SubInventory | Update | Update | Update | Update | Update | |
POR : Preferences - Task | Update | Update | Update | Update | Update |
If set to Yes, a requester can make project related changes to the charge account information in the Edit Charge Account page and Allocate Costs to Multiple accounts page.
This profile controls whether items on a requisition can be charged to P-Cards (both employee and supplier) when encumbrance is turned on. When set to Yes, all eligible items can be charged to a P-Card even when encumbrance is turned on. For all purchase orders charged to a P-Card, the purchase order encumbrance should be manually relieved using Oracle General Ledger.
Set this profile option to Yes when you want the Expense Account Rules to apply to the requester’s Favorite Charge Accounts.
This profile is used to control if check funds is initiated as part of the requisition submission process. Valid values are; Display error on failure, Display warning on failure, and No checkfunds.
If set to Yes, iProcurement generates and displays the charge account at checkout
Yes inidcates that the supplier P-Card takes precedence over employee P-Card when both P-Card types are eligible to be assigned to a requisition line.
Enable requesters to set their preferred award ID.
Enable requesters to set their Expenditure Item Date calculation as sysdate plus this profile value.
Enables requesters to set their expenditure organization for project-related requisitions.
Enables requesters to set their expenditure type for project-related requisitions.
This profile determines the iProcurement result tables.
Enables requesters to set their project number for project related requisitions.
Enables requesters to indicate whether ordered items are to replenish inventory.
If items are to replenish inventory, requesters can select a default subinventory for those items. This is only valid if the POR: Preferences - Inventory Replenishment profile is set to Yes.
Requesters can set their task number for project related requisitions.
The table below lists the profile options that impact iProcurement Requisition Approval.
Profile Option | Default | User Access | System Administration: Site | System Administration: Application | System Administration: Responsibility | System Administration: User |
---|---|---|---|---|---|---|
PO: Allow Requisition Approval Forward Action | Update | |||||
PO: Notification Lines Display Limit | 20 | Update | Update | Update | ||
PO:Workflow Processing Mode | Update | Update | Update | Update | ||
POR: Display Graphical Approval List | Yes | Update | Update | Update | Update | Update |
POR: Reapproval after Contractor Assignment | Always | Update | ||||
POR : System Approvers are Mandatory | Yes | Update |
When this profile is set to Yes; Approve, Reject, Forward, Approve and Forward actions are allowed in a requisition approval notification. Otherwise, only Approve and Reject actions are allowed.
Maximum number of requisition lines to be displayed in a requisition approval notification.
Determines the performance of the Purchasing approval workflow processes. Online completes an entire approval workflow process before letting you proceed to the next activity. Background allows you to proceed to the next activity while the approval process completes in the background. Whichever option you choose, you can always view the current status of a requisition or purchase order through the Requisitions Summary or Purchase Orders Summary windows.
When this profile option is set to Background, you must start the Workflow Background Process, using the System Administration responsibility. It is recommended that you set this process to run frequently, if you are using it for Background mode approvals.
If profile is set to Yes, the approval list graph is displayed
Some contractor requests require contractor assignment after the requisition is created; others do not. (See the Oracle iProcurement online Help for details.) This profile option determines whether reapproval of the requisition is required after contractor assignment. Select Always to always require approval. Conditionally Required means that reapproval is required only if a change has been made that triggers reapproval - for example, at least one line amount has changed, or the requester modified the unit price, quantity, unit of measure, account, distribution, or project information on the requisition during the checkout that follows contractor assignment.
If the new line amount is below the requester's approval limit, then only the requester's reapproval (no additional approval) is required.
Yes indicates that the default approvers on the approver list are mandatory.
The table below lists the profile options that impact iProcurement Requisition Checkout.
Profile Option | Default | User Access | System Administration: Site | System Administration: Application | System Administration: Responsibility | System Administration: User |
---|---|---|---|---|---|---|
POR: Days Needed By | 2 | Update | Update | Update | Update | Update |
PO: Default Need-By Time | Update | |||||
POR : Preferences - Deliver to Location | Update | Update | Update | Update | Update | |
POR : Preferences - Requester | Update | Update | Update | Update | Update | |
POR: One Time Location | Update | Update | Update | Update | ||
POR: Override Location Flag | Yes | Update | Update | Update | ||
POR: Override Requestor | No | Update | Update | Update | ||
TAX: Allow Override of Tax Recovery Rate | Update | Update | Update |
Indicates the default number of days until the requester needs the order. This value is used to calculate the need by date.
Yes indicates that the time is defaulted to need-by dates in purchase order.
Enables requesters to set their preferred deliver to location.
Enables requesters to set a default requester.
Enter the location to be used as the one-time address. iProcurement uses the location code entered here as the one time location. The actual one-time address details are entered during checkout.
If this profile is set to Yes, the default location to deliver orders can be overridden.
If this profile is set to Yes, a requester can override the default requester.
This profile controls the ability to modify the tax recovery rate that can be defaulted during the requisitioning process.
The table below lists the profile options that impact iProcurement Search.
Profile Option | Default | User Access | System Administration: Site | System Administration: Application | System Administration: Responsibility | System Administration: User |
---|---|---|---|---|---|---|
PO: Legal Requisition Type | Update | Update | Update | |||
POR:Allow Manual Selection of Source | No | Update | Update | Update | Update | |
POR: Change Catalog Language | No | Update | Update | Update | Update | Update |
Indicates whether requesters can enter internal requisitions sourced from stock by means of an internal sales order, purchase requisitions sourced from a supplier by means of a purchase order, or both types. Valid values are Both, Internal, and Purchase. Impacts both Oracle Purchasing and Oracle iProcurement.
If set to Yes and internally orderable items are displayed, then the Stocked Internally column will display the Select Source link for all internally orderable items. If set to No, then no distinction will be made between strictly purchasable items and items that are internally orderable.
If catalog items exist in multiple languages, requesters can search for items in a language other than their default session language. For example, if an item exists only in the German version of the catalog, requesters will not find it unless they change their search language to German, using the Change Catalog Language link on the Shop home and search results pages. Set this profile option to Yes to enable requesters to change their search language.
Set this profile option to No to hide the Change Catalog Language link, to restrict requesters to purchasing items only in the default session language. You should set this profile option to No if you do not want requesters to purchase items that are available in languages other than their session language.
The table below lists the profile options that impact iProcurement Services Procurement.
Profile Option | Default | User Access | System Administration: Site | System Administration: Application | System Administration: Responsibility | System Administration: User |
---|---|---|---|---|---|---|
PO: Enable Services Procurement | No | Update | ||||
POR: Contractor Expense Line Type | Update | Update | Update | Update | ||
POR: Reapproval after Contractor Assignment | Always | Update |
The table below lists the profile options that impact the iProcurement User Interface.
Profile Option | Default | User Access | System Administration: Site | System Administration: Application | System Administration: Responsibility | System Administration: User |
---|---|---|---|---|---|---|
ICX: Date format mask | Update | Update | Update | |||
ICX: Language | Update | Update | Update | |||
ICX: Numeric characters | Update | Update | ||||
POR: Catalog Result Set Size | 7 | Update | Update | Update | Update | Update |
POR: Default Shopping Sort | Update | Update | ||||
POR: Default Shopping Sort Order | Ascending | Update | Update | |||
POR: Display Graphical Approval List | Yes | Update | Update | Update | Update | Update |
POR: Display Legacy Accounting Flex UI | No | Update | Update | Update | Update | Update |
POR: Display Shopping Category Count | Yes | Update | Update | Update | ||
POR: Enable Advanced Search | Update | Update | Update | Update | ||
POR: My Favorite Store | -1 | Update | Update | Update | Update | Update |
POR: Result Set Size | 10 | Update | Update | Update | Update | Update |
POR: Search Results Skin | Paragraph | Update | Update | Update | Update | Update |
POR: Show Thumbnail Images | Yes | Update | Update | Update | Update | Update |
POR: Thumbnail Height | Update | Update | Update | Update | Update | |
POR: Thumbnail Width | Update | Update | Update | Update | Update |
This profile determines the default number of rows shown in iProcurement catalog search result tables..
Determines the item attribute that is used to sort search results by default. Replaces POR: Sort by Relevance. Relevance may still be used here.
Determines the default sort order to be ascending or descending. Used together with POR: Default Shopping Sort.
Determines whether to use the charge account key flexfield user interface from previous releases on the Edit Lines page during checkout. This user interface displays the charge account as separate segments, in separate fields. The settings are:
Yes: The separate segments appear.
No: The new user interface displays the segments in a single field
If this profile is set to Yes, Oracle iProcurement displays the count of items within each shopping category on the Shop home page. When the item count is enabled, iProcurement removes browsing categories that do not have items from the requester's view.
Set this profile option if you are not using a local content zone, but are implementing only punchout or transparent punchout content zones. Punchout and transparent punchout content zones do not use the advanced searching feature; only local content uses these. Therefore, if you are implementing only punchout or transparent punchout content zones, you can set this profile option to No to hide all Advanced Search links. If this profile option is set to No, requesters can still use standard searching, which includes searching of punchout and transparent punchout content zones; only the advanced searching feature is disabled.
Specifies the store that always displays at the top of the Shop page. If no favorite store is specified, or if you specify -1 for this profile option, Oracle iProcurement displays the system-assigned store as the favorite store. The system-assigned store is the store that the requester has access to that has the lowest sequence number.
Indicates how many records per page requesters see when viewing search results on the Receiving and Requisition Status pages.
Inidcates the skin in which search results are displayed. Values are Paragraph or Grid. See the iProcurement online Help for details.
Set this profile option to control whether thumbnail images loaded to the local catalog appears on the Search Results Summary and Search Results pages. For example, to wait until all thumbnail images are loaded before displaying them or, if you encounter issues, set this profile option to No to hide all thumbnail images.
To display all thumbnail images, set this profile option to Yes.
This profile option sets the default, but requesters can also choose whether to display thumbnail images using their iProcurement Preferences. For example, if this profile option is set to No, a requester can choose Yes to display them for oneself.
Note: The purpose of this profile option is to temporarily show or hide thumbnail images. This profile option does not control whether thumbnail images appears on the Compare Item page. Use schema editing to control that page.
Set this profile option if you are uploading items to the local catalog and you want to specify thumbnail images for the items. Thumbnail images appear on the Search Results Summary, Search Results, and Compare Items pages. Use this profile option to specify the height, in number of pixels, for all thumbnail images. Use this profile option when the size of the source file needs to be adjusted for thumbnail images. (It is recommended that you set either this or the POR: Thumbnail Width profile option rather than both profile options, to avoid fixed sizing.
Set this profile option if you are uploading items to the local catalog and you want to specify thumbnail images for the items. Thumbnail images appear on the Search Results Summary, Search Results, and Compare Items pages. Use this profile option to specify the width, in number of pixels, for all thumbnail images. Use this profile option when the size of the source file needs to be adjusted for thumbnail images. (It is recommended that you set either this or the POR: Thumbnail Height profile option rather than both profile options, to avoid fixed sizing