JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

Supplierscontacts

Maintains supplier contact records, including names, emails, and roles for consistent communication and procurement 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].[Supplierscontacts] WHERE SupplierContactId = 10003

Insert

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

Create a Suppliercontacts. SuppliersUniqId is used to uniquely identify the Supplier. 

INSERT INTO [Cdata].[Procurement].[Supplierscontacts] (SuppliersUniqId,Salutation,FirstName,LastName,AdministrativeContactFlag,MobileCountryCode,MobileAreaCode,MobileNumber) VALUES ('300000051066029','Mr.','Test1','Test2',true,'1','650','555-2234')

Update

The Oracle Fusion Cloud Financials API uses SuppliersUniqId instead of SuppliersSupplierId and SupplierContactUniqId instead of SupplierContactId 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].[Supplierscontacts] set PhoneNumber='66565' WHERE SuppliersUniqId = 454545454 and SupplierContactUniqId=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 SupplierContactId instead of SupplierContactUniqId. You can update the record in the following way: 

Update [Cdata].[Procurement].[Supplierscontacts] 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 contact.

SuppliersUniqId [KEY] String True

The stable identifier for the supplier. Use this value in insert, update, and delete operations instead of SuppliersSupplierId.

SupplierContactId [KEY] Long True

The unique identifier for the supplier contact, assigned by the system.

SupplierContactUniqId [KEY] String True

The stable identifier for the supplier contact. Use this value in insert, update, and delete operations instead of SupplierContactId.

SalutationCode String False

An abbreviation identifying the honorific title (for example, Mr., Ms., Dr.) of the supplier contact. Valid values are defined in the CONTACT_TITLE lookup type.

Salutation String False

The honorific title for the supplier contact, such as 'Mr.', 'Ms.', 'Dr.', or other formal titles.

FirstName String False

The first name of the supplier contact.

MiddleName String False

The middle name of the supplier contact, if available.

LastName String False

The last name or family name of the supplier contact.

JobTitle String False

The job title or position held by the supplier contact within their organization.

AdministrativeContactFlag Bool False

Indicates whether the supplier contact is an administrative contact. 'True' means the contact is administrative; 'False' means they are not. The default value is 'False.'

PhoneCountryCode String False

An abbreviation representing the country code for the phone number of the supplier contact.

PhoneAreaCode String False

An abbreviation representing the area or region code for the phone number of the supplier contact.

PhoneNumber String False

The primary phone number for the supplier contact.

PhoneExtension String False

The phone extension for the supplier contact, if applicable.

MobileCountryCode String False

An abbreviation representing the country code for the mobile phone number of the supplier contact.

MobileAreaCode String False

An abbreviation representing the area or region code for the mobile phone number of the supplier contact.

MobileNumber String False

The mobile phone number of the supplier contact.

FaxCountryCode String False

An abbreviation representing the country code for the fax number of the supplier contact.

FaxAreaCode String False

An abbreviation representing the area or region code for the fax number of the supplier contact.

FaxNumber String False

The fax number for the supplier contact.

Email String False

The email address of the supplier contact.

Status String True

The current status of the supplier contact, such as 'Active,' 'Inactive,' or 'Pending.'

InactiveDate Date False

The date when the supplier contact was marked as inactive in the system, indicating they are no longer available for contact.

PersonProfileId [KEY] Long False

A unique identifier for the person profile associated with the supplier contact, used for linking the contact to their personal profile.

CreationDate Datetime True

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

CreatedBy String True

The user or system that created the supplier contact record.

LastUpdateDate Datetime True

The date and time of the most recent update made to the supplier contact record.

LastUpdatedBy String True

The user or system responsible for the last update made to the supplier contact record.

DFF String False

This field can only be used during insertion. For updates and deletions, refer to child table operations, if applicable.

addresses String False

This field can only be used during insertion. For updates and deletions, refer to child table operations, if applicable.

BilltoBuId Long True

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

BindPurchaseFlag String True

Indicates whether the supplier contact is linked to purchase-related activities. The value can be 'true' or 'false.'

BindReqBuId Long True

The unique identifier for the business unit required for processing the supplier contact record.

BindSourcingOnlyFlag String True

Indicates whether the supplier contact is limited to sourcing-related activities only. 'True' means the contact is restricted to sourcing, while 'False' means they are available for other activities.

BindSysdate Date True

The system date when the binding operation for the supplier contact was executed.

Finder String True

A reference to a lookup or search function used for locating or retrieving the supplier contact record.

SupplierId Long True

The unique identifier for the supplier associated with this contact record.

CUReferenceNumber Int False

A reference number used to map child aggregates with their respective parent tables.

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