Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BIP: xdo_user_roles: unimplemented or unreasonable conversion requested
Summary
BIP: xdo_user_roles: unimplemented or unreasonable conversion requested
Content
Hi experts,
https://fuscdrmsmc33-fa-ext.us.oracle.com/xmlpserver:
in my Data Model, I need to get the user roles, so I followed the following page
https://docs.oracle.com/cd/E36909_01/fusionapps.1111/e26386/create_data_sets.htm#T556760
and created a Data Model basing on a simple SQL Query:
select :xdo_user_roles as USER_ROLES from dual
When I try to view data:, there is an error:
oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested
Do yo know what is wrong ?
But "select:xdo_user_name as USER_ID from dual" works fine for me.
or I use "select :xdo_user_roles as USER_ROLES from dual" in my local environment, it works fine.
Answers
-
I got this from the log... is the error related to the size of XDO_USER_ROLES
Can you post list of roles of user who are trying to run ?
Also run same query with user who has bi consumer role.
0 -
171027_08230057][DATA PROCESSOR ID:1858119674][SCH JOB INFO:]XDO_USER_ROLES->PJR_RUN_IMPORT_RESOURCE_ACTUAL_HOURS_PROCESS_PRIV_OBI, ORA_OKC_CONTRACT_AMENDMENT_DUTY_OBI, OKC_EDIT_CONTRACT_PRIV_OBI, FBI_TRANSACTION_ANALYSIS_GENERIC_DUTY, POZ_IMPORT_SUPPLIER_PRIV_OBI, BIAdministrator, PJR_RUN_IMPORT_PROJECT_RESOURCE_REQUESTS_PROCESS_PRIV_OBI, OKC_AUTHOR_CONTRACT_TERMS_AND_CONDITIONS_NON_STANDARD_PRIV_OBI, ORA_GL_PROJECTS_PERIOD_STATUS_MANAGEMENT_DUTY_OBI, ORA_ZCM_SALES_PARTY_MANAGEMENT_DUTY_OBI, XLA_DEFINE_SUBLEDGER_APPLICATION_PRIV_OBI, ORA_MOT_QUOTA_MANAGEMENT_SETUP_DUTY_OBI, ORA_ZX_WHT_ADMINISTRATION_DUTY_OBI, ORA_AP_PAYABLES_INVOICE_INQUIRY_DUTY_OBI, ORA_POQ_SUPPLIER_QUALIFICATION_ADMINISTRATION_DUTY_OBI, ORA_RCS_SUPPLY_CHAIN_APPLICATION_ADMINISTRATOR_JOB, FND_DIAG_REGULAR_USER_DUTY_OBI, ORA_EXM_CORPORATE_CARD_ACCOUNT_ADMINISTRATION_DUTY_OBI, PER_SYNCHRONIZE_USERS_ROLES_PROCESS_PRIV_OBI, ASM_MANAGE_IMPLEMENTATION_PROJECT_PRIV_OBI, XLA_IMPORT_SUBLEDGER_BALANCE_FOR_SUPPORTING_REFERENCE_PRIV_OBI, OBIA_EXTRACTTRANSFORMLOAD_RWD, BIA_OVERVIEW_PRIV, OKC_VIEW_CONTRACT_TERMS_AND_CONDITIONS_EXTERNAL_PARTY_PRIV_OBI, OKC_RUN_CONTRACT_PDF_GENERATION_PRIV_OBI, ORA_IBY_PAYEE_BANK_ACCOUNT_MANAGEMENT_DUTY_OBI, ORA_XLE_LEGAL_ENTITIES_ADMIN_DUTY_OBI, ORA_HZRESOURCE_TEAM_ADMINISTRATOR_DUTY_OBI, ORA_IEX_COLLECTIONS_ADMINISTRATION_DUTY_OBI, BIA_HELP_PRIV, XLA_MANAGE_SUBLEDGER_ACCOUNTING_CLASS_USAGE_PRIV_OBI, GL_ADMINISTER_FINANCIAL_STATEMENT_REPORT_PRIV_OBI, ORA_MKL_LEAD_REGISTRATION_SUBMISSION_DUTY_OBI, CMP_DEFINE_COMPENSATION_PLAN_DEFINITION_PRIV_OBI, OKC_VIEW_CONTRACT_PRIV_OBI, BIA_ADMINISTRATOR_DUTY, ORA_MOT_TERRITORY_MANAGEMENT_DUTY_OBI, BIA_MANAGE_SCHEDULE_PRIV, GMS_MANAGE_GRANTS_SPONSOR_PRIV_OBI, OKC_DEFINE_CONTRACT_TERMS_TEMPLATE_PRIV_OBI, XLA_REVIEW_SUBLEDGER_ACCOUNTING_METHOD_PRIV_OBI, PO_VIEW_PURCHASE_AGREEMENT_PRIV_OBI, ORA_PON_NEGOTIATION_VIEWING_DUTY_OBI, FBI_HCM_TRANSACTION_ADMINISTRATION_TRANSACTION_ANALYSIS_DUTY, GMS_MANAGE_GRANTS_PERSONNEL_PRIV_OBI, ORA_MSP_PLANNING_ADMINISTRATION_DUTY_OBI, ORA_MOT_TERRITORY_MANAGEMENT_T2P_MIGRATION_DUTY_OBI, ORA_HZRESOURCE_ADMINISTRATOR_DUTY_OBI, PJF_MANAGE_PROJECT_BURDEN_SCHEDULE_PRIV_OBI, ORA_FND_DIAG_VIEWER_DUTY_OBI, ORA_ARB_BILL_MANAGEMENT_SETUP_MAINTENANCE_DUTY_OBI, ORA_PER_DOCUMENT_MANAGEMENT_DUTY_OBI, ORA_CN_INCENTIVE_COMPENSATION_ADMINISTRATOR_JOB, PON_VIEW_SUPPLIER_NEGOTIATION_PRIV_OBI, PER_MANAGE_PERSON_PRIV_OBI, ORA_FA_FIXED_ASSET_INQUIRY_DUTY_OBI, EGP_MANAGE_ITEM_CATALOG_PRIV_OBI, XLA_MANAGE_SUBLEDGER_DESCRIPTION_RULE_PRIV_OBI, ORA_WSH_SHIPPING_ADMINISTRATION_DUTY_OBI, ORA_OKC_CONTRACT_TERMS_AUTHORING_OVERRIDE_DUTY_OBI, BIConsumer, ORA_OKC_ALL_BUSINESS_UNITS_CONTRACT_INQUIRY_DUTY_OBI, ORA_IBY_PAYMENTS_FUNDS_CAPTURE_ADMINISTRATION_DUTY_OBI, ORA_HRT_WORKFORCE_PROFILE_ADMINISTRATION_DUTY_OBI, ORA_OKC_CONTRACT_AUTHORING_DUTY_OBI, ORA_EGI_PRODUCT_HUB_ADMINISTRATION_DUTY_OBI, ORA_ZCA_CUSTOMER_RELATIONSHIP_MANAGEMENT_APPLICATION_ADMINISTRATOR_JOB, ORA_ZCM_SETUP_CUSTOMER_CENTER_DUTY_OBI, ORA_PO_PROCUREMENT_APPLICATION_ADMIN_JOB, ORA_MSP_PLANNING_COLLECTED_DATA_MANAGEMENT_DUTY_OBI, GMS_MANAGE_GRANTS_KEYWORD_PRIV_OBI, ORA_BEN_BENEFITS_ELECTIONS_DUTY_OBI, ORA_XLA_ACCOUNTING_HUB_ADMINISTRATION_DUTY_OBI, ORA_AP_PAYABLES_ADMINISTRATION_DUTY_OBI, PER_EXTRACT_WORKER_MODEL_DETAILS_PRIV_OBI, AR_SET_UP_RECEIVABLES_RECEIPT_CLASS_PRIV_OBI, PJT_IMPORT_PROJECT_WORK_PLAN_PROCESS_PRIV_OBI, PJF_RUN_IMPORT_PROJECT_RATE_SCHEDULES_PROCESS_PRIV_OBI, ORA_HEY_HIGHER_EDUCATION_APPLICATION_ADMINISTRATOR_JOB, POZ_VIEW_SUPPLIER_REGISTRATION_REQUEST_PRIV_OBI, OKC_VIEW_CONTRACT_LIBRARY_CLAUSE_PRIV_OBI, PJF_RUN_GENERATE_BURDEN_TRANSACTIONS_PROCESS_PRIV_OBI, ORA_ASM_FUNCTIONAL_SETUPS_DUTY_OBI, ORA_INV_UNIT_OF_MEASURE_MANAGEMENT_DUTY_OBI, GL_RUN_CHART_OF_ACCOUNTS_MAPPING_RULES_REPORT_PRIV_OBI, PJO_RUN_IMPORT_PROJECT_BUDGET_PROCESS_PRIV_OBI, ORA_FUN_FSCM_LOAD_INTERFACE_ADMIN_DUTY_OBI, ORA_PER_HCM_EXTRACT_DEFINITION_DUTY_OBI, ORA_FND_DIAG_REGULAR_USER_JOB, OKC_SPECIFY_CUSTOMER_CONTRACT_MANAGEMENT_BUSINESS_FUNCTION_PROPERTIES_PRIV_OBI, BIA_FUNCTIONAL_DEVELOPER_DUTY, ORA_PJT_PROJECT_EXECUTION_APPLICATION_ADMINISTRATION_DUTY_OBI, ORA_PJF_PROJECTS_APPLICATION_ADMINISTRATOR_JOB, ORA_GL_GENERAL_ACCOUNTING_FUNCTIONAL_ADMINISTRATION_DUTY_OBI, PJT_MANAGE_PROJECT_ENTERPRISE_RESOURCE_LOAD_SERVICE_PRIV_OBI, EssbaseCalcManager, ORA_MOT_TERRITORY_MANAGEMENT_EXPORT_IMPORT_DUTY_OBI, PJB_RUN_IMPORT_PROJECT_CONTRACT_BILLING_EVENTS_PROCESS_PRIV_OBI, OKC_AUTHOR_CONTRACT_TERMS_AND_CONDITIONS_TEMPLATE_PRIV_OBI, ORA_MOT_QUOTA_MANAGEMENT_EXPORT_IMPORT_DUTY_OBI, OKC_AUTHOR_CONTRACT_TERMS_AND_CONDITIONS_STANDARD_PRIV_OBI, ORA_POQ_SUPPLIER_QUALIFICATION_VIEWING_DUTY_OBI, ORA_OKC_CONTRACT_SEARCH_VIEW_DUTY_OBI, PO_SFO_UPGRADE_PRIV_OBI, ORA_GEO_ADMIN_DUTY_OBI, ORA_GL_GENERAL_LEDGER_TECHNICAL_ADMINISTRATION_DUTY_OBI, ORA_DOO_ORDER_ORCHESTRATION_ADMINISTRATION_DUTY_OBI, PER_RUN_HCM_EXTRACT_REPORT_PRIV_OBI, IEX_RUN_AGING_7_BUCKET_BY_COLLECTOR_PRIV_OBI, ORA_EGP_ITEM_INQUIRY_DUTY_OBI, ORA_OKC_CONTRACT_TERMS_AUTHORING_NON_STANDARD_DUTY_OBI, ORA_MKT_MARKETING_MAINTENANCE_DUTY_OBI, BIA_CONFIGURE_EXTERNAL_STORAGE_PRIV, FBI_SERVICE_ADMINISTRATIVE_TRANSACTION_ANALYSIS_DUTY, PER_EXTRACT_WORKSTRUCTURE_REPORT_DETAILS_PRIV_OBI, XLA_MANAGE_SUBLEDGER_ACCOUNTING_METHOD_PRIV_OBI, PER_EXTRACT_WORKER_REPORT_DETAILS_PRIV_OBI, PER_EXTRACT_WORKSTRUCTURE_MODEL_DETAILS_PRIV_OBI, HRC_LOAD_HR_BATCH_DATA_PRIV_OBI, PJO_RUN_IMPORT_PROJECT_PLAN_PROCESS_PRIV_OBI, ORA_FND_DIAG_ADVANCED_USER_JOB, ORA_PAY_PAYROLL_IMPLEMENTATION_VIEW_DUTY_OBI, XLA_MANAGE_SUBLEDGER_MAPPING_SET_VALUE_PRIV_OBI, BIA_CONFIGURE_CLOUD_EXTRACT_PRIV, ORA_HRA_PERFORMANCE_MANAGEMENT_ADMINISTRATION_DUTY_OBI, PJF_RUN_UPDATE_WORK_TYPE_ATTRIBUTE_PROCESS_PRIV_OBI, ORA_FUN_ENTERPRISE_STRUCTURES_ADMINISTRATION_DUTY_OBI, ARB_SETUP_BILL_MANAGEMENT_SYSTEM_OPTION_PRIV_OBI, ORA_ASM_IMPLEMENTATION_MANAGER_DUTY_OBI, OKC_MANAGE_CONTRACT_TYPE_PRIV_OBI, ORA_CZ_PRODUCT_CONFIGURATOR_MANAGER_JOB, ORA_RCV_RECEIVING_ADMINISTRATION_DUTY_OBI, ORA_PAY_COMMON_HCM_IMPLEMENTION_DUTY_OBI, ORA_MANAGE_TRADING_COMMUNITY_IMPORT_PROCESS_DUTY_OBI, ORA_PER_HCM_INFORMATION_COMPARISON_DUTY_OBI, ORA_FND_APPLICATION_DEVELOPER_JOB, PJF_RUN_DENORMALIZE_ORGANIZATION_HIERARCHIES_PRIV_OBI, OKC_VIEW_CONTRACT_TERMS_AND_CONDITIONS_PRIV_OBI, ORA_BEN_BENEFITS_IMPLEMENTATION_DUTY_OBI, ESSAdmin, CMS_DEFINE_TOTAL_COMPENSATION_STATEMENT_SETUP_PRIV_OBI, XLA_IMPORT_SUBLEDGER_CONTROL_BALANCE_PRIV_OBI, ORA_PER_USER_ROLE_MANAGEMENT_DUTY_OBI, ORA_PJF_PROJECT_FINANCIAL_APPLICATION_ADMINISTRATION_DUTY_OBI, ORA_OKC_CONTRACT_SETUP_DUTY_OBI, PJS_RUN_MAINTAIN_PROJECT_PERFORMANCE_PROCESS_PRIV_OBI, ORA_HRC_HUMAN_CAPITAL_MANAGEMENT_APPLICATION_ADMINISTRATOR_JOB, HRG_MANAGE_PERFORMANCE_GOAL_PRIV_OBI, ORA_EXM_EXPENSES_ADMINISTRATION_DUTY_OBI, ORA_ASM_FUNCTIONAL_SETUPS_USER_ABSTRACT, POQ_VIEW_SUPPLIER_QUALIFICATION_INITIATIVE_PRIV_OBI, ASM_SUBMIT_EXPORT_SETUP_DATA_PROCESS_PRIV_OBI, ORA_DOO_ORCHESTRATION_INFRASTRUCTURE_ADMINISTRATION_DUTY_OBI, IEX_RUN_AGING_7_BUCKET_PRIV_OBI, ORA_PER_WORKFORCE_STRUCTURES_MANAGEMENT_DUTY_OBI, OKC_SEARCH_CONTRACT_TERMS_TEMPLATE_PRIV_OBI, OKC_VIEW_CONTRACT_TEMPLATE_PRIV_OBI, ORA_FUN_FINANCIAL_APPLICATION_ADMINISTRATOR_JOB, CMS_MONITOR_TOTAL_COMPENSATION_STATEMENT_PROCESSES_PRIV_OBI, ORA_PER_MANAGE_USER_AND_ROLES_DUTY_OBI, ORA_PAY_ELEMENT_ENTRY_MANAGEMENT_DUTY_OBI, XLA_MANAGE_SUBLEDGER_APPLICATION_TRANSACTION_OBJECT_PRIV_OBI, ASM_SUBMIT_IMPORT_SETUP_DATA_PROCESS_PRIV_OBI, ORA_AR_RECEIVABLES_ADMINISTRATION_DUTY_OBI, HRA_MANAGE_PERFORMANCE_TEMPLATE_PRIV_OBI, ORA_MANAGE_TRADING_COMMUNITY_IMPORT_BATCH_DUTY_OBI, ORA_GMS_GRANTS_MANAGEMENT_ADMINISTRATION_DUTY_OBI, OKC_SPECIFY_PROCUREMENT_CONTRACT_MANAGEMENT_BUSINESS_FUNCTION_PROPERTIES_PRIV_OBI, XLA_UPDATE_SUBLEDGER_APPLICATION_PRIV_OBI, PJF_RUN_IMPORT_PROJECT_PROCESS_PRIV_OBI, ORA_CST_COST_MANAGEMENT_ADMINISTRATION_DUTY_OBI, ORA_OKC_CONTRACT_TERMS_LIBRARY_ADMINISTRATION_DUTY_OBI, ORA_GL_MANAGE_GENERAL_LEDGER_ACCOUNTING_PERIOD_STATUS_AGGR_OBI, ORA_MKT_MARKETING_BUDGET_MAINTENANCE_DUTY_OBI, XLA_MANAGE_SUBLEDGER_JOURNAL_ENTRY_RULE_SET_PRIV_OBI, ORA_PAY_FAST_FORMULA_MANAGEMENT_DUTY_OBI, OKC_VIEW_CONTRACT_TERMS_TEMPLATE_PRIV_OBI, FND_DIAG_ADVANCED_USER_DUTY_OBI, PJF_RUN_BUILD_NEW_ORGANIZATION_BURDEN_RATES_PROCESS_PRIV_OBI, ORA_MOT_QUOTA_EXPORT_MANAGEMENT_DUTY_OBI, ORA_PAY_PROCESS_AND_REPORT_SUBMISSION_DUTY_OBI, IEX_RUN_AGING_4_BUCKET_PRIV_OBI, XLA_MANAGE_SUBLEDGER_ACCOUNTING_EXISTING_SCOPE_PRIV_OBI, PO_VIEW_PURCHASE_ORDER_PRIV_OBI, PER_MANAGE_HCM_EXTRACT_DEFINITION_REPORT_PRIV_OBI, ORA_PAY_PAYROLL_IMPLEMENTATION_DUTY_OBI, XLA_PURGE_ACCOUNTING_EVENT_DIAGNOSTIC_DATA_PRIV_OBI, ORA_IBY_CUSTOMER_PAYMENT_INSTRUMENT_MANAGEMENT_DUTY_OBI, PJO_RUN_IMPORT_PROJECT_FORECASTS_PROCESS_PRIV_OBI, OKC_VIEW_CONTRACT_TERMS_TEMPLATE_BY_WEB_SERVICE_PRIV_OBI, XLA_MANAGE_SUBLEDGER_MAPPING_SET_PRIV_OBI, ORA_INV_INVENTORY_ADMINISTRATION_DUTY_OBI, GL_RUN_BALANCING_SEGMENT_VALUE_ASSIGNMENT_REPORT_PRIV_OBI, ORA_HZRESOURCE_ORGANIZATION_ADMINISTRATOR_DUTY_OBI, XLA_MANAGE_SUBLEDGER_ACCOUNT_RULE_PRIV_OBI, GL_CREATE_FINANCIAL_STATEMENT_REPORT_PRIV_OBI, ORA_ASM_APPLICATION_IMPLEMENTATION_ADMIN_ABSTRACT, ORA_WSH_CARRIER_MANAGEMENT_DUTY_OBI, ORA_ASM_APPLICATION_IMPLEMENTATION_CONSULTANT_JOB, ASM_REVIEW_APPLICATIONS_OFFERINGS_PRIV_OBI, ORA_AR_CUSTOMER_MAINTENANCE_DUTY_OBI, PER_MANAGE_PERSON_DOCUMENTATION_PRIV_OBI, ORA_ZCM_PARTNER_SALES_PARTY_MANAGEMENT_DUTY_OBI, ORA_ASM_SETUP_OBJECTS_PROVIDER_DUTY_OBI, ORA_ZX_TAX_ADMINISTRATION_DUTY_OBI, ORA_POZ_SUPPLIER_PROFILE_INQUIRY_DUTY_OBI, XLA_SUBMIT_ACCOUNTING_EVENT_DIAGNOSTIC_REPORT_PRIV_OBI, BICC_REST_EXTRACT_PRIV, ORA_MSP_ORDER_PROMISING_MANAGEMENT_DUTY_OBI, ASM_MANAGE_TASK_LISTS_PRIV_OBI, ORA_HRA_PERFORMANCE_MANAGEMENT_IMPLEMENTATION_DUTY_OBI, HZ_VIEW_TRADING_COMMUNITY_IMPORT_BATCH_ERRORS_AND_DETAILS_PRIV_OBI, XLA_MANAGE_SUBLEDGER_JOURNAL_LINE_RULE_PRIV_OBI, ORA_ZCM_SALES_PARTY_REVIEW_DUTY_OBI, ORA_PAY_PAYROLL_FLOW_SUBMISSION_DUTY_OBI, ORA_FND_DIAG_VIEWER_JOB, ORA_AP_PAYABLES_INVOICE_IMPORT_SUBMISSION_DUTY_OBI, FBI_ARCHIVED_HCM_APPROVAL_TASK_TRANSACTION_ANALYSIS_DUTY, CN_ADD_PLAN_DOCUMENT_TEMPLATE_PRIV_OBI, ORA_FND_APPLICATION_ADMINISTRATOR_JOB, ORA_PO_SETUP_DUTY_OBI, XLA_ACTIVATE_SUBLEDGER_JOURNAL_ENTRY_RULE_SET_ASSIGNMENT_PRIV_OBI, BIPDataModelDeveloper, ORA_MOT_TERRITORY_MANAGEMENT_SETUP_DUTY_OBI, PJT_RUN_TRANSFER_ABSENCE_RECORDS_TO_ORACLE_FUSION_PROJECT_EXECUTION_PROCESS_PRIV_OBI, IEX_SEND_COLLECTIONS_CORRESPONDENCE_PRIV_OBI, OKC_DEFINE_CONTRACT_LIBRARY_CLAUSE_PRIV_OBI, PJF_RUN_ACCOUNTING_PERIOD_PROCESSES_PRIV_OBI, PO_MANAGE_PROCUREMENT_CONFIGURATION_PRIV_OBI, ORA_IBY_PAYMENTS_DISBURSEMENT_ADMINISTRATION_DUTY_OBI, XLA_MANAGE_SUBLEDGER_SUPPORTING_REFERENCE_PRIV_OBI, BIAuthor, HRC_LOAD_HCM_DATA_CO_EXISTENCE_PRIV_OBI, XLA_CREATE_AND_ASSIGN_SUBLEDGER_STANDARD_SOURCE_PRIV_OBI, ORA_CE_CASH_MANAGEMENT_ADMINISTRATION_DUTY_OBI, ORA_SVC_SR_ADMINISTRATOR_OBI, ORA_PER_DEPARTMENT_MANAGEMENT_DUTY_OBI, GMS_RUN_IMPORT_AWARD_PROCESS_PRIV_OBI, AP_IMPORT_PAYABLES_INVOICE_PRIV_OBI, ORA_INV_INVENTORY_ABC_ANALYSIS_DUTY_OBI, CMS_GENERATE_TOTAL_COMPENSATION_STATEMENT_PRIV_OBI, PJR_RUN_IMPORT_PROJECT_RESOURCE_ASSIGNMENTS_PROCESS_PRIV_OBI, ORA_EGP_ITEM_MANAGEMENT_DUTY_OBI, GL_MANAGE_ACCOUNTING_PERIOD_STATUS_PRIV_OBI, ORA_MOT_QUOTA_MANAGEMENT_DUTY_OBI, ORA_PER_DIVISION_MANAGEMENT_DUTY_OBI, ORA_EGP_PRODUCT_MODEL_ADMINISTRATION_DUTY_OBI, PO_VERIFY_UPGRADED_STRUCTURE_PRIV_OBI
[171027_08230057][DATA PROCESSOR ID:1858119674][SCH JOB INFO:]XDO_USER_UI_LOCALE->en_US
[171027_08230057][DATA PROCESSOR ID:1858119674][SCH JOB INFO:]XDO_USER_UI_ORACLE_LANG->US
[171027_08230057][DATA PROCESSOR ID:1858119674][SCH JOB INFO:]XDO_USER_REPORT_LOCALE->en_US
[171027_08230057][DATA PROCESSOR ID:1858119674][SCH JOB INFO:]XDO_USER_REPORT_ORACLE_LANG->US
[171027_08230057][DATA PROCESSOR ID:1858119674][SCH JOB INFO:]XDO_DASHBOARD_EXPR->null
I got this from the log... is the error related to the size of XDO_USER_ROLES?thanks !
Kurt
0 -
hi,
thanks for the reply.
I guess this is because the value is to large for the variable. But I don't have the resolution for it.
The user I used was faadmin, which is a BICosumer:
roles:
XDO_USER_ROLES->PJR_RUN_IMPORT_RESOURCE_ACTUAL_HOURS_PROCESS_PRIV_OBI, ORA_OKC_CONTRACT_AMENDMENT_DUTY_OBI, OKC_EDIT_CONTRACT_PRIV_OBI, FBI_TRANSACTION_ANALYSIS_GENERIC_DUTY, POZ_IMPORT_SUPPLIER_PRIV_OBI, BIAdministrator, PJR_RUN_IMPORT_PROJECT_RESOURCE_REQUESTS_PROCESS_PRIV_OBI, OKC_AUTHOR_CONTRACT_TERMS_AND_CONDITIONS_NON_STANDARD_PRIV_OBI, ORA_GL_PROJECTS_PERIOD_STATUS_MANAGEMENT_DUTY_OBI, ORA_ZCM_SALES_PARTY_MANAGEMENT_DUTY_OBI, XLA_DEFINE_SUBLEDGER_APPLICATION_PRIV_OBI, ORA_MOT_QUOTA_MANAGEMENT_SETUP_DUTY_OBI, ORA_ZX_WHT_ADMINISTRATION_DUTY_OBI, ORA_AP_PAYABLES_INVOICE_INQUIRY_DUTY_OBI, ORA_POQ_SUPPLIER_QUALIFICATION_ADMINISTRATION_DUTY_OBI, ORA_RCS_SUPPLY_CHAIN_APPLICATION_ADMINISTRATOR_JOB, FND_DIAG_REGULAR_USER_DUTY_OBI, ORA_EXM_CORPORATE_CARD_ACCOUNT_ADMINISTRATION_DUTY_OBI, PER_SYNCHRONIZE_USERS_ROLES_PROCESS_PRIV_OBI, ASM_MANAGE_IMPLEMENTATION_PROJECT_PRIV_OBI, XLA_IMPORT_SUBLEDGER_BALANCE_FOR_SUPPORTING_REFERENCE_PRIV_OBI, OBIA_EXTRACTTRANSFORMLOAD_RWD, BIA_OVERVIEW_PRIV, OKC_VIEW_CONTRACT_TERMS_AND_CONDITIONS_EXTERNAL_PARTY_PRIV_OBI, OKC_RUN_CONTRACT_PDF_GENERATION_PRIV_OBI, ORA_IBY_PAYEE_BANK_ACCOUNT_MANAGEMENT_DUTY_OBI, ORA_XLE_LEGAL_ENTITIES_ADMIN_DUTY_OBI, ORA_HZRESOURCE_TEAM_ADMINISTRATOR_DUTY_OBI, ORA_IEX_COLLECTIONS_ADMINISTRATION_DUTY_OBI, BIA_HELP_PRIV, XLA_MANAGE_SUBLEDGER_ACCOUNTING_CLASS_USAGE_PRIV_OBI, GL_ADMINISTER_FINANCIAL_STATEMENT_REPORT_PRIV_OBI, ORA_MKL_LEAD_REGISTRATION_SUBMISSION_DUTY_OBI, CMP_DEFINE_COMPENSATION_PLAN_DEFINITION_PRIV_OBI, OKC_VIEW_CONTRACT_PRIV_OBI, BIA_ADMINISTRATOR_DUTY, ORA_MOT_TERRITORY_MANAGEMENT_DUTY_OBI, BIA_MANAGE_SCHEDULE_PRIV, GMS_MANAGE_GRANTS_SPONSOR_PRIV_OBI, OKC_DEFINE_CONTRACT_TERMS_TEMPLATE_PRIV_OBI, XLA_REVIEW_SUBLEDGER_ACCOUNTING_METHOD_PRIV_OBI, PO_VIEW_PURCHASE_AGREEMENT_PRIV_OBI, ORA_PON_NEGOTIATION_VIEWING_DUTY_OBI, FBI_HCM_TRANSACTION_ADMINISTRATION_TRANSACTION_ANALYSIS_DUTY, GMS_MANAGE_GRANTS_PERSONNEL_PRIV_OBI, ORA_MSP_PLANNING_ADMINISTRATION_DUTY_OBI, ORA_MOT_TERRITORY_MANAGEMENT_T2P_MIGRATION_DUTY_OBI, ORA_HZRESOURCE_ADMINISTRATOR_DUTY_OBI, PJF_MANAGE_PROJECT_BURDEN_SCHEDULE_PRIV_OBI, ORA_FND_DIAG_VIEWER_DUTY_OBI, ORA_ARB_BILL_MANAGEMENT_SETUP_MAINTENANCE_DUTY_OBI, ORA_PER_DOCUMENT_MANAGEMENT_DUTY_OBI, ORA_CN_INCENTIVE_COMPENSATION_ADMINISTRATOR_JOB, PON_VIEW_SUPPLIER_NEGOTIATION_PRIV_OBI, PER_MANAGE_PERSON_PRIV_OBI, ORA_FA_FIXED_ASSET_INQUIRY_DUTY_OBI, EGP_MANAGE_ITEM_CATALOG_PRIV_OBI, XLA_MANAGE_SUBLEDGER_DESCRIPTION_RULE_PRIV_OBI, ORA_WSH_SHIPPING_ADMINISTRATION_DUTY_OBI, ORA_OKC_CONTRACT_TERMS_AUTHORING_OVERRIDE_DUTY_OBI, BIConsumer, ORA_OKC_ALL_BUSINESS_UNITS_CONTRACT_INQUIRY_DUTY_OBI, ORA_IBY_PAYMENTS_FUNDS_CAPTURE_ADMINISTRATION_DUTY_OBI, ORA_HRT_WORKFORCE_PROFILE_ADMINISTRATION_DUTY_OBI, ORA_OKC_CONTRACT_AUTHORING_DUTY_OBI, ORA_EGI_PRODUCT_HUB_ADMINISTRATION_DUTY_OBI, ORA_ZCA_CUSTOMER_RELATIONSHIP_MANAGEMENT_APPLICATION_ADMINISTRATOR_JOB, ORA_ZCM_SETUP_CUSTOMER_CENTER_DUTY_OBI, ORA_PO_PROCUREMENT_APPLICATION_ADMIN_JOB, ORA_MSP_PLANNING_COLLECTED_DATA_MANAGEMENT_DUTY_OBI, GMS_MANAGE_GRANTS_KEYWORD_PRIV_OBI, ORA_BEN_BENEFITS_ELECTIONS_DUTY_OBI, ORA_XLA_ACCOUNTING_HUB_ADMINISTRATION_DUTY_OBI, ORA_AP_PAYABLES_ADMINISTRATION_DUTY_OBI, PER_EXTRACT_WORKER_MODEL_DETAILS_PRIV_OBI, AR_SET_UP_RECEIVABLES_RECEIPT_CLASS_PRIV_OBI, PJT_IMPORT_PROJECT_WORK_PLAN_PROCESS_PRIV_OBI, PJF_RUN_IMPORT_PROJECT_RATE_SCHEDULES_PROCESS_PRIV_OBI, ORA_HEY_HIGHER_EDUCATION_APPLICATION_ADMINISTRATOR_JOB, POZ_VIEW_SUPPLIER_REGISTRATION_REQUEST_PRIV_OBI, OKC_VIEW_CONTRACT_LIBRARY_CLAUSE_PRIV_OBI, PJF_RUN_GENERATE_BURDEN_TRANSACTIONS_PROCESS_PRIV_OBI, ORA_ASM_FUNCTIONAL_SETUPS_DUTY_OBI, ORA_INV_UNIT_OF_MEASURE_MANAGEMENT_DUTY_OBI, GL_RUN_CHART_OF_ACCOUNTS_MAPPING_RULES_REPORT_PRIV_OBI, PJO_RUN_IMPORT_PROJECT_BUDGET_PROCESS_PRIV_OBI, ORA_FUN_FSCM_LOAD_INTERFACE_ADMIN_DUTY_OBI, ORA_PER_HCM_EXTRACT_DEFINITION_DUTY_OBI, ORA_FND_DIAG_REGULAR_USER_JOB, OKC_SPECIFY_CUSTOMER_CONTRACT_MANAGEMENT_BUSINESS_FUNCTION_PROPERTIES_PRIV_OBI, BIA_FUNCTIONAL_DEVELOPER_DUTY, ORA_PJT_PROJECT_EXECUTION_APPLICATION_ADMINISTRATION_DUTY_OBI, ORA_PJF_PROJECTS_APPLICATION_ADMINISTRATOR_JOB, ORA_GL_GENERAL_ACCOUNTING_FUNCTIONAL_ADMINISTRATION_DUTY_OBI, PJT_MANAGE_PROJECT_ENTERPRISE_RESOURCE_LOAD_SERVICE_PRIV_OBI, EssbaseCalcManager, ORA_MOT_TERRITORY_MANAGEMENT_EXPORT_IMPORT_DUTY_OBI, PJB_RUN_IMPORT_PROJECT_CONTRACT_BILLING_EVENTS_PROCESS_PRIV_OBI, OKC_AUTHOR_CONTRACT_TERMS_AND_CONDITIONS_TEMPLATE_PRIV_OBI, ORA_MOT_QUOTA_MANAGEMENT_EXPORT_IMPORT_DUTY_OBI, OKC_AUTHOR_CONTRACT_TERMS_AND_CONDITIONS_STANDARD_PRIV_OBI, ORA_POQ_SUPPLIER_QUALIFICATION_VIEWING_DUTY_OBI, ORA_OKC_CONTRACT_SEARCH_VIEW_DUTY_OBI, PO_SFO_UPGRADE_PRIV_OBI, ORA_GEO_ADMIN_DUTY_OBI, ORA_GL_GENERAL_LEDGER_TECHNICAL_ADMINISTRATION_DUTY_OBI, ORA_DOO_ORDER_ORCHESTRATION_ADMINISTRATION_DUTY_OBI, PER_RUN_HCM_EXTRACT_REPORT_PRIV_OBI, IEX_RUN_AGING_7_BUCKET_BY_COLLECTOR_PRIV_OBI, ORA_EGP_ITEM_INQUIRY_DUTY_OBI, ORA_OKC_CONTRACT_TERMS_AUTHORING_NON_STANDARD_DUTY_OBI, ORA_MKT_MARKETING_MAINTENANCE_DUTY_OBI, BIA_CONFIGURE_EXTERNAL_STORAGE_PRIV, FBI_SERVICE_ADMINISTRATIVE_TRANSACTION_ANALYSIS_DUTY, PER_EXTRACT_WORKSTRUCTURE_REPORT_DETAILS_PRIV_OBI, XLA_MANAGE_SUBLEDGER_ACCOUNTING_METHOD_PRIV_OBI, PER_EXTRACT_WORKER_REPORT_DETAILS_PRIV_OBI, PER_EXTRACT_WORKSTRUCTURE_MODEL_DETAILS_PRIV_OBI, HRC_LOAD_HR_BATCH_DATA_PRIV_OBI, PJO_RUN_IMPORT_PROJECT_PLAN_PROCESS_PRIV_OBI, ORA_FND_DIAG_ADVANCED_USER_JOB, ORA_PAY_PAYROLL_IMPLEMENTATION_VIEW_DUTY_OBI, XLA_MANAGE_SUBLEDGER_MAPPING_SET_VALUE_PRIV_OBI, BIA_CONFIGURE_CLOUD_EXTRACT_PRIV, ORA_HRA_PERFORMANCE_MANAGEMENT_ADMINISTRATION_DUTY_OBI, PJF_RUN_UPDATE_WORK_TYPE_ATTRIBUTE_PROCESS_PRIV_OBI, ORA_FUN_ENTERPRISE_STRUCTURES_ADMINISTRATION_DUTY_OBI, ARB_SETUP_BILL_MANAGEMENT_SYSTEM_OPTION_PRIV_OBI, ORA_ASM_IMPLEMENTATION_MANAGER_DUTY_OBI, OKC_MANAGE_CONTRACT_TYPE_PRIV_OBI, ORA_CZ_PRODUCT_CONFIGURATOR_MANAGER_JOB, ORA_RCV_RECEIVING_ADMINISTRATION_DUTY_OBI, ORA_PAY_COMMON_HCM_IMPLEMENTION_DUTY_OBI, ORA_MANAGE_TRADING_COMMUNITY_IMPORT_PROCESS_DUTY_OBI, ORA_PER_HCM_INFORMATION_COMPARISON_DUTY_OBI, ORA_FND_APPLICATION_DEVELOPER_JOB, PJF_RUN_DENORMALIZE_ORGANIZATION_HIERARCHIES_PRIV_OBI, OKC_VIEW_CONTRACT_TERMS_AND_CONDITIONS_PRIV_OBI, ORA_BEN_BENEFITS_IMPLEMENTATION_DUTY_OBI, ESSAdmin, CMS_DEFINE_TOTAL_COMPENSATION_STATEMENT_SETUP_PRIV_OBI, XLA_IMPORT_SUBLEDGER_CONTROL_BALANCE_PRIV_OBI, ORA_PER_USER_ROLE_MANAGEMENT_DUTY_OBI, ORA_PJF_PROJECT_FINANCIAL_APPLICATION_ADMINISTRATION_DUTY_OBI, ORA_OKC_CONTRACT_SETUP_DUTY_OBI, PJS_RUN_MAINTAIN_PROJECT_PERFORMANCE_PROCESS_PRIV_OBI, ORA_HRC_HUMAN_CAPITAL_MANAGEMENT_APPLICATION_ADMINISTRATOR_JOB, HRG_MANAGE_PERFORMANCE_GOAL_PRIV_OBI, ORA_EXM_EXPENSES_ADMINISTRATION_DUTY_OBI, ORA_ASM_FUNCTIONAL_SETUPS_USER_ABSTRACT, POQ_VIEW_SUPPLIER_QUALIFICATION_INITIATIVE_PRIV_OBI, ASM_SUBMIT_EXPORT_SETUP_DATA_PROCESS_PRIV_OBI, ORA_DOO_ORCHESTRATION_INFRASTRUCTURE_ADMINISTRATION_DUTY_OBI, IEX_RUN_AGING_7_BUCKET_PRIV_OBI, ORA_PER_WORKFORCE_STRUCTURES_MANAGEMENT_DUTY_OBI, OKC_SEARCH_CONTRACT_TERMS_TEMPLATE_PRIV_OBI, OKC_VIEW_CONTRACT_TEMPLATE_PRIV_OBI, ORA_FUN_FINANCIAL_APPLICATION_ADMINISTRATOR_JOB, CMS_MONITOR_TOTAL_COMPENSATION_STATEMENT_PROCESSES_PRIV_OBI, ORA_PER_MANAGE_USER_AND_ROLES_DUTY_OBI, ORA_PAY_ELEMENT_ENTRY_MANAGEMENT_DUTY_OBI, XLA_MANAGE_SUBLEDGER_APPLICATION_TRANSACTION_OBJECT_PRIV_OBI, ASM_SUBMIT_IMPORT_SETUP_DATA_PROCESS_PRIV_OBI, ORA_AR_RECEIVABLES_ADMINISTRATION_DUTY_OBI, HRA_MANAGE_PERFORMANCE_TEMPLATE_PRIV_OBI, ORA_MANAGE_TRADING_COMMUNITY_IMPORT_BATCH_DUTY_OBI, ORA_GMS_GRANTS_MANAGEMENT_ADMINISTRATION_DUTY_OBI, OKC_SPECIFY_PROCUREMENT_CONTRACT_MANAGEMENT_BUSINESS_FUNCTION_PROPERTIES_PRIV_OBI, XLA_UPDATE_SUBLEDGER_APPLICATION_PRIV_OBI, PJF_RUN_IMPORT_PROJECT_PROCESS_PRIV_OBI, ORA_CST_COST_MANAGEMENT_ADMINISTRATION_DUTY_OBI, ORA_OKC_CONTRACT_TERMS_LIBRARY_ADMINISTRATION_DUTY_OBI, ORA_GL_MANAGE_GENERAL_LEDGER_ACCOUNTING_PERIOD_STATUS_AGGR_OBI, ORA_MKT_MARKETING_BUDGET_MAINTENANCE_DUTY_OBI, XLA_MANAGE_SUBLEDGER_JOURNAL_ENTRY_RULE_SET_PRIV_OBI, ORA_PAY_FAST_FORMULA_MANAGEMENT_DUTY_OBI, OKC_VIEW_CONTRACT_TERMS_TEMPLATE_PRIV_OBI, FND_DIAG_ADVANCED_USER_DUTY_OBI, PJF_RUN_BUILD_NEW_ORGANIZATION_BURDEN_RATES_PROCESS_PRIV_OBI, ORA_MOT_QUOTA_EXPORT_MANAGEMENT_DUTY_OBI, ORA_PAY_PROCESS_AND_REPORT_SUBMISSION_DUTY_OBI, IEX_RUN_AGING_4_BUCKET_PRIV_OBI, XLA_MANAGE_SUBLEDGER_ACCOUNTING_EXISTING_SCOPE_PRIV_OBI, PO_VIEW_PURCHASE_ORDER_PRIV_OBI, PER_MANAGE_HCM_EXTRACT_DEFINITION_REPORT_PRIV_OBI, ORA_PAY_PAYROLL_IMPLEMENTATION_DUTY_OBI, XLA_PURGE_ACCOUNTING_EVENT_DIAGNOSTIC_DATA_PRIV_OBI, ORA_IBY_CUSTOMER_PAYMENT_INSTRUMENT_MANAGEMENT_DUTY_OBI, PJO_RUN_IMPORT_PROJECT_FORECASTS_PROCESS_PRIV_OBI, OKC_VIEW_CONTRACT_TERMS_TEMPLATE_BY_WEB_SERVICE_PRIV_OBI, XLA_MANAGE_SUBLEDGER_MAPPING_SET_PRIV_OBI, ORA_INV_INVENTORY_ADMINISTRATION_DUTY_OBI, GL_RUN_BALANCING_SEGMENT_VALUE_ASSIGNMENT_REPORT_PRIV_OBI, ORA_HZRESOURCE_ORGANIZATION_ADMINISTRATOR_DUTY_OBI, XLA_MANAGE_SUBLEDGER_ACCOUNT_RULE_PRIV_OBI, GL_CREATE_FINANCIAL_STATEMENT_REPORT_PRIV_OBI, ORA_ASM_APPLICATION_IMPLEMENTATION_ADMIN_ABSTRACT, ORA_WSH_CARRIER_MANAGEMENT_DUTY_OBI, ORA_ASM_APPLICATION_IMPLEMENTATION_CONSULTANT_JOB, ASM_REVIEW_APPLICATIONS_OFFERINGS_PRIV_OBI, ORA_AR_CUSTOMER_MAINTENANCE_DUTY_OBI, PER_MANAGE_PERSON_DOCUMENTATION_PRIV_OBI, ORA_ZCM_PARTNER_SALES_PARTY_MANAGEMENT_DUTY_OBI, ORA_ASM_SETUP_OBJECTS_PROVIDER_DUTY_OBI, ORA_ZX_TAX_ADMINISTRATION_DUTY_OBI, ORA_POZ_SUPPLIER_PROFILE_INQUIRY_DUTY_OBI, XLA_SUBMIT_ACCOUNTING_EVENT_DIAGNOSTIC_REPORT_PRIV_OBI, BICC_REST_EXTRACT_PRIV, ORA_MSP_ORDER_PROMISING_MANAGEMENT_DUTY_OBI, ASM_MANAGE_TASK_LISTS_PRIV_OBI, ORA_HRA_PERFORMANCE_MANAGEMENT_IMPLEMENTATION_DUTY_OBI, HZ_VIEW_TRADING_COMMUNITY_IMPORT_BATCH_ERRORS_AND_DETAILS_PRIV_OBI, XLA_MANAGE_SUBLEDGER_JOURNAL_LINE_RULE_PRIV_OBI, ORA_ZCM_SALES_PARTY_REVIEW_DUTY_OBI, ORA_PAY_PAYROLL_FLOW_SUBMISSION_DUTY_OBI, ORA_FND_DIAG_VIEWER_JOB, ORA_AP_PAYABLES_INVOICE_IMPORT_SUBMISSION_DUTY_OBI, FBI_ARCHIVED_HCM_APPROVAL_TASK_TRANSACTION_ANALYSIS_DUTY, CN_ADD_PLAN_DOCUMENT_TEMPLATE_PRIV_OBI, ORA_FND_APPLICATION_ADMINISTRATOR_JOB, ORA_PO_SETUP_DUTY_OBI, XLA_ACTIVATE_SUBLEDGER_JOURNAL_ENTRY_RULE_SET_ASSIGNMENT_PRIV_OBI, BIPDataModelDeveloper, ORA_MOT_TERRITORY_MANAGEMENT_SETUP_DUTY_OBI, PJT_RUN_TRANSFER_ABSENCE_RECORDS_TO_ORACLE_FUSION_PROJECT_EXECUTION_PROCESS_PRIV_OBI, IEX_SEND_COLLECTIONS_CORRESPONDENCE_PRIV_OBI, OKC_DEFINE_CONTRACT_LIBRARY_CLAUSE_PRIV_OBI, PJF_RUN_ACCOUNTING_PERIOD_PROCESSES_PRIV_OBI, PO_MANAGE_PROCUREMENT_CONFIGURATION_PRIV_OBI, ORA_IBY_PAYMENTS_DISBURSEMENT_ADMINISTRATION_DUTY_OBI, XLA_MANAGE_SUBLEDGER_SUPPORTING_REFERENCE_PRIV_OBI, BIAuthor, HRC_LOAD_HCM_DATA_CO_EXISTENCE_PRIV_OBI, XLA_CREATE_AND_ASSIGN_SUBLEDGER_STANDARD_SOURCE_PRIV_OBI, ORA_CE_CASH_MANAGEMENT_ADMINISTRATION_DUTY_OBI, ORA_SVC_SR_ADMINISTRATOR_OBI, ORA_PER_DEPARTMENT_MANAGEMENT_DUTY_OBI, GMS_RUN_IMPORT_AWARD_PROCESS_PRIV_OBI, AP_IMPORT_PAYABLES_INVOICE_PRIV_OBI, ORA_INV_INVENTORY_ABC_ANALYSIS_DUTY_OBI, CMS_GENERATE_TOTAL_COMPENSATION_STATEMENT_PRIV_OBI, PJR_RUN_IMPORT_PROJECT_RESOURCE_ASSIGNMENTS_PROCESS_PRIV_OBI, ORA_EGP_ITEM_MANAGEMENT_DUTY_OBI, GL_MANAGE_ACCOUNTING_PERIOD_STATUS_PRIV_OBI, ORA_MOT_QUOTA_MANAGEMENT_DUTY_OBI, ORA_PER_DIVISION_MANAGEMENT_DUTY_OBI, ORA_EGP_PRODUCT_MODEL_ADMINISTRATION_DUTY_OBI, PO_VERIFY_UPGRADED_STRUCTURE_PRIV_OBI
Kurt.
0