Requisition White paper, Exams of Computer science

Download Requisition White paper and more Exams Computer science in PDF only on Docsity!

An Oracle White Paper

June 2013

Requisition Import

Oracle Fusion Self Service Procurement 11.1.7.0.

• Introduction
• Importing Requisitions
• Grouping Requisitions
• Understanding the Interface Tables
• How to Read this Document
• Requisition Header Interface Table
• Requisition Line Interface Table
• Requisition Distribution Interface Table
• Resolving Failed Requisition Interface Rows

Figure 1. Import Requisition Process

Importing Requisitions

The Import Requisitions process is used to import requisitions from Oracle applications or external

applications into Oracle Fusion Self Service Procurement. The task Import Requisitions is controlled

by the privilege Import Requisition. By default, the buyer inherits the Requisition Import Submission

Duty, which contains the Import Requisition privilege. Thus the Import Requisition task is available by

default from the Purchasing work area.

As part of the External Data Integration Services for Oracle Cloud feature, predefined Excel templates

are available to load data to interface tables. The scheduled process Load Interface File for Import

Requisitions loads transaction data from the data file on the content management server to the

interface tables. For convenience, the ID columns are not available in the Excel templates and will be

derived by the application.

The table below displays details of the input parameters of the Import Requisitions process:

Table 1. Input Parameters

ATTRIBUTE REQUIRED DEFAULT DESCRIPTION AND VALIDATION

Import Source No Used to retrieve the correct set of records for processing by matching the values provided for the attribute INTERFACE_SOURCE_CODE in the interface table.

Import Batch ID

No Used to retrieve the correct set of records for processing by matching against the records in the interface tables.

Maximum Batch Size

No 2,500 Number field used to limit the number of requisition lines that will be batch processed. If the parameter is not specified, the default value of 2500 will be used as the maximum batch size.

Requisitioning BU

Yes Only the records with the specified requisitioning BU are processed.

Group By Yes From the Requisitioning BU Configuration Choice list with the following choices: Item, Buyer, Category, Location, Supplier, and None (where None means group all requisition lines together). This field is dependent on the Requisitioning BU field: When a requisitioning BU is selected, the Group Requisition Import By value from the

How to Read this Document

This section contains details of the Requisition Header Interface Table, Requisition Line

Interface Table, and Requisition Distribution Interface Table.

• Attribute column: Indicates the name of the attribute as it appears in the interface table

definition.

• Oracle Cloud Spreadsheet Column: Indicates the name of the attribute as it appears in the

Oracle Cloud spreadsheet.

• Required Column: Indicates whether or not a value for the attribute is required.
• Default Column: Indicates whether the application can default any value to the attribute.

Certain required attributes can also have a default value. In those cases, when the attribute is null in the

interface table, the application will attempt to obtain a default value. If the application cannot

determine a default value for a required attribute that has a null value in the interface table, an error will

be raised.

The attributes indicated as N/A (Not Applicable) in the required column, are attributes that are

populated by the application and should not be provided by the integrating application.

1. Description and Validation columns: Provides a brief description of the attribute and any

additional validation applied to the loaded data.

2. Data Type column: Indicates whether the attribute is number, text, date, or timestamp.
3. Size column: Provides the size in bytes for each attribute.

Requisition Header Interface Table

Table 3. Requisition Header Interface Table

ATTRIBUTE ORACLE CLOUD SPREADSHEET COLUMN

REQUIRED DEFAULT DESCRIPTION AND VALIDATION

DATA TYPE

SIZE (IN BYTES)

REQ_HEADER_INTER

FACE_ID

N/A Yes Requisition header interface unique identifier.

Number 18

PROCESS_FLAG N/A N/A Application-updated flag that tracks the processing status of the record in the interface table.

Text 30

INTERFACE_SOURCE

_CODE

Interface Source Code

Yes The source from which the requisition lines were submitted for processing. If a value is provided during job submission, it is used to match the requisition lines

Text 25

ATTRIBUTE ORACLE CLOUD

SPREADSHEET COLUMN

REQUIRED DEFAULT DESCRIPTION AND VALIDATION

DATA TYPE

SIZE (IN BYTES)

that are selected for processing.

INTERFACE_SOURCE _LINE_ID

Interface Source Line ID

No Source transaction reference identification.

Number 18

DOCUMENT_STATUS Status Code Yes Status code of the requisition. The possible lookup code values are INCOMPLETE, and APPROVED.

When loading incomplete requisitions, you can set the input parameter Initiate Approval After Requisition Import to Y, so the requisition is submitted for approval once it is fully loaded in the requisition tables.

Text 25

BATCH_ID Batch ID No An identifier if provided during job submission that is used to match the requisition lines that are selected for processing.

Number 18

APPROVER_ID N/A Yes (When document status = APPROVED and approver e-mail is null.)

Unique identification of the approver of the requisition. The person ID must be provided within Oracle Fusion Application.

Number 18

APPROVER_EMAIL Approver Yes (When document status = APPROVED and approver ID is null.)

E-mail of the requisition approver.

The approver e-mail is used to derive the Approver ID.

Text 240

JUSTIFICATION Justification No Reason for the requisition. Text 1000

PREPARER_ID N/A Yes (If preparer e- mail is null.)

Unique identifier of the person who created the requisition.

Number 18

PREPARER_EMAIL Entered By Yes (If preparer ID is null.)

E-mail of the person who created the requisition.

The preparer e-mail is used to derive the preparer ID.

Text 240

REQUISITION_NUMBE

R

Requisition Yes Next requisition number input parameter or from the Configure d Requisitio

Number used to identify the requisition.

The requisition number must be unique within a requisitioning BU.

Text 64

ATTRIBUTE ORACLE CLOUD

SPREADSHEET COLUMN

REQUIRED DEFAULT DESCRIPTION AND VALIDATION

DATA TYPE

SIZE (IN BYTES)

JOB_DEFINITION_NAM

E

N/A N/A Scheduled Process job name indicating the job that created or last updated the row.

Text 100

JOB_DEFINITION_PAC

KAGE

N/A N/A Scheduled Process package name indicating package that created or last updated the row.

Text 900

OBJECT_VERSION_NU

MBER

N/A N/A Used to implement Optimistic Locking. The number is incremented every time the row is updated and compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Number 9

ATTRIBUTE_CATEGO

RY

N/A No Descriptive Flexfield: structure definition of the user descriptive flexfield.

Text 30

ATTRIBUTE1 ATTRIBUTE1 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE2 ATTRIBUTE2 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE3 ATTRIBUTE3 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE4 ATTRIBUTE4 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE5 ATTRIBUTE5 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE6 ATTRIBUTE6 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE7 ATTRIBUTE7 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE8 ATTRIBUTE8 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE9 ATTRIBUTE9 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE10 ATTRIBUTE10 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE11 ATTRIBUTE11 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE ORACLE CLOUD

SPREADSHEET COLUMN

REQUIRED DEFAULT DESCRIPTION AND VALIDATION

DATA TYPE

SIZE (IN BYTES)

ATTRIBUTE12 ATTRIBUTE12 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE13 ATTRIBUTE13 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE14 ATTRIBUTE14 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE15 ATTRIBUTE15 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE16 ATTRIBUTE16 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE17 ATTRIBUTE17 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE18 ATTRIBUTE18 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE19 ATTRIBUTE19 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE20 ATTRIBUTE20 No Descriptive Flexfield: Segment of the user descriptive flexfield.

Text 150

ATTRIBUTE_DATE1 ATTRIBUTE_DA

TE

No Descriptive Flexfield: Segment of the user descriptive flexfield.

Date

ATTRIBUTE_DATE2 ATTRIBUTE_DA

TE

No Descriptive Flexfield: Segment of the user descriptive flexfield.

