Trade Agreements

Supplier Access Configuration

This topic describes the configurations required for supplier solicitation.

VPD Configuration

  1. Login as DBA.ADMIN.
  2. Create a new SUPPLIER VPD profile. For more information, see Creating a New VPD Profile.
  3. Select Use External Predicate Rule.
  4. Use following external predicates to restrict access to campaign data.

Table Name

Predicate

External Predicate Access

Description
GTM_CAMPAIGN EXISTS  (SELECT GL_USER_GID FROM USER_ASSOCIATION WHERE  USER_ASSOCIATION.GL_USER_GID = SYS_CONTEXT('gl_user_ctx', 'gl_user_gid')  AND USER_ASSOCIATION_QUAL = 'SUPPLIER' AND USER_ASSOCIATION_VALUE IN  (SELECT GCIP.INVOLVED_PARTY_CONTACT_GID FROM GTM_CAMPAIGN_INVOLVED_PARTY  GCIP WHERE GCIP.GTM_CAMPAIGN_GID = GTM_CAMPAIGN.GTM_CAMPAIGN_GID AND  GCIP.INVOLVED_PARTY_QUAL_GID='SUPPLIER' UNION SELECT  GCLIP.INVOLVED_PARTY_CONTACT_GID FROM GTM_CA_LINE_INV_PARTY GCLIP,  GTM_CAMPAIGN_LINE GCL WHERE GCLIP.GTM_CAMPAIGN_LINE_GID =  GCL.GTM_CAMPAIGN_LINE_GID AND GCL.GTM_CAMPAIGN_GID =  GTM_CAMPAIGN.GTM_CAMPAIGN_GID AND  GCLIP.INVOLVED_PARTY_QUAL_GID='SUPPLIER') AND EXISTS (SELECT 'a' FROM  GTM_CAMPAIGN_STATUS GCS, STATUS_VALUE SV1 WHERE GCS.GTM_CAMPAIGN_GID =  GTM_CAMPAIGN.GTM_CAMPAIGN_GID AND GCS.STATUS_VALUE_GID =  SV1.STATUS_VALUE_GID AND GCS.STATUS_TYPE_GID = SV1.STATUS_TYPE_GID AND  SV1.STATUS_VALUE_XID = 'CAMPAIGN_IN_PROGRESS')) Read

Restricts campaign data access for suppliers.
GTM_CAMPAIGN_LINE EXISTS (SELECT GL_USER_GID FROM  USER_ASSOCIATION WHERE USER_ASSOCIATION.GL_USER_GID =  SYS_CONTEXT('gl_user_ctx', 'gl_user_gid') AND USER_ASSOCIATION_QUAL =  'SUPPLIER' AND USER_ASSOCIATION_VALUE IN (SELECT  GCIP.INVOLVED_PARTY_CONTACT_GID FROM GTM_CAMPAIGN_INVOLVED_PARTY GCIP  WHERE GCIP.GTM_CAMPAIGN_GID = GTM_CAMPAIGN_LINE.GTM_CAMPAIGN_GID AND  GCIP.INVOLVED_PARTY_QUAL_GID='SUPPLIER' UNION SELECT  GCLIP.INVOLVED_PARTY_CONTACT_GID FROM GTM_CA_LINE_INV_PARTY GCLIP WHERE  GCLIP.GTM_CAMPAIGN_LINE_GID = GTM_CAMPAIGN_LINE.GTM_CAMPAIGN_LINE_GID  AND GCLIP.INVOLVED_PARTY_QUAL_GID='SUPPLIER') AND EXISTS (SELECT 'a'  FROM GTM_CAMPAIGN_STATUS GCS, STATUS_VALUE SV1 WHERE  GCS.GTM_CAMPAIGN_GID = GTM_CAMPAIGN_LINE.GTM_CAMPAIGN_GID AND  GCS.STATUS_VALUE_GID = SV1.STATUS_VALUE_GID AND GCS.STATUS_TYPE_GID =  SV1.STATUS_TYPE_GID AND SV1.STATUS_VALUE_XID = 'CAMPAIGN_IN_PROGRESS')) Read

