1. Administering Oracle Fusion Analytics Warehouse
  2. Manage Users, Groups, Application Roles, and Data Access
  3. Manage Uploads and Downloads

Manage Uploads and Downloads

As the cloud account administrator with security administrator or functional administrator or service administrator role, you can upload and download data to your data warehouse using the Upload tile on the Console.

Topics:

About Uploading and Downloading Your Data

The Upload tile in the Console enables the cloud account administrators to upload and download the following:

  • Data security assignments
  • Financial categories
  • Financial category assignments
  • User to group associations

You can upload and download only csv files.

Upload and Download Data Security Assignments

You can download security assignment template files to help you set up security assignments, and then upload the files to your environment.

You can download Sample or Current files. Sample provides a csv file with relevant headers to help familiarize you with the types of data you can expect. Current provides a list of current data assignments you can download to your test or production environments. If you need to filter your options to show specific data security contexts, use the Filter option. Regardless of the file you download, you need to populate these columns: USERNAME, SEC_OBJ_CODE, and SEC_OBI_MEMBER_VAL. Don't change any of the header names in the downloaded files. When you are done updating the files, you can upload them to your environment.

Note:

Replace existing configuration settings deletes existing data security assignments.
  1. Sign in to your service.
  2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Uploads under Application Administration.
    You see the Uploads page.
  3. On the Uploads page, click Download File, select Data Security Assignments and then select the type of file you want to download.

    Note:

    You can also download data security assignment files using the Download File button available from the Security Assignments tab on the Security page. In this case, you don't need to specifically select Data Security Assignments. Click Download File, select the type of file you want to download, and proceed with the remaining steps.
  4. Open the csv file you downloaded and populate the fields as required:
    • USERNAME: The user name and user display name.
    • SEC_OBJ_CODE: The object code for which you are adding the data security assignment.
    • SEC_OBJ_MEMBER_VAL: The security assignment member for each context. See Security Object Tables.
  5. When you are done updating the file, save your changes.
  6. On the Uploads page, click Upload File and the applicable file type.

    Note:

    You can also upload data security assignment files using the Upload button available from the Security Assignments tab on the Security page. In this case, you don't need to specifically select Data Security Assignments. Click Upload and then proceed with the remaining steps.
  7. Select whether you want to Merge to the existing settings or Replace existing configuration settings.
  8. Select the file you want to upload and click Upload File.
    You can review the status of the upload on the Uploads tab.
  9. Use the Actions menu next to the file name to perform actions on a specific upload file:
    • Click Properties to check the upload statistics.
    • Click Download to download the file you just uploaded in the event you want to upload the file again.
    • Click Delete if a file fails to process and you want to remove the file history.

Security Object Tables

Use these security object codes and associated SQL to access the assignment member for each context.

Security Objects

Table 5-1 Security Object Codes

Security Object Code
AP Business Units OA4F_SEC_FIN_AP_BUSINESSUNIT_LIST
AR Business Units OA4F_SEC_FIN_AR_BUSINESSUNIT_LIST
Cost Organizations OA4F_SEC_CST_COST_ORG_LIST
FA Asset Book OA4F_SEC_FIN_FA_ASSET_BOOK_LIST
HCM Business Units OA4F_SEC_HCM_BUSINESSUNIT_LIST
HCM Country List OA4F_SEC_HCM_COUNTRY_LIST
HCM Departments OA4F_SEC_HCM_DEPARTMENT_LIST
HCM Legal Employers OA4F_SEC_HCM_LEGAL_EMPLOYER_LIST
HCM Show Self Record OA4F_SEC_HCM_SEE_SELF_RECORD
Inventory Business Units OA4F_SEC_INV_BUSINESSUNIT_LIST
Inventory Organizations OA4F_SEC_INV_ORG_TRANSACTIONS_LIST
Ledgers OA4F_SEC_FIN_LEDGER_LIST
Order Management Business Units OA4F_SEC_OM_BUSINESS_UNIT_LIST
Project Business Units OA4F_SEC_PPM_PROJECT_BUSINESSUNIT_LIST
Project Expenditure Business Units OA4F_SEC_PPM_EXPENDITURE_BUSINESSUNIT_LIST
Project Organizations OA4F_SEC_PPM_PROJECT_ORGANIZATION_LIST
Requisition Business Units OA4F_SEC_PROC_REQ_BUSINESSUNIT_LIST
Spend Procurement Business Units OA4F_SEC_PROC_SPEND_PRC_BUSINESSUNIT_LIST

