Previous  Next          Contents    Library

Oracle Purchasing Documentation Updates

This document contains important information. Please read this section for the latest updates, revisions, and additions to your user's guide.

Setup Overview

Important setup information needs to be added to the "Setup Overview" section.

See: Setup Overview.

Define Locations (Required)

Add this step after Step 3 Set Up Calendars, Currencies, and Set of Books. See: Site Locations.

If you're also setting up other Oracle applications, you may already have defined locations when you set up those applications.

Define Freight Carriers (Optional)

Add this step after Step 5 Set Up Units of Measure. See: Defining Freight Carriers.

Note: You must perform this step for each inventory organization.

If you're also setting up Oracle Inventory, you may already have defined freight carriers when you set up Inventory.

Define Categories

Add this step after Step 6 Set Up Items.

Defining categories involves the following tasks:

If you're also setting up Oracle Inventory, you should already have defined categories when you set up Inventory.

Define Payment Terms (Optional)

Add this step after Step 13 Set Up Cross-Reference Types, Tax Names, and Location Associations. See: Payment Terms.

If you're also setting up Oracle Payables, you may already have defined payment terms when you set up Payables.

Define Transaction Reasons (Optional)

Add this step after Step 22 Set Up Financial Options. See: Defining Transaction Reasons.

If you're also setting up Oracle Inventory, you may already have defined transaction reasons when you set up Inventory.

Set Up Approval Workflow Option (Required with defaults)

Add this step after Step 30 Modify Change Order Workflow Options. See the section "Choosing Workflow Options" later in this document for information on setting up this approval workflow option.

Additional Setup Notes

