Purchase Requisitions

Overview of Requisitions

A requisition is created when you add items to a shopping cart (catalog or non-catalog items) and checkout the items. Checkout is a 3-stage process. Each stage has it’s own page and sub-pages that you can drill down to, in order to enter the information relevant to the requisition. Given below are the details of the 3-stage checkout process.

Note: Please note that internal requisitions are not supported in CLM.

Preferences page

Click the Preferences link located at the top of the page to view and edit the default values that will appear on the requisition. The CLM Preferences (Office and Contacts defaults) link opens a region that enables you to select the Location and Contact for an Office Type (COTR Office, Requesting Office, Issuing Office etc.). The selected master data defaults the addresses and charge account information on the requisition. You can change the values of the defaulted data on the specific requisition. This data on the requisition is retained, even if the preference settings change at a later point of time.

Checkout: Requisition Information

The first stage displays the Checkout: Requisition Information page. Enter the relevant requisition header information on this page.

A requisition number is automatically assigned to the requisition. This number typically has the following structure, which can be changed during setup: Prefix-Fiscal Year-Agency Identifier- Serial Number (example: PR-10-CDC-12345). For more information on document numbering, please refer to the appendix - Common CLM Functionality.

For more information on setting up CLM document numbering, please refer to the Oracle Contract Lifecycle Management for Public Sector Implementation Guide.

Click the Edit Requisition Number link below the Requisition Number to change the numbering sequences and serial numbers via the popup.

Enter a Requisition Description that will help you to identify the requisition’s purpose. The requisition description is defaulted from the description of the first item. This is a mandatory field.

Addresses region

The Addresses region in the Checkout: Requisition Information page enables you to enter the relevant office addresses and contacts for the following offices. Please note that the addresses and contact information default based on the address preference setup in the Preferences page, however you can overwrite the default values.

Business Priority and Project Information region

The fields in the Business Priority and Project Information region are:

Sourcing Information region

The fields in the Sourcing Information region are:

Delivery Information region

The following fields are in the Delivery Information region. Fields in this region are used to enter default values for all the lines in the requisition.

Billing region

The information in this region is related to Oracle Projects and Billing. Fields in this region are used to enter default values for all the lines in the requisition. For more information, please refer to the Oracle iProcurement Implementation and Administration Guide.

Editing Requisition Lines

In the Checkout: Requisition Information page, click Edit Lines in order to view and edit the requisition lines.

The Line Number is automatically populated for you. A line can be a CLIN (contract line) or a SLIN (sub-line). A CLIN/SLIN can be a priced line or an informational line. An informational line does not have any pricing details associated with it. Similarly, SLINs, which are used to capture additional information about the CLIN, can be priced sub-lines or informational sub-lines.

CLIN numbers are always 4 digit numeric values that fall in the range 0001-9999. SLINS are lines that use a 6-character numbering format – numeric or alphanumeric. The first 4 digits of the SLINs are populated with the parent CLIN number. The next 2 digits are automatically generated, based on whether the SLIN is a Priced sub-line or an Informational sub-line. Informational SLINs have the last 2 digits numeric values in the range 01-99. For Priced SLINs, the last 2 digits are always alphabetical values ranging from AA to ZZ (except the alphabets I and O which are not used in number generation at all).

A CLIN or SLIN can be further defined as an Option Line. An Option Line stores and displays information that is used at a future point in time. For example, in a CLIN/SLIN structure that consists of the following, SLIN 0001AD is an Option Line:

In the example above, the SLIN 0001AD can be exercised or used only in the future (i.e. when the warranty coverage for the above hardware part expires).

The Requisition Information: Edit Lines page consists of 4 tabs – Delivery, Billing, Accounts, and Attachments.

Using the Edit Lines page, you can edit the line information in the Delivery, Project, Item and Accounting tabs. You can also perform actions such as copy, delete and reorganize the CLIN/SLIN structure of the requisition lines.

Delivery: The fields that you can change on the Delivery tab are: Need-By Date, Period of Performance Start Date, Period of Performance End Date, Requestor, Deliver-To Location, and Destination Type.

Note: Please note that Need-By Date and the Period of Performance dates cannot be entered together, you would need to enter either one of them.

Billing: Select a p-card if applicable. The fields you can change on the Billing tab are: Project, Expenditure Type, Expenditure Organization, Expenditure Item Date.

Click the Split icon to split the line into 2 or more billing lines. The Requisition Information: Split Cost Allocation page opens, enabling you to split the line. Click Apply to return to the Edit Lines page.

Accounts: The charge account for the line is defaulted in this tab, along with the line information. You can also split the line into 2 or more lines using the Split icon.

Click the Charge Account hyperlink in order to enter the funding and other account related information for the line.

External Account: In cases where CLM is used without Oracle e-Business Suite as the backing financial system or when a CLM site needs to use funds from another agency, the External Account field is present to record line of accounting that represents the funds from the other system. This is a free text, non segmented, non-validated field that can be printed and externally integrated.

