JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

DraftPurchaseOrders

Maintains partially completed purchase orders not yet communicated to suppliers, tracking preliminary details for further updates.

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].[DraftPurchaseOrders] WHERE POHeaderId = 10003

Insert

Create an DraftPurchaseOrder.

INSERT INTO DraftPurchaseOrders(Currency,ProcurementBU,RequisitioningBUId,Buyer,Supplier,SupplierSite,BillToLocation,PayOnReceiptFlag,BuyerManagedTransportFlag,RequiredAcknowledgment,SupplierCommunicationMethod) VALUES ('US Dollar','US1 Business Unit',300000046987012,'Roth, Calvin','EIP Inc','EIP Inc','Seattle',false,true,'None','NONE')

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 POHeaderUniqId instead of POHeaderId 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].[DraftPurchaseOrders] set Description='abcd' WHERE POHeaderUniqId=454545454;

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

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

Update [Cdata].[Procurement].[DraftPurchaseOrders] set Description='abcd' WHERE POHeaderUniqId=454545454 and BuyerId=445128;

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 POHeaderUniqId instead of POHeaderId 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].[DraftPurchaseOrders] WHERE POHeaderUniqId=454545454;

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

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

DELETE FROM [Cdata].[Procurement].[DraftPurchaseOrders] WHERE POHeaderId=454545454 and BuyerId=445128;

Columns

Name Type ReadOnly Description
POHeaderId [KEY] Long True

The unique identifier for the header of a draft purchase order, used to reference the overall purchase order document.

POHeaderUniqId [KEY] String True

A unique identifier for the draft purchase order header that should be used for insert, update, and delete operations, instead of using the POHeaderId.

OrderNumber String False

The number that uniquely identifies a purchase order within the sold-to legal entity, typically used for tracking and referencing the order.

Description String False

A text description of the purchase order, providing more context about the order's purpose or content.

DocumentStyleId Long False

The unique identifier for the style of the purchasing document, helping to distinguish between different document formats or layouts.

DocumentStyle String False

The name of the purchasing document style, used to control the parameters and values displayed on the application to match the document’s intended use.

StatusCode String False

An abbreviation identifying the status of the purchase order within its lifecycle, which helps categorize its current state.

Status String True

The current status of the draft purchase order, indicating whether it is in a draft, pending, or finalized state.

ProcurementBUId Long False

The unique identifier for the business unit responsible for managing and owning the purchase order.

ProcurementBU String False

The name of the business unit that is responsible for managing and owning the purchase order.

RequisitioningBUId Long False

The unique identifier for the business unit that is responsible for creating the requisition linked to the purchase order.

RequisitioningBU String False

The name of the business unit that is responsible for creating the requisition from which the purchase order is derived.

BuyerId Long False

The unique identifier for the buyer who is responsible for managing the purchase order.

Buyer String False

The name of the person who is responsible for managing the purchase order, typically overseeing its creation and processing.

BuyerEmail String False

The email address of the buyer, allowing communication and notifications regarding the purchase order.

CurrencyCode String False

The abbreviation for the currency used in the purchase order, typically using ISO 4217 codes.

Currency String False

The currency used for the purchase order, which determines how amounts are calculated and paid.

ConversionRateTypeCode String False

An abbreviation identifying the type of conversion rate applied when converting currencies in the purchase order.

ConversionRateType String False

The type of conversion rate used by the application to determine the exchange rate for converting one currency into another.

ConversionRateDate Date False

The specific date used for determining the conversion rate, as exchange rates may vary by date.

ConversionRate Decimal False

The actual conversion rate used to convert between currencies for the purchase order.

SupplierId Long False

The unique identifier for the supplier fulfilling the items or services listed on the purchase order.

Supplier String False

The name of the supplier responsible for delivering the items or services listed on the purchase order.

SupplierSiteId Long False

The unique identifier for the supplier's site, which represents the location from where the supplier will fulfill the order.

SupplierSite String False

The name of the supplier's site, indicating the location from where the supplier will ship the goods.

SupplierCommunicationMethod String False

The method used to communicate the purchase order to the supplier, such as email, fax, or other communication channels.

SupplierFax String False

The fax number used to communicate the purchase order to the supplier, in case fax is the preferred communication method.

SupplierOrder String True

The supplier-specific order number, which links to the purchase order for tracking or reference purposes.

SupplierEmailAddress String False

The email address of the supplier for communication related to the purchase order.

SoldToLegalEntityId Long False

The unique identifier for the legal entity that is financially responsible for the purchase order, used for invoicing and legal purposes.

SoldToLegalEntity String False

The name of the legal entity that is financially responsible for the purchase order, typically the entity making the purchase.

BillToBUId Long False

The unique identifier for the business unit responsible for processing supplier invoices related to the purchase order.

BillToBU String False

The name of the business unit responsible for processing supplier invoices for the purchase order.

BillToLocationId Long False

The unique identifier for the location where the supplier sends the invoice, which can be different from the physical shipping address.

BillToLocation String False

The location where the supplier is instructed to send invoices for payment.

BillToLocationInternalCode String False

An internal abbreviation or code used to identify the bill-to location, typically for internal reference.

DefaultShipToLocationId Long False

The unique identifier for the default location where goods should be shipped.

DefaultShipToLocation String False

The name of the location where the supplier is expected to ship the items or goods.

DefaultShipToLocationInternalCode String False

Abbreviation that internally identifies the default value of the ship-to location where the supplier should ship the goods.

MasterContractId Long False

Value that uniquely identifies the contract from enterprise contracts. This attribute allows a direct connection between execution documents in Oracle Purchasing Cloud and high-level contracts in Oracle Enterprise Contracts Cloud.

MasterContractNumber String False

Number that identifies the contract from enterprise contracts. This attribute allows a direct connection between execution documents in Oracle Purchasing Cloud and high-level contracts in Oracle Enterprise Contracts Cloud.

MasterContractTypeId Long False

Value that uniquely identifies the contract type. This attribute specifies the nature of the enterprise contract. The contract type specifies what kind of information you can enter, including the presence of lines and contract terms.

MasterContractType String False

Type of contract. This attribute specifies the nature of the enterprise contract. The contract type specifies what kind of information you can enter, including the presence of lines and contract terms.

RequiredAcknowledgmentCode String False

Abbreviation that identifies the acknowledgment that the purchase order requires from the supplier. Values include Y for document and schedule, D for document, or N for none.

RequiredAcknowledgment String False

Acknowledgment that the application requires from the supplier. Values include 'Document and Schedule' (supplier must acknowledge the header and schedule of the purchase order), 'Document' (supplier must acknowledge the header of the purchase order), or 'None' (the purchase order does not require acknowledgment).

AcknowledgmentDueDate Date False

Date when the application requests the supplier to acknowledge the purchase order.

AcknowledgmentWithinDays Decimal False

Number of days for the supplier to decide to accept or reject the purchase order.

BuyerManagedTransportFlag Bool False

Contains one of the following values: true or false. If true, then the buyer or an agent that the buyer designates must arrange transportation from picking up the requested item to delivering it to the ship-to location that the purchase order specifies. If false, then the supplier must arrange transportation. This attribute does not have a default value.

RequiresSignatureFlag Bool False

Contains one of the following values: true or false. If true, then the purchase order requires signatures to meet legal requirements. If false, then the purchase order does not require signatures. This attribute does not have a default value.

PendingSignatureFlag Bool True

Indicates whether the purchase order is awaiting a signature, used for tracking purposes.

PaymentTermsId Long False

The unique identifier for the payment terms that define when and how the supplier will be paid.

PaymentTerms String False

The payment terms for the purchase order, which govern when payments are made, including discount dates and due dates.

FOBCode String False

An abbreviation identifying the type of freight on board term applied to the order, such as 'CIF' or 'FOB'.

FOB String False

The location where the ownership of goods transfers from the supplier to the buyer during shipping.

FreightTermsCode String False

An abbreviation identifying the freight terms for the purchase order, which determine who bears the cost of shipping.

FreightTerms String False

The terms that define who is responsible for paying the freight charges associated with the shipment.

SupplierContactId Long False

The unique identifier for the supplier contact, who is responsible for managing communications regarding the purchase order.

SupplierContact String False

The name of the contact person representing the supplier, who communicates with the buyer.

NoteToSupplier String False

A note directed to the supplier providing instructions or additional details on how to process the purchase order.

NoteToReceiver String False

A note directed to the receiver providing instructions or additional details on how to process the items upon arrival.

CarrierId Long False

The unique identifier for the carrier company that transports the items by land, sea, or air.

Carrier String False

The name of the carrier company responsible for transporting the items.

ModeOfTransportCode String False

An abbreviation identifying the mode of transport used by the carrier, such as 'Air' or 'Sea'.

ModeOfTransport String False

The mode of transport used by the carrier, such as air, sea, or land.

ServiceLevelCode String False

An abbreviation identifying the service level for the shipping method, such as 'Overnight' or 'Standard'.

ServiceLevel String False

The service level describing how quickly the items need to be shipped, such as 'Express' or 'Economy'.

ConfirmingOrderFlag Bool False

Contains one of the following values: true or false. If true, then the purchase order is communicated verbally before the supplier receives the purchase order. If false, then there is no verbal communication before sending the purchase order. This attribute does not have a default value.

PayOnReceiptFlag Bool False

Contains one of the following values: true or false. If true, then the application creates an invoice that requests payment for the item according to the receipt transaction. If false, then the application does not require the supplier to create this invoice and instead requests payment according to the receipt of the shipped item. This attribute does not have a default value.

DocumentCreationMethod String False

The method by which the purchase order document was created, such as manually, automatically, or by using a template.

ShippingMethod String False

The method of transportation chosen for the order, detailing the carrier and service level, such as 'Air - Express'.

DefaultTaxationCountryCode String False

The abbreviation identifying the country used for taxation purposes for the purchase order.

DefaultTaxationCountry String False

The country in which the transaction is subject to tax, used for calculating tax liabilities.

FirstPartyRegistrationId Long False

The unique identifier for the first party registration number, used for tax reporting.

FirstPartyRegistrationNumber String False

Value that is a unique sequence of letters or numbers assigned to a first party by a tax authority when it is registered. This attribute is used to identify the first party registration.

ThirdPartyRegistrationId Long False

Value that uniquely identifies the third party registration.

ThirdPartyRegistrationNumber String False

Value that is a unique sequence of letters or numbers assigned to a third party or third-party site by a tax authority. This attribute is used to identify the party or party-site level tax registration.

DocumentFiscalClassificationId Long False

The unique identifier for the fiscal classification of the document, which affects tax categorization.

DocumentFiscalClassificationCode String False

An abbreviation identifying the fiscal classification applied to the document for tax purposes.

DocumentFiscalClassification String False

The classification of the document as per the tax authority's rules, affecting its taxation.

BudgetaryControlEnabledFlag Bool True

Indicates whether budgetary control is enabled for the purchase order, helping manage expenditures within budget.

CancelFlag Bool True

Indicates whether the purchase order is marked for cancellation.

ChangeOrderNumber String True

The unique number associated with a change order to track modifications made to the original purchase order.

ChangeOrderInitiatingParty String False

The party who initiated the change order request, such as the buyer, supplier, or requester.

ChangeOrderDescription String False

A textual description detailing the reason or purpose of the change order, providing clarity on why changes were made.

ChangeOrderStatusCode String True

An abbreviation indicating the current status of the change order in its lifecycle.

ChangeOrderStatus String True

The current status of the change order, indicating whether it's in draft, pending approval, or finalized.

ChangeOrderTypeCode String True

An abbreviation identifying the type of change order being processed.

ChangeOrderType String True

The type of change order, specifying whether it's a revision, cancellation, or other types of change.

ChangeRequestedBy String True

The individual or entity who requested the change to the purchase order.

ContractTermsExistFlag Bool True

Indicates whether contract terms exist for the purchase order, helping determine if additional contractual obligations apply.

DuplicatedFromHeaderId Long True

The header ID of the original purchase order from which this one was duplicated.

FundsStatus String True

The status of funds for the purchase order, indicating if the funds are approved, pending, or unavailable.

FundsStatusCode String True

An abbreviation identifying the funds status of the purchase order, helping to categorize the financial approval stage.

ImportSourceCode String False

The source application from which the purchase order was imported, such as an external ERP system.

ReferenceNumber String True

A reference number used to link the purchase order to other related documents or transactions.

LastUpdateDate Datetime True

The date and time when the purchase order was last updated.

LastUpdatedBy String True

The individual who last updated the purchase order, helping to track changes.

CreationDate Datetime True

The date and time when the purchase order was originally created.

CreatedBy String True

The individual who originally created the purchase order.

SupplierCCEmailAddress String False

An email address to which a copy of the purchase order communication is sent for CC purposes.

SupplierBCCEmailAddress String False

An email address to which a copy of the purchase order communication is sent for BCC purposes, hidden from other recipients.

OverridingApproverId Long False

The unique identifier for the user designated as the overriding approver for approval routing, allowing a change in the approval process.

OverridingApprover String False

The name of the person who overrides the first approver to route the purchase order for approval.

OverrideB2BCommunicationFlag Bool False

Indicates whether the purchase order can be communicated using an alternative communication method other than B2B, with true meaning it can't be sent through B2B.

HasPOlineswithMultipleDistributionsFlag Bool True

A flag indicating whether the purchase order lines are distributed across multiple accounts or locations.

HasReceivedOrInvoicedSchedulesFlag Bool True

Indicates whether there are any received or invoiced schedules related to the purchase order.

AdditionalContactEmail String False

Email addresses for additional supplier contacts who may need to receive notifications regarding the purchase order.

SpecialHandlingType String False

The special handling type applied to the purchase order, detailing any specific handling instructions.

SpecialHandlingTypeCode String False

An abbreviation identifying the special handling type for the purchase order, such as expedited processing or custom packaging.

specialHandlingDFF String False

A special handling DFF (descriptive flexfield) used only for insert operations; for updates and deletes, use child table operations.

summaryAttributes String False

Summary attributes used for insert operations; for updates or deletes, refer to child table operations.

DFF String False

A DFF (descriptive flexfield) used for inserts only; for updates and deletes, refer to child table operations.

lines String False

Used for insert operations to add lines to the purchase order; for updates and deletes, use child table operations.

globalDFFs String False

Global descriptive flexfields used only for insert operations; for updates and deletes, use child table operations.

Finder String True

The finder used for searching and referencing related purchase order records.

Intent String True

The intent or purpose for which the purchase order was created.

SysEffectiveDate String True

The system-effective date, used for tracking the period when the purchase order data is valid.

EffectiveDate Date True

The effective date used to determine the resources valid as of the specified start date.

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