JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

PurchaseRequisitions

Handles internal purchase requests for items or services, capturing details for eventual PO creation or approval.

Table-Specific Information

Select

The driver uses the Oracle Fusion Cloud Financials API to process some of the filters having 'queryable'='true' in metadata. The driver processes other filters within the driver.

For example, the following query is processed server-side: 

SELECT * FROM [Cdata].[Procurement].[PurchaseRequisitions] WHERE RequisitionHeaderId = 10003

Insert

Create an PurchaseRequisition. 

INSERT INTO [Cdata].[Procurement].[PurchaseRequisitions](RequisitioningBUId,PreparerId,ExternallyManagedFlag,Description,InterfaceSourceCode,Justification) VALUES (300000046987012,300000050813523,false,'POST-ing a Requisition Header from REST','Rest123','Need this for business purposes')

You can also add aggregates with the parent table, using TEMP table and aggregates. Refer to Invoices.

Update

The Oracle Fusion Cloud Financials API uses RequisitionHeaderUniqId instead of RequisitionHeaderId as a path parameter in the URL to update the record.

If you want to update a record directly using the Id (without any other filter), you can update the record in the following way: 

Update [Cdata].[Procurement].[PurchaseRequisitions] set Description='abcd' WHERE RequisitionHeaderUniqId=454545454;

Note: This does not require an extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter, use RequisitionHeaderId instead of RequisitionHeaderUniqId. You can update the record in the following way: 

Update [Cdata].[Procurement].[PurchaseRequisitions] set Description='abcd' WHERE RequisitionHeaderId=454545454 and Requisition='aaa';

Note: Update on aggregates are not allowed by the API. Use the child tables to add/update/delete aggregates.

Delete

The Oracle Fusion Cloud Financials API uses RequisitionHeaderUniqId instead of RequisitionHeaderId as a path parameter in the URL to delete the record.

If you want to delete a record directly using the Id (without any other filter), you can delete the record in the following way: 

DELETE FROM [Cdata].[Procurement].[PurchaseRequisitions] WHERE RequisitionHeaderUniqId=454545454;

Note: This does not require an extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter, use RequisitionHeaderId instead of RequisitionHeaderUniqId. You can delete the record in the following way: 

DELETE FROM [Cdata].[Procurement].[PurchaseRequisitions] WHERE RequisitionHeaderUniqId=454545454 and Requisition='aaa';

Columns

Name Type ReadOnly Description
RequisitionHeaderId [KEY] Long True

The unique identifier for the header of the requisition, linking the requisition data to the main requisition record.

RequisitionHeaderUniqId [KEY] String True

A unique identifier for the requisition header, to be used in insert, update, and delete operations instead of RequisitionHeaderId.

Requisition String True

The requisition number or identifier used to track the specific requisition in the system.

RequisitioningBUId Long False

The unique identifier for the business unit that raised the requisition for goods or services, linking the requisition to the originating business unit.

RequisitioningBU String False

The name of the business unit that initiated the requisition for goods and services.

PreparerId Long False

The unique identifier for the user who created the requisition, linking the requisition to the preparer.

Preparer String True

The name or identifier of the user who created the requisition.

PreparerEmail String False

The email address of the user who owns the requisition, typically the creator unless ownership has been transferred.

Description String False

A brief description of the requisition, providing context or details about the request.

Justification String False

The reason or rationale for creating the requisition, explaining why the goods or services are required.

DocumentStatus String True

The current status of the requisition document (for example, Pending, Approved, Rejected).

DocumentStatusCode String True

A code that represents the status of the requisition document for easier reference in system processes.

SubmissionDate Datetime True

The date and time when the requisition was submitted for approval or processing.

ApprovedDate Datetime True

The date when the requisition was officially approved.

FunctionalCurrencyCode String True

The currency code used for financial transactions in the requisition, typically representing the currency of the requisitioning business unit.

SoldToLegalEntityId Long True

The unique identifier for the legal entity to which the requisition is sold, used for legal and financial tracking.

SoldToLegalEntity String True

The name or description of the legal entity to which the requisition is assigned.

FundsStatus String True

The status of the funds for the requisition, indicating whether funds are available or require additional approvals.

FundsStatusCode String True

A code representing the funds status for the requisition, used for easier system tracking.

InterfaceSourceCode String False

An abbreviation that identifies the source of the requisition, typically used when importing requisition data.

InterfaceSourceLineId Long True

The unique identifier for the line item in the interface source, used to track the specific line associated with the requisition.

EmergencyPONumber String True

The purchase order number assigned in emergency cases for expedited requisitions.

ModifyingApproverId Long True

The unique identifier for the user who is modifying the requisition's approval details.

ModifyingApprover String True

The name of the user who is modifying the approval details of the requisition.

ModifyingApproverEmail String True

The email address of the user modifying the requisition's approval details.

OverridingApproverId Long False

