Procurement Data Model
In the Procurement Data Model schema, the connector models information such as suppliers, purchase orders, and shopping lists associated with the authenticated account as an easy-to-use SQL database. Live connectivity to these objects means that any changes to your Oracle Fusion Cloud Financials account are immediately reflected in the connector.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Oracle Fusion Cloud Financials account.
Common tables include:
| Table | Description |
| PurchaseOrders | Represents finalized purchase orders for goods or services from external suppliers, capturing key terms and statuses. |
| PurchaseOrderslines | Lists line-level details within a purchase order, specifying items, quantities, unit prices, and related buying terms. |
| PurchaseOrderslinesschedules | Defines the planned shipment dates and delivery details for each line item in a purchase order. |
| PurchaseOrderslinesschedulesdistributions | Allocates purchase order schedule costs to particular accounts or projects, ensuring accurate financial tracking. |
| PurchaseRequisitions | Handles internal purchase requests for items or services, capturing details for eventual PO creation or approval. |
| PurchaseRequisitionslines | Displays item-level details (part, quantity, pricing) for each line in the requisition, forming the basis for purchasing decisions. |
| PurchaseAgreementLines | Describes goods or services in a purchase agreement, excluding delivery or fulfillment specifics, to outline negotiated items. |
| PurchaseAgreements | Holds purchase agreement headers (quantity- or value-based) with negotiated terms, used by subsequent POs or contracts. |
| Suppliers | Manages core supplier records, including contact details, addresses, business classifications, and attachments. |
| Suppliersaddresses | Captures location data for suppliers, such as physical or mailing addresses, to support invoicing and shipping. |
| Supplierscontacts | Maintains supplier contact records, including names, emails, and roles for consistent communication and procurement updates. |
| ProcurementApprovedSupplierListEntries | Tracks relationships between suppliers and the items or categories they’re approved to supply, ensuring compliance and vendor checks. |
| PurchaseOrdersattachments | Stores documents (for example, contracts, specifications) linked to a purchase order, enhancing detail for audits or approvals. |
| PurchaseRequisitionsattachments | Maintains documents attached to purchase requisitions, such as quotes, justifications, or requirement definitions. |
| PurchaseOrdersDFF | Captures additional descriptive flexfield data at the purchase order header level, allowing custom fields. |
| PurchaseRequisitionslinesdistributions ; | Splits the requisition line cost across multiple accounts or projects, aiding correct budget and financial reporting. |
| RequisitionProcessingRequests | Handles the conversion of approved requisition lines into purchase documents (for example, purchase orders), orchestrating the procurement flow. |
| WorkConfirmations | Handles confirmations of completed work for complex service or construction purchase orders, aiding accurate billing and progress tracking. |
| SupplierNegotiationResponses | Retrieves supplier-submitted responses to sourcing negotiations (for example, RFI, RFQ), offering visibility into proposed terms and pricing. |
| PublicShoppingLists | Defines public shopping list headers, grouping related items for streamlined requisition or bulk purchasing. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including modifying agreements and uploading attachments.