Announcement

Collapse
No announcement yet.

Display certain reference qualifiers to the user

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Display certain reference qualifiers to the user

    Hi All,

    As per my requirement, I want to show only non-public related reference qualifiers to the user.
    In short, when the user logged in to the OTM, the user should able to see only non-public related reference qualifiers on the shipment page.
    How can we achieve this.

    Thank you.
    Jock

  • #2
    Hi Jock

    Created a vpd for table name SHIPMENT_REFNUM_QUAL and restrict your refnums

    Query should be like:
    (DOMAIN_NAME = SYS_CONTEXT('gl_user_ctx','domain_name') AND not EXISTS (SELECT SHIPMENT_REFNUM_QUAL_gid from SHIPMENT_REFNUM_QUAL where domain_name='PUBLIC'))

    Regards
    Arpit

    Comment


    • #3
      Hi Arpit,

      Thanks for your reply.
      But I tried i the same way.
      I am getting below error message when I click on the shipment id.
      java.sql.SQLException: ORA-28113: policy predicate has error

      I gave ADMIN ACL to the role as well and VPD as suggested by you.

      Please let me know where I went wrong.

      Thank you.

      Comment

      Working...
      X