Defense Funding: This checkbox determines if the LOA (Line of Accounting) is provided from the DoD or not. In case of DoD orders, this information is relevant for FPDS-NG reporting.

Operations Accounting Flex: This flexfield displays the segment-wise combination of the account. You can click on the Search icon next to the field and choose another combination of segments for the account. This flexfield name is dependent on the organization's accounting structure.

FMS Case Number: Foreign Military Sales (FMS) case number, which is assigned for DoD purchases for FMS. It is used for FPDS-NG reporting and other roll up reporting so the amount of money spent can be tracked. This free-text field displays regardless of whether the Charge Account or External Account is being utilized.

Agency Accounting Identifier: This field is used to identify the accounting system to which funds belong. This free-text field displays regardless of whether the Charge Account or External Account is being utilized.

Note: 'Apply this Cost Allocation information to all applicable requisition lines' is not supported in CLM.

You can enter a funded value in the Split Cost Allocation page. The funded value is defaulted to the total line amount in the Accounts tab. However this can be modified and the funded value may be 0 or less than the line amount. The Partial Funded checkbox is selected to indicate that the funded value is less than the line amount. The following funding-related fields are in the Accounts tab to capture the funding information:

For more information on Funding, please refer to the appendix - Common CLM Functionality.

Attachments: Add an attachment to the line by selecting the Add Attachments icon. The Add Attachments page displays, with the attachment options. Click Add Another to add another attachment, or click Apply to save your attachment to the line and return to the Edit Lines page.

Actions:

From any of the tabs (except the Attachments tab), select a line using the Select checkbox and then click Update. The line information is available for you to update.

Using any of the tabs (except the Attachments tab), select a line using the Select checkbox and then click Copy. The line information is copied to a new line.

Using any of the tabs (except the Attachments tab), select a line using the Select checkbox and then click Delete. The line is deleted from the requisition.

If you perform actions such as copy and delete on a line that has sub-lines and/or option lines, then entire line structure gets copied/deleted.

Using any of the tabs (except the Attachments tab), select a line using the Select checkbox and then click Move. The Organize Lines page opens, enabling you to move the selected line before or after other lines.

Organize Lines

The Organize Lines page consists of 2 regions: Current Structure (source) and Target Structure (destination). Select one or more lines by clicking on the Select checkbox in the Current Structure region. Then select the type of move you wish to perform using the Select Action LOV in the Target Structure region. Select from one of the 3 possible values: Move After Selected Line (moves the line after the line you selected in the Edit Lines page), Move Before Selected Line (moves the line above the line you selected in the Edit Lines page) and Move as sub-line(s) under selected line (moves a line as a SLIN under a CLIN). Click Done to save and apply your changes and return to the Edit Lines page. The Edit Lines page displays, showing you the new structure of the lines.

Update Selected Lines

When you need to change any values of the items that you created while shopping, you can use the Update Selected Lines page to make updates to the item line information. If you have selected a line and clicked Update, the Requisition Information: Update Selected Line page opens with the following regions:

Item region

Most of the requisition information is defaulted on this page. Enter or update the rest of the fields, if required.

Pricing related fields are displayed if the line is a priced line. If the line is Informational, the pricing related fields are not displayed.

Select a Contract Type - The Contract Type list is used to determine the pricing calculation for the item or service to be procured. For example, if the Contract Type is Firm Fixed Price, the price is calculated as Quantity * Unit Price. For an item type of Goods billed by Quantity, the Contract Types are different from the item type of Goods or Services billed by Amount. For more information on Contract Types and their pricing formulas, please refer to the appendix - Common CLM Functionality.

Enter a Cost Constraint while updating the line, if required. The default value of the Cost Constraint list is Null. A Cost Constraint is an indicator at CLIN/SLIN level that controls the pricing and/or the document printing behavior for that CLIN/SLIN.

Enter a Quantity, Unit of Measure, Unit Price, Currency as per your requirements. The total line amount is automatically calculated for that item or service. The total line amount is calculated for that Contract Type and the formula that was used in calculating the total line amount is displayed below the final price value. The field label of the total line amount is also subject to change, depending on the contract type selected by you. Example: For some contract types, the total line amount may be called Extended Price and for other contract types, it may be called Total Amount.

Below the Extended Price field, a pricing formula is displayed, telling you the formula that was used in calculating the Extended Price. For goods or services billed by amount line types only, the Pricing Details hyperlink is displayed; on clicking the hyperlink, the Pricing Details popup displays, showing you additional pricing attributes that contribute to the calculation of the total line amount.

Note: Please note that rate based temp labor line types are not supported in CLM.

Supplier region

Enter the supplier information that you will need to procure the items from. If you enter supplier information for a non-catalog request, selecting the New Supplier check box tells iProcurement not to validate the supplier. This allows you to enter a name for suppliers that are not yet approved for use by your organization. It does not add them to your supplier base.

Please note that the Supplier region is updateable for non-catalog items only. In case of catalog items, the Supplier region is view-only and you cannot update it.

Additional Item Information region

