上载和下载数据安全分配

您可以下载安全分配模板文件，以帮助您设置安全分配，然后将文件上载到您的环境中。

您可以使用 Oracle Fusion Data Intelligence 管理控制台中的安全性或上载磁贴下载和上载文件

您可以通过以下选项下载数据安全分配：

  • Sample（示例） - 提供了一个包含相关标头的 csv 文件，可帮助您熟悉可预期的数据类型。
  • 当前 - 提供可以下载到测试或生产环境的当前数据分配列表。
  • 筛选依据 - 提供用于选择特定数据安全上下文的选项。

无论下载哪个文件，都需要填充以下列：USERNAME、SEC_OBJ_CODE 和 SEC_OBI_MEMBER_VAL。不要更改下载的文件中的任何标题名称。更新完文件后，可以将其上载到您的环境。

  1. 登录到您的服务。
  2. 在 Oracle Fusion Data Intelligence 管理控制台中，单击上载或安全性。
    • 加载
    • 安全性，然后选择“安全性分配”选项卡。
  3. 单击下载文件，选择数据安全分配，然后选择要下载的文件的类型。
  4. 打开您下载的 csv 文件，并根据需要填写字段：
    • USERNAME：用户名和用户显示名称。
    • SEC_OBJ_CODE：要为其添加数据安全分配的对象代码。
    • SEC_OBJ_MEMBER_VAL：每个上下文的安全性分配成员。请参阅安全对象表。
  5. 更新完文件后，保存所做的更改。
  6. 在“上载”页或“安全性”页的“安全性分配”选项卡中，单击上载和适用的文件类型。
    1. 选择是要合并到现有设置还是替换现有配置设置。

      注意：

      替换现有配置设置将删除现有数据安全分配。

      确保已满足以下先决条件：

      • 安全分配具有与应用程序角色的 1:1 映射。
      • 应用程序角色将分配给组。
      • 正在分配到安全上下文的用户是组的一部分，该组通过应用程序角色链接到安全上下文。
    2. 选择要上载的文件，然后单击上载文件。
      您可以在上载选项卡上查看上载的状态。
  7. 在“上载”页中，使用文件名旁边的操作对特定上载文件执行操作：
    • 单击属性以检查上载统计信息。
    • 单击 Download（下载）可下载您刚在要再次上载文件时上载的文件。
    • 如果文件无法处理并且您希望删除文件历史记录，请单击删除。

安全性对象表

使用这些安全对象代码和关联的 SQL 访问每个上下文的分配成员。

安全性对象

安全对象 代码
应付账款业务单位 OA4F_SEC_FIN_AP_BUSINESSUNIT_LIST
应收账款业务单位 OA4F_SEC_FIN_AR_BUSINESSUNIT_LIST
成本组织 OA4F_SEC_CST_COST_ORG_LIST
FA 资产账簿 OA4F_SEC_FIN_FA_ASSET_BOOK_LIST
HCM 业务单位 OA4F_SEC_HCM_BUSINESSUNIT_LIST
HCM 国家/地区列表 OA4F_SEC_HCM_COUNTRY_LIST
HCM 部门 OA4F_SEC_HCM_DEPARTMENT_LIST
HCM 合法雇主 OA4F_SEC_HCM_LEGAL_EMPLOYER_LIST
HCM 显示个人记录 OA4F_SEC_HCM_SEE_SELF_RECORD
库存业务单位 OA4F_SEC_INV_BUSINESSUNIT_LIST
库存组织 OA4F_SEC_INV_ORG_TRANSACTIONS_LIST
分类账 OA4F_SEC_FIN_LEDGER_LIST
订单管理业务单位 OA4F_SEC_OM_BUSINESS_UNIT_LIST
项目业务单位 OA4F_SEC_PPM_PROJECT_BUSINESSUNIT_LIST
项目支出业务单位 OA4F_SEC_PPM_EXPENDITURE_BUSINESSUNIT_LIST
项目组织 OA4F_SEC_PPM_PROJECT_ORGANIZATION_LIST
请购业务单位 OA4F_SEC_PROC_REQ_BUSINESSUNIT_LIST
支出采购业务单位 OA4F_SEC_PROC_SPEND_PRC_BUSINESSUNIT_LIST

