PunchoutConnections
Manages URL redirections for punchout catalogs, integrating external supplier catalogs into the procurement flow.
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 Procurement.PunchoutConnections WHERE Finder = 'findBySourceApplication' AND RequisitionBuId = 300000046987012 AND SourceApplication = 'test';
Due to the limitations of the Oracle Fusion Cloud Financials API, querying this view requires the use of Finders.
The PunchoutConnections view supports the 'findBySourceApplication' finder. The fields which can be used along with it are
- RequisitionBuId
- SourceApplication
- DeliverToLocationId
Columns
| Name | Type | Description |
| CatalogId [KEY] | Long | The unique identifier for the catalog associated with the punchout connection, linking it to a specific catalog in the system. |
| CatalogName | String | The name of the catalog associated with the punchout connection, used for identifying and managing the catalog. |
| PunchoutItemId [KEY] | Decimal | The unique identifier for the specific item within the catalog that is being connected through the punchout connection. |
| PunchoutRedirectionURL | String | The URL that redirects the user to the external punchout catalog, where they can view and select items for purchase. |
| Finder | String | The function or mechanism used to search for or retrieve punchout connections, allowing for quick access to the relevant connection records. |
| SourceApplication | String | The name of the source application initiating the punchout connection, indicating the system or platform from which the connection originates. |