No Search Result Showing in Payment History Screen (Doc ID 2556231.1)

Last updated on FEBRUARY 11, 2020

Applies to:

Symptoms

We are facing issue with Financial Query - Payment History Screen.

When we navigate to Main Menu ->Financial Query ->Payment History Screen - No data is coming as search result.
Following base portal and base zone are being used for this screen:

Base portal - CIPYSRCH
Base Zone - CIPAYMENT

After further investigation it seems that the base zone has a search query which checks if the account and person access group is available for the user or not.

Below is the section of the query:
/* Start GDPR Changes */
  ,CI_ACCT ACC, CI_PER PR,
  (SELECT v.cis_division, v.descr
  FROM ci_access_user_divisions_vw v
  WHERE user_id =:USERID
  AND language_cd =:LANGUAGE
  ) VW,
  (SELECT DISTINCT v.access_grp_cd
  FROM ci_usr_acc_grp_vw v
  WHERE v.user_id =:USERID
  ) GS
/* End GDPR Changes */
/* Start GDPR Changes */
AND apr.PER_ID = PR.PER_ID
AND apr.ACCT_ID = ACC.ACCT_ID
AND ACC.CIS_DIVISION = VW.CIS_DIVISION(+)
AND trim(ACC.ACCESS_GRP_CD)= trim(GS.ACCESS_GRP_CD)
AND PR.CIS_DIVISION = VW.CIS_DIVISION(+)
AND trim(PR.ACCESS_GRP_CD) = trim(GS.ACCESS_GRP_CD)
/* End GDPR Changes */

However we have different access group for account and person. For example Account has access group X and Person has access group Y.
Even though the user has access to both X and Y, no result is shown in the UI.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.