Assignment Member SQL

Table 5-2 Assignment Member SQL

Security Object Code SQL Code
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_LEDGER_D L, DW_INTERNAL_ORG_D D, DW_INTERNAL_ORG_D_TL TL, DW_CONTENT_PARAM_CONFIG PARAM
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.PRIMARY_LEDGER = L.LEDGER_NAME
AND  TO_CHAR(L.LEDGER_ID)=PARAM.PARAMETER_VALUE AND PARAM.PARAMETER_CODE='PARAM_ERP_FINANCIALS_LEDGER_ID_LIST_REPORT' AND PARAM.PARAMETER_VALUE<>'ALL'
AND D.ORGANIZATION_ID<>-99999

UNION

SELECT TL.ORGANIZATION_NAME AS NAME,TL.ORGANIZATION_ID AS VALUE FROM DW_LEDGER_D L, DW_INTERNAL_ORG_D D, DW_INTERNAL_ORG_D_TL TL, DW_CONTENT_PARAM_CONFIG PARAM
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.PRIMARY_LEDGER = L.LEDGER_NAME
AND  PARAM.PARAMETER_CODE='PARAM_ERP_FINANCIALS_LEDGER_ID_LIST_REPORT' AND PARAM.PARAMETER_VALUE='ALL'
AND (TO_CHAR(L.LEDGER_CHART_OF_ACCOUNTS_ID) IN (SELECT PARAM.PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG PARAM WHERE PARAM.PARAMETER_CODE='PARAM_ERP_FINANCIALS_CHART_OF_ACCOUNT_ID')
     OR EXISTS (SELECT 1 FROM dw_content_param_config param WHERE param.parameter_code = 'PARAM_ERP_FINANCIALS_CHART_OF_ACCOUNT_ID' AND param.parameter_value = 'ALL')
    )
AND D.ORGANIZATION_ID<>-99999

UNION

SELECT
    tl.organization_name   AS name,
    tl.organization_id     AS value
FROM
    dw_ledger_set_assignments_d assignments,
    dw_ledger_d               l,
    dw_internal_org_d         d,
    dw_internal_org_d_tl      tl,
    dw_content_param_config   param
