Function "per_bipntf_flex.getEFFAttributesFromCompare" is not retriving the data properly.

Summary:

We are using TABLE(per_bipntf_flex.getEFFAttributesFromCompare(htd.TRANSACTION_ID, 'Responsive', 'j_CategoryPerAsgEitResponsiveEmplFlowsVORow','FALSE')) function to fetch additional assignment information in transaction console. For the second time when we are entering the additional assignment infomation this function is not fetching any of the details.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT  ATTRIBUTE_NEW_VALUEFROM

   TABLE(per_bipntf_flex.getEFFAttributesFromCompare(htd.TRANSACTION_ID, 'Responsive', 'j_CategoryPerAsgEitResponsiveEmplFlowsVORow','FALSE'))  eff,  fnd_df_contexts_vl dc,  fnd_ef_ui_page_task_flows tf,  FND_DF_SEGMENTS_vl dsWHERE ds.APPLICATION_ID=800 AND dc.APPLICATION_ID=800AND dc.DESCRIPTIVE_FLEXFIELD_CODE = 'PER_ASSIGNMENT_EIT_EFF'AND eff.CONTEXT_CODE                = dc.CONTEXT_CODEAND tf.DESCRIPTIVE_FLEXFIELD_CODE   = 'PER_ASSIGNMENT_EIT_EFF'AND eff.CONTEXT_CODE                = tf.CONTEXT_CODEAND ds.DESCRIPTIVE_FLEXFIELD_CODE   = 'PER_ASSIGNMENT_EIT_EFF'AND eff.CONTEXT_CODE                = ds.CONTEXT_CODEAND eff.ATTRIBUTE_NAME                = ds.SEGMENT_IDENTIFIER--AND ATTRIBUTE_NAME not in ('AssignmentExtraInfoId','EffectiveEndDate','EffectiveStartDate')and dc.NAME = 'SG Romania Document Number Generation'and eff.LABEL_VALUE = 'Process Name'