上傳並下載資料安全性指派

您可以下載安全性指派範本檔案以協助您設定安全性指派，然後將檔案上傳至您的環境。

您可以使用 Oracle Fusion Data Intelligence 管理主控台中的安全性或上傳磚塊來下載與上傳檔案

您有下列選項可下載「資料安全性指派」：

  • 範例 - 提供含有相關標頭的 csv 檔案，協助您熟悉可預期的資料類型。
  • 目前 - 提供您可以下載至測試或生產環境的目前資料指派清單。
  • 篩選依據 - 提供選取特定資料安全相關資訊環境的選項。

無論您下載的檔案為何，您都需要植入下列欄：USERNAME、SEC_OBJ_CODE 與 SEC_OBI_MEMBER_VAL。請勿變更下載檔案中的任何標頭名稱。完成更新檔案後，您可以將它們上傳至您的環境。

  1. 登入您的服務。
  2. 在「Oracle Fusion Data Intelligence 管理主控台」中，按一下：上傳或安全性。
    • 上載
    • 安全性，然後選取「安全性指派」頁籤。
  3. 按一下下載檔案，選取資料安全性指派，然後選取您要下載的檔案類型。
  4. 開啟您下載的 csv 檔案，並視需要完成欄位：
    • 使用者名稱：使用者名稱與使用者顯示名稱。
    • SEC_OBJ_CODE：您要新增資料安全性指派的物件代碼。
    • SEC_OBJ_MEMBER_VAL：每個環境定義的安全性指派成員。請參閱安全性物件表格。
  5. 完成更新檔案後，請儲存變更。
  6. 在「上傳」頁面或「安全」頁面的「安全指派」頁籤中，按一下上傳和適用的檔案類型。
    1. 選取您要合併至現有設定值或取代現有組態設定值。

      備註：

      取代現有組態設定值會刪除現有的資料安全性指派。

      確保符合下列先決條件：

      • 安全性指派具有與應用程式角色的 1:1 對應。
      • 應用程式角色會指派給群組。
      • 被指派至安全性內容的使用者，是透過應用程式角色連結至安全性內容之群組的一部分。
    2. 選取您要上傳的檔案，然後按一下上傳檔案。
      您可以在上傳頁籤上複查上傳的狀態。
  7. 在「上傳」頁面中，使用檔案名稱旁邊的動作，對特定上傳檔案執行動作：
    • 按一下特性以檢查上傳統計資料。
    • 按一下下載，即可在想要再次上傳檔案時，下載剛剛上傳的檔案。
    • 如果無法處理檔案且想要移除檔案歷史記錄，請按一下刪除。

安全物件表格

使用這些安全性物件代碼與相關聯的 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'