WHERE
    param.PARAMETER_VALUE = 'ALL'
    AND param.parameter_code = 'PARAM_ERP_FINANCIALS_LEDGER_SET_ID_LIST_REPORT'
    AND assignments.ledger_id = l.ledger_id
    AND d.primary_ledger = l.ledger_name
    AND ( 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 (TO_CHAR(L.LEDGER_CHART_OF_ACCOUNTS_ID) IN (SELECT PARAM.PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG PARAM WHERE PARAM.PARAMETER_CODE='PARAM_ERP_FINANCIALS_CHART_OF_ACCOUNT_ID')
             OR EXISTS (SELECT 1 FROM dw_content_param_config param WHERE param.parameter_code = 'PARAM_ERP_FINANCIALS_CHART_OF_ACCOUNT_ID' AND param.parameter_value = 'ALL')
        )
    AND d.organization_id <> -99999

UNION

SELECT
    tl.organization_name   AS name,
    tl.organization_id     AS value
FROM
    dw_ledger_set_assignments_d assignments,
    dw_ledger_d               l,
    dw_internal_org_d         d,
    dw_internal_org_d_tl      tl,
    dw_content_param_config   param
WHERE
    TO_CHAR(assignments.ledger_set_id) = param.parameter_value
    AND param.PARAMETER_VALUE <> 'ALL'
    AND param.parameter_code = 'PARAM_ERP_FINANCIALS_LEDGER_SET_ID_LIST_REPORT'
    AND assignments.ledger_id = l.ledger_id
    AND d.primary_ledger = l.ledger_name
    AND ( 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
ORDER BY NAME
OA4F_SEC_FIN_AR_BUSINESSUNIT_LIST 
SELECT
TL.ORGANIZATION_NAME AS NAME,
TL.ORGANIZATION_ID AS VALUE
FROM DW_LEDGER_D L,
DW_INTERNAL_ORG_D D,
DW_INTERNAL_ORG_D_TL TL,
DW_CONTENT_PARAM_CONFIG PARAM
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.PRIMARY_LEDGER = L.LEDGER_NAME
AND  TO_CHAR(L.LEDGER_ID)=PARAM.PARAMETER_VALUE
AND PARAM.PARAMETER_CODE='PARAM_ERP_FINANCIALS_LEDGER_ID_LIST_REPORT' AND PARAM.PARAMETER_VALUE<>'ALL'
AND D.ORGANIZATION_ID<>-99999

UNION

SELECT
TL.ORGANIZATION_NAME AS NAME,
TL.ORGANIZATION_ID AS VALUE
FROM DW_LEDGER_D L,
DW_INTERNAL_ORG_D D,
DW_INTERNAL_ORG_D_TL TL,
DW_CONTENT_PARAM_CONFIG PARAM
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.PRIMARY_LEDGER = L.LEDGER_NAME
AND  PARAM.PARAMETER_CODE='PARAM_ERP_FINANCIALS_LEDGER_ID_LIST_REPORT' AND PARAM.PARAMETER_VALUE='ALL'
AND (TO_CHAR(L.LEDGER_CHART_OF_ACCOUNTS_ID) IN (SELECT PARAM.PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG PARAM WHERE PARAM.PARAMETER_CODE='PARAM_ERP_FINANCIALS_CHART_OF_ACCOUNT_ID')
     OR EXISTS (SELECT 1 FROM dw_content_param_config param WHERE param.parameter_code = 'PARAM_ERP_FINANCIALS_CHART_OF_ACCOUNT_ID' AND param.parameter_value = 'ALL')
    )
AND D.ORGANIZATION_ID<>-99999

UNION

SELECT
    tl.organization_name   AS name,
    tl.organization_id     AS value
FROM
    dw_ledger_set_assignments_d assignments,
    dw_ledger_d               l,
    dw_internal_org_d         d,
    dw_internal_org_d_tl      tl,
    dw_content_param_config   param
WHERE
    param.parameter_code = 'PARAM_ERP_FINANCIALS_LEDGER_SET_ID_LIST_REPORT'
    AND param.PARAMETER_VALUE = 'ALL'
    AND assignments.ledger_id = l.ledger_id
    AND d.primary_ledger = l.ledger_name
    AND( 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 (TO_CHAR(L.LEDGER_CHART_OF_ACCOUNTS_ID) IN (SELECT PARAM.PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG PARAM WHERE PARAM.PARAMETER_CODE='PARAM_ERP_FINANCIALS_CHART_OF_ACCOUNT_ID')
         OR EXISTS (SELECT 1 FROM dw_content_param_config param WHERE param.parameter_code = 'PARAM_ERP_FINANCIALS_CHART_OF_ACCOUNT_ID' AND param.parameter_value = 'ALL')
        )
    AND  d.organization_id <> -99999

UNION

SELECT
    tl.organization_name   AS name,
    tl.organization_id     AS value
FROM
    dw_ledger_set_assignments_d assignments,
    dw_ledger_d               l,
    dw_internal_org_d         d,
    dw_internal_org_d_tl      tl,
    dw_content_param_config   param
WHERE
    TO_CHAR(assignments.ledger_set_id) = param.parameter_value
    AND param.parameter_code = 'PARAM_ERP_FINANCIALS_LEDGER_SET_ID_LIST_REPORT'
    AND param.PARAMETER_VALUE <> 'ALL'
    AND assignments.ledger_id = l.ledger_id
    AND d.primary_ledger = l.ledger_name
    AND( 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
ORDER BY NAME
OA4F_SEC_FIN_FA_ASSET_BOOK_LIST 
SELECT
BOOK_TYPE_CODE AS name,
BOOK_TYPE_CODE AS value
FROM
DW_FA_BOOK_CONTROLS_D
OA4F_SEC_FIN_LEDGER_LIST 
SELECT ledger.ledger_name   AS name,
       ledger.ledger_id     AS value
  FROM dw_ledger_d ledger,
       dw_content_param_config param
 WHERE param.parameter_code = 'PARAM_ERP_FINANCIALS_LEDGER_ID_LIST_REPORT'
   AND param.parameter_value = 'ALL'
   AND ( TO_CHAR(ledger.ledger_chart_of_accounts_id) IN (SELECT param.parameter_value FROM dw_content_param_config param WHERE param.parameter_code = 'PARAM_ERP_FINANCIALS_CHART_OF_ACCOUNT_ID')
          OR  EXISTS (SELECT 1 FROM dw_content_param_config param WHERE param.parameter_code = 'PARAM_ERP_FINANCIALS_CHART_OF_ACCOUNT_ID' AND param.parameter_value = 'ALL') )
    AND ledger.ledger_id <> - 99999
UNION
SELECT ledger.ledger_name   AS name,
       ledger.ledger_id     AS value
  FROM dw_ledger_d ledger,
       dw_content_param_config param
 WHERE TO_CHAR(ledger.ledger_id) = param.parameter_value
   AND param.parameter_code = 'PARAM_ERP_FINANCIALS_LEDGER_ID_LIST_REPORT'
   AND param.parameter_value <> 'ALL'
   AND ( TO_CHAR(ledger.ledger_chart_of_accounts_id) IN (SELECT param.parameter_value FROM dw_content_param_config param  WHERE param.parameter_code = 'PARAM_ERP_FINANCIALS_CHART_OF_ACCOUNT_ID')
        OR EXISTS (SELECT 1 FROM dw_content_param_config param WHERE param.parameter_code = 'PARAM_ERP_FINANCIALS_CHART_OF_ACCOUNT_ID' AND param.parameter_value = 'ALL')  )
    AND ledger.ledger_id <> - 99999
UNION
SELECT ledger.ledger_name   AS name,
       ledger.ledger_id     AS value
  FROM dw_ledger_set_d ledgerset,
       dw_content_param_config param,
       dw_ledger_set_assignments_d assignments,
       dw_ledger_d ledger
 WHERE ledgerset.ledger_set_id = assignments.ledger_set_id
   AND assignments.ledger_id = ledger.ledger_id
   AND param.parameter_code = 'PARAM_ERP_FINANCIALS_LEDGER_SET_ID_LIST_REPORT'
   AND param.parameter_value = 'ALL'
   AND ( TO_CHAR(ledger.ledger_chart_of_accounts_id) IN (SELECT param.parameter_value FROM dw_content_param_config param WHERE param.parameter_code = 'PARAM_ERP_FINANCIALS_CHART_OF_ACCOUNT_ID')
          OR EXISTS (SELECT 1 FROM dw_content_param_config param WHERE param.parameter_code = 'PARAM_ERP_FINANCIALS_CHART_OF_ACCOUNT_ID' AND param.parameter_value = 'ALL') )
    AND ledgerset.ledger_set_id <> - 99999 AND ledger.ledger_id <> - 99999
UNION
SELECT ledger.ledger_name   AS name,
       ledger.ledger_id     AS value
  FROM dw_ledger_set_d ledgerset,
       dw_content_param_config param,
       dw_ledger_set_assignments_d assignments,
       dw_ledger_d ledger
 WHERE TO_CHAR(ledgerset.ledger_set_id) = param.parameter_value
   AND ledgerset.ledger_set_id = assignments.ledger_set_id
   AND assignments.ledger_id = ledger.ledger_id
   AND param.parameter_code = 'PARAM_ERP_FINANCIALS_LEDGER_SET_ID_LIST_REPORT'
   AND param.parameter_value <> 'ALL'
   AND ( TO_CHAR(ledger.ledger_chart_of_accounts_id) IN (SELECT param.parameter_value FROM dw_content_param_config param WHERE param.parameter_code = 'PARAM_ERP_FINANCIALS_CHART_OF_ACCOUNT_ID')
          OR EXISTS (SELECT 1 FROM dw_content_param_config param WHERE param.parameter_code = 'PARAM_ERP_FINANCIALS_CHART_OF_ACCOUNT_ID' AND param.parameter_value = 'ALL') )
    AND ledgerset.ledger_set_id <> - 99999 AND 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.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_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_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

Upload and Download Financial Categories

You can download financial category template files to help you set up financial categories, and then upload the files to your environment.

You can download Sample or Current files. Sample provides a csv file with relevant headers to help familiarize you with the types of data you can expect. Current provides a list of current data assignments you can download to your test or production environments. Regardless of the file you download, you need to populate the FINANCIAL_CATEGORY column. Don't change any of the header names in the downloaded files. When you are done updating the files, you can upload them to your environment.

Note:

Replace existing configuration settings deletes existing data security assignments.
  1. Sign in to your service.
  2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Uploads under Application Administration.
    You see the Uploads page.
  3. On the Uploads page, click Download File, select Financial Categories and then select the type of file you want to download.
  4. Open the csv file you downloaded and populate the fields as required:
    • FINANCIAL_CATEGORY: The financial category code.
  5. When you are done updating the file, save your changes.
  6. On the Uploads page, click Upload File and the applicable file type.
  7. Select whether you want to Merge to the existing settings or Replace existing configuration settings.
  8. Select the file you want to upload and click Upload File.
    You can review the status of the upload on the Uploads tab.
  9. Use the Actions menu next to the file name to perform actions on a specific upload file:
    • Click Properties to check the upload statistics.
    • Click Download to download the file you just uploaded in the event you want to upload the file again.
    • Click Delete if a file fails to process and you want to remove the file history.

Upload and Download Financial Category Assignments

You can download financial category assignment template files to help you set up financial categories, and then upload the files to your environment.

You can download Sample or Current files. Sample provides a csv file with relevant headers to help familiarize you with the types of data you can expect. Current provides a list of current data assignments you can download to your test or production environments. Prior to download a file, you must select the segment combination you want to use to map your financial categories in the Select Columns dialog. The list prepopulates the segments defined in your chart of accounts that are BI enabled. Regardless of the file you download, you need to populate the FINANCIAL_CATEGORY column. Don't change any of the header names in the downloaded files. When you are done updating the files, you can upload them to your environment.

Note:

Replace existing configuration settings deletes existing data security assignments.
  1. Sign in to your service.
  2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Uploads under Application Administration.
    You see the Uploads page.
  3. On the Uploads page, click Download File, select Financial Category Assignments and then select the type of file you want to download.
  4. Open the csv file you downloaded and populate the fields as required:
    • CHART_OF_ACCOUNTS – Name of your chart of accounts.
    • Actual segment values.
    • FINANCIAL_CATEGORY: The financial category code. This can be a predefined category or a custom category defined using the Financial Categories upload option.
  5. When you are done updating the file, save your changes.
  6. On the Uploads page, click Upload File and the applicable file type.
  7. Select whether you want to Merge to the existing settings or Replace existing configuration settings.

    Note:

    If you want to change the segment combination for your financial category definition, then ensure to provide the data for all chart of accounts and use the replace option. The data is completely replaced. Different segment combinations for different chart of accounts is NOT supported.
  8. Select the file you want to upload and click Upload File.
    You can review the status of the upload on the Uploads tab.
  9. Use the Actions menu next to the file name to perform actions on a specific upload file:
    • Click Properties to check the upload statistics.
    • Click Download to download the file you just uploaded in the event you want to upload the file again.
    • Click Delete if a file fails to process and you want to remove the file history.

Upload and Download User Group Mappings

You can download user group mapping template files to help you set up user group mappings, and then upload the files to your environment.

You can download "Sample" or "Current" files. Sample provides a csv file with relevant headers to help familiarize you with the types of data you can expect. Current provides a list of current data assignments you can download to your test or production environments. Regardless of the file you download, you need to populate the USERNAME and GROUPNAME columns. Use the Operation column to make bulk changes to the user group mappings. Don't change any of the header names in the downloaded files. When you're done updating the files, you can upload them to your environment.
  1. Sign in to your service.
  2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Uploads under Application Administration.
    You see the Uploads page.
  3. On the Uploads page, click Download File, select User Group Mapping, and then select the type of file you want to download.
  4. Open the csv file you downloaded and populate the fields as required:
    • USERNAME: The username in Oracle Identity Cloud Service.
    • GROUPNAME: The group name in Oracle Identity Cloud Service.
    • OPERATION: Enter ADD or leave it blank to add the user group mappings or enter REMOVE to remove the user group mappings.
  5. When you're done updating the security file, save your changes.
  6. On the Uploads page, click Upload File and then select the applicable file type.
  7. Select the file you want to upload and click Upload File.
    You can review the status of the upload on the Uploads tab.
  8. Use the Actions menu next to the file name to perform actions on a specific upload file:
    • Click Properties to check the upload statistics.
    • Click Download to download the file you just uploaded in the event you want to upload the file again.
    • Click Delete if a file fails to process and you want to remove the file history.