分配成员 SQL

安全对象代码 SQL 代码
OA4F_SEC_CST_COST_ORG_LIST 
SELECT
DISTINCT TL.ORGANIZATION_NAME AS NAME,
TL.ORGANIZATION_ID AS VALUE
FROM
DW_CST_COST_ORG_BOOKS_D D,
DW_INTERNAL_ORG_D_TL TL
WHERE
D.COST_ORG_ID = TL.ORGANIZATION_ID
AND  TL.LANGUAGE = (SELECT PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG WHERE PARAMETER_CODE='PARAM_GLOBAL_FAW_LANGUAGES')
AND D. COST_ORG_ID <>-99999
OA4F_SEC_FIN_AP_BUSINESSUNIT_LIST 
SELECT TL.ORGANIZATION_NAME AS NAME, TL.ORGANIZATION_ID AS VALUE 
FROM DW_INTERNAL_ORG_D D, DW_INTERNAL_ORG_D_TL TL
WHERE (D.PAYABLES_INVOICING_BU_FLAG = 'Y' OR D.PAYABLES_PAYMENT_BU_FLAG = 'Y') 
AND D.ORGANIZATION_ID = TL.ORGANIZATION_ID 
AND TL.LANGUAGE = (SELECT PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG WHERE PARAMETER_CODE='PARAM_GLOBAL_FAW_LANGUAGES') 
AND D.ORGANIZATION_ID <> -99999
OA4F_SEC_FIN_AR_BUSINESSUNIT_LIST 
SELECT TL.ORGANIZATION_NAME AS NAME, TL.ORGANIZATION_ID AS VALUE 
FROM DW_INTERNAL_ORG_D D, DW_INTERNAL_ORG_D_TL TL
WHERE (D.BILLING_REVENUE_MNG_BU_FLAG = 'Y' OR D.CUSTOMER_PAYMENTS_BU_FLAG = 'Y') 
AND D.ORGANIZATION_ID = TL.ORGANIZATION_ID 
AND TL.LANGUAGE = (SELECT PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG WHERE PARAMETER_CODE='PARAM_GLOBAL_FAW_LANGUAGES') 
AND D.ORGANIZATION_ID <> -99999
OA4F_SEC_FIN_FA_ASSET_BOOK_LIST 
SELECT 
BOOK_TYPE_CODE AS name,
BOOK_TYPE_CODE AS value
FROM 
DW_FA_MC_BOOK_CONTROLS_D
WHERE MC_FLAG = 'N'
OA4F_SEC_FIN_LEDGER_LIST 
SELECT ledger.ledger_name   AS name,        
                ledger.ledger_id     AS value 
FROM dw_ledger_d ledger 
WHERE ledger.ledger_id <> - 99999
OA4F_SEC_HCM_BUSINESSUNIT_LIST 
SELECT TL.BUSINESS_UNIT_NAME AS NAME,
TL.BUSINESS_UNIT_ID AS VALUE
FROM DW_BUSINESS_UNIT_D_TL TL
WHERE TL.LANGUAGE =  (SELECT PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG WHERE PARAMETER_CODE='PARAM_GLOBAL_FAW_LANGUAGES')
OA4F_SEC_HCM_COUNTRY_LIST 
SELECT TL.COUNTRY_NAME AS NAME, TL.COUNTRY AS VALUE 
FROM DW_COUNTRY_D_TL TL WHERE TL.LANGUAGE = (SELECT PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG WHERE PARAMETER_CODE='PARAM_GLOBAL_FAW_LANGUAGES')
OA4F_SEC_HCM_DEPARTMENT_LIST 
select TL.DEPARTMENT_NAME AS NAME, TL.DEPARTMENT_ID AS VALUE FROM DW_DEPARTMENT_D_TL TL where
      LANGUAGE = (SELECT PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG WHERE
      PARAMETER_CODE='PARAM_GLOBAL_FAW_LANGUAGES')
OA4F_SEC_HCM_LEGAL_EMPLOYER_LIST 
SELECT TL.LEGAL_EMPLOYER_NAME AS NAME, TL.LEGAL_EMPLOYER_ID AS VALUE FROM DW_LEGAL_EMPLOYER_D_TL TL WHERE LANGUAGE =  (SELECT PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG WHERE PARAMETER_CODE='PARAM_GLOBAL_FAW_LANGUAGES')
OA4F_SEC_HCM_SEE_SELF_RECORD 
SELECT YESNO_LKP_CODE AS VALUE,
  NAME                AS NAME
FROM DW_YESNO_LKP_TL
WHERE CODE_TYPE LIKE 'FA_YESNO'
AND LANGUAGE        =  (SELECT PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG WHERE PARAMETER_CODE='PARAM_GLOBAL_FAW_LANGUAGES')
AND YESNO_LKP_CODE IN ( 'NO')
OA4F_SEC_INV_BUSINESSUNIT_LIST 
SELECT TL.BUSINESS_UNIT_NAME AS NAME, TL.BUSINESS_UNIT_ID AS VALUE
FROM DW_BUSINESS_UNIT_D_TL TL
WHERE TL.BUSINESS_UNIT_ID IN (SELECT DISTINCT(INV_BUSINESS_UNIT_ID) FROM DW_INV_ORGANIZATION_D)
AND TL.LANGUAGE = (SELECT PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG WHERE PARAMETER_CODE='PARAM_GLOBAL_FAW_LANGUAGES') AND TL.BUSINESS_UNIT_ID <> '-99999'
OA4F_SEC_INV_ORG_TRANSACTIONS_LIST 
SELECT INV_ORGANIZATION_NAME AS NAME, INV_ORGANIZATION_ID AS VALUE FROM DW_INV_ORGANIZATION_D_TL TL
WHERE TL.LANGUAGE = (SELECT PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG WHERE PARAMETER_CODE='PARAM_GLOBAL_FAW_LANGUAGES') AND TL.INV_ORGANIZATION_ID <> '-99999'
OA4F_SEC_OM_BUSINESS_UNIT_LIST 
SELECT
TL.BUSINESS_UNIT_NAME AS NAME,
TL.BUSINESS_UNIT_ID AS VALUE
FROM  DW_BUSINESS_UNIT_D_TL TL
WHERE  TL.LANGUAGE = (SELECT PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG WHERE PARAMETER_CODE='PARAM_GLOBAL_FAW_LANGUAGES')
AND TL.BUSINESS_UNIT_ID<>-99999
OA4F_SEC_PPM_CONTRACT_BUSINESSUNIT_LIST 
SELECT 
TL.ORGANIZATION_NAME AS NAME,
TL.ORGANIZATION_ID AS VALUE 
FROM 
DW_INTERNAL_ORG_D D, 
DW_INTERNAL_ORG_D_TL TL
WHERE (D.CUST_CONTRACT_MNGMNT_BU_FLAG = 'Y' AND D.BUSINESS_UNIT_FLAG = 'Y') 
AND D.ORGANIZATION_ID = TL.ORGANIZATION_ID 
AND TL.LANGUAGE = (SELECT PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG WHERE PARAMETER_CODE='PARAM_GLOBAL_FAW_LANGUAGES')
AND D.ORGANIZATION_ID<>-99999
OA4F_SEC_PPM_EXPENDITURE_BUSINESSUNIT_LIST 
SELECT
TL.ORGANIZATION_NAME AS NAME,
TL.ORGANIZATION_ID AS VALUE
FROM
DW_INTERNAL_ORG_D D,
DW_INTERNAL_ORG_D_TL TL
WHERE (D.PROJECT_ACCOUNTING_BU_FLAG  = 'Y' AND D.BUSINESS_UNIT_FLAG = 'Y')
AND  D.ORGANIZATION_ID = TL.ORGANIZATION_ID
AND  TL.LANGUAGE = USERENV('LANG')
AND D.ORGANIZATION_ID<>-99999
OA4F_SEC_PPM_PROJECT_BUSINESSUNIT_LIST 
SELECT
TL.ORGANIZATION_NAME AS NAME,
TL.ORGANIZATION_ID AS VALUE
FROM
DW_INTERNAL_ORG_D D,
DW_INTERNAL_ORG_D_TL TL
WHERE (D.PROJECT_ACCOUNTING_BU_FLAG  = 'Y' AND D.BUSINESS_UNIT_FLAG = 'Y')
AND  D.ORGANIZATION_ID = TL.ORGANIZATION_ID
AND  TL.LANGUAGE = USERENV('LANG')
AND D.ORGANIZATION_ID<>-99999
OA4F_SEC_PPM_PROJECT_ORGANIZATION_LIST 
SELECT
TL.ORGANIZATION_NAME AS NAME,
TL.ORGANIZATION_ID AS VALUE
FROM
DW_INTERNAL_ORG_D D,
DW_INTERNAL_ORG_D_TL TL
WHERE (D.PROJECT_ORGANIZATION_FLAG  = 'Y' )
AND  D.ORGANIZATION_ID = TL.ORGANIZATION_ID
AND  TL.LANGUAGE = USERENV('LANG')
AND D.ORGANIZATION_ID<>-99999
OA4F_SEC_PROC_REQ_BUSINESSUNIT_LIST 
SELECT
TL.ORGANIZATION_NAME AS NAME,
TL.ORGANIZATION_ID AS VALUE
FROM
DW_INTERNAL_ORG_D D,
DW_INTERNAL_ORG_D_TL TL
WHERE (D.REQUISITION_BU_FLAG  = 'Y' AND D.BUSINESS_UNIT_FLAG = 'Y')
AND  D.ORGANIZATION_ID = TL.ORGANIZATION_ID
AND  TL.LANGUAGE = (SELECT PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG WHERE PARAMETER_CODE='PARAM_GLOBAL_FAW_LANGUAGES')
AND D.ORGANIZATION_ID<>-99999
OA4F_SEC_PROC_SPEND_PRC_BUSINESSUNIT_LIST 
SELECT
TL.ORGANIZATION_NAME AS NAME,
TL.ORGANIZATION_ID AS VALUE
FROM
DW_INTERNAL_ORG_D D,
DW_INTERNAL_ORG_D_TL TL
WHERE (D.PROCUREMENT_BU_FLAG = 'Y' AND D.BUSINESS_UNIT_FLAG = 'Y')
AND  D.ORGANIZATION_ID = TL.ORGANIZATION_ID
AND  TL.LANGUAGE = (SELECT PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG WHERE PARAMETER_CODE='PARAM_GLOBAL_FAW_LANGUAGES')
AND D.ORGANIZATION_ID<>-99999
OA4F_SEC_SCM_MFGORG_LIST 
SELECT
MFG_ORGANIZATION_NAME AS NAME, 
MFG_ORGANIZATION_ID AS VALUE
FROM
DW_MFG_ORGANIZATION_D_TL TL
WHERE TL.LANGUAGE = (SELECT PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG WHERE PARAMETER_CODE='PARAM_GLOBAL_FAW_LANGUAGES')
AND TL.MFG_ORGANIZATION_ID <> '-99999'
OA4F_SEC_SCM_MNTORG_LIST 
SELECT
INV_ORGANIZATION_NAME AS NAME,
INV_ORGANIZATION_ID AS VALUE
FROM
DW_INV_ORGANIZATION_D_TL TL
WHERE TL.LANGUAGE = (SELECT PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG WHERE PARAMETER_CODE='PARAM_GLOBAL_FAW_LANGUAGES')
AND TL.INV_ORGANIZATION_ID <> '-99999'