Solved

Is it possible to add a field to a Subscription?

  • 14 September 2021
  • 4 replies
  • 64 views

Userlevel 4
Badge +9

Hello,

We are using Apps 10, UPD11

Is it possible to add a field to the list of fields in the Subscription?  For AR Customer Invoices Analysis, we’d like to add “Status”.  

 

 

Thank you,

Joann

icon

Best answer by Kasun Balasooriya 14 September 2021, 20:37

View original

4 replies

Userlevel 6
Badge +13

Hi @jtobin ,

As noted in the documentation, Not all logical units and fields are available for subscription. Given below are the requirements for a logical unit and its fields to be subscribable. Pleaser refer the following extract : 

 

Subscribable Logical Units and Fields

Not all logical units and fields are available for subscription. Given below are the requirements for a logical unit and its fields to be subscribable.

Logical Unit

  • Logical Unit must have a base table.
  • Objkey/Rowkey and OBJID must be available and enabled on the logical unit.

Fields

  • Field must be available in both the base table and the view currently used in the client form. Both the view and the table must be of the same logical unit. (e.g. client side derived attributes are not supported)
  • Field must have valid Foundation1 properties
  • Data type must be NUMBER, DATE or VARCHAR2. CLOB columns are not currently supported.

 

Documentation link:

 https://docs.ifs.com/techdocs/foundation1/010_overview/270_monitoring/about_obj_subscription/default.htm#Subscribable_Fields

 

If the status is not listed under the filed list available for subscription, it is most likely due to one of the above reasons. Hope this helps. 

 

Thanks,

Kasun

 

Userlevel 4
Badge +9

Hello @Kasun Balasooriya,

Thank you for your response and the link to the documentation. It does look like it’s available in Aurena but we won’t be moving to Aurena for quite some time.  Do you know why it would be available in Aurena but not IEE?

Thanks,

Joann 

Userlevel 5
Badge +9

Joann,

If you add the Subscription in Aurena, does it trigger on the field you want, even if the change is made in IEE? I realize that is not a solution (having to go to Aurena for anything you wish to subscribe to), but it is certainly interesting!

If the field is available in Aurena but not IEE, I will have to debug what code is being called to create the trigger and see what the difference is…

 

Thanks,

Joe Kaufman

 

Userlevel 4
Badge +9

Hello @sutekh137.  Thank you for the suggestion!  It is worth trying.  And it may encourage some users to use Aurena for certain tasks, which will in turn get them comfortable using Aurena.

 

Thank you,

Joann

Reply