Troubleshooting

The following guide can be used to troubleshoot problems with the Object Subscription functionality.

Content

• Cannot subscribe to any object in a form
• The message "Subscriptions for this logical unit is disabled by the Administrator" is shown
• Field not available in the Subscription dialog
• Streams Notification is not received even though the object has changed after a successful subscription

Cannot subscribe to any object in a form

It is sometime not possible to subscribe to any object in a form because of limitation in the form/logical unit or limitations in the object subscription functionality. For a particular form/logical unit to be subscribable the following characteristics must be there.

• The Dictionary information must be up to date.
• OBJKEY and OBJID must exists in the view used in the client form and ROWKEY column must exists in the base table of the logical unit
• ROWKEY Functionality must be enabled on the logical unit
• Subscriptions for the logical unit should be enabled.

The message "Subscriptions for this logical unit is disabled by the Administrator" is shown

The subscription has been disabled at the logical unit level or at the individual subscription level by the Administrator.

Check the Object Subscription Logical Unit Form or the Object Subscription Overview form

Field not available in the Subscription dialog

Sometimes it is not possible to subscribe to all fields visible in the form. For a field to become subscribable the following requirements must be met.

• Field must be available in both the base table and the view currently used in the client form. (e.g. client side derived attributes are not supported).
• If the field name in the view is different to that of the table, then model properties for the field must be set correctly to reflect the difference.
• Both the view and the table must belong to the same logical unit.
• Field must have valid Foundation1 properties
• Data type must be either VARCHAR2, NUMBER or DATE

Streams Notification is not received even though the object has changed after a successful subscription

This can be caused by number of different reasons. Give below is a list of things to check to find the reason why

• Is Oracle Scheduler running properly ?
• Is there a warning icon in the streams panel ? This means that there is an issue with the push notification services. See troubleshooting Streams functionality for more details.
• Is the subscription enabled in Object Subscription Overview form ?
• Is tracking enabled for the logical unit, and are the triggers enabled in Object Subscription Logical Unit Form ?
• Are their messages left in the Queue FND_TRK_LU_DMO_Q in Oracle Queues? If 'No of Subscribers is zero, then somehow the subscriber for the Queue has been removed. If so log in to the database as the application owner and execute the procedure 'Fnd_Obj_Tracking_SYS.Initialize_Queue'
• Are their any errors in the debug console when a user performs the changes to the business object (e.g. : modifying the CustomerOrder) ?
• Are there any Server Errors in the Database Alert Log which says Object Tracking Error or Client Notification Error ? If so contact IFS with this information.