ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9111

PurchaseRequisitions

The Purchase Requisitions resource manages purchase requisitions. A purchase requisition is an internal demand for purchasing an item or service, typically from a supplier who resides outside your organization. You must have the necessary roles and privileges to use this REST resource. For additional details, refer to the Job Roles and Privileges and Status Codes topics. You can use Oracle Visual Builder Add-in for Excel to integrate web applications via REST resources to retrieve, analyze, and edit data. For more information, refer to Use Visual Builder Add-in for Excel to Manage Web Applications Data in the Learn More section of this guide.

Table Specific Information

Select

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

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. Please 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 any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please 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 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 any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please 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

RequisitionHeaderId of PurchaseRequisitions

RequisitionHeaderUniqId [KEY] String True

Use this column's value in insert, update and delete operations, wherever applicable, instead of RequisitionHeaderId

Requisition String True

Requisition of PurchaseRequisitions

RequisitioningBUId Long False

Value that uniquely identifies the business unit that raised the requisition for goods and services.

RequisitioningBU String False

Name of the business unit that raised the requisition for goods and services.

PreparerId Long False

Value that uniquely identifies the user who created the requisition.

Preparer String True

Preparer of PurchaseRequisitions

PreparerEmail String False

Email address of the user who owns the requisition. This user is the person who created the requisition unless ownership was transferred from the user who created the requisition.

Description String False

Description of the requisition.

Justification String False

Reason for creating the requisition.

DocumentStatus String True

DocumentStatus of PurchaseRequisitions

DocumentStatusCode String True

DocumentStatusCode of PurchaseRequisitions

SubmissionDate Datetime True

SubmissionDate of PurchaseRequisitions

ApprovedDate Datetime True

ApprovedDate of PurchaseRequisitions

FunctionalCurrencyCode String True

FunctionalCurrencyCode of PurchaseRequisitions

SoldToLegalEntityId Long True

SoldToLegalEntityId of PurchaseRequisitions

SoldToLegalEntity String True

SoldToLegalEntity of PurchaseRequisitions

FundsStatus String True

FundsStatus of PurchaseRequisitions

FundsStatusCode String True

FundsStatusCode of PurchaseRequisitions

InterfaceSourceCode String False

Abbreviation that identifies the source of the requisition from a requisition import process.

InterfaceSourceLineId Long True

InterfaceSourceLineId of PurchaseRequisitions

EmergencyPONumber String True

EmergencyPONumber of PurchaseRequisitions

ModifyingApproverId Long True

ModifyingApproverId of PurchaseRequisitions

ModifyingApprover String True

ModifyingApprover of PurchaseRequisitions

ModifyingApproverEmail String True

ModifyingApproverEmail of PurchaseRequisitions

OverridingApproverId Long False

Value that uniquely identifies the user specified on the requisition as the overriding approver for approval routing.

OverridingApproverPersonNumber String False

Person number of the user specified on the requisition as the overriding approver for approval routing.

OverridingApprover String True

OverridingApprover of PurchaseRequisitions

OverridingApproverEmail String True

OverridingApproverEmail of PurchaseRequisitions

FundsOverrideApproverId Long True

FundsOverrideApproverId of PurchaseRequisitions

FundsOverrideApprover String True

FundsOverrideApprover of PurchaseRequisitions

FundsOverrideApproverEmail String True

FundsOverrideApproverEmail of PurchaseRequisitions

ApprovedById Long False

Value that uniquely identifies the approver of the requisition.

ApprovedByEmail String False

Email address of the approver of the requisition.

BudgetaryControlEnabledFlag Bool True

BudgetaryControlEnabledFlag of PurchaseRequisitions

EmergencyRequisitionFlag Bool True

EmergencyRequisitionFlag of PurchaseRequisitions

ExternallyManagedFlag Bool False

Contains one of the following values: true, or false. If true, then requisition is externally managed. If false, then requisition isn't externally managed. This attribute doesn't have a default value.

InternalTransferFlag Bool True

InternalTransferFlag of PurchaseRequisitions

FundsChkFailWarnFlag Bool False

Contains one of the following values: true, or false, or Null. If true, then funds check failed. If false, then funds check didn't fail. If Null, then the value hasn't been set. The default value is Null.

CreationDate Datetime True

CreationDate of PurchaseRequisitions

LastUpdateDate Datetime True

LastUpdateDate of PurchaseRequisitions

CreatedBy String True

CreatedBy of PurchaseRequisitions

LastUpdatedBy String True

LastUpdatedBy of PurchaseRequisitions

ActiveRequisitionFlag Bool False

Contains one of the following values: Y or N. If Y, then the requisition is active for a preparer-business unit combination. If N, then the requisition isn???t active for a preparer-business unit combination. The default value is N.

SourceApplicationCode String False

Abbreviation that uniquely identifies the application used to create the requisition. This attribute isn't currently used.

HasPendingApprovalLinesFlag Bool True

HasPendingApprovalLinesFlag of PurchaseRequisitions

HasRejectedLinesFlag Bool True

HasRejectedLinesFlag of PurchaseRequisitions

HasReturnedLinesFlag Bool True

HasReturnedLinesFlag of PurchaseRequisitions

HasWithdrawnLinesFlag Bool True

HasWithdrawnLinesFlag of PurchaseRequisitions

LifecycleStatusCode String True

LifecycleStatusCode of PurchaseRequisitions

LifecycleStatus String True

LifecycleStatus of PurchaseRequisitions

HasActionRequiredLinesFlag Bool True

HasActionRequiredLinesFlag of PurchaseRequisitions

IdentificationKey String True

IdentificationKey of PurchaseRequisitions

LockedByBuyerFlag Bool True

LockedByBuyerFlag of PurchaseRequisitions

RejectedReason String True

RejectedReason of PurchaseRequisitions

RejectedById Long True

RejectedById of PurchaseRequisitions

RejectedByDisplayName String True

RejectedByDisplayName of PurchaseRequisitions

RequisitionLineGroup String True

RequisitionLineGroup of PurchaseRequisitions

InsufficientFundsFlag Bool False

Contains one of the following values: true, false, or Null. If true, then the requisition was submitted for approval with a funds override request due to insufficient funds. If false, then the requisition was submitted for approval without a funds override request. If Null, then the value hasn't been set. The default value is Null.

SpecialHandlingTypeCode String False

Abbreviation that identifies the special handling type of the requisition.

SpecialHandlingType String False

Type of special handling required for the requisition. Examples of special handling cases are Bill only, Bill and replace, and so on.

TaxationCountryCode String False

Abbreviation that identifies the taxation country associated with the requisition.

TaxationCountry String False

Display name of the taxation country associated with the requisition.

ConcatDocumentFiscalClassificationCode String False

Value that uniquely identifies the concatenation of parent classification and document fiscal classification.

DocumentFiscalClassificationCode String False

Abbreviation that identifies the document fiscal classification associated with the requisition.

DocumentFiscalClassification String False

Display name of the document fiscal classification associated with the requisition.

TaxAttrsUserOverrideHeaderFlag Bool True

TaxAttrsUserOverrideHeaderFlag of PurchaseRequisitions

specialHandlingDFF String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

summaryAttributes String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

DFF String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

lines String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

BindPreparerId Long True

bindpreparerid

BindRequisitionHeaderId Long True

bindrequisitionheaderid

Finder String True

finder

EffectiveDate Date True

This query parameter is used to fetch resources which are effective dated as of the specified start date.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9111