Unable to Subscribe to an Approval Step

Hi experts,

I’ve an issue in Aurena version on the following.

Tested Environment: APP10 CMB Aurena (UPD25)

Test Steps:

Navigate to any Document Revision with Approval Steps, and having proper access.

Click Subscribe for any Approval Step.

It gives an error: “APPROVAL_ROUTING DOC_NO” is non Existing Table Column.

When checking the log window, it shows as follows;

22:35:23 DEBUG - POST: {

url: StreamSubscriptions.svc/SubscriptionVirtualSet,

etag: null,

payload: {"SendEmail":false,"Disabled":false,"SelfNotify":false,"OneTime":false,"LuName":"ApprovalRouting","KeyRef":"KEY_REF=DOC_CLASS=100^DOC_NO=D01001^DOC_REV=A1^DOC_SHEET=1^^LINE_NO=1^LU_NAME=DocIssue^STEP_NO=1^","PageUrl":"page/DocumentRevision/Form","ColumnData":"u\"ATTRIBUTE=AppDate^LABEL=Approval Date^\",\"ATTRIBUTE=ApprovalStatus^LABEL=Approval Status^\",\"ATTRIBUTE=AppSign^LABEL=Approved/Rejected By^\",\"ATTRIBUTE=Description^LABEL=Description^\",\"ATTRIBUTE=GroupId^LABEL=Group ID^\",\"ATTRIBUTE=Note^LABEL=Note^\",\"ATTRIBUTE=PersonId^LABEL=Person ID^\",\"ATTRIBUTE=SecurityCheckpointReq^LABEL=Security Checkpoint Required^\",\"ATTRIBUTE=StepNo^LABEL=Step No^\"]"}

}

22:35:23 INFO - REQUEST method "POST"

22:35:23 INFO - REQUEST uri "https://cmbgse1916.corpnet.ifsworld.com:48080/main/ifsapplications/projection/v1/StreamSubscriptions.svc/SubscriptionVirtualSet?odata-debug=json"

22:35:23 INFO - REQUEST protocol "HTTP/1.1"

22:35:23 INFO - REQUEST headers {"Host":"cmbgse1916.corpnet.ifsworld.com:48080","Content-Length":"670","sec-ch-ua-platform":"\"Windows\"","X-XSRF-TOKEN":"WLMC-1SMR-J3HF-RHD1-J26V-PMQW-LRMG-4RO2","Accept-Language":"en-US,en;q=0.5","sec-ch-ua":"\"Google Chrome\";v=\"129\", \"Not=A?Brand\";v=\"8\", \"Chromium\";v=\"129\"","sec-ch-ua-mobile":"?0","X-Requested-With":"XMLHttpRequest","User-Agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36","Accept":"application/json;odata.metadata=full;IEEE754Compatible=true","Content-Type":"application/json;IEEE754Compatible=true","Origin":"https://cmbgse1916.corpnet.ifsworld.com:48080","Sec-Fetch-Site":"same-origin","Sec-Fetch-Mode":"cors","Sec-Fetch-Dest":"empty","Referer":"https://cmbgse1916.corpnet.ifsworld.com:48080/main/ifsapplications/web/page/DocumentRevision/Form;path=0.1743295830.780940358;$filter=Objstate%20eq%20IfsApp.DocumentRevisionHandling.DocIssueState'Preliminary';record=KERvY0NsYXNzPScxMDAnLERvY05vPSdEMDEwMDEnLERvY1NoZWV0PScxJyxEb2NSZXY9J0ExJyk%3D","Accept-Encoding":"gzip, deflate, br, zstd","Cookie":"JSESSIONID=88eLLqHfMV83RI7j19DC2b2jQSCO5QilA5H2RSDIn1FI1zLq1d4p!-715899505; _WL_AUTHCOOKIE_JSESSIONID=ZQXJKE.kXRJP.swoeiM-; XSRF-TOKEN=WLMC-1SMR-J3HF-RHD1-J26V-PMQW-LRMG-4RO2","ECID-Context":"1.00jWk^WBW1OFS8H_yt_AiW0002uW0009Ph;kXjE","Connection":"Keep-Alive","X-Forwarded-For":"10.17.255.81","X-WebLogic-KeepAliveSecs":"30","X-WebLogic-Request-ClusterInfo":"true","x-weblogic-cluster-hash":"+Pp8DjfZgYKflXW6Qy733x05xKw"}

22:35:23 INFO - RESPONSE status {"code":"500","info":"Internal Server Error"}

22:35:23 INFO - RESPONSE headers {"OData-Version":"4.0","Content-Type":"application/json"}