Restricts campaign line data access for suppliers.
GTM_CAMPAIGN_LINE EXISTS (SELECT GL_USER_GID FROM  USER_ASSOCIATION WHERE USER_ASSOCIATION.GL_USER_GID =  SYS_CONTEXT('gl_user_ctx', 'gl_user_gid') AND USER_ASSOCIATION_QUAL =  'SUPPLIER' AND USER_ASSOCIATION_VALUE IN (SELECT  GCIP.INVOLVED_PARTY_CONTACT_GID FROM GTM_CAMPAIGN_INVOLVED_PARTY GCIP  WHERE GCIP.GTM_CAMPAIGN_GID = GTM_CAMPAIGN_LINE.GTM_CAMPAIGN_GID AND  GCIP.INVOLVED_PARTY_QUAL_GID='SUPPLIER' UNION SELECT  GCLIP.INVOLVED_PARTY_CONTACT_GID FROM GTM_CA_LINE_INV_PARTY GCLIP WHERE  GCLIP.GTM_CAMPAIGN_LINE_GID = GTM_CAMPAIGN_LINE.GTM_CAMPAIGN_LINE_GID  AND GCLIP.INVOLVED_PARTY_QUAL_GID='SUPPLIER') AND EXISTS (SELECT 'a'  FROM GTM_CAMPAIGN_STATUS GCS, STATUS_VALUE SV1 WHERE  GCS.GTM_CAMPAIGN_GID = GTM_CAMPAIGN_LINE.GTM_CAMPAIGN_GID AND  GCS.STATUS_VALUE_GID = SV1.STATUS_VALUE_GID AND GCS.STATUS_TYPE_GID =  SV1.STATUS_TYPE_GID AND SV1.STATUS_VALUE_XID = 'CAMPAIGN_IN_PROGRESS')  AND EXISTS (SELECT 'a' FROM GTM_CA_LINE_STATUS GCLS, STATUS_VALUE SV2  WHERE GCLS.GTM_CAMPAIGN_LINE_GID =   GTM_CAMPAIGN_LINE.GTM_CAMPAIGN_LINE_GID AND GCLS.STATUS_VALUE_GID =  SV2.STATUS_VALUE_GID AND GCLS.STATUS_TYPE_GID = SV2.STATUS_TYPE_GID AND  SV2.STATUS_VALUE_XID IN ('CAMPAIGN_LINE_RESUBMITTED',  'CAMPAIGN_LINE_SUBMITTED') )) Update

Use this predicate to restrict write access for suppliers to GTM_CAMPAIGN_LINE table.
DOCUMENT EXISTS (SELECT 'X' FROM USER_ASSOCIATION,  DOCUMENT_CONTEXT WHERE DOCUMENT.DOCUMENT_GID =  DOCUMENT_CONTEXT.DOCUMENT_GID AND USER_ASSOCIATION.GL_USER_GID =  SYS_CONTEXT('GL_USER_CTX','GL_USER_GID') AND  USER_ASSOCIATION.USER_ASSOCIATION_VALUE =  DOCUMENT_CONTEXT.DOCUMENT_CONTEXT_VALUE AND  DOCUMENT_CONTEXT.DOCUMENT_CONTEXT_QUAL_GID = 'PARTY ID' AND  USER_ASSOCIATION.USER_ASSOCIATION_QUAL = 'SUPPLIER') OR EXISTS (SELECT 'X' FROM USER_ASSOCIATION WHERE DOCUMENT.USED_AS = 'T') Read

Restricts document access for supplier
GTM_CAMPAIGN   (1=2) Insert/Update/Delete

Restricts suppliers to make any changes to campaign data
PARTNER_ITEM EXISTS (SELECT GL_USER_GID FROM USER_ASSOCIATION WHERE USER_ASSOCIATION.GL_USER_GID = SYS_CONTEXT('gl_user_ctx', 'gl_user_gid') AND USER_ASSOCIATION_QUAL = 'SUPPLIER' AND USER_ASSOCIATION_VALUE = PARTNER_ITEM.PARTNER_GID) Read

Restricts supplier to see only Partner Items for which they are Trading Partner
PARTNER_ITEM    (1=2) Insert/Update/Delete  

Restricts suppliers to make any changes to Partner Item data
PARTY_SITE EXISTS (SELECT GL_USER_GID FROM USER_ASSOCIATION WHERE USER_ASSOCIATION.GL_USER_GID = SYS_CONTEXT('gl_user_ctx', 'gl_user_gid') AND USER_ASSOCIATION_QUAL = 'SUPPLIER' AND USER_ASSOCIATION_VALUE = PARTY_SITE.PARTY_GID) Read

Restricts supplier to see only those Party Sites which are related to the supplier
PARTY_SITE   (1=2) Insert/Update/Delete

Restricts suppliers to make any changes to Party Site data
GTM_CAMPAIGN_TYPE (1=2) Insert/Update/Delete

Restricts suppliers to make any changes to Campaign Type
QF_PREFERENCE_CRITERIA (1=2) Insert/Update/Delete

Restricts suppliers to make any changes to Preference Criteria data
QF_RVC_METHOD (1=2) Insert/Update/Delete

Restricts suppliers to make any changes to Regional Value Content Method data
GTM_PROD_CLASS_TYPE (1=2) Insert/Update/Delete

Restricts suppliers to make any changes to Product Classification Type data
GTM_TRADE_AGREEMENT (1=2) Insert/Update/Delete

Restricts suppliers to make any changes to Trade Agreement data
REPORT (1=2) Insert/Update/Delete

Restricts suppliers to make any changes to Report data
DOCUMENT_DEF (1=2) Insert/Update/Delete

Restricts suppliers to make any changes to Document Definition data
CONTACT (1=2) Insert/Update/Delete

Restricts suppliers to make any changes to Party data
GTM_PARTY_SCREENING (1=2) Read

Restricts suppliers to see any restricted screening result

 

Note:
1) Above predicates are defined using Involved party qualifier = “SUPPLIER”, customer can use a different involved party qualifier by making changes in the above predicates.
2) To restrict a particular access type for a table, use “(1=2)” as predicate.
3) User needs to create a Document Context qualifier with the name ‘PARTY ID’, and use the same in a document context property as needed by Upload Document action.
4) In case customer setup a workbench for supplier response, an external predicate (TRANSPORTATION_WORKBENCH.LAYOUT_GID = '<WORKBENCH NAME>') must be defined against   TRANSPORTATION_WORKBENCH table.

Access Control

Create new SUPPLIER_DEFAULT access control list. For more information, see Access Control List.

  1. Child Access Control List - Add the following entries:
    • COMMON
    • GTM_COMMON
    • GTM Campaign - Update
    • GTM Campaign - View
    • Integration Actions
    • Integration - Update
    • Integration - View
    • REST - GTM Campaign - View
    • REST - GTM Campaign - Update
    • Power Data  - Update
    • Document - View
    • Document - Update
    • Remark Qualifier - View  
    • Partner Item - View
    • GTM Trade Agreement - View
    • GTM Product Classification - View
    • Location - View
    • Reports - View
  1. Access Control Entry Points - Add the following entry:
    • glog.ejb.savedquery.SavedQuerySession.getSavedQueries
    • glog.webserver.powerdata.GenericManagementServlet
    • glog.webserver.util.QueryResponseServlet.action.respond_to_campaign_line
    • glog.webserver.util.QueryResponseServlet.action.download_document_template_gtm_campaign_line
    • glog.webserver.util.QueryResponseServlet.action.prepare_document_gtm_campaign_line
    • glog.webserver.util.QueryResponseServlet.action.add_document_action_decider_gtm_campaign_line
    • glog.webserver.util.QueryResponseServlet.action.add_document_gtm_campaign_line
    • glog.webserver.util.QueryResponseServlet.action.copy_document_gtm_campaign_line
    • glog.webserver.util.QueryResponseServlet.action.link_document_gtm_campaign_line
    • glog.webserver.util.QueryResponseServlet.action.view_document_content
    • glog.webserver.util.QueryResponseServlet.action.view_reqdoc_gtm_ca_line

User Role

Create new SUPPLIER user role with the details below. For more Information, see User Role.

  • Level - SUPPLIER
  • Data Source Profile ID - Default
  • VPD Profile ID - VPD profile ID created above. In this case, the VPD profile ID is SUPPLIER .
  • User Role Grants - Add ADMIN, DBA.ADMIN, and SERVPROV.ADMIN.
  • Access Control List - Add above created Access control “SUPPLIER_DEFAULT”, and check Granted.

User Menu

  1. Create new SUPPLIER_MENU user menu. For more information, see Menu Editor.
  2. Add SUPPLIER_GTM_CAMPAIGN and SUPPLIER_GTM_CAMPAIGN_LINE screen sets.

User Menu Access

  1. Logout as DBA and login as SERVPROV.ADMIN.
  2. Go to Manage User Access. Provide menu access as follows:
    1.  Select

    1. User Access Type - User Menu

    2. Level - SUPPLIER (User Role created above)

    3. User Role ID - SUPPLIER (User Role created above)

    4. Domain Name - SERVPROV

    1. Select Edit User Access.
    2. Select Exclude all user menus except the following.
    3. Add above created SUPPLIER_MENU user menu.
  3. Go to Manage User Access. Provide saved query access to supplier if needed as follows:
    1. Select
      1. User Access Type – Saved Query
      2. Level - SUPPLIER (User Role created above)
      3. User Role ID - SUPPLIER (User Role created above)
      4. Domain Name - SERVPROV
    2. Select Edit User Access.
    3. Select ‘Exclude all saved queries except the following’.
    4. Add any saved query (created via Supplier finder).
  4.     Go to Manage User Access.. Provide workbench access to supplier if needed as follows:
    1. Select
      1. User Access Type – Saved Query
      2. Level - SUPPLIER (User Role created above)
      3. User Role ID - SUPPLIER (User Role created above)
      4. Domain Name - SERVPROV
    1. Select Edit User Access.
    2. Select ‘Exclude all layouts except the following’.
    3. Add any workbench layout ID (created via campaign user login)

Note: You should be careful while configuring the campaign optimization properties, if required. These properties reframe the queries by appending the Domain Name to the criteria provided on the finder screen. Since the campaign data resides in the domain of the campaign user, the optimization properties might not fetch proper results.

Note: Based on your business requirement, you can provide additional access or remove some of the access to configure actions to be used by the supplier.

User Management

Create users for each supplier and assign SUPPLIER user role to the users. For more information, see User Manager.

User Association

Create a user association entry in the Manage Association UI for each supplier user by selecting SUPPLIER user association qualifier. For more information, see Manage Association.

Related Topics

GTM Power Data

Copyright © 2001, 2023, Oracle and/or its affiliates.

For the latest installation and reference guides, go to the online library. For the additional materials, see Knowledge Document 796594.1 on My Oracle Support.

For questions about Oracle Transportation Management or Global Trade Management, contact Support or find the Support phone number for your region.

If you have any questions or comments about this documentation page, please Contact Oracle Documentation. Was this page helpful? Click to send feedback.How can we improve this page?What did you like about this page?Comments