If you are using HxGN EAM (Oracle Forms), you must manually enable Flex SQL functionality on the appropriate database tables in the HxGN EAM user schema that are used for Databridge integration/transactions. Flex SQL is primarily used to create and update account details for interface transactions. Because Flex SQL creates additional triggers on a table, it can also validate transactions for business process compliance and customize HxGN EAM to meet the needs of the business process for your organization.
If you are using HxGN EAM or HxGN EAM for SQL Server, you do not need to manually
enable Flex SQL, because Flex SQL is automatically activated on the database tables.
Enable Flex SQL for any table in the HxGN EAM user schema that is required to support the interface transactions being implemented. Every table in the HxGN EAM user schema is available for Flex SQL.
The list of values in the Flex SQL tables form (YNFLXT) filters for tables beginning
with R5.
Activating Flex SQL for a table creates two triggers in the HxGN EAM user schema, which adds "overhead" to the application. Balance the "overhead" caused by using Flex SQL with the interface business requirements.
-
Open the Flex SQL tables form (YNFLXT).
-
Select the Table for which to enable Flex SQL.
-
Select File > Save. The information is saved to the database.
After enabling Flex SQL for the appropriate tables, you must define Flex SQL procedures
for each of the tables for which you have enabled Flex SQL.