22:35:23 INFO - RESPONSE body "{\"error\":{\"code\":\"DATABASE_ERROR\",\"message\":\"Database error occurred. Contact administrator.\",\"details\":r{\"code\":20105,\"message\":\"ORA-20105: Assert.IS_VIEW_COL: \\\"APPROVAL_ROUTING.DOC_NO\\\" is non existing table column.\"}]}}"

22:35:23 TRACE - SERVER version "odata-server-core Version 4.5.0.3-ifs"

22:35:23 TRACE - SERVER environment {"authType":"CLIENT_CERT","localAddr":"10.17.32.138","localName":"cmbgse1916.corpnet.ifsworld.com","localPort":"48100","pathInfo":"/StreamSubscriptions.svc/SubscriptionVirtualSet","pathTranslated":null,"remoteAddr":"10.17.255.81","remoteHost":"10.17.255.81","remotePort":"58003","remoteUser":"ALAIN","scheme":"https","serverName":"cmbgse1916.corpnet.ifsworld.com","serverPort":"48080","servletPath":"/v1"}

22:35:23 TRACE - SERVER uri {"kind":"resource","uriResourceParts":r{"uriResourceKind":"entitySet","segment":"SubscriptionVirtualSet","type":"IfsApp.StreamSubscriptions.SubscriptionVirtual","isCollection":true}],"customQueryOptions":{"odata-debug":"json"}}