This region contains additional information about the item to be procured.

Federal Customer Designation region

The fields within this region provide information that will allow the requester to designate a particular classification code, project and/or program to the item being procured.

Additional Shipping Information region

The fields in this region provide specific shipment information about the items being procured.

Inspection Information region

The fields in this region enable you to define the specific inspection location for the items/goods being procured.

Delivery region

Billing region

This region consists of fields associated to Oracle Projects. For more information on this region, please refer to the Oracle iProcurement Implementation and Administration Guide.

Notes and Attachments region

Add notes or attachments using this region. Notes are usually short texts that you need to communicate to suppliers. You can also attach documents in the line details by clicking the Add Attachments icon. The Add Attachment page displays, and you can add an attachment of type Desktop File/Text/URL or From Document Catalog to the requisition line. Enter the Attachment Summary Information and then define the attachment by selecting a File, URL or text to attach. Click Add Another if you wish to attach another document in addition to the one you have just attached. Click Apply to save your attachment to the checkout and return to the checkout process.

Click Apply to save your changes and proceed with the checkout.

Checkout: Approvals and Notes

Step 2 of the checkout process involves viewing and managing approvals and notes. View the sequence of approvers for your requisition and enter a justification if you need to make any changes to the approval hierarchy. Optionally enter a note to the buyer.

You can attach documents during the checkout by clicking the Add Attachment button. The Add Attachment page displays, and you can add an attachment of type Desktop File/Text/URL or From Document Catalog. Enter the Attachment Summary Information and then define the attachment by selecting a File, URL or text to attach. Click Add Another if you wish to attach another document in addition to the one you have just attached. Click Apply to save your attachment to the checkout and return to the checkout process.

For more information on setting up approvals management, please refer to the Oracle Contract Lifecycle Management for Public Sector Implementation Guide.

Checkout: Review and Submit

Step 3 of the checkout process involves reviewing and submitting the requisition for approval. A requisition number is displayed at the top of the Checkout: Review and Submit page, along with the Total (with Options) of the Requisition lines and Total Without Options. The Total value of the requisition includes option line values. The Total Without Options value excludes the values of the option lines. For more information on Options, please refer to the Editing Requisition Lines section in this chapter.

If you have attached any documents to the requisition, the Requisition Attachments region displays a summary line of the attachments.

The Lines region displays all the lines that have been created as part of the requisition. Click on the Show link to display a few more requisition details, including Billing Information.

Click Submit to submit the requisition for approval. You can continue to create further requisitions using the Continue Shopping button, which takes you back to the Stores tab.

When the requisition is approved, use it to create a solicitation or an award using Document Builder in the CLM Sourcing or CLM Purchasing modules.

Requisitions - Views and Search

The Requisitions > Requisitions tab consists of a View region where you can see requisitions according to the view selected. For example, you can see the requisitions that you have created using the All My Requisitions view. Select a view from the View LOV and click Go. The Views region populates with the relevant requisition details.

Search for a requisition that you do not see in your view by clicking Search. The Requisitions Search page enables you to enter one or multiple search criteria to find your requisition. For example, you can search by Requester, Requisition Number, Issuing Office, Suggested COTR Office Address, Suggested COTR Office Contact, Suggested Award etc. Enter values in the Search Criteria fields and then click Go. The search results display in the region below. The search results display the requisition numbers with a hyperlink, so you can click on any requisition number and open it to view the details of the requisition. If the requisition has an order associated to it (that is, an order has been created from the requisition), the order number displays in the search results as well.

Some of the actions that you can perform by selecting a requisition (use the Select radio button) and clicking the appropriate action button (either in the search results page or in the Views page):

Notifications

Unlike the Notifications region in the Stores page that displays the recent notifications only, this Requisitions > Notifications page displays all the notifications depending on the Notifications View that you select. The Views LOV displays the following seeded notification views: All Notifications, FYI Notifications, Notifications From Me, Open Notifications, To Do Notifications.

You can perform the following actions after selecting one or more notifications: Open a notification, Reassign a notification to another approver, Close a notification.

Approvals

The Requisitions > Approvals page has a View region where you can view requisitions at different stages of approval. For example, the seeded views in the page are: Requisitions I Have Approved and Requisitions to Approve. The results of the view are displayed in the region below. Select a requisition by clicking on the Select radio button and then perform any of the following actions:

Use Search to enter search criteria to look for a requisition or a set of similar requisitions. Search for a requisition that you do not see in your view by clicking Search. The Requisitions Search page enables you to enter one or multiple search criteria to find your requisition. For example, you can search by Requester, Requisition Number, Issuing Office, Suggested COTR Office Address, Suggested COTR Office Contact, Suggested Award etc. Enter values in the Search Criteria fields and then click Go. The search results display in the region below. The search results display the requisition numbers with a hyperlink, so you can click on any requisition number and open it to view the details of the requisition. If the requisition has an order associated to it (that is, an order has been created from the requisition), the order number displays in the search results as well. Using the search results, you can select a requisition and perform the following actions: