JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

Suppliersaddresses

Captures location data for suppliers, such as physical or mailing addresses, to support invoicing and shipping.

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].[Suppliersaddresses] WHERE SupplierAddressId = 10003

Insert

Create a Supplieraddress.

You need to provide SuppliersUniqId, instead of SuppliersSupplierId , to insert the record. 

INSERT INTO [Cdata].[Procurement].[Suppliersaddresses] (SuppliersUniqId,AddressName,Country,AddressLine1,City,State,PostalCode,AddressPurposeOrderingFlag,AddressPurposeRemitToFlag,AddressPurposeRFQOrBiddingFlag) VALUES ('300000051066029','Headquarter','United States','Example Road','Redwood City','CA','94065',true,true,false)

Update

The Oracle Fusion Cloud Financials API uses SuppliersUniqId instead of SuppliersSupplierId and SupplierAddressUniqId instead of SupplierAddressId 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].[Suppliersaddresses] set PhoneNumber='66565' WHERE SuppliersUniqId = 454545454 and SupplierAddressUniqId=454;

Note: This does not require an extra GET request to retrieve the UniqId. You need to provide all the UniqIds.

Alternatively, if you want to apply any other filter, use SuppliersSupplierId instead of SuppliersUniqId and SupplierAddressId instead of SupplierAddressUniqId. You can update the record in the following way: 

Update [Cdata].[Procurement].[Suppliersaddresses] set PhoneNumber='66565' WHERE SuppliersSupplierId = 454545454

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

Columns

Name Type ReadOnly Description
SuppliersSupplierId [KEY] Long True

The unique identifier for the supplier associated with the supplier address.

SuppliersUniqId [KEY] String True

This value should be used in insert, update, and delete operations instead of SuppliersSupplierId for a more stable reference to the supplier.

SupplierAddressId [KEY] Long True

The unique identifier for the supplier address within the system.

SupplierAddressUniqId [KEY] String True

This value should be used in insert, update, and delete operations instead of SupplierAddressId for a more stable reference to the address.

AddressName String False

The name assigned to the supplier address, which may be used for distinguishing between different addresses associated with the same supplier.

CountryCode String False

An abbreviation representing the country where the supplier address is located.

Country String False

The full name of the country where the supplier address is located.

AddressLine1 String False

The first line of the street address for the supplier's location.

AddressLine2 String False

The second line of the street address for the supplier's location, if applicable.

AddressLine3 String False

The third line of the street address for the supplier's location, if applicable.

AddressLine4 String False

The fourth line of the street address for the supplier's location, if applicable.

City String False

The city or locality where the supplier address is located.

State String False

The state or province where the supplier address is located.

PostalCode String False

The postal code for the supplier address, used for location identification.

PostalCodeExtension String False

An optional four-digit extension to the postal code, typically used to further refine the location.

Province String False

The province or regional division of the supplier address.

County String False

The county or district of the supplier address.

Building String False

The building number or name associated with the supplier address.

FloorNumber String False

The floor number or specific level within the building for the supplier address.

PhoneticAddress String False

The phonetic representation of the supplier address, used for Japanese kana or Chinese kanji scripts.

LanguageCode String False

An abbreviation identifying the language in which the supplier address is recorded.

Language String False

The full name of the language in which the supplier address is recorded, such as 'English' or 'Japanese.'

Addressee String False

The individual or role associated with receiving communications at the supplier address.

GlobalLocationNumber String False

The global location number (GLN) assigned to the supplier address for global identification purposes.

AdditionalAddressAttribute1 String False

An additional customizable attribute for the supplier address format, allowing flexibility in storing extra address details.

AdditionalAddressAttribute2 String False

Another customizable attribute for additional details of the supplier address.

AdditionalAddressAttribute3 String False

A third customizable attribute for storing extra information about the supplier address.

AdditionalAddressAttribute4 String False

A fourth customizable attribute for storing further address information.

AdditionalAddressAttribute5 String False

A fifth customizable attribute for storing additional supplier address details.

AddressPurposeOrderingFlag Bool False

Indicates whether the supplier address can be used for ordering purposes. If true, it is usable for order transactions; if false, it is not.

AddressPurposeRemitToFlag Bool False

Indicates whether the supplier address is available for sending payments. If true, it can be used for remittance; if false, it cannot.

AddressPurposeRFQOrBiddingFlag Bool False

Indicates whether the supplier address can be used for requests for proposal or bidding. If true, it is available for such purposes.

PhoneCountryCode String False

The country code associated with the phone number of the supplier address.

PhoneAreaCode String False

The area or region code associated with the phone number for the supplier address.

PhoneNumber String False

The phone number for the supplier address, used for direct contact.

PhoneExtension String False

The extension number for the phone at the supplier address, if applicable.

FaxCountryCode String False

The country code associated with the fax number for the supplier address.

FaxAreaCode String False

The area or region code for the fax number of the supplier address.

FaxNumber String False

The fax number for the supplier address, used for sending documents.

Email String False

The email address associated with the supplier address, used for electronic communications.

InactiveDate Date False

The date when the supplier address was marked as inactive, indicating that it is no longer in use.

Status String True

The current status of the supplier address, such as active, inactive, or pending.

CreationDate Datetime True

The timestamp indicating when the supplier address record was created in the system.

CreatedBy String True

The user or system responsible for creating the supplier address record.

LastUpdateDate Datetime True

The timestamp of the last update made to the supplier address record.

LastUpdatedBy String True

The user or system responsible for the most recent update to the supplier address record.

DFF String False

This column can only be used for insert operations. For updates and deletes, use the appropriate child table operations.

BilltoBuId Long True

The unique identifier for the billing business unit associated with the supplier address.

BindPurchaseFlag String True

A flag indicating whether the supplier address is bound to purchase-related activities.

BindReqBuId Long True

The unique identifier for the business unit required for the supplier address.

BindSourcingOnlyFlag String True

Indicates whether the supplier address is bound only for sourcing activities (true) or has other uses (false).

BindSysdate Date True

The system date when the supplier address binding action occurred.

Finder String True

A reference to a lookup or search function used for locating the supplier address.

SupplierId Long True

The unique identifier for the supplier associated with this address.

CUReferenceNumber Int False

A reference number used to link child aggregates with the parent supplier address data.

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