22:35:23 TRACE - SERVER runtime -{"class":"ODataHandlerWrapper","method":"process","duration":35461,"unit":"µs","children"::{"class":"ODataHandlerWrapper","method":"fillODataRequest","duration":47,"unit":"µs","children":"{"class":"ODataHandlerWrapper","method":"copyHeaders","duration":24,"unit":"µs"},{"class":"ODataHandlerWrapper","method":"fillUriInformation","duration":16,"unit":"µs"}]},{"class":"ODataHandler","method":"process","duration":35411,"unit":"µs","children":n{"class":"ODataHandler","method":"processInternal","duration":30430,"unit":"µs","children":u{"class":"Parser","method":"parseUri","duration":122,"unit":"µs"},{"class":"UriValidator","method":"validate","duration":23,"unit":"µs"},{"class":"ODataDispatcher","method":"dispatch","duration":30276,"unit":"µs"}]},{"class":"ODataHandler","method":"handleException","duration":4960,"unit":"µs","children":6{"class":"ErrorProcessor","method":"processError","duration":4864,"unit":"µs"}]}]}]}]

22:35:23 TRACE - SERVER stacktrace {"exceptions":E{"class":"com.ifsworld.fnd.common.exceptions.DatabaseException","message":"Failed to execute the generated database statement","invocation":{"class":"com.ifsworld.fnd.storage.StorageProviderUtils","method":"createODataProviderExceptionFrom","line":1144}},{"class":"java.sql.SQLException","message":"ORA-20105: Assert.IS_VIEW_COL: \"APPROVAL_ROUTING.DOC_NO\" is non existing table column.\nORA-06512: at \"IFSAPP.OBJECT_CONNECTION_SYS\", line 1051\nORA-06512: at \"IFSAPP.ERROR_SYS\", line 140\nORA-06512: at \"IFSAPP.ERROR_SYS\", line 341\nORA-06512: at \"IFSAPP.ASSERT_SYS\", line 624\nORA-06512: at \"IFSAPP.OBJECT_CONNECTION_SYS\", line 1006\nORA-06512: at \"IFSAPP.STREAM_SUBSCRIPTIONS_SVC\", line 3387\nORA-06512: at \"IFSAPP.STREAM_SUBSCRIPTIONS_SVC\", line 3410\nORA-06512: at \"IFSAPP.STREAM_SUBSCRIPTIONS_SVC\", line 1359\nORA-06512: at \"IFSAPP.STREAM_SUBSCRIPTIONS_SVC\", line 1369\nORA-06512: at line 1\n","invocation":{"class":"oracle.jdbc.driver.T4CTTIoer11","method":"processError","line":494}},{"class":"oracle.jdbc.OracleDatabaseException","message":"ORA-20105: Assert.IS_VIEW_COL: \"APPROVAL_ROUTING.DOC_NO\" is non existing table column.\nORA-06512: at \"IFSAPP.OBJECT_CONNECTION_SYS\", line 1051\nORA-06512: at \"IFSAPP.ERROR_SYS\", line 140\nORA-06512: at \"IFSAPP.ERROR_SYS\", line 341\nORA-06512: at \"IFSAPP.ASSERT_SYS\", line 624\nORA-06512: at \"IFSAPP.OBJECT_CONNECTION_SYS\", line 1006\nORA-06512: at \"IFSAPP.STREAM_SUBSCRIPTIONS_SVC\", line 3387\nORA-06512: at \"IFSAPP.STREAM_SUBSCRIPTIONS_SVC\", line 3410\nORA-06512: at \"IFSAPP.STREAM_SUBSCRIPTIONS_SVC\", line 1359\nORA-06512: at \"IFSAPP.STREAM_SUBSCRIPTIONS_SVC\", line 1369\nORA-06512: at line 1\n","invocation":{"class":"oracle.jdbc.driver.T4CTTIoer11","method":"processError","line":498}}],"stacktrace":,{"class":"com.ifsworld.fnd.storage.StorageProviderUtils","method":"createODataProviderExceptionFrom","line":1144},{"class":"com.ifsworld.fnd.storage.PlsqlStatementExecutor","method":"executeStatement","line":130},{"class":"com.ifsworld.fnd.storage.PlsqlStatementExecutor","method":"execute","line":105},{"class":"com.ifsworld.fnd.storage.PlsqlStatementExecutor","method":"execute","line":81},{"class":"com.ifsworld.fnd.storage.PlsqlStatementExecutor","method":"execute","line":58},{"class":"com.ifsworld.fnd.storage.invoker.CreateWriter","method":"createEntity","line":136},{"class":"com.ifsworld.fnd.storage.invoker.CreateWriter","method":"invokeInternal","line":106},{"class":"com.ifsworld.fnd.storage.invoker.CreateWriter","method":"invoke","line":97},{"class":"com.ifsworld.fnd.storage.invoker.CreateWriter","method":"invoke","line":59},{"class":"com.ifsworld.fnd.provider.processor.FndEntityProcessor","method":"createEntity","line":385},{"class":"com.ifsworld.fnd.provider.processor.FndEntityProcessor","method":"createEntity","line":333},{"class":"org.apache.olingo.server.core.ODataDispatcher","method":"handleEntityCollectionDispatching","line":544},{"class":"org.apache.olingo.server.core.ODataDispatcher","method":"handleEntityDispatching","line":510},{"class":"org.apache.olingo.server.core.ODataDispatcher","method":"handleResourceDispatching","line":151},{"class":"org.apache.olingo.server.core.ODataDispatcher","method":"dispatch","line":117},{"class":"org.apache.olingo.server.core.ODataHandlerImpl","method":"processInternal","line":164},{"class":"org.apache.olingo.server.core.ODataHandlerImpl","method":"process","line":85},{"class":"com.ifsworld.fnd.provider.ODataHandlerWrapper","method":"process","line":64},{"class":"com.ifsworld.fnd.provider.ODataHandlerWrapper","method":"process","line":77},{"class":"web.FndODataServlet","method":"serviceODataRequest","line":313},{"class":"web.FndODataServlet","method":"serviceProjectionRequest","line":157},{"class":"web.FndODataServlet","method":"service","line":110},{"class":"javax.servlet.http.HttpServlet","method":"service","line":790},{"class":"weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction","method":"run","line":295},{"class":"weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction","method":"run","line":260},{"class":"weblogic.servlet.internal.StubSecurityHelper","method":"invokeServlet","line":137},{"class":"weblogic.servlet.internal.ServletStubImpl","method":"execute","line":353},{"class":"weblogic.servlet.internal.TailFilter","method":"doFilter","line":25},{"class":"weblogic.servlet.internal.FilterChainImpl","method":"doFilter","line":78},{"class":"web.ResponseFilter","method":"doFilter","line":62},{"class":"weblogic.servlet.internal.FilterChainImpl","method":"doFilter","line":78},{"class":"web.InitConfigurationFilter","method":"doFilter","line":173},{"class":"weblogic.servlet.internal.FilterChainImpl","method":"doFilter","line":78},{"class":"weblogic.servlet.internal.RequestEventsFilter","method":"doFilter","line":32},{"class":"weblogic.servlet.internal.FilterChainImpl","method":"doFilter","line":78},{"class":"weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction","method":"wrapRun","line":3800},{"class":"weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction","method":"run","line":3766},{"class":"weblogic.security.acl.internal.AuthenticatedSubject","method":"doAs","line":344},{"class":"weblogic.security.service.SecurityManager","method":"runAsForUserCode","line":197},{"class":"weblogic.servlet.provider.WlsSecurityProvider","method":"runAsForUserCode","line":203},{"class":"weblogic.servlet.provider.WlsSubjectHandle","method":"run","line":71},{"class":"weblogic.servlet.internal.WebAppServletContext","method":"doSecuredExecute","line":2454},{"class":"weblogic.servlet.internal.WebAppServletContext","method":"securedExecute","line":2302},{"class":"weblogic.servlet.internal.WebAppServletContext","method":"execute","line":2280},{"class":"weblogic.servlet.internal.ServletRequestImpl","method":"runInternal","line":1739},{"class":"weblogic.servlet.internal.ServletRequestImpl","method":"run","line":1699},{"class":"weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor","method":"run","line":272},{"class":"weblogic.invocation.ComponentInvocationContextManager","method":"_runAs","line":352},{"class":"weblogic.invocation.ComponentInvocationContextManager","method":"runAs","line":337},{"class":"weblogic.work.LivePartitionUtility","method":"doRunWorkUnderContext","line":57},{"class":"weblogic.work.PartitionUtility","method":"runWorkUnderContext","line":41},{"class":"weblogic.work.SelfTuningWorkManagerImpl","method":"runWorkUnderContext","line":655},{"class":"weblogic.work.ExecuteThread","method":"execute","line":420},{"class":"weblogic.work.ExecuteThread","method":"run","line":360}]}

