Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

Suppliers

Manages core supplier records, including contact details, addresses, business classifications, and attachments.

Table-Specific Information

Select

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

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

SELECT * FROM [Cdata].[Procurement].[Suppliers] WHERE SupplierId = 10003

Insert

Create a Supplier. 

INSERT INTO [Cdata].[Procurement].[Suppliers] (BusinessRelationshipCode,Supplier,TaxOrganizationTypeCode) VALUES ('SPEND_AUTHORIZED', 'Lee Supplies1', 'CORPORATION')

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 SupplierUniqId instead of SupplierId 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].[Suppliers] set YearEstablished=2021 WHERE SupplierUniqId = 454545454;

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

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

Update [Cdata].[Procurement].[Suppliers] set YearEstablished=2021 WHERE SupplierUniqId = 454545454 and ParentSupplier='asdw';

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

Columns

Name Type ReadOnly Description
SupplierId [KEY] Long True

The unique identifier assigned to each supplier in the system.

SupplierUniqId [KEY] String True

This value should be used in all insert, update, and delete operations as a more stable identifier than SupplierId.

SupplierPartyId Long False

A unique identifier for the supplier party, which can represent an entity or organization associated with the supplier.

Supplier String False

The official name of the supplier as recorded in the system.

SupplierNumber String False

An identifier used to distinguish the supplier, often assigned by external systems or organizations.

AlternateName String False

An alternate or secondary name for the supplier, which may be used in different contexts or regions.

TaxOrganizationTypeCode String False

The abbreviation identifying the supplier's tax organization type. The valid values are defined in the lookup type POZ_ORGANIZATION_TYPE, which can be managed through the Setup and Maintenance work area.

TaxOrganizationType String False

The full description of the tax organization type associated with the supplier, based on the lookup type POZ_ORGANIZATION_TYPE.

SupplierTypeCode String False

A code representing the type of supplier according to the lookup type POZ_VENDOR_TYPE, which can be maintained in the Setup and Maintenance work area.

SupplierType String False

The description of the supplier type, as defined in the POZ_VENDOR_TYPE lookup. This value should be updated as needed.

InactiveDate Date False

The date when the supplier was marked as inactive in the system, meaning they no longer conduct business.

Status String True

The current operational status of the supplier, which may include values such as active, inactive, or pending.

BusinessRelationshipCode String False

A code representing the business relationship between the enterprise and the supplier, defined in the lookup type ORA_POZ_BUSINESS_RELATIONSHIP.

BusinessRelationship String False

A textual description of the business relationship with the supplier, providing more context about the supplier's role.

ParentSupplierId Long False

The unique identifier for the parent supplier, if applicable. This is used to track hierarchical supplier relationships.

ParentSupplier String False

The name of the parent supplier in the supplier hierarchy, which may be relevant for organizations with multiple subsidiary suppliers.

ParentSupplierNumber String True

The unique identifier for the parent supplier, which may be assigned by external systems or the supplier itself.

CreationDate Datetime True

The timestamp of when the supplier record was created in the system.

CreatedBy String True

The name or identifier of the user who created the supplier record.

LastUpdateDate Datetime True

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

LastUpdatedBy String True

The name or identifier of the user who last updated the supplier record.

CreationSourceCode String True

A code that identifies the source of the supplier record creation, such as an integration system or manual entry.

CreationSource String True

A description of the source from which the supplier record was created, providing additional context.

DataFoxScore Long False

An intelligence score assigned to the supplier by Oracle DataFox. Although the attribute exists, it is not currently being used in the system.

DataFoxScoringCriteria String False

A detailed explanation of the criteria used by Oracle DataFox to assign scores to suppliers, though this is not currently active.

Alias String False

An alternate internal name used for the supplier organization, useful for internal references or different naming conventions.

DUNSNumber String False

A unique number assigned to the supplier organization by Dun & Bradstreet for identification in business transactions.

OneTimeSupplierFlag Bool False

Indicates whether the supplier is a one-time supplier (true) or not (false). By default, the value is false.

RegistryId String True

An identifier for the supplier's registration in a relevant registry or official record.

CustomerNumber String False

The unique number the supplier assigns to the buying organization for tracking purposes.

StandardIndustryClass String False

The standard industry classification code assigned to the supplier, which categorizes their business within a specific industry.

IndustryCategory String False

A code representing the supplier's industry category, as defined by Oracle DataFox intelligence. This attribute is not currently in use.

IndustrySubcategory String False

A code representing the supplier's industry subcategory, also provided by Oracle DataFox intelligence, but not in use.

NationalInsuranceNumber String False

A unique identification number for a supplier who is an individual, used by some countries for tracking work, taxation, and government benefits.

NationalInsuranceNumberExistsFlag Bool False

Indicates whether the National Insurance number is available for the supplier (true) or not (false). By default, the value is false.

CorporateWebsite String False

The official website URL for the supplier organization.

YearEstablished Int False

The year the supplier organization was originally established.

MissionStatement String False

A description of the supplier's mission or core values as defined by the organization.

YearIncorporated Int False

The year when the supplier organization was formally incorporated as a legal entity.

ChiefExecutiveTitle String False

The formal title of the chief executive officer within the supplier organization.

ChiefExecutiveName String False

The name of the individual currently serving as the chief executive officer of the supplier organization.

PrincipalTitle String False

The formal title of the principal officer within the supplier organization.

PrincipalName String False

The name of the principal officer responsible for managing the supplier organization.

FiscalYearEndMonthCode String False

A code representing the month when the fiscal year ends for the supplier organization. Valid values are defined in the MONTH lookup type.

FiscalYearEndMonth String False

The full name of the month when the fiscal year ends for the supplier organization, such as 'December' or 'June.'

CurrentFiscalYearPotentialRevenue Decimal False

The estimated potential revenue that the supplier expects to generate during the current fiscal year.

PreferredFunctionalCurrencyCode String False

The currency code used by the supplier in their financial transactions. This value is defined by the supplier organization.

PreferredFunctionalCurrency String False

The full name of the currency that the supplier prefers to use for financial transactions, such as 'USD' or 'EUR.'

TaxRegistrationCountryCode String False

A code representing the country where the supplier is registered for value-added tax purposes.

TaxRegistrationCountry String False

The full name of the country where the supplier is registered for value-added tax purposes.

TaxRegistrationNumber String False

A unique identification number assigned to the supplier for tax purposes in some countries, such as those in the European Union.

TaxpayerCountryCode String False

A code representing the country where the supplier organization is responsible for paying taxes.

TaxpayerCountry String False

The full name of the country where the supplier organization is located and responsible for tax obligations.

TaxpayerId String False

A unique identification number for the supplier used for tax reporting purposes.

TaxpayerIdExistsFlag Bool False

Indicates whether the taxpayer ID is available for the supplier (true) or not (false). By default, the value is false.

FederalReportableFlag Bool False

Indicates whether the supplier is reportable to the Internal Revenue Service (IRS) in the United States under the 1099 tax code.

FederalIncomeTaxTypeCode String False

A code identifying the type of income tax that applies to the supplier for IRS 1099 reporting purposes.

FederalIncomeTaxType String False

A description of the type of income tax that applies to the supplier, used for IRS 1099 reporting.

StateReportableFlag Bool False

Indicates whether the supplier is reportable to a state taxing authority in the United States for tax purposes.

TaxReportingName String False

The name used for tax reporting purposes for suppliers who are reportable under the IRS 1099 tax code.

NameControl String False

The first four characters of the supplier's last name, used for IRS 1099 reporting and matching.

VerificationDate Date False

The date when the supplier's tax verification for the 1099 tax code was most recently updated.

UseWithholdingTaxFlag Bool False

Indicates whether withholding tax is applicable to the supplier (true) or not (false). By default, the value is false.

WithholdingTaxGroupId Long False

The unique identifier for the tax group assigned to the supplier for withholding tax purposes.

WithholdingTaxGroup String False

The description of the withholding tax group assigned to the supplier based on applicable tax regulations.

BusinessClassificationNotApplicableFlag Bool False

Indicates whether a business classification is applicable to the supplier (false) or not (true). By default, the value is false.

DataFoxId String False

The unique identifier assigned by Oracle DataFox to the company linked with the supplier. This attribute is not in use.

DataFoxCompanyName String False

The company name provided by Oracle DataFox for the linked supplier organization. This attribute is not in use.

DataFoxLegalName String False

The legal name of the supplier company as provided by Oracle DataFox. This attribute is not in use.

DataFoxCompanyPrimaryURL String False

The primary website URL for the supplier as tracked by Oracle DataFox. This attribute is not in use.

DataFoxNAICSCode String False

The NAICS code provided by Oracle DataFox for the supplier organization. This attribute is not in use.

DataFoxCountry String False

The country where the supplier organization is located, as provided by Oracle DataFox. This attribute is not in use.

DataFoxEIN String False

The employer identification number (EIN) provided by Oracle DataFox for the supplier organization. This attribute is not in use.

DataFoxLastSyncDate Datetime False

The timestamp when the supplier profile was last synchronized with Oracle DataFox. This attribute is not in use.

OBNEnabledFlag Bool True

Indicates whether the OBN (Oracle Business Network) feature is enabled for the supplier.

OnOFACListFlag Bool False

Indicates whether the supplier is listed on the US Government's Office of Foreign Assets Control (OFAC) list, which tracks sanctioned individuals and organizations.

OFACSources String False

Details about the specific lists within the US Government's consolidated screening list that the supplier appears on, such as from the Office of Foreign Assets Control.

contacts String False

Used only for insert operations. For update and delete, use the appropriate child table operations.

productsAndServices String False

Used only for insert operations. For update and delete, use the appropriate child table operations.

DFF String False

Used only for insert operations. For update and delete, use the appropriate child table operations.

globalDFF String False

Used only for insert operations. For update and delete, use the appropriate child table operations.

businessClassifications String False

Used only for insert operations. For update and delete, use the appropriate child table operations.

sites String False

Used only for insert operations. For update and delete, use the appropriate child table operations.

addresses String False

Used only for insert operations. For update and delete, use the appropriate child table operations.

BilltoBuId Long True

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

BindPurchaseFlag String True

A flag that indicates whether the supplier is bound to a particular purchase type or condition.

BindReqBuId Long True

The unique identifier for the required business unit associated with the supplier.

BindSourcingOnlyFlag String True

Indicates whether the supplier is restricted to sourcing activities only (true or false).

BindSysdate Date True

The system date when the binding action was performed for the supplier.

Finder String True

A reference to a search or lookup system associated with the supplier record.

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