Procurement Data Model
In the Procurement Data Model schema, the add-in 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 add-in.
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.