Enabling Flex business rules on Infor EAM transaction tables

If you are using Infor EAM (Oracle Forms), you must manually enable Flex SQL functionality on the appropriate database tables in the Infor 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 Infor EAM to meet the needs of the business process for your organization.

Note: If you are using Infor EAM or Infor 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 Infor EAM user schema that is required to support the interface transactions being implemented. Every table in the Infor EAM user schema is available for Flex SQL.

Note: 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 Infor EAM user schema, which adds "overhead" to the application. Balance the "overhead" caused by using Flex SQL with the interface business requirements.

To enable Flex SQL on Infor EAM transaction tables:

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.

Note: 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.