Date

ATTRIBUTE_DATE3 ATTRIBUTE_DA

TE

No Descriptive Flexfield: Segment of the user descriptive flexfield.

Date

ATTRIBUTE_DATE4 ATTRIBUTE_DA

TE

No Descriptive Flexfield: Segment of the user descriptive flexfield.

Date

ATTRIBUTE_DATE5 ATTRIBUTE_DA

TE

No Descriptive Flexfield: Segment of the user descriptive flexfield.

Date

ATTRIBUTE_DATE6 ATTRIBUTE_DA

TE

No Descriptive Flexfield: Segment of the user descriptive flexfield.

Date

ATTRIBUTE_DATE7 ATTRIBUTE_DA

TE

No Descriptive Flexfield: Segment of the user descriptive flexfield.

Date

ATTRIBUTE_DATE8 ATTRIBUTE_DA

TE

No Descriptive Flexfield: Segment of the user descriptive flexfield.

Date

ATTRIBUTE_DATE9 ATTRIBUTE_DA No Descriptive Flexfield: Date

ATTRIBUTE ORACLE CLOUD

SPREADSHEET COLUMN

REQUIRED DEFAULT DESCRIPTION AND VALIDATION

DATA TYPE

SIZE (IN BYTES)

descriptive flexfield.

ATTRIBUTE_NUMBER7 ATTRIBUTE_NU MBER

No Descriptive Flexfield: Segment of the user descriptive flexfield.

Number

ATTRIBUTE_NUMBER8 ATTRIBUTE_NU

MBER

No Descriptive Flexfield: Segment of the user descriptive flexfield.

Number

ATTRIBUTE_NUMBER9 ATTRIBUTE_NU

MBER

No Descriptive Flexfield: Segment of the user descriptive flexfield.

Number

ATTRIBUTE_NUMBER

ATTRIBUTE_NU

MBER

No Descriptive Flexfield: Segment of the user descriptive flexfield.

Number

DEFAULT_TAXATION_

COUNTRY

Taxation Country No Default from Oracle Fusion Tax setup

Country where the transaction is deemed to have taken place for taxation purposes.

Text 2

DEFAULT_TAXATION_

TERRITORY

Taxation Territory No Default from Oracle Fusion Tax setup

Territory where the transaction is deemed to have taken place for taxation purposes.

Text 80

DOCUMENT_SUB_TYP

E

Document Sub Type

No Default from Oracle Fusion Tax setup

Document sub type code. Text 240

DOCUMENT_SUB_TYP

E_NAME

Document Sub Type Name

No Default from Oracle Fusion Tax setup

Document sub type name. Text 240

LOAD_REQUEST_ID N/A N/A Application-generated number that uniquely identifies the request to create requisitions through Oracle Cloud.

Number 18

INTERFACE_HEADER_

KEY

Interface Header Key

Yes, for Oracle Cloud

Oracle Cloud alternate header key code for integrating applications to be able to identify the requisition header data loaded in the interface table.

For Oracle Cloud, the provided header key must be unique for a load request.

Text 50

Requisition Line Interface Table

Table 4. Requisition Line Interface Table

ATTRIBUTE ORACLE CLOUD SPREADSHEET COLUMN

REQUIRED DEFAULT DESCRIPTION AND VALIDATION

DATA TYPE

SIZE (IN BYTES)

REQ_LINE_INTERFAC

E_ID

Yes Requisition line interface unique identifier.

Number 18

REQ_HEADER_INTER

FACE_ID

No Requisition header interface unique identifier.

Number 18

PROCESS_FLAG N/A N/A Application-updated flag that tracks the processing status of the record in the interface table.

Text 30

GROUP_CODE Group-By Code No Value by which the requisition lines are grouped when they are being processed by the import program. Requisition lines that are grouped together will be put on the same requisition header.

Text 30

PRC_BU_ID N/A No From the supplier site or from the first BU assigned to the buyer.