22:35:23 TRACE - DATABASE {"origin":"MT","type":"sql","text":"{? = call Login_SYS.Init_Odp_Session_(?,?,?,?,?,?,?,?,?,?,?)}"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"10","time":"156913843","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Security not checked for Fnd_Session_API.Set_Rfc3066__"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"12","time":"156913843","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Security not checked for Fnd_Session_Util_API.Set_Rfc3066_"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"14","time":"156913845","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Security not checked for ASSERT_SYS.Encode_Single_Quote_String"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"12","time":"156913845","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Security not checked for ASSERT_SYS.Encode_Single_Quote_String"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"9","time":"156913845","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Security not checked for Fnd_Session_API.Set_Fnd_User"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"10","time":"156913845","category":"FRAMEWORK","level":"DEBUG","type":"Framework","text":"Package: LOGIN_SYS"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"11","time":"156913845","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Security not checked for Fnd_Session_Util_API.Set_Fnd_User_"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"15","time":"156913845","category":"APPLICATION","level":"TRACE","type":"Application","text":"========================================== "}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"15","time":"156913845","category":"APPLICATION","level":"TRACE","type":"Application","text":"Set_Fnd_User_ "}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"15","time":"156913845","category":"APPLICATION","level":"TRACE","type":"Application","text":"========================================== "}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"15","time":"156913845","category":"APPLICATION","level":"TRACE","type":"Application","text":"Foundation User is set to ALAIN."}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"7","time":"156913845","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"============================ "}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"7","time":"156913845","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Login_SYS.Init_Fnd_Session__ "}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"7","time":"156913845","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"============================ "}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"7","time":"156913845","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Directory Id: ALAIN"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"7","time":"156913845","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Foundation User: ALAIN"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"7","time":"156913845","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Current Language Code Rfc3066: en-US"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"7","time":"156913845","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Language Code Rfc3066: en-US"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"7","time":"156913845","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Current Language Code: en"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"7","time":"156913845","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Language Code: en"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"7","time":"156913845","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Calendar: GREGORIAN"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"8","time":"156913845","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Security not checked for Fnd_Session_API.Set_Property"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"10","time":"156913845","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Security not checked for Fnd_Session_Util_API.Set_Property_"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"7","time":"156913845","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Security not checked for Fnd_Session_API.Set_Property"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"5","time":"156913845","category":"FRAMEWORK","level":"DEBUG","type":"Framework","text":"Checking CUD security for StreamSubscriptions.SubscriptionVirtual"}

