JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

ShoppingCatalogSmartFormDetailsinformationTemplateAssignments

Associates information templates (additional fields or questionnaires) with a smart form, ensuring comprehensive data collection.

Columns

Name Type Description
ShoppingCatalogSmartFormDetailsSmartFormId [KEY] Long The unique identifier for the smart form associated with the information template assignment. Example: 1001 for the smart form ID.
SmartFormId Long The unique identifier for the smart form used in the assignment. Example: 2001 for the smart form ID associated with the template.
InformationTemplateAssignmentId [KEY] Long The unique identifier for the information template assignment. Example: 3001 for the ID of the information template assignment.
InformationTemplateId Long The unique identifier for the information template. Example: 4001 for the ID of the assigned template.
InformationTemplate String The name of the information template being assigned. Example: 'Procurement Template' for the assigned template.
InformationTemplateDisplayName String The display name of the information template. Example: 'Purchase Order Template' for the user-friendly name of the template.
InstructionText String The instruction text associated with the information template. Example: 'Please fill in the required fields for the purchase order.'
DFFContextCode String The context code for the descriptive flexfield associated with the information template assignment. Example: 'PO_HEADER' for a context related to purchase orders.
Finder String A reference or placeholder used for searching and locating specific records of the information template assignment. Example: 'Search by Template Name'.
SysEffectiveDate String The system-effective date used for filtering resources based on their effective date. Example: '2023-06-01' for filtering based on June 1st, 2023.
EffectiveDate Date This query parameter is used to fetch resources that are effective as of the specified start date. Example: '2023-06-01' for filtering resources effective from June 1st, 2023.

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