If you want to define catalog groups, which is optional, do so after the step Define Categories above. See: Defining Item Catalog Groups. (If you're also setting up Oracle Inventory, you may already have defined item catalog groups when you set up Inventory.)

If you want to define descriptive flexfields, do so last, after all the other setup steps. See: Oracle Applications Flexfields Guide.

Choosing Workflow Options

In addition to the other workflow setup options described in the section "Choosing Workflow Options" in your documentation, you need to consider one more option--an item attribute in the Main Requisition Approval Process called "Send PO Autocreation to Background."

Send PO Autocreation to Background

This item attribute is used by the "Get AutoCreate PO Mode" function activity in the Main Requisition Approval Process. By default, the attribute is set to 'Y' for Yes, to send automatic document creation to background mode. But you can change it to 'N' for No if you'd rather process automatic document creation in online mode.

Background and online modes affect your system performance in different ways. For more information on what background and online mean, see PO: Workflow Processing Mode in the section Profile Options in Purchasing.

Attention: Since this attribute is set to 'Y' by default--which means automatic document creation occurs in background mode--you must start the Workflow Background Process in the Submit Requests window in the System Administrator responsibility. As long as this attribute is set to 'Y,' you must start the Workflow Background Process. You can submit the process for all workflows or just for a particular workflow, in this case the PO Requisition Approval workflow. See: To Schedule Background Engines.

Note: A function activity in both the PO and Requisition Approval workflows, called "Get Workflow Approval Mode," sets the processing mode for the entire approval workflow in Purchasing, based on how the profile option PO: Workflow Processing Mode is set. While this function activity sets the processing mode for the entire approval workflow in Purchasing, the item attribute "Send PO Autocreation to Background" enables you to change the processing mode specifically for automatic document creation, regardless of how the profile option PO: Workflow Processing Mode is set. "Send PO Autocreation to Background" informs the function activity "Get AutoCreate PO Mode" whether "Launch Create PO Workflow" in the Main Requisition Approval Process should initiate automatic document creation in background or online modes.

See:

Choosing Workflow Options

Approval Workflows

Profile Options in Purchasing

The first description below is about a new profile option. The second contains more information about a profile option already described in your documentation.

PO: Set Debug Concurrent ON

This profile option is used, usually by technical support staff only, for finding problems with Requisition Import. The default value is No. The user can view and update this profile option. It can also be updated at the user, responsibility, application, and site levels.

Caution: For performance reasons, it is very important that this profile option always be set to No, unless you are instructed otherwise by Oracle Corporation.

PO: Set Debug Workflow ON

This profile option is used, usually by technical support staff only, for finding problems with Purchasing workflow processes. The default value is No. The user can view and update this profile option. It can also be updated at the user, responsibility, application, and site levels.

Caution: For performance reasons, it is very important that this profile option always be set to No, unless you are instructed otherwise by Oracle Corporation.

See:

Profile Options in Purchasing

Using the Account Generator in Oracle Purchasing

Note the changes described here if you need to open and view, or customize, the Account Generator in Purchasing.

The section "Using the Account Generator in Oracle Purchasing" currently lists eight Account Generator workflows (also called item types) that automatically build charge, budget, accrual, and variance accounts--four for purchase orders and releases, and four for requisitions.

However, to enhance the performance of the Account Generator in Purchasing whenever an account is generated on a purchase order or requisition, these eight item types were recently collapsed into two--one for purchase orders and releases, and one for requisitions:

This means that when you open (or customize) an Account Generator item type in the Oracle Workflow Builder, you'll see (or customize) just these two--not eight, as described in your documentation currently.

Collapsing the eight item types into two has not changed anything else about how the Account Generator in Purchasing works as described currently in your documentation. However, it does change how the processes are organized within the two item types, and what you can and cannot customize.

The following sections show which parts of your documentation need to be updated accordingly.

See: Using the Account Generator in Oracle Purchasing

Decide How to Use the Account Generator

This section is unchanged. See your current documentation for the latest information.

The Default Account Generator Processes for Oracle Purchasing

For this section, substitute the following information.

Evaluate whether the default Account Generator processes meet your accounting requirements. No setup steps are required to use the default. The default processes can also be updated later as your needs change.

Note: If you used FlexBuilder in Release 10 but did not customize the default configuration, you can use the default Account Generator process in Release 11, which gives you the same result as the default assignments in FlexBuilder.

Each Account Generator workflow is called an item type. Purchasing comes with the following Account Generator item types for purchase orders, releases, and requisitions:

Each item type above contains the following top-level processes:

In turn, each of these top-level processes contains other processes within them and, within these, additional subprocesses and function activities. These are described below.

Viewing Account Generator Processes in the Workflow Builder

For this section, substitute the following information.

To open the PO Account Generator in the Oracle Workflow Builder, choose Open from the File menu and select PO Account Generator. To open the PO Requisition Account Generator in the Workflow Builder, choose Open from the File menu and select PO Requisition Account Generator. Explore how these item types break down in the Workflow Builder's Navigator.

Although all the processes are listed together in the Workflow Builder's Navigator, only two--Generate Default Accounts and Generate Accounts Using FlexBuilder Rules--are the top-level processes. Note that the icons for the two top-level processes look slightly different from the other process icons, indicating that they are the top-most processes. The rest of the processes belong to the two top-level processes. For example, when you open (double-click) the top-level process Generate Default Accounts to view it as a diagram, you see it contains four main processes--Generate Default Accrual Account, Generate Default Budget Account, Generate Default Charge Account, and Generate Default Variance Account.

When you open the process Generate Default Accrual Account, you see it contains many function activities and one subprocess--Build Project Related Account. (For an example of how a default Account Generator process itself looks in the Workflow Builder, see the current Purchasing documentation.) As you can see, all of these processes and subprocesses are listed under Processes in the Workflow Builder's Navigator.

To better understand which processes are subprocesses of the others, use the following structural breakdown:

Standard Flexfield Workflow

All of the processes listed above contain additional function activities not listed here, such as Start and End function activities. These are standard function activities provided in the Standard Flexfield Workflow item type. These also include the function activities "Copy Values from Code Combination" and "Validate Code Combination" that you see used in the Account Generator processes. For information on how to use these function activities, see the Oracle Applications Flexfields Guide.

Item Attributes

Each account generator (workflow item type) contains a number of item attributes. These attributes correspond to all the raw parameters and some derived parameters that were used in FlexBuilder. The item attributes for the PO Requisition Account Generator are slightly different from the item attributes for the PO Account Generator.

Build Project Related Account

The subprocess Build Project Related Account is available for you to customize if Oracle Projects is installed. To use this process, you provide your own rules to the process, in the form of workflow process definitions, to build the account.

For more information about using the Account Generator when you integrate Purchasing with Oracle Projects, read the following essay: Using the Account Generator in Oracle Projects.

What the Account Generator Does in Oracle Purchasing

This section is unchanged. See your current documentation for the latest information.

Generate Account Using FlexBuilder Rules Process

For this section, substitute the following information.

If you customized FlexBuilder in a previous release to generate account combinations, you can use the Generate Accounts Using FlexBuilder Rules process to replicate your FlexBuilder setup automatically, without changing any of your predefined FlexBuilder Rules, and without customizing the Account Generator. This top-level process consists of the following processes:

To build accounts, these processes call the appropriate functions that were generated during your upgrade from Release 10 to Release 11.

If you are upgrading from Release 10, follow the guidelines in the FlexBuilder chapter of the Oracle Applications Upgrade Preparation Manual.

Customizing the Account Generator for Oracle Purchasing

For this section, substitute the following information.

Purchasing provides default Account Generator processes for you to use. If the defaults do not satisfy your accounting requirements, you can use the Oracle Workflow Builder to customize the default processes.

You can customize any of the following processes and the subprocesses within them:

You cannot customize the two top-level processes:

You cannot customize any process belonging to Generate Accounts Using FlexBuilder Rules:

You cannot customize most function activities, since these map directly to PL/SQL programs in the Oracle database, but you can replace a function activity with one of your own. See Customization Example below.

If you want to create a new process or customize an existing one to meet your business needs, make a backup copy of the default processes that Oracle provides, and then use the Oracle Workflow Builder to customize a process or create a new one.

For more information on the generic features and functions of the Account Generator, see Customizing the Account Generator.

For more information on how to use the Oracle Workflow Builder, see the Oracle Workflow Guide.

Customization Guidelines

For this section, substitute the following information.

When you choose to customize the Account Generator in Purchasing, consider the following:

Once the Account Generator successfully builds accounts for a document, it does not attempt to rebuild when you update the document. For example, if you build a custom process to generate the requisition charge account for Expense purchases based on requestor, and change the requestor after the Account Generator constructs the charge account, it will not attempt to rebuild.

Requisition Import does not use the Account Generator to construct charge, budget, accrual, or variance accounts. Any custom process that you create cannot be used by this utility.

Customization Example

For this section, substitute the following information.

In the Generate Default Charge Account process, under the PO Account Generator item type, you could modify the Build Expense Charge Account subprocess by replacing the Get Expense Account ID function activity with one of your own. A new function activity, however, must have the same result type as the function activity you replace. In your new function activity in this example, you also must set the item attribute, Temp Account ID, with the code combination identification number (CCID) of the account being built. This attribute is used by the function activity, Copy Values from Account ID, to fetch the concatenated segments.

You must test any customizations to the Account Generator before using them on a production database.

Implementing a Customized Account Generator Process

For this section, substitute the following information.

Use the Account Generator Processes window to choose either the Generate Default Accounts process or the Generate Accounts Using FlexBuilder Rules process and associate the process with the appropriate Accounting Flexfield structure and item type.

Choosing the Process for a Flexfield Structure

For this section, substitute the following information.

If you customize any of the customizable processes belonging to the Generate Default Accounts process, and you make sure the Generate Default Accounts process is associated with the appropriate Accounting Flexfield structure and item type in the Account Generator Processes window, your customizations will take effect.

Using the Account Generator Profile Option

This section is unchanged. See your current documentation for the latest information.

Receiving Catalog Information Electronically

The Purchasing Documents Open Interface supports price breaks. If you additionally want to import price break information through the Purchasing Documents Open Interface, add the following information to the Purchasing Documents Open Interface section of the Oracle Manufacturing, Distribution, Sales and Service Open Interfaces Manual, Release 11.

Importing Price Break Information

The following, additional columns are required in the PO_LINES_INTERFACE table if you want to import price break information:

If you are importing price break information through catalog quotations, you can also, optionally populate the following columns in the PO_LINES_INTERFACE table:

Recall that the PO_LINES_INTERFACE table contains both line and shipment information, and imports data into both the PO_LINES and PO_LINE_LOCATIONS tables in Purchasing. So, if you wanted to create two price breaks corresponding to one blanket agreement or quotation line, you would create two records in the PO_LINES_INTERFACE table. That is, one header-level record in the PO_HEADERS_INTERFACE table would have two records in the PO_LINES_INTERFACE table, and both of these line records would have the same INTERFACE_HEADER_ID.

For example:

Header: one header-level record (row) in PO_HEADERS_INTERFACE corresponds to:

See:

Receiving Price/Sales Catalog Information Electronically

Purchasing Documents Open Interface, Oracle Manufacturing, Distribution, Sales and Service Open Interfaces Manual, Release 11

Confirm Receipts Workflow Select Orders Process

The Confirm Receipts Workflow Select Orders process in Purchasing must be running in order to use the Confirm Receipts workflow. The Confirm Receipts workflow sends notifications through the Web, e-mail, or Notifications Summary window to requestors or buyers who create requisitions through Oracle Self-Service Web Applications or Purchasing. It lets people know that they should have received an item.

The Confirm Receipts workflow sends notifications for items with a Destination or Deliver-To Type of Expense, a Routing of Direct Delivery, and a Need-By date that is equal to or later than the current date.

The Workflow Background Process must be running before you can submit the Confirm Receipts Workflow Select Orders process. In the Submit Requests window, in the System Administrator responsibility, select Workflow Background Process in the Request Name field. See: To Schedule Background Engines.

To submit the Confirm Receipts Workflow Select Orders process, navigate to the Submit Requests window, select Confirm Receipts Workflow Select Orders in the Request Name field, choose Schedule, and choose how often you want the process to run. For example, if you set it to run one or two times a day, the Confirm Receipts workflow will query for purchase orders that meet the criteria described above and send notifications (if required) one or two times a day.

See: Confirm Receipts


         Previous  Next          Contents    Library