22:35:23 TRACE - DATABASE {"origin":"MT","type":"sql","textWithBinds":"BEGIN :Return_$ := Stream_Subscriptions_SVC.CRUD_Create(:Attr, :Action$, subscription_virtual## => '');END;","bindParams":{"Action$":{"value":"DO","direction":"IN","dbColumn":"null","dbType":"VARCHAR2"},"Attr":{"value":"SEND_EMAIL\u001f0\u001eDISABLED\u001f0\u001eSELF_NOTIFY\u001f0\u001eONE_TIME\u001f0\u001eLU_NAME\u001fApprovalRouting\u001eKEY_REF\u001fKEY_REF=DOC_CLASS=100^DOC_NO=D01001^DOC_REV=A1^DOC_SHEET=1^^LINE_NO=1^LU_NAME=DocIssue^STEP_NO=1^\u001ePAGE_URL\u001fpage/DocumentRevision/Form\u001e","direction":"IN","dbColumn":"null","dbType":"VARCHAR2"},"Return_$":{"value":"null","direction":"OUT","dbColumn":"STREAM_SUBSCRIPTIONS_SVC.ENTITY_DEC","dbType":"STRUCTURE"}},"text":"BEGIN NULL := Stream_Subscriptions_SVC.CRUD_Create('SEND_EMAIL\u001f0\u001eDISABLED\u001f0\u001eSELF_NOTIFY\u001f0\u001eONE_TIME\u001f0\u001eLU_NAME\u001fApprovalRouting\u001eKEY_REF\u001fKEY_REF=DOC_CLASS=100^DOC_NO=D01001^DOC_REV=A1^DOC_SHEET=1^^LINE_NO=1^LU_NAME=DocIssue^STEP_NO=1^\u001ePAGE_URL\u001fpage/DocumentRevision/Form\u001e', 'DO', subscription_virtual## => '');END;"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"5","time":"156913845","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Calling Projection Method: Stream_Subscriptions_SVC.CRUD_Create"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"6","time":"156913845","category":"CALLSTACK","level":"INFORMATION","type":"","text":"Stream_Subscriptions_SVC.CRUD_Create entered."}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"10","time":"156913846","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Security not checked for ASSERT_SYS.Assert_Is_Table_Column"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"13","time":"156913846","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Security not checked for Server_Log_API.Log_Autonomous"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"15","time":"156913846","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Security not checked for Server_Log_API.Log"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"11","time":"156913846","category":"CALLSTACK","level":"DEBUG","type":"","text":"__anonymous_block at line 1 STREAM_SUBSCRIPTIONS_SVC.CRUD_CREATE at line 1369 STREAM_SUBSCRIPTIONS_SVC.CRUD_CREATE.BASE at line 1359 STREAM_SUBSCRIPTIONS_SVC.CRUD_CREATE___ at line 3410 STREAM_SUBSCRIPTIONS_SVC.CRUD_CREATE___.CORE_PROJECTION_STREAMSUBSCRIPTIONS at line 3387 OBJECT_CONNECTION_SYS.GET_ROWID_FROM_KEYREF at line 1006 ASSERT_SYS.ASSERT_IS_TABLE_COLUMN at line 624 ERROR_SYS.APPL_GENERAL at line 341 ERROR_SYS.RAISE_APPLICATION_ERROR___ at line 129 ERROR_SYS.RAISE_APPLICATION_ERROR___.FORMAT_CALL_STACK___ at line 123 "}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"7","time":"156913846","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Security not checked for Server_Log_API.Log_Server_Error_"}

22:35:23 TRACE - DATABASE {"origin":"DB","indentation":"9","time":"156913846","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Security not checked for Server_Log_API.Log"}

22:35:23 ERROR - IS_VIEW_COL - (Server Application Error): "APPROVAL_ROUTING.DOC_NO" is non existing table column.

Database error occurred. Contact administrator.

undefined

I would appreciate your insights on whether this is a functional issue or a system bug, as well as any guidance you may have on how it can be resolved.

The same issue can be identified in Cloud Environments as well.

Thanks & Regards

Page 1 / 1

It's either a bug in the subscription functionality or simply some fringe case they didn't foresee or something that was purposefully left out in the design for whatever reason.

You can file a support case to the platform team so that they can have a look, or try to workaround the problem with a custom event and event action.

What's the reason for wanting to subscribe to a feature that almost have subscriptions baked in?

@Mathias Dahl ,

Certainly. I’ll make infra team aware. So, to clarify, this issue is not related to DOCMAN and cannot be addressed through DOCMAN, correct?

Yeah, they want subscriptions for approvals as well

Thanks

@Mathias Dahl ,

Certainly. I’ll make infra team aware. So, to clarify, this issue is not related to DOCMAN and cannot be addressed through DOCMAN, correct?

The issue is of course related to Docman, but I don't think there is a bug in Docman.

Yeah, they want subscriptions for approvals as well

Can you share some more details? What's their end goal with this? Did you consider using custom events instead?

Hi Aravinda / Mathias,

My company also found this same bug recently, and have reported it to IFS Support (Case ID: CS0303112).

In our case, we have implemented a Custom Event Action to send notification emails in relation to approval steps (for approvers and/or doc responsible persons). However, in some cases other users also have an “interest” in the outcome of an approval step. For example, an engineer may want to know if a specific document has been approved or rejected by the SLT even though the engineer is not directly responsible for the doc, or involved in the approval process. In this situation, the user might want to use the subscription system so they receive a streams notification (or an email) when the approval step is either approved or rejected.

The ability to subscribe to a record is available on almost all IFS pages, and so the expectation is that the IFS Subscription system should work reliably across the full application.

Robin

Reply

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded