Setting up inbox entries

Set up inbox entries by identifying the notifications that you wish to be displayed in the inbox. Select a SQL statement for the entry to query the database for the appropriate information to retrieve to the inbox. Select an appropriate screen to associate with the entry, e.g., the Work Orders form for an inbox entry for work orders that currently require approval. Enter a Dataspy to enable the system to automatically query for the records associated with the inbox entry to the called screen. You can also designate whether the entry is accessible to all users (public), or specify the user groups for which to enable the entry.

To set up inbox entries:

  1. Open the Inbox Codes form.
  2. Click New Record.
  3. Inbox Code—Enter a unique code identifying the the inbox entry, and then enter a description of the activity to complete for the inbox entry in the adjacent field. The description will be displayed in the Inbox on the Start Center.
  4. SQL Statement—Enter the SQL statement to calculate the number of applicable records for the inbox entry. The system automatically populates SQL Statement Text.
    Note: SQL Statement cannot exceed the performance score limit defined in the INBXSCOR installation parameter.
  5. Public—Select to give all user groups access to the inbox entry.
    Note: Inbox entries for which user groups have been associated cannot be public.
  6. Screen—Enter the system screen for which to enable a hyperlink to call the screen for the inbox entry.
    Note: If you update Screen, the system clears Dataspy.
  7. Forms Screen—Enter the Infor EAM Oracle Forms screen for which to enable a hyperlink to call the screen for the inbox entry.
  8. Dataspy—Select the Dataspy used to retrieve records for the called system screen.
  9. Filter—Enter the where clause with which to associate the inbox entry.
  10. Click Save Record.