The unique identifier for the user designated as the overriding approver for approval routing, responsible for final approval.

OverridingApproverPersonNumber String False

The person number of the overriding approver, linking to the user in the HR system.

OverridingApprover String True

The name of the overriding approver specified on the requisition for approval routing.

OverridingApproverEmail String True

The email address of the overriding approver, used for communication and approval notifications.

FundsOverrideApproverId Long True

The unique identifier for the user who approves overrides to the requisition's funds availability.

FundsOverrideApprover String True

The name of the user responsible for approving funds overrides on the requisition.

FundsOverrideApproverEmail String True

The email address of the user responsible for approving funds overrides.

ApprovedById Long False

The unique identifier for the user who approved the requisition.

ApprovedByEmail String False

The email address of the approver, used for notifications and approvals.

BudgetaryControlEnabledFlag Bool True

Indicates whether budgetary control is enabled for the requisition (True/False).

EmergencyRequisitionFlag Bool True

Indicates whether the requisition is an emergency requisition, requiring expedited processing (True/False).

ExternallyManagedFlag Bool False

Indicates whether the requisition is externally managed (True) or internally managed (False).

InternalTransferFlag Bool True

Indicates whether the requisition involves an internal transfer of goods or services (True/False).

FundsChkFailWarnFlag Bool False

Indicates whether a funds check failed (True), did not fail (False), or has not been set (Null).

CreationDate Datetime True

The date and time when the requisition record was created in the system.

LastUpdateDate Datetime True

The date and time when the requisition was last updated.

CreatedBy String True

The user who created the requisition record in the system.

LastUpdatedBy String True

The user who last updated the requisition record.

ActiveRequisitionFlag Bool False

Indicates whether the requisition is active for the preparer and business unit combination (Y/N).

SourceApplicationCode String False

The code identifying the application that created the requisition, though this attribute is not currently in use.

HasPendingApprovalLinesFlag Bool True

Indicates whether there are any lines in the requisition that are pending approval (True/False).

HasRejectedLinesFlag Bool True

Indicates whether any lines in the requisition have been rejected (True/False).

HasReturnedLinesFlag Bool True

Indicates whether any lines in the requisition have been returned for modifications (True/False).

HasWithdrawnLinesFlag Bool True

Indicates whether any lines in the requisition have been withdrawn (True/False).

LifecycleStatusCode String True

The code representing the lifecycle status of the requisition, such as 'Open', 'Closed', or 'Approved'.

LifecycleStatus String True

The display name of the lifecycle status, providing more context about the requisition's stage.

HasActionRequiredLinesFlag Bool True

Indicates whether there are lines in the requisition that require action (True/False).

IdentificationKey String True

A unique key used to identify the requisition in the system, often used for lookup purposes.

LockedByBuyerFlag Bool True

Indicates whether the requisition is locked by the buyer, preventing further changes (True/False).

RejectedReason String True

The reason given for rejecting the requisition, providing context for the decision.

RejectedById Long True

The unique identifier for the user who rejected the requisition.

RejectedByDisplayName String True

The display name of the user who rejected the requisition, used for communication and reporting.

RequisitionLineGroup String True

A grouping identifier for requisition lines, typically used to categorize or associate multiple lines together.

InsufficientFundsFlag Bool False

Indicates whether the requisition was submitted with insufficient funds and required a funds override (True/False).

SpecialHandlingTypeCode String False

An abbreviation that identifies the special handling type for the requisition (for example, 'Bill Only', 'Bill and Replace').

SpecialHandlingType String False

The type of special handling required for the requisition, such as 'Bill Only', 'Bill and Replace', or others.

TaxationCountryCode String False

The country code representing the taxation country associated with the requisition.

TaxationCountry String False

The display name of the taxation country associated with the requisition.

ConcatDocumentFiscalClassificationCode String False

A code that identifies the concatenation of parent classification and document fiscal classification for the requisition.

DocumentFiscalClassificationCode String False

A code that identifies the fiscal classification for the document, used for financial and tax reporting.

DocumentFiscalClassification String False

The display name of the document fiscal classification, providing context for tax and legal purposes.

TaxAttrsUserOverrideHeaderFlag Bool True

Indicates whether the user has overridden the tax attributes at the header level for the requisition.

specialHandlingDFF String False

A flexfield column used for special handling data, only applicable during insert operations.

summaryAttributes String False

A column used for summary-level attributes, only applicable during insert operations.

DFF String False

A column for capturing flexfield data, only applicable during insert operations.

lines String False

A column used to reference requisition lines, only applicable during insert operations.

BindPreparerId Long True

The identifier used to bind the preparer's data when performing operations on the requisition.

BindRequisitionHeaderId Long True

The identifier used to bind the requisition header data during operations.

Finder String True

A placeholder or reference for the search functionality to locate requisition records.

EffectiveDate Date True

The date from which the requisition data is considered effective, used to filter records within the valid date range.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434