Unique identifier of the business unit that manages and owns the purchasing document.

The Procurement BU must be a BU that has a procurement service provider relationship with the Requisitioning BU specified on the requisition header.

Number 18

PRC_BU_NAME Procurement BU No From the supplier site or from the first BU assigned to the buyer.

Business unit that manages and owns the purchasing document.

The procurement BU name is used to derive the procurement BU ID.

Text 240

ITEM_ID N/A No Unique number for an item.

ITEM_ID is not applicable for fixed price service lines. The item must be a standard purchasable item in the item master.

Number 18

ITEM_NUMBER Item No Unique number for an item.

The item number is used to derive the item ID.

Text 300

ITEM_DESCRIPTION Item Description Yes Defaults from BPA or from item master item

Description of the requested item.

Text 240

ATTRIBUTE ORACLE CLOUD

SPREADSHEET COLUMN

REQUIRED DEFAULT DESCRIPTION AND VALIDATION

DATA TYPE

SIZE (IN BYTES)

goods based line type.

• Deliver-to Location must not be a one-time location.
• Project information must not be provided in the distribution.

DESTINATION_ORGAN IZATION_ID

N/A Yes (If destination organization code is null.)

From the deliver-to location, or from the Requisitio ning BU Configurat ion.

Unique identification of the organization to which the requested item will be delivered.

When not provided, the deliver-to organization is based on the deliver-to location if it is not a global location. Otherwise, it is defaulted from Requisitioning BU Configuration.

Number 18

DESTINATION_ORGAN

IZATION_CODE

Deliver-to Organization

Yes (If destination organization ID is null.)

From the deliver-to location, or from the Requisitio ning BU Configurat ion.

Code of the organization to which the requested item will be delivered.

The destination organization code is used to derive the destination organization ID.

Text 3

DESTINATION_SUBINV

ENTORY

Subinventory No Subinventory to which the requested item should be delivered.

Applies only for Inventory destination type. The subinventory must belong to the deliver-to organization, and must not be restricted for the item.

Text 10

DELIVER_TO_LOCATI

ON_ID

N/A Yes (If deliver-to location code is null.)

The location of the requester.

Unique identification of the final location where the goods previously received from the supplier will be delivered.

The deliver-to location must be active and must be in the Requisitioning BU's set of locations. If the deliver-to organization is provided and the deliver-to location is not global, then the deliver-to location must be associated to the deliver-to organization.

Number 18

DELIVER_TO_LOCATI

ON_CODE

Deliver-to Location

Yes (If deliver-to location ID is null.)

The location of the requester.

Code of the final location where the goods previously received from the supplier will be delivered.

The deliver-to location code is used to derive the

Text 60

ATTRIBUTE ORACLE CLOUD

SPREADSHEET COLUMN

REQUIRED DEFAULT DESCRIPTION AND VALIDATION

DATA TYPE

SIZE (IN BYTES)

deliver-to location ID.

REQUESTER_ID N/A Yes From the preparer.

Unique identification of the requester.

Number 18

REQUESTER_EMAIL Requester Yes (If requester ID is null.)

From the preparer.

E-mail of the requester.

The requester e-mail is used to derive the requester ID.

Text 240

SUGGESTED_BUYER_

ID

N/A No Based on the requisition procureme nt BU.

Unique identification of the person responsible for placing item resupply orders with suppliers and negotiating supplier contracts.

The suggested buyer must be a purchasing agent defined for the requisition procurement BU if there is a procurement BU context, or for one of the procurement service providers for the requisitioning BU.

Number 18

SUGGESTED_BUYER_

EMAIL

Suggested Buyer No Based on the requisition procureme nt BU.

E-mail of the person responsible for placing item resupply orders with suppliers and negotiating supplier contracts.

The suggested buyer e- mail is used to derive the suggested buyer ID.

Text 240

NEW_SUPPLIER_FLAG New Supplier No N Indicates whether or not the supplier is new.

Possible values are Y, or N. When the new supplier is Y, the application will not attempt to autosource an agreement for the requisition line.

Text 1

SUGGESTED_VENDO

R_NAME

Supplier No From the BPA.

Organization or individual that provides goods or services to the buying organization for payment.

When the new supplier is N or null, the suggested vendor name is used to derive the vendor ID.

Text 360

VENDOR_ID N/A No From the BPA.

Unique identification of the organization or individual that provides goods or services to the buying organization for payment.

Vendor ID should not be provided when the new supplier is Y.

Number 18

ATTRIBUTE ORACLE CLOUD

SPREADSHEET COLUMN

REQUIRED DEFAULT DESCRIPTION AND VALIDATION

DATA TYPE

SIZE (IN BYTES)

CE BPA. item in the currency provided.

The currency unit price is not applicable for fixed price service lines. When a BPA exists, the price is defaulted from the BPA. If the BPA allows price override, then the provided price will be saved in the requisition line; otherwise, the BPA price will override the provided price. The price must not exceed the maximum price allowed for the blanket agreement line.

RATE Conversion Rate Yes (When rate type is User.)

Based on the rate type and for a given rate date.

Ratio at which the principal unit of one currency can be converted into another currency.

Number

RATE_DATE Conversion Date Yes (When rate type is not User.)

Current date.

Date as of which a conversion rate is used to convert an amount into another currency.

Date

RATE_TYPE Conversion Rate Type

Yes (When the requisition transaction currency is different from the functional currency.)

From the Conversio n Rate Type defined on the current Requisitio ning BU's Financial options.

Source of a currency conversion rate, such as user defined, spot, or corporate. For user-defined rate, provide ‘USER’ in the rate type.

Text 30

SECONDARY_UOM_C

ODE

Secondary UOM No From the master item.

Secondary unit of measure of the requested item.

When provided, it must match the secondary UOM of the item.

Text 3

SECONDARY_QUANTI

TY

Secondary Quantity

Yes(If item is secondary item tracking enabled.)

Quantity in the secondary unit of measure of the requested item.

The secondary quantity must be within the deviation factor specified for the provided item.

Number

CURRENCY_AMOUNT Amount Yes (For fixed price service lines.)

From the BPA.

Amount of the item to be added to the requisition in the currency provided.

Only applies for fixed price service requisition lines. When there is a BPA, the amount is defaulted from the BPA. If the BPA allows price override, then the

Number

ATTRIBUTE ORACLE CLOUD

SPREADSHEET COLUMN

REQUIRED DEFAULT DESCRIPTION AND VALIDATION

DATA TYPE

SIZE (IN BYTES)

provided amount will be saved in the requisition line; otherwise, the BPA amount will override the provided amount. The amount cannot be greater than the price limit on the source document for the fixed price line.

NEGOTIATED_BY_PRE PARER_FLAG

Negotiated No Indicates if the requested item is negotiated with the supplier.

Must be Y to automate the purchase order creation for items with CPA as a source document.

Text 1

NEGOTIATION_REQUI

RED_FLAG

Negotiation Required

No Indicates if negotiation is required for the requested item.

Possible values are Y or N.

Text 1

AUTOSOURCE_FLAG Autosource Flag No Y Allows purchasing documents to derive the supply source from purchase agreements. The supplier and the price information are derived from the source agreement.

Possible values are Y and N. When Y, the application will autosource an agreement, BPA, or CPA, by a matching some or all the information below, depending on what is available:

• Item and its revision
• Currency
• Category
• Deliver-to Organization
• Supplier
• Supplier Site Line Type
• Purchase Basis (Goods or Services) UOM Code

Text 1

SOURCE_DOC_HEAD

ER_ID

N/A No Autosourc ed

The unique identifier of an agreement in a Procurement BU.

The source document, BPA, or CPA, must be open in the Procurement BU, valid for the need-by date (or sysdate), and

Number 18