errror

This XML file does not appear to have any style information associated with it. The document tree is shown below. values for processing.. [2026-02-19T19:22:54.508+00:00][dp id:1331789722][sch info:]P_PAY_PERIOD->[Ljava.lang.Object;@5ad7c [2026-02-19T19:22:54.508+00:00][dp id:1331789722][sch info:]P_PAYBATCH->null [2026-02-19T19:22:54.508+00:00][dp id:1331789722][sch info:]P_MPA_STAT->null [2026-02-19T19:22:54.508+00:00][dp id:1331789722][sch info:]P_INC_TYPE->null [2026-02-19T19:22:54.508+00:00][dp id:1331789722][sch info:]p_badge->null [2026-02-19T19:22:54.508+00:00][dp id:1331789722][sch info:]XDO_USER_NAME->1437297 [2026-02-19T19:22:54.508+00:00][dp id:1331789722][sch info:]XDO_USER_ROLES->BI_ZPM_REPORTING_DUTY, BI_COMMON_CONTENT_REPORTING_DUTY, ASM_REVIEW_APPLICATIONS_OFFERINGS_PRIV_OBI, DELL_CDM_SETUP_JR, ASM_MANAGE_IMPLEMENTATION_PROJECT_PRIV_OBI, AR_GENERATE_CUSTOMER_STATEMENTS_PRIV_OBI, CN_ACCEPT_INCENTIVE_COMPENSATION_PLAN_DOCUMENT_PRIV_OBI, ORA_ZCM_PARTNER_SALES_PARTY_MANAGEMENT_DUTY_OBI, AR_RUN_OPEN_ITEMS_REVALUATION_REPORT_PRIV_OBI, BIA_ADMINISTRATOR_DUTY, AR_MATURE_AND_ELIMINATE_RISK_ON_RECEIVABLES_BILL_RECEIVABLE_PRIV_OBI, ORA_PER_WORKER_LOCATION_CHANGE_DUTY_OBI, ORA_AR_ACCOUNT_RECEIVABLE_SETUP_MAINTENANCE_DUTY_OBI, ORA_GL_ACCOUNTS_RECEIVABLE_PERIOD_STATUS_MANAGEMENT_DUTY_OBI, PER_MANAGE_PERSON_DOCUMENTATION_PRIV_OBI, OKC_RUN_CONTRACT_PDF_GENERATION_PRIV_OBI, AR_CREATE_RECEIVABLES_BILLS_RECEIVABLE_BATCH_PRIV_OBI, ORA_IBY_CUSTOMER_PAYMENT_INSTRUMENT_MANAGEMENT_DUTY_OBI, DELL_ICM_INQUIRY_JR, PER_MANAGE_PERSON_DISABILITY_BY_WORKER_PRIV_OBI, IBY_CREATE_SETTLEMENT_BATCH_PRIV_OBI, ORA_PER_DIRECT_REPORTS_MANAGEMENT_DUTY_OBI, AR_RUN_REVERSAL_STATUS_REPORT_PRIV_OBI, BI_SVC_REPORTING_DUTY, ORA_HZRESOURCE_ADMINISTRATOR_DUTY_OBI, DELL_ICM_SETUP_JR, BIA_HELP_PRIV, AR_MANAGE_RECEIVABLES_AUTOMATIC_RECEIPT_BATCH_PRIV_OBI, ORA_ASM_SETUP_OBJECTS_PROVIDER_DUTY_OBI, ORA_PER_MANAGE_USER_AND_ROLES_DUTY_OBI, OKC_VIEW_CONTRACT_PRIV_OBI, BI_CDM_REPORTING_DUTY, BI_PRJ_REPORTING_DUTY, BI_EXT_REPORTING_DUTY, BIAdministrator, XLA_PURGE_ACCOUNTING_EVENT_DIAGNOSTIC_DATA_PRIV_OBI, ORA_PER_WORKER_INFORMATION_SHARING_DUTY_OBI, ORA_ASM_FUNCTIONAL_SETUPS_USER_ABSTRACT, FBI_VACANCY_TRANSACTION_ANALYSIS_DUTY, ORA_MANAGE_TRADING_COMMUNITY_IMPORT_PROCESS_DUTY_OBI, AR_RUN_RECEIVABLES_AGING_REPORT_PRIV_OBI, ORA_PER_MANAGE_PERSON_DISABILITY_BY_WORKER_OBI, BIA_CONFIGURE_EXTERNAL_STORAGE_PRIV, BI_GRC_REPORTING_DUTY, DELL_ICM_PARTICIPANT_JR, GL_MANAGE_ACCOUNTING_PERIOD_STATUS_PRIV_OBI, ORA_CMP_LINE_MANAGER_WORKFORCE_COMPENSATION_MANAGEMENT_DUTY_OBI, ORA_OSS_SUBSCRIPTION_SEARCH_VIEW_DUTY_OBI, FBI_RECEIVABLES_TRANSACTION_ANALYSIS_DUTY, DELL_TL_PERSONA_TALENT_ACQUISITION_GLOBAL_JR, FBI_RECEIVABLES_TO_LEDGER_RECONCILIATION_TRANSACTION_ANALYSIS_DUTY, FBI_INCENTIVE_COMPENSATION_ADMIN_RATE_TRANSACTION_ANALYSIS_DUTY, CSE_EXPORT_ASSET_DETAILS_PRIV_OBI, AR_RUN_BAD_DEBTS_PROVISION_REPORT_PRIV_OBI, FBI_WORKFORCE_MODELING_TRANSACTION_ANALYSIS_DUTY, ORA_ASM_FUNCTIONAL_SETUPS_DUTY_OBI, ORA_ZCM_SETUP_CUSTOMER_CENTER_DUTY_OBI, JE_RUN_GLOBAL_THIRD_PARTY_ACCOUNT_BALANCE_REPORT_PRIV_OBI, BI_PRC_REPORTING_DUTY, FBI_SERVICE_ADMINISTRATIVE_TRANSACTION_ANALYSIS_DUTY, ORA_MOT_TERRITORY_MANAGEMENT_EXPORT_IMPORT_DUTY_OBI, ORA_MOT_TERRITORY_MANAGEMENT_DUTY_OBI, IRC_VIEW_JOB_OFFER_PRIV_OBI, FBI_RECEIVABLES_REVENUE_ADJUSTMENTS_TRANSACTION_ANALYSIS_DUTY, ORA_CN_INCENTIVE_COMPENSATION_CREDITS_EARNINGS_MANAGEMENT_DUTY_OBI, DELL_TL_HR_INQUIRY_NON_SEN_-_GLOBAL_DATA, DELL_BI_ADMINISTRATOR_JR, DELL_TL_COMP_INQUIRY_LTD_-_GLOBAL_DATA, ORA_CSE_MANAGE_CUSTOMER_ASSETS_DUTY_OBI, ORA_IRC_VIEW_CANDIDATE_JOB_APPLICATION_OBI, BI_FIN_REPORTING_DUTY, EGP_MANAGE_ITEM_CATALOG_PRIV_OBI, DELL_TL_HR_INQUIRY_NON_SENSITIVE_JR, ORA_AR_RECEIVABLE_INQUIRY_DUTY_OBI, AR_SUBMIT_BPA_BALANCE_FORWARD_BILL_PRINT_PROCESS_PRIV_OBI, XLA_POST_SUBLEDGER_JOURNAL_ENTRY_TO_GENERAL_LEDGER_PRIV_OBI, ORA_MANAGE_TRADING_COMMUNITY_IMPORT_BATCH_DUTY_OBI, CN_INCENTIVE_COMPENSATION_PARTICIPANT_ABSTRACT_CUSTOM, JE_RUN_GLOBAL_SUBLEDGER_DETAIL_JOURNAL_REPORT_PRIV_OBI, FBI_WORKFORCE_PROFILE_TRANSACTION_ANALYSIS_DUTY, DELL_TL_REC_TRANSACTIONS_JR, PER_PRINT_WORKER_PORTRAIT_PRIV_OBI, ORA_FUN_FSCM_LOAD_INTERFACE_ADMIN_DUTY_OBI, DELL_ICM_REPORTING_SHELL_DR, FBI_GOAL_MANAGEMENT_TRANSACTION_ANALYSIS_DUTY, ORA_PER_PERSON_VIEW_DUTY_OBI, AR_SUBMIT_AUTOMATIC_BILLING_ADJUSTMENTS_PRIV_OBI, AR_SUBMIT_AUTOMATIC_CLEARING_FOR_RECEIPTS_PROCESS_PRIV_OBI, ORA_AR_BILLS_RECEIVABLE_MANAGEMENT_DUTY_OBI, ORA_OSS_SUBSCRIPTION_AUTHORING_DUTY_OBI, BI_HED_REPORTING_DUTY, BI_MFG_REPORTING_DUTY, IRC_VIEW_CANDIDATE_JOB_APPLICATION_PRIV_OBI, ORA_AR_PAYMENT_MANAGEMENT_DUTY_OBI, ORA_SVC_SR_ADMINISTRATOR_OBI, AR_SUBMIT_RECEIVABLES_AUTOMATIC_RECEIPT_CREATION_PROCESS_PRIV_OBI, AR_RUN_REVENUE_RECOGNITION_PRIV_OBI, DELL_TL_COMP_ALL_SUBJECT_AREAS_DR, FBI_WORKFORCE_TRANSACTION_ANALYSIS_DUTY, AR_CREATE_RECEIVABLES_AUTOMATIC_RECEIPT_BATCH_PRIV_OBI, DELL_TL_DOR_ADD_TA_-_GLOBAL_DATA, HRT_RUN_TALENT_PROFILE_SUMMARY_REPORT_PRIV_OBI, AR_RUN_POTENTIAL_RECONCILING_ITEMS_REPORT_PRIV_OBI, AR_IMPORT_RECEIVABLES_RECEIPT_THROUGH_LOCKBOX_PRIV_OBI, AR_RUN_RECEIPT_ANALYSIS_DAYS_LATE_PRIV_OBI, DELL_TL_COMP_INQUIRY_LIMITED_JR, ORA_MKT_MARKETING_BUDGET_MAINTENANCE_DUTY_OBI, ORA_EGP_ITEM_INQUIRY_DUTY_OBI, ASM_MANAGE_TASK_LISTS_PRIV_OBI, IRC_PERFORM_CANDIDATE_DUPLICATE_CHECK_AND_MERGE_PRIV_OBI, ORA_MOT_QUOTA_MANAGEMENT_EXPORT_IMPORT_DUTY_OBI, AR_RUN_RECEIPTS_AWAITING_BANK_CLEARANCE_REPORT_PRIV_OBI, ORA_AR_ACCOUNTS_RECEIVABLE_MONITORING_DUTY_OBI, IRC_VIEW_JOB_REQUISITION_PRIV_OBI, BIA_OVERVIEW_PRIV, XLA_SUBMIT_JOURNAL_ENTRIES_REPORT_PRIV_OBI, DELL_PRM_SETUP_JR, AR_SET_UP_RECEIVABLES_RECEIPT_CLASS_PRIV_OBI, DELL_TL_SS_EMPLOYEE_JR, CMP_GENERATE_COMPENSATION_ALLOCATION_STATEMENTS_BY_LINE_MANAGER_PRIV_OBI, AR_RUN_LATE_CHARGES_REPORT_PRIV_OBI, FBI_RECRUITING_SETUP_TRANSACTION_ANALYSIS_DUTY, JE_RUN_GLOBAL_THIRD_PARTY_BALANCES_SUMMARY_REPORT_PRIV_OBI, DELL_ICM_SENSITIVE_REPORTING_JR, CN_CUSTOMIZE_INCENTIVE_COMPENSATION_PARTICIPANT_COMPENSATION_PLAN_PRIV_OBI, AR_SUBMIT_BPA_TRANSACTION_PRINT_PROCESS_PRIV_OBI, FBI_COMPENSATION_TRANSACTION_ANALYSIS_DUTY, XLA_TRANSFER_ONLINE_JOURNAL_ENTRY_TO_GENERAL_LEDGER_PRIV_OBI, AR_SUBMIT_AUTOINVOICE_IMPORT_PROCESS_PRIV_OBI, DELL_ICM_REPORTING_JR, IBY_SUBMIT_OFFLINE_TRANSACTIONS_PRIV_OBI, AR_RUN_ACCOUNT_STATUS_REPORT_PRIV_OBI, FBI_TRANSACTION_ANALYSIS_GENERIC_DUTY, AR_CREATE_RECEIVABLES_BILLS_RECEIVABLE_REMITTANCE_BATCH_PRIV_OBI, ORA_HRT_WORKFORCE_PROFILE_ADMINISTRATION_DUTY_OBI, AR_GENERATE_XML_INVOICES_PRIV_OBI, DELL_ITAA_SUBSCRIPTION_SPECIALIST, DELL_ICM_ANALYST_JR, XLA_SUBMIT_ACCOUNT_ANALYSIS_REPORT_PRIV_OBI, AR_SUBMIT_PRINT_ADJUSTMENTS_PROCESS_PRIV_OBI, DELL_ICM_QUOTA_IMPORT_JR, IBY_SUBMIT_RECEIPT_OF_PAYMENT_NOTIFICATIONS_PRIV_OBI, HZ_VIEW_TRADING_COMMUNITY_IMPORT_BATCH_ERRORS_AND_DETAILS_PRIV_OBI, WLF_PRINT_COMPLETION_CERTIFICATE_PRIV_OBI, ORA_IBY_PAYMENT_SETTLEMENT_MANAGEMENT_DUTY_OBI, ORA_EGP_ITEM_MANAGEMENT_DUTY_OBI, ORA_AR_ACCOUNTS_RECEIVABLE_MANAGER_JOB, DELL_COMMON_LOOKUP_JR, IRC_MANAGE_CANDIDATE_POOL_PRIV_OBI, DELL_BI_PUBLISHER_DATA_MODELS_JR, BI_ZBS_REPORTING_DUTY, ORA_PER_WORKER_DOCUMENT_MANAGEMENT_DUTY_OBI, BICC_REST_EXTRACT_PRIV, DELL_BI_AUTHOR_JR, DELL_TL_DOR_VIEW_TA_-_GLOBAL_DATA, ORA_CN_INCENTIVE_COMPENSATION_ASSIGNMENT_ADMISTRATION_DUTY_OBI, CN_APPROVE_AND_MONITOR_INCENTIVE_COMPENSATION_PLAN_DOCUMENTS_PRIV_OBI, ORA_HZRESOURCE_TEAM_ADMINISTRATOR_DUTY_OBI, DELL_TL_HR_MANAGE_DOR_JR, FBI_SUBSCRIPTION_TRANSACTION_ANALYSIS_DUTY, ORA_XLA_SUBLEDGER_ACCOUNTING_MANAGER_DUTY_OBI, HRA_PRINT_PERFORMANCE_DOCUMENT_PRIV_OBI, DELL_ICM_COMPENSATION_MANAGER_JR, AR_CREATE_RECEIVABLES_RECEIPT_REMITTANCE_BATCH_PRIV_OBI, DELL_ICM_PARTICIPANT_MANAGER_JR, XLA_SUBMIT_ACCOUNTING_EVENT_DIAGNOSTIC_REPORT_PRIV_OBI, BIConsumer, ORA_ZCM_SALES_PARTY_MANAGEMENT_DUTY_OBI, XLA_SUBMIT_THIRD_PARTY_BALANCES_REPORT_PRIV_OBI, DELL_BI_CONSUMER_JR, ORA_CN_INCENTIVE_COMPENSATION_PARTICIPANT_PLAN_MANAGEMENT_DUTY_OBI, IBY_PERFORM_ALL_FC_ACTIONS_PRIV_OBI, ORA_MKT_MARKETING_MAINTENANCE_DUTY_OBI, FBI_SCHEDULING_TRANSACTION_ANALYSIS_DUTY, DELL_TL_REC_ALL_SUBJECT_AREAS_DR, ORA_PER_USER_ROLE_MANAGEMENT_DUTY_OBI, FBI_INCENTIVE_COMPENSATION_PARTICIPANT_RATE_TRANSACTION_ANALYSIS_DUTY, ORA_IRC_MANAGE_CANDIDATE_POOL_OBI, AR_RUN_TRANSACTION_DETAIL_REPORT_PRIV_OBI, AR_RUN_DOCUMENT_NUMBER_AUDIT_REPORT_PRIV_OBI, ORA_PER_WORKER_WORK_TERMS_AND_ASSIGNMENT_VIEW_DUTY_OBI, FBI_INCENTIVE_COMPENSATION_TRANSACTION_ANALYSIS_DUTY, HRX_UPDATE_US_W4_PRIV_OBI, FBI_RECRUITING_SOURCING_TRANSACTION_ ANALYSIS_DUTY, XLA_CREATE_SUBLEDGER_JOURNAL_ENTRY_ONLINE_PRIV_OBI, ORA_MOT_TERRITORY_MANAGEMENT_SETUP_DUTY_OBI, BI_MKT_REPORTING_DUTY, ORA_CN_INCENTIVES_ADMINISTRATION_DUTY_OBI, ORA_PER_CONTINGENT_WORKER_ADDITION_DUTY_OBI, BIPDataModelDeveloper, BI_OSS_REPORTING_DUTY, AP_IMPORT_PAYABLES_INVOICE_PRIV_OBI, AR_SUBMIT_RECEIVABLES_RECEIPT_REMITTANCE_BATCH_PROCESS_PRIV_OBI, DELL_ICM_PLAN_ADMINISTRATOR_JR, AR_RUN_RECEIPTS_AWAITING_REMITTANCE_REPORT_PRIV_OBI, ORA_IRC_UPDATE_CANDIDATE_JOB_APPLICATION_OBI, ORA_ZCM_SALES_PARTY_REVIEW_DUTY_OBI, ORA_MKL_LEAD_REGISTRATION_SUBMISSION_DUTY_OBI, ORA_PER_DOCUMENT_MANAGEMENT_DUTY_OBI, ORA_AR_CUSTOMER_MAINTENANCE_DUTY_OBI, XLA_CREATE_SUBLEDGER_MULTIPERIOD_AND_ACCRUAL_REVERSAL_ENTRY_PRIV_OBI, ORA_MOT_TERRITORY_MANAGEMENT_T2P_MIGRATION_DUTY_OBI, AR_RUN_RECEIVABLES_TO_GENERAL_LEDGER_RECONCILIATION_REPORT_PRIV_OBI, AR_PRINT_RECEIVABLES_BILL_RECEIVABLE_PRIV_OBI, BI_HCM_REPORTING_DUTY, BIA_MANAGE_SCHEDULE_PRIV, FBI_RECEIVABLES_RECEIPTS_TRANSACTION_ANALYSIS_DUTY, BI_LOY_REPORTING_DUTY, AR_PREVIEW_RECEIVABLES_INVOICE_PRIV_OBI, ORA_AR_BILLING_MANAGEMENT_DUTY_OBI, FBI_SUBLEDGER_ACCOUNTING_TRANSACTION_ANALYSIS_DUTY, ORA_IRC_VIEW_JOB_OFFER_OBI, FBI_PERFORMANCE_MANAGEMENT_TRANSACTION_ANALYSIS_DUTY, DELL_IT_APPLICATION_ADMINISTRATOR_JR, ORA_MOT_QUOTA_EXPORT_MANAGEMENT_DUTY_OBI, AR_RUN_INVOICES_POSTED_TO_SUSPENSE_REPORT_PRIV_OBI, ORA_IRC_VIEW_JOB_REQUISITION_OBI, PO_VIEW_PURCHASE_ORDER_PRIV_OBI, BI_PSC_REPORTING_DUTY, ORA_MOT_QUOTA_MANAGEMENT_SETUP_DUTY_OBI, ORA_PER_WORKER_GALLERY_SEARCH_DUTY_OBI, ORA_PON_NEGOTIATION_VIEWING_DUTY_OBI, BIA_CONFIGURE_CLOUD_EXTRACT_PRIV, ORA_IRC_VIEW_NON_RESTRICTED_CANDIDATE_JOB_APPLICATION_OBI, OKC_VIEW_CONTRACT_TERMS_AND_CONDITIONS_PRIV_OBI, ORA_MOT_QUOTA_MANAGEMENT_DUTY_OBI, ORA_OKC_ALL_BUSINESS_UNITS_CONTRACT_INQUIRY_DUTY_OBI, HRG_MANAGE_PERFORMANCE_GOAL_PRIV_OBI, DELL_TL_REC_TRANSACTIONS_-_GLOBAL_DATA, ORA_PER_PORTRAIT_MAINTENANCE_DUTY_OBI, ORA_GEO_ADMIN_DUTY_OBI, IBY_SUBMIT_SETTLEMENT_BATCH_ACCOMPANYING_LETTER_PRIV_OBI, AR_SUBMIT_AUTOMATIC_RECEIPT_REVERSAL_PROCESS_PRIV_OBI, PO_VIEW_PURCHASE_AGREEMENT_PRIV_OBI, DELL_ICM_ADMINISTRATOR_JR, DELL_TL_SS_MANAGER_JR, DELL_TL_HR_NON_SENSITIVE_RUN_BI_CUSTOM_REPORTS_DR, IRC_ACCESS_INTERNAL_CANDIDATE_EXPERIENCE_PRIV_OBI, JE_RUN_GLOBAL_THIRD_PARTY_DETAIL_AND_BALANCES_REPORT_PRIV_OBI, AR_DISPUTE_RECEIVABLES_TRANSACTION_PRIV_OBI, AR_RUN_BANK_RISK_REPORT_PRIV_OBI, ORA_OSS_SUBSCRIPTION_AMENDMENT_DUTY_OBI, DELL_ICM_SENSITIVE_REPORTING_SHELL_DR, ORA_PAY_PERSONAL_PAY_METHOD_MANAGEMENT_DUTY_OBI, AR_RUN_PROJECTED_GAINS_AND_LOSSES_REPORT_PRIV_OBI, BEN_REVIEW_BENEFIT_PARTICIPANT_ENROLLMENT_RESULT_PRIV_OBI, DELL_TL_HR_ALL_SUBJECT_AREAS_DR, DELL_ITAA_CUSTOMER_RELATIONSHIP_MANAGEMENT_APPLICATION_ADMINISTRATOR_CUSTOM_JR, FBI_COMPENSATION_MARKET_DATA_TRANSACTION_ANALYSIS_DUTY, ORA_HRG_GOAL_MGT_LINE_MANAGER_DUTY_OBI, FBI_RECRUITING_TRANSACTION_ANALYSIS_DUTY, AR_RUN_RECEIPT_WRITE_OFF_REPORT_PRIV_OBI, BI_SCM_REPORTING_DUTY, BI_OKC_REPORTING_DUTY, XLA_REVIEW_SUBLEDGER_JOURNAL_ENTRY_PRIV_OBI, FBI_RECEIVABLES_CUSTOMER_ANALYSIS_DUTY, DELL_TL_HR_VIEW_DOR_JR, DELL_TL_COMP_RUN_BI_CUSTOM_REPORTS_DR, XLA_SUBMIT_SUBLEDGER_PERIOD_CLOSE_EXCEPTIONS_REPORT_PRIV_OBI, FBI_AVAILABILITY_PATTERNS_TRANSACTION_ANALYSIS_DUTY, PON_VIEW_SUPPLIER_NEGOTIATION_PRIV_OBI, AR_RUN_CUSTOMER_BALANCE_REVALUATION_REPORT_PRIV_OBI, ORA_HZRESOURCE_ORGANIZATION_ADMINISTRATOR_DUTY_OBI, AR_RUN_OPEN_BALANCES_REVALUATION_REPORT_PRIV_OBI, XLA_CREATE_SUBLEDGER_JOURNAL_ENTRY_BATCH_PRIV_OBI, AR_RUN_BILLING_HISTORY_REPORT_PRIV_OBI, BI_IC_REPORTING_DUTY, BIAuthor, DELL_TL_REC_RUN_BI_CUSTOM_REPORTS_DR, JE_RUN_GLOBAL_JOURNALS_AND_THIRD_PARTY_REPORT_PRIV_OBI, CN_ADD_PLAN_DOCUMENT_TEMPLATE_PRIV_OBI, CUSTOM_BI_WEBCAT_REPORTING_DUTY [2026-02-19T19:22:54.508+00:00][dp id:1331789722][sch info:]XDO_USER_UI_LOCALE->en [2026-02-19T19:22:54.508+00:00][dp id:1331789722][sch info:]XDO_USER_UI_ORACLE_LANG->US [2026-02-19T19:22:54.508+00:00][dp id:1331789722][sch info:]XDO_USER_REPORT_LOCALE->en_US [2026-02-19T19:22:54.508+00:00][dp id:1331789722][sch info:]XDO_USER_REPORT_ORACLE_LANG->US [2026-02-19T19:22:54.508+00:00][dp id:1331789722][sch info:]XDO_DASHBOARD_EXPR->null [2026-02-19T19:22:54.508+00:00][dp id:1331789722][sch info:]FUSION_SECURITY_ENABLED->true [2026-02-19T19:22:54.508+00:00][dp id:1331789722][sch info:]FUSION_ESS_APPLSESSION_ID-> [2026-02-19T19:22:54.508+00:00][dp id:1331789722][sch info:]XDO_DM_OUTPUT_FORMAT->xml [2026-02-19T19:22:54.508+00:00][dp id:1331789722][sch info:]XDO_USER_TIMEZONE->America/New_York [2026-02-19T19:22:54.508+00:00][dp id:1331789722][sch info:]TimeZone Details: User Preference time zone selected:sun.util.calendar.ZoneInfo[id="America/New_York",offset=-18000000,dstSavings=3600000,useDaylight=true,transitions=361,lastRule=java.util.SimpleTimeZone[id=America/New_York,offset=-18000000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=3,startMonth=2,startDay=8,startDayOfWeek=1,startTime=7200000,startTimeMode=0,endMode=3,endMonth=10,endDay=1,endDayOfWeek=1,endTime=7200000,endTimeMode=0]] Java SimpleDateFormat with no timezone set:2026-02-19 07:22:54.033+000019 JVM Java.Util.Timezone:sun.util.calendar.ZoneInfo[id="UTC",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null] Java SimpleDateFormat with JVM timezone:2026-02-19 07:22:54.033+000019 FND Cononical Date Format with JVM timezone:2026-02-19T19:22:54.508+00:00 [2026-02-19T19:22:54.508+00:00][dp id:1331789722][sch info:]Writing Data ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Number of queries :2 [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Returning Final Query from QueryParser: SELECT record_number || '-' || 'MC' AS RecordNumber, record_number || '-' || 'MC' AS RecordName, EXTN_ATTRIBUTE_CHAR039 AS Paysheet_ID, 'Auto Approved' AS MPA_Status, EXTN_ATTRIBUTE_CHAR004 AS PlanComponentId_c, 'N' AS Recoverable_c, CURRENCY_CODE AS HomeCurrencyCode_c, EXTN_ATTRIBUTE_NUMBER037 AS AmountInLocalCurrency_c, EXTN_ATTRIBUTE_CHAR022 AS IncentiveTypeCode_c, EXTN_ATTRIBUTE_CHAR002 AS Badge_Id, EXTN_ATTRIBUTE_NUMBER001 AS PeriodId_c, EXTN_ATTRIBUTE_CHAR005 AS ParticipantPayId_c, EXTN_ATTRIBUTE_CHAR043 AS ParticipantPayIdMC, OWNER_RESOURCE_ID OraZcxOwner_Id_c, EXTN_ATTRIBUTE_NUMBER002 AS CreditedParticipantId_c, EXTN_ATTRIBUTE_CHAR001 AS PayrunId_c, ID AS RECORD_ID, (SELECT bu_id FROM fun_all_business_units_v WHERE bu_name = 'ICM_DIRECT_INCTV') AS OrgId_c, 'MAV_DIR_MPA_CODE_1012' AS ReasonCodeLOV_c, EXTN_ATTRIBUTE_CHAR011 AS PaymentBatch_c, EXTN_ATTRIBUTE_CHAR029 AS MPAStatus_c FROM SVC_REF_ENTITIES zre WHERE zre.ATTRIBUTE_CATEGORY = 'MTQ_ICM_PPH_OBJ_c' AND NVL(zre.EXTN_ATTRIBUTE_NUMBER037, 0) <> 0 AND (zre.EXTN_ATTRIBUTE_CHAR002 IN (:p_badge) OR 'ALL' IN (SELECT NVL(MAX(:p_badge),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR022 IN (:P_INC_TYPE) OR 'ALL' IN (SELECT NVL(MAX(:P_INC_TYPE),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_NUMBER001 IN (:P_PAY_PERIOD) OR 'ALL' IN (SELECT NVL(MAX(:P_PAY_PERIOD),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR029 IN (:P_MPA_STAT) OR 'ALL' IN (SELECT NVL(MAX(:P_MPA_STAT),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR011 IN (:P_PAYBATCH) OR 'ALL' IN (SELECT NVL(MAX(:P_PAYBATCH),'ALL') FROM DUAL)) UNION ALL SELECT record_number || '-' || 'MPA' AS RecordNumber, record_number || '-' || 'MPA' AS RecordName, EXTN_ATTRIBUTE_CHAR039 AS Paysheet_ID, EXTN_ATTRIBUTE_CHAR029 AS MPA_Status, EXTN_ATTRIBUTE_CHAR004 AS PlanComponentId_c, EXTN_ATTRIBUTE_CHAR013 AS Recoverable_c, CURRENCY_CODE AS HomeCurrencyCode_c, NVL(EXTN_ATTRIBUTE_NUMBER023, 0) AS AmountInLocalCurrency_c, EXTN_ATTRIBUTE_CHAR022 AS IncentiveTypeCode_c, EXTN_ATTRIBUTE_CHAR002 AS Badge_Id, EXTN_ATTRIBUTE_NUMBER001 AS PeriodId_c, EXTN_ATTRIBUTE_CHAR005 AS ParticipantPayId_c, EXTN_ATTRIBUTE_CHAR043 AS ParticipantPayIdMC, OWNER_RESOURCE_ID OraZcxOwner_Id_c, EXTN_ATTRIBUTE_NUMBER002 AS CreditedParticipantId_c, EXTN_ATTRIBUTE_CHAR001 AS PayrunId_c, ID AS RECORD_ID, (SELECT bu_id FROM fun_all_business_units_v WHERE bu_name = 'ICM_DIRECT_INCTV') AS OrgId_c, EXTN_ATTRIBUTE_CHAR023 AS ReasonCodeLOV_c, EXTN_ATTRIBUTE_CHAR011 AS PaymentBatch_c, EXTN_ATTRIBUTE_CHAR029 AS MPAStatus_c FROM SVC_REF_ENTITIES zre WHERE zre.ATTRIBUTE_CATEGORY = 'MTQ_ICM_PPH_OBJ_c' AND NVL(zre.EXTN_ATTRIBUTE_NUMBER023, 0) <> 0 AND (zre.EXTN_ATTRIBUTE_CHAR002 IN (:p_badge) OR 'ALL' IN (SELECT NVL(MAX(:p_badge),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR022 IN (:P_INC_TYPE) OR 'ALL' IN (SELECT NVL(MAX(:P_INC_TYPE),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_NUMBER001 IN (:P_PAY_PERIOD) OR 'ALL' IN (SELECT NVL(MAX(:P_PAY_PERIOD),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR029 IN (:P_MPA_STAT) OR 'ALL' IN (SELECT NVL(MAX(:P_MPA_STAT),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR011 IN (:P_PAYBATCH) OR 'ALL' IN (SELECT NVL(MAX(:P_PAYBATCH),'ALL') FROM DUAL)) [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]DataSet Name:newquery: Type:sqlQuery: Data Source:ApplicationDB_CRM [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]DataSet Name:newquery: Driver Type:1 [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]DataSet Name:newquery: DB Fetch Size:1000 [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]DataSet Name:newquery: SQL Query Timeout:500 [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]DataSet Name:newquery: SQL Query:newquery: SELECT record_number || '-' || 'MC' AS RecordNumber, record_number || '-' || 'MC' AS RecordName, EXTN_ATTRIBUTE_CHAR039 AS Paysheet_ID, 'Auto Approved' AS MPA_Status, EXTN_ATTRIBUTE_CHAR004 AS PlanComponentId_c, 'N' AS Recoverable_c, CURRENCY_CODE AS HomeCurrencyCode_c, EXTN_ATTRIBUTE_NUMBER037 AS AmountInLocalCurrency_c, EXTN_ATTRIBUTE_CHAR022 AS IncentiveTypeCode_c, EXTN_ATTRIBUTE_CHAR002 AS Badge_Id, EXTN_ATTRIBUTE_NUMBER001 AS PeriodId_c, EXTN_ATTRIBUTE_CHAR005 AS ParticipantPayId_c, EXTN_ATTRIBUTE_CHAR043 AS ParticipantPayIdMC, OWNER_RESOURCE_ID OraZcxOwner_Id_c, EXTN_ATTRIBUTE_NUMBER002 AS CreditedParticipantId_c, EXTN_ATTRIBUTE_CHAR001 AS PayrunId_c, ID AS RECORD_ID, (SELECT bu_id FROM fun_all_business_units_v WHERE bu_name = 'ICM_DIRECT_INCTV') AS OrgId_c, 'MAV_DIR_MPA_CODE_1012' AS ReasonCodeLOV_c, EXTN_ATTRIBUTE_CHAR011 AS PaymentBatch_c, EXTN_ATTRIBUTE_CHAR029 AS MPAStatus_c FROM SVC_REF_ENTITIES zre WHERE zre.ATTRIBUTE_CATEGORY = 'MTQ_ICM_PPH_OBJ_c' AND NVL(zre.EXTN_ATTRIBUTE_NUMBER037, 0) <> 0 AND (zre.EXTN_ATTRIBUTE_CHAR002 IN (:p_badge) OR 'ALL' IN (SELECT NVL(MAX(:p_badge),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR022 IN (:P_INC_TYPE) OR 'ALL' IN (SELECT NVL(MAX(:P_INC_TYPE),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_NUMBER001 IN (:P_PAY_PERIOD1_0,:P_PAY_PERIOD1_1) OR 'ALL' IN (SELECT NVL(MAX(:P_PAY_PERIOD2_0,:P_PAY_PERIOD2_1),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR029 IN (:P_MPA_STAT) OR 'ALL' IN (SELECT NVL(MAX(:P_MPA_STAT),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR011 IN (:P_PAYBATCH) OR 'ALL' IN (SELECT NVL(MAX(:P_PAYBATCH),'ALL') FROM DUAL)) UNION ALL SELECT record_number || '-' || 'MPA' AS RecordNumber, record_number || '-' || 'MPA' AS RecordName, EXTN_ATTRIBUTE_CHAR039 AS Paysheet_ID, EXTN_ATTRIBUTE_CHAR029 AS MPA_Status, EXTN_ATTRIBUTE_CHAR004 AS PlanComponentId_c, EXTN_ATTRIBUTE_CHAR013 AS Recoverable_c, CURRENCY_CODE AS HomeCurrencyCode_c, NVL(EXTN_ATTRIBUTE_NUMBER023, 0) AS AmountInLocalCurrency_c, EXTN_ATTRIBUTE_CHAR022 AS IncentiveTypeCode_c, EXTN_ATTRIBUTE_CHAR002 AS Badge_Id, EXTN_ATTRIBUTE_NUMBER001 AS PeriodId_c, EXTN_ATTRIBUTE_CHAR005 AS ParticipantPayId_c, EXTN_ATTRIBUTE_CHAR043 AS ParticipantPayIdMC, OWNER_RESOURCE_ID OraZcxOwner_Id_c, EXTN_ATTRIBUTE_NUMBER002 AS CreditedParticipantId_c, EXTN_ATTRIBUTE_CHAR001 AS PayrunId_c, ID AS RECORD_ID, (SELECT bu_id FROM fun_all_business_units_v WHERE bu_name = 'ICM_DIRECT_INCTV') AS OrgId_c, EXTN_ATTRIBUTE_CHAR023 AS ReasonCodeLOV_c, EXTN_ATTRIBUTE_CHAR011 AS PaymentBatch_c, EXTN_ATTRIBUTE_CHAR029 AS MPAStatus_c FROM SVC_REF_ENTITIES zre WHERE zre.ATTRIBUTE_CATEGORY = 'MTQ_ICM_PPH_OBJ_c' AND NVL(zre.EXTN_ATTRIBUTE_NUMBER023, 0) <> 0 AND (zre.EXTN_ATTRIBUTE_CHAR002 IN (:p_badge) OR 'ALL' IN (SELECT NVL(MAX(:p_badge),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR022 IN (:P_INC_TYPE) OR 'ALL' IN (SELECT NVL(MAX(:P_INC_TYPE),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_NUMBER001 IN (:P_PAY_PERIOD3_0,:P_PAY_PERIOD3_1) OR 'ALL' IN (SELECT NVL(MAX(:P_PAY_PERIOD4_0,:P_PAY_PERIOD4_1),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR029 IN (:P_MPA_STAT) OR 'ALL' IN (SELECT NVL(MAX(:P_MPA_STAT),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR011 IN (:P_PAYBATCH) OR 'ALL' IN (SELECT NVL(MAX(:P_PAYBATCH),'ALL') FROM DUAL)) [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 1: p_badge:null [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 2: p_badge:null [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 3: P_INC_TYPE:null [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 4: P_INC_TYPE:null [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 5: P_PAY_PERIOD1_0:2026010 [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 6: P_PAY_PERIOD1_1:2026008 [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 7: P_PAY_PERIOD2_0:2026010 [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 8: P_PAY_PERIOD2_1:2026008 [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 9: P_MPA_STAT:null [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 10: P_MPA_STAT:null [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 11: P_PAYBATCH:null [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 12: P_PAYBATCH:null [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 13: p_badge:null [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 14: p_badge:null [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 15: P_INC_TYPE:null [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 16: P_INC_TYPE:null [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 17: P_PAY_PERIOD3_0:2026010 [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 18: P_PAY_PERIOD3_1:2026008 [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 19: P_PAY_PERIOD4_0:2026010 [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 20: P_PAY_PERIOD4_1:2026008 [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 21: P_MPA_STAT:null [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 22: P_MPA_STAT:null [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 23: P_PAYBATCH:null [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]Bind Variables ... [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:] 24: P_PAYBATCH:null [2026-02-19T19:22:54.510+00:00][dp id:1331789722][sch info:]CACHE MODE SQL_ACTION returning from cache [2026-02-19T19:22:54.512+00:00][dp id:1331789722][sch info:]CACHE MODE SQL_ID returning from cache [2026-02-19T19:22:54.512+00:00][dp id:1331789722][sch info:]XMLGEN:Exception while processing datamodel...:_Custom_Incentive_Compensation_Global_SCP_Governance_Solution_Direct_GSGS_OIC_Jobs_Direct_MPA_Data_Models_and_Reports_Data_Model_MPA_xdm [2026-02-19T19:22:54.512+00:00][dp id:1331789722][sch info:]Process Cancelled Stage:false [2026-02-19T19:22:54.512+00:00][dp id:1331789722][sch info:]XMLPGEN:ORA-00909: invalid number of arguments https://docs.oracle.com/error-help/db/ora-00909/ [2026-02-19T19:22:54.513+00:00][dp id:1331789722][sch info:]java.sql.SQLSyntaxErrorException: ORA-00909: invalid number of arguments https://docs.oracle.com/error-help/db/ora-00909/ at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:715) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:615) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1372) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:972) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:237) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:524) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:298) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:1257) at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1424) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1298) at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1855) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1631) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3973) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4160) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1120) at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:144) at oracle.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:2671) at oracle.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:780) at oracle.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:655) at oracle.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:523) at oracle.xdo.dataengine.XMLPGEN.writeXMLDataStructure(XMLPGEN.java:410) at oracle.xdo.dataengine.XMLPGEN.processDataSet(XMLPGEN.java:2541) at oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:2077) at oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:3936) at oracle.xdo.dataengine.DataProcessor.processData(DataProcessor.java:386) at oracle.xdo.servlet.dataengine.DataProcessorImpl.processData(DataProcessorImpl.java:311) at oracle.xdo.servlet.dataengine.DataProcessorImpl.render(DataProcessorImpl.java:688) at oracle.xdo.servlet.ReportModelContextImpl.getReportXMLData(ReportModelContextImpl.java:438) at oracle.xdo.servlet.CoreProcessor.getReportXMLData(CoreProcessor.java:2324) at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:634) at oracle.xdo.servlet.CoreProcessor.processRequest(CoreProcessor.java:299) at oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:171) at oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1719) at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:806) at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:252) at oracle.xdo.servlet.resources.ReportItemServiceImpl$ReportItemRunner.call(ReportItemServiceImpl.java:117) at oracle.xdo.servlet.resources.ReportItemServiceImpl$ReportItemRunner.call(ReportItemServiceImpl.java:82) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:842) Caused by: Error : 909, Position : 1354, SQL = SELECT record_number || '-' || 'MC' AS RecordNumber, record_number || '-' || 'MC' AS RecordName, EXTN_ATTRIBUTE_CHAR039 AS Paysheet_ID, 'Auto Approved' AS MPA_Status, EXTN_ATTRIBUTE_CHAR004 AS PlanComponentId_c, 'N' AS Recoverable_c, CURRENCY_CODE AS HomeCurrencyCode_c, EXTN_ATTRIBUTE_NUMBER037 AS AmountInLocalCurrency_c, EXTN_ATTRIBUTE_CHAR022 AS IncentiveTypeCode_c, EXTN_ATTRIBUTE_CHAR002 AS Badge_Id, EXTN_ATTRIBUTE_NUMBER001 AS PeriodId_c, EXTN_ATTRIBUTE_CHAR005 AS ParticipantPayId_c, EXTN_ATTRIBUTE_CHAR043 AS ParticipantPayIdMC, OWNER_RESOURCE_ID OraZcxOwner_Id_c, EXTN_ATTRIBUTE_NUMBER002 AS CreditedParticipantId_c, EXTN_ATTRIBUTE_CHAR001 AS PayrunId_c, ID AS RECORD_ID, (SELECT bu_id FROM fun_all_business_units_v WHERE bu_name = 'ICM_DIRECT_INCTV') AS OrgId_c, 'MAV_DIR_MPA_CODE_1012' AS ReasonCodeLOV_c, EXTN_ATTRIBUTE_CHAR011 AS PaymentBatch_c, EXTN_ATTRIBUTE_CHAR029 AS MPAStatus_c FROM SVC_REF_ENTITIES zre WHERE zre.ATTRIBUTE_CATEGORY = 'MTQ_ICM_PPH_OBJ_c' AND NVL(zre.EXTN_ATTRIBUTE_NUMBER037, 0) <> 0 AND (zre.EXTN_ATTRIBUTE_CHAR002 IN (:p_badge) OR 'ALL' IN (SELECT NVL(MAX(:p_badge),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR022 IN (:P_INC_TYPE) OR 'ALL' IN (SELECT NVL(MAX(:P_INC_TYPE),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_NUMBER001 IN (:P_PAY_PERIOD1_0,:P_PAY_PERIOD1_1) OR 'ALL' IN (SELECT NVL(MAX(:P_PAY_PERIOD2_0,:P_PAY_PERIOD2_1),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR029 IN (:P_MPA_STAT) OR 'ALL' IN (SELECT NVL(MAX(:P_MPA_STAT),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR011 IN (:P_PAYBATCH) OR 'ALL' IN (SELECT NVL(MAX(:P_PAYBATCH),'ALL') FROM DUAL)) UNION ALL SELECT record_number || '-' || 'MPA' AS RecordNumber, record_number || '-' || 'MPA' AS RecordName, EXTN_ATTRIBUTE_CHAR039 AS Paysheet_ID, EXTN_ATTRIBUTE_CHAR029 AS MPA_Status, EXTN_ATTRIBUTE_CHAR004 AS PlanComponentId_c, EXTN_ATTRIBUTE_CHAR013 AS Recoverable_c, CURRENCY_CODE AS HomeCurrencyCode_c, NVL(EXTN_ATTRIBUTE_NUMBER023, 0) AS AmountInLocalCurrency_c, EXTN_ATTRIBUTE_CHAR022 AS IncentiveTypeCode_c, EXTN_ATTRIBUTE_CHAR002 AS Badge_Id, EXTN_ATTRIBUTE_NUMBER001 AS PeriodId_c, EXTN_ATTRIBUTE_CHAR005 AS ParticipantPayId_c, EXTN_ATTRIBUTE_CHAR043 AS ParticipantPayIdMC, OWNER_RESOURCE_ID OraZcxOwner_Id_c, EXTN_ATTRIBUTE_NUMBER002 AS CreditedParticipantId_c, EXTN_ATTRIBUTE_CHAR001 AS PayrunId_c, ID AS RECORD_ID, (SELECT bu_id FROM fun_all_business_units_v WHERE bu_name = 'ICM_DIRECT_INCTV') AS OrgId_c, EXTN_ATTRIBUTE_CHAR023 AS ReasonCodeLOV_c, EXTN_ATTRIBUTE_CHAR011 AS PaymentBatch_c, EXTN_ATTRIBUTE_CHAR029 AS MPAStatus_c FROM SVC_REF_ENTITIES zre WHERE zre.ATTRIBUTE_CATEGORY = 'MTQ_ICM_PPH_OBJ_c' AND NVL(zre.EXTN_ATTRIBUTE_NUMBER023, 0) <> 0 AND (zre.EXTN_ATTRIBUTE_CHAR002 IN (:p_badge) OR 'ALL' IN (SELECT NVL(MAX(:p_badge),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR022 IN (:P_INC_TYPE) OR 'ALL' IN (SELECT NVL(MAX(:P_INC_TYPE),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_NUMBER001 IN (:P_PAY_PERIOD3_0,:P_PAY_PERIOD3_1) OR 'ALL' IN (SELECT NVL(MAX(:P_PAY_PERIOD4_0,:P_PAY_PERIOD4_1),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR029 IN (:P_MPA_STAT) OR 'ALL' IN (SELECT NVL(MAX(:P_MPA_STAT),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR011 IN (:P_PAYBATCH) OR 'ALL' IN (SELECT NVL(MAX(:P_PAYBATCH),'ALL') FROM DUAL)), Original SQL = SELECT record_number || '-' || 'MC' AS RecordNumber, record_number || '-' || 'MC' AS RecordName, EXTN_ATTRIBUTE_CHAR039 AS Paysheet_ID, 'Auto Approved' AS MPA_Status, EXTN_ATTRIBUTE_CHAR004 AS PlanComponentId_c, 'N' AS Recoverable_c, CURRENCY_CODE AS HomeCurrencyCode_c, EXTN_ATTRIBUTE_NUMBER037 AS AmountInLocalCurrency_c, EXTN_ATTRIBUTE_CHAR022 AS IncentiveTypeCode_c, EXTN_ATTRIBUTE_CHAR002 AS Badge_Id, EXTN_ATTRIBUTE_NUMBER001 AS PeriodId_c, EXTN_ATTRIBUTE_CHAR005 AS ParticipantPayId_c, EXTN_ATTRIBUTE_CHAR043 AS ParticipantPayIdMC, OWNER_RESOURCE_ID OraZcxOwner_Id_c, EXTN_ATTRIBUTE_NUMBER002 AS CreditedParticipantId_c, EXTN_ATTRIBUTE_CHAR001 AS PayrunId_c, ID AS RECORD_ID, (SELECT bu_id FROM fun_all_business_units_v WHERE bu_name = 'ICM_DIRECT_INCTV') AS OrgId_c, 'MAV_DIR_MPA_CODE_1012' AS ReasonCodeLOV_c, EXTN_ATTRIBUTE_CHAR011 AS PaymentBatch_c, EXTN_ATTRIBUTE_CHAR029 AS MPAStatus_c FROM SVC_REF_ENTITIES zre WHERE zre.ATTRIBUTE_CATEGORY = 'MTQ_ICM_PPH_OBJ_c' AND NVL(zre.EXTN_ATTRIBUTE_NUMBER037, 0) <> 0 AND (zre.EXTN_ATTRIBUTE_CHAR002 IN (:p_badge) OR 'ALL' IN (SELECT NVL(MAX(:p_badge),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR022 IN (:P_INC_TYPE) OR 'ALL' IN (SELECT NVL(MAX(:P_INC_TYPE),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_NUMBER001 IN (:P_PAY_PERIOD1_0,:P_PAY_PERIOD1_1) OR 'ALL' IN (SELECT NVL(MAX(:P_PAY_PERIOD2_0,:P_PAY_PERIOD2_1),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR029 IN (:P_MPA_STAT) OR 'ALL' IN (SELECT NVL(MAX(:P_MPA_STAT),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR011 IN (:P_PAYBATCH) OR 'ALL' IN (SELECT NVL(MAX(:P_PAYBATCH),'ALL') FROM DUAL)) UNION ALL SELECT record_number || '-' || 'MPA' AS RecordNumber, record_number || '-' || 'MPA' AS RecordName, EXTN_ATTRIBUTE_CHAR039 AS Paysheet_ID, EXTN_ATTRIBUTE_CHAR029 AS MPA_Status, EXTN_ATTRIBUTE_CHAR004 AS PlanComponentId_c, EXTN_ATTRIBUTE_CHAR013 AS Recoverable_c, CURRENCY_CODE AS HomeCurrencyCode_c, NVL(EXTN_ATTRIBUTE_NUMBER023, 0) AS AmountInLocalCurrency_c, EXTN_ATTRIBUTE_CHAR022 AS IncentiveTypeCode_c, EXTN_ATTRIBUTE_CHAR002 AS Badge_Id, EXTN_ATTRIBUTE_NUMBER001 AS PeriodId_c, EXTN_ATTRIBUTE_CHAR005 AS ParticipantPayId_c, EXTN_ATTRIBUTE_CHAR043 AS ParticipantPayIdMC, OWNER_RESOURCE_ID OraZcxOwner_Id_c, EXTN_ATTRIBUTE_NUMBER002 AS CreditedParticipantId_c, EXTN_ATTRIBUTE_CHAR001 AS PayrunId_c, ID AS RECORD_ID, (SELECT bu_id FROM fun_all_business_units_v WHERE bu_name = 'ICM_DIRECT_INCTV') AS OrgId_c, EXTN_ATTRIBUTE_CHAR023 AS ReasonCodeLOV_c, EXTN_ATTRIBUTE_CHAR011 AS PaymentBatch_c, EXTN_ATTRIBUTE_CHAR029 AS MPAStatus_c FROM SVC_REF_ENTITIES zre WHERE zre.ATTRIBUTE_CATEGORY = 'MTQ_ICM_PPH_OBJ_c' AND NVL(zre.EXTN_ATTRIBUTE_NUMBER023, 0) <> 0 AND (zre.EXTN_ATTRIBUTE_CHAR002 IN (:p_badge) OR 'ALL' IN (SELECT NVL(MAX(:p_badge),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR022 IN (:P_INC_TYPE) OR 'ALL' IN (SELECT NVL(MAX(:P_INC_TYPE),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_NUMBER001 IN (:P_PAY_PERIOD3_0,:P_PAY_PERIOD3_1) OR 'ALL' IN (SELECT NVL(MAX(:P_PAY_PERIOD4_0,:P_PAY_PERIOD4_1),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR029 IN (:P_MPA_STAT) OR 'ALL' IN (SELECT NVL(MAX(:P_MPA_STAT),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR011 IN (:P_PAYBATCH) OR 'ALL' IN (SELECT NVL(MAX(:P_PAYBATCH),'ALL') FROM DUAL)), Error Message = ORA-00909: invalid number of arguments at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:723) ... 40 more [2026-02-19T19:22:54.513+00:00][dp id:1331789722][sch info:] Start Datamodel diagnostic details.. ====================================================================== Data processor Id: Dp{1331789722} Report absolute path: /Custom/Incentive Compensation/Global SCP Governance Solution/Direct-GSGS-OIC Jobs/Direct-MPA Data Models and Reports/Data Model-MPA.xdm Datamodel name: _Custom_Incentive_Compensation_Global_SCP_Governance_Solution_Direct_GSGS_OIC_Jobs_Direct_MPA_Data_Models_and_Reports_Data_Model_MPA_xdm User name: 1437297 JDBC Session Module: BIP_Data Model-MPA.xdm JDBC Session Action: Dp{1331789722} Processing mode: online Calling module: online Enable Audit Events: true Enable SQLID generation: true StringList: 2 Cache SQL Rowset: false Data Chunk Cache Size: 5242880 Optimize LOB Readers: true Allow DB Modifications: false Is DM Customized: false Output format: 1 Auto db Fetchsize enabled: true Default db Fetchsize : 20 SQL Query Timeout : 3600 Olnine SQL Query Timeout : 500 Offline SQL Query Timeout : 3600 XML data size limit: 2147483648 XML Sample data size limit: 1048576 Processed with Scalable mode enabled: true Track xml size enabled: true SQL Session Trace enabled: false SQL Session Trace File: SQL Query Pruning enabled: false Is Layout Elements passed: false Layout Elements size: 0 Webservice timeout: 1800 Debug Mode: false Estimate XML DataSize: false Generate Output XML: true Optimize By CSV Processing: false Enable Link between RDG: true DataSet Name:report Number of elements:0 Total Query Execution time (ms):0 DataSet Name:Parameters Number of elements:5 Total Query Execution time (ms):0 DataSet Name:Triggers Number of elements:0 Total Query Execution time (ms):0 DataSet Name:newquery DataSet Type:sqlQuery-oracle Data Source Name:ApplicationDB_CRM Is DataSet Execution Skipped:false DataSet DB fetch size:1000 DataSet Query Timeout:500 Total Number Of Times Query Executed:0 Total Number Of Rows Processed:0 Sql Action Id:Dp{1344669697}Sql{6f3b09bc} Sql Session Details:SQLID:{0787nx486jv2u}SQL_HASH:{275311706}SQL_EXEC_ID:{84355932} Number of elements:21 Total Query Execution time (ms):0 ------------------------------------------------------------------------ Total Number of Datasets: 4 Total Number of Elements: 26 Total Parse Time (ms): 0 Total Datamodel Validation Time: .000 mseconds Total Xplan Generation Time: .000 mseconds Total Data Generation Time: 6.000 mseconds Total XML Data Size Generated: 397 Processing Exceptions: java.sql.SQLSyntaxErrorException: ORA-00909: invalid number of arguments https://docs.oracle.com/error-help/db/ora-00909/ at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:715) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:615) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1372) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:972) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:237) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:524) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:298) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:1257) at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1424) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1298) at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1855) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1631) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3973) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4160) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1120) at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:144) at oracle.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:2671) at oracle.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:780) at oracle.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:655) at oracle.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:523) at oracle.xdo.dataengine.XMLPGEN.writeXMLDataStructure(XMLPGEN.java:410) at oracle.xdo.dataengine.XMLPGEN.processDataSet(XMLPGEN.java:2541) at oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:2077) at oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:3936) at oracle.xdo.dataengine.DataProcessor.processData(DataProcessor.java:386) at oracle.xdo.servlet.dataengine.DataProcessorImpl.processData(DataProcessorImpl.java:311) at oracle.xdo.servlet.dataengine.DataProcessorImpl.render(DataProcessorImpl.java:688) at oracle.xdo.servlet.ReportModelContextImpl.getReportXMLData(ReportModelContextImpl.java:438) at oracle.xdo.servlet.CoreProcessor.getReportXMLData(CoreProcessor.java:2324) at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:634) at oracle.xdo.servlet.CoreProcessor.processRequest(CoreProcessor.java:299) at oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:171) at oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1719) at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:806) at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:252) at oracle.xdo.servlet.resources.ReportItemServiceImpl$ReportItemRunner.call(ReportItemServiceImpl.java:117) at oracle.xdo.servlet.resources.ReportItemServiceImpl$ReportItemRunner.call(ReportItemServiceImpl.java:82) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:842) Caused by: Error : 909, Position : 1354, SQL = SELECT record_number || '-' || 'MC' AS RecordNumber, record_number || '-' || 'MC' AS RecordName, EXTN_ATTRIBUTE_CHAR039 AS Paysheet_ID, 'Auto Approved' AS MPA_Status, EXTN_ATTRIBUTE_CHAR004 AS PlanComponentId_c, 'N' AS Recoverable_c, CURRENCY_CODE AS HomeCurrencyCode_c, EXTN_ATTRIBUTE_NUMBER037 AS AmountInLocalCurrency_c, EXTN_ATTRIBUTE_CHAR022 AS IncentiveTypeCode_c, EXTN_ATTRIBUTE_CHAR002 AS Badge_Id, EXTN_ATTRIBUTE_NUMBER001 AS PeriodId_c, EXTN_ATTRIBUTE_CHAR005 AS ParticipantPayId_c, EXTN_ATTRIBUTE_CHAR043 AS ParticipantPayIdMC, OWNER_RESOURCE_ID OraZcxOwner_Id_c, EXTN_ATTRIBUTE_NUMBER002 AS CreditedParticipantId_c, EXTN_ATTRIBUTE_CHAR001 AS PayrunId_c, ID AS RECORD_ID, (SELECT bu_id FROM fun_all_business_units_v WHERE bu_name = 'ICM_DIRECT_INCTV') AS OrgId_c, 'MAV_DIR_MPA_CODE_1012' AS ReasonCodeLOV_c, EXTN_ATTRIBUTE_CHAR011 AS PaymentBatch_c, EXTN_ATTRIBUTE_CHAR029 AS MPAStatus_c FROM SVC_REF_ENTITIES zre WHERE zre.ATTRIBUTE_CATEGORY = 'MTQ_ICM_PPH_OBJ_c' AND NVL(zre.EXTN_ATTRIBUTE_NUMBER037, 0) <> 0 AND (zre.EXTN_ATTRIBUTE_CHAR002 IN (:p_badge) OR 'ALL' IN (SELECT NVL(MAX(:p_badge),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR022 IN (:P_INC_TYPE) OR 'ALL' IN (SELECT NVL(MAX(:P_INC_TYPE),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_NUMBER001 IN (:P_PAY_PERIOD1_0,:P_PAY_PERIOD1_1) OR 'ALL' IN (SELECT NVL(MAX(:P_PAY_PERIOD2_0,:P_PAY_PERIOD2_1),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR029 IN (:P_MPA_STAT) OR 'ALL' IN (SELECT NVL(MAX(:P_MPA_STAT),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR011 IN (:P_PAYBATCH) OR 'ALL' IN (SELECT NVL(MAX(:P_PAYBATCH),'ALL') FROM DUAL)) UNION ALL SELECT record_number || '-' || 'MPA' AS RecordNumber, record_number || '-' || 'MPA' AS RecordName, EXTN_ATTRIBUTE_CHAR039 AS Paysheet_ID, EXTN_ATTRIBUTE_CHAR029 AS MPA_Status, EXTN_ATTRIBUTE_CHAR004 AS PlanComponentId_c, EXTN_ATTRIBUTE_CHAR013 AS Recoverable_c, CURRENCY_CODE AS HomeCurrencyCode_c, NVL(EXTN_ATTRIBUTE_NUMBER023, 0) AS AmountInLocalCurrency_c, EXTN_ATTRIBUTE_CHAR022 AS IncentiveTypeCode_c, EXTN_ATTRIBUTE_CHAR002 AS Badge_Id, EXTN_ATTRIBUTE_NUMBER001 AS PeriodId_c, EXTN_ATTRIBUTE_CHAR005 AS ParticipantPayId_c, EXTN_ATTRIBUTE_CHAR043 AS ParticipantPayIdMC, OWNER_RESOURCE_ID OraZcxOwner_Id_c, EXTN_ATTRIBUTE_NUMBER002 AS CreditedParticipantId_c, EXTN_ATTRIBUTE_CHAR001 AS PayrunId_c, ID AS RECORD_ID, (SELECT bu_id FROM fun_all_business_units_v WHERE bu_name = 'ICM_DIRECT_INCTV') AS OrgId_c, EXTN_ATTRIBUTE_CHAR023 AS ReasonCodeLOV_c, EXTN_ATTRIBUTE_CHAR011 AS PaymentBatch_c, EXTN_ATTRIBUTE_CHAR029 AS MPAStatus_c FROM SVC_REF_ENTITIES zre WHERE zre.ATTRIBUTE_CATEGORY = 'MTQ_ICM_PPH_OBJ_c' AND NVL(zre.EXTN_ATTRIBUTE_NUMBER023, 0) <> 0 AND (zre.EXTN_ATTRIBUTE_CHAR002 IN (:p_badge) OR 'ALL' IN (SELECT NVL(MAX(:p_badge),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR022 IN (:P_INC_TYPE) OR 'ALL' IN (SELECT NVL(MAX(:P_INC_TYPE),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_NUMBER001 IN (:P_PAY_PERIOD3_0,:P_PAY_PERIOD3_1) OR 'ALL' IN (SELECT NVL(MAX(:P_PAY_PERIOD4_0,:P_PAY_PERIOD4_1),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR029 IN (:P_MPA_STAT) OR 'ALL' IN (SELECT NVL(MAX(:P_MPA_STAT),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR011 IN (:P_PAYBATCH) OR 'ALL' IN (SELECT NVL(MAX(:P_PAYBATCH),'ALL') FROM DUAL)), Original SQL = SELECT record_number || '-' || 'MC' AS RecordNumber, record_number || '-' || 'MC' AS RecordName, EXTN_ATTRIBUTE_CHAR039 AS Paysheet_ID, 'Auto Approved' AS MPA_Status, EXTN_ATTRIBUTE_CHAR004 AS PlanComponentId_c, 'N' AS Recoverable_c, CURRENCY_CODE AS HomeCurrencyCode_c, EXTN_ATTRIBUTE_NUMBER037 AS AmountInLocalCurrency_c, EXTN_ATTRIBUTE_CHAR022 AS IncentiveTypeCode_c, EXTN_ATTRIBUTE_CHAR002 AS Badge_Id, EXTN_ATTRIBUTE_NUMBER001 AS PeriodId_c, EXTN_ATTRIBUTE_CHAR005 AS ParticipantPayId_c, EXTN_ATTRIBUTE_CHAR043 AS ParticipantPayIdMC, OWNER_RESOURCE_ID OraZcxOwner_Id_c, EXTN_ATTRIBUTE_NUMBER002 AS CreditedParticipantId_c, EXTN_ATTRIBUTE_CHAR001 AS PayrunId_c, ID AS RECORD_ID, (SELECT bu_id FROM fun_all_business_units_v WHERE bu_name = 'ICM_DIRECT_INCTV') AS OrgId_c, 'MAV_DIR_MPA_CODE_1012' AS ReasonCodeLOV_c, EXTN_ATTRIBUTE_CHAR011 AS PaymentBatch_c, EXTN_ATTRIBUTE_CHAR029 AS MPAStatus_c FROM SVC_REF_ENTITIES zre WHERE zre.ATTRIBUTE_CATEGORY = 'MTQ_ICM_PPH_OBJ_c' AND NVL(zre.EXTN_ATTRIBUTE_NUMBER037, 0) <> 0 AND (zre.EXTN_ATTRIBUTE_CHAR002 IN (:p_badge) OR 'ALL' IN (SELECT NVL(MAX(:p_badge),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR022 IN (:P_INC_TYPE) OR 'ALL' IN (SELECT NVL(MAX(:P_INC_TYPE),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_NUMBER001 IN (:P_PAY_PERIOD1_0,:P_PAY_PERIOD1_1) OR 'ALL' IN (SELECT NVL(MAX(:P_PAY_PERIOD2_0,:P_PAY_PERIOD2_1),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR029 IN (:P_MPA_STAT) OR 'ALL' IN (SELECT NVL(MAX(:P_MPA_STAT),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR011 IN (:P_PAYBATCH) OR 'ALL' IN (SELECT NVL(MAX(:P_PAYBATCH),'ALL') FROM DUAL)) UNION ALL SELECT record_number || '-' || 'MPA' AS RecordNumber, record_number || '-' || 'MPA' AS RecordName, EXTN_ATTRIBUTE_CHAR039 AS Paysheet_ID, EXTN_ATTRIBUTE_CHAR029 AS MPA_Status, EXTN_ATTRIBUTE_CHAR004 AS PlanComponentId_c, EXTN_ATTRIBUTE_CHAR013 AS Recoverable_c, CURRENCY_CODE AS HomeCurrencyCode_c, NVL(EXTN_ATTRIBUTE_NUMBER023, 0) AS AmountInLocalCurrency_c, EXTN_ATTRIBUTE_CHAR022 AS IncentiveTypeCode_c, EXTN_ATTRIBUTE_CHAR002 AS Badge_Id, EXTN_ATTRIBUTE_NUMBER001 AS PeriodId_c, EXTN_ATTRIBUTE_CHAR005 AS ParticipantPayId_c, EXTN_ATTRIBUTE_CHAR043 AS ParticipantPayIdMC, OWNER_RESOURCE_ID OraZcxOwner_Id_c, EXTN_ATTRIBUTE_NUMBER002 AS CreditedParticipantId_c, EXTN_ATTRIBUTE_CHAR001 AS PayrunId_c, ID AS RECORD_ID, (SELECT bu_id FROM fun_all_business_units_v WHERE bu_name = 'ICM_DIRECT_INCTV') AS OrgId_c, EXTN_ATTRIBUTE_CHAR023 AS ReasonCodeLOV_c, EXTN_ATTRIBUTE_CHAR011 AS PaymentBatch_c, EXTN_ATTRIBUTE_CHAR029 AS MPAStatus_c FROM SVC_REF_ENTITIES zre WHERE zre.ATTRIBUTE_CATEGORY = 'MTQ_ICM_PPH_OBJ_c' AND NVL(zre.EXTN_ATTRIBUTE_NUMBER023, 0) <> 0 AND (zre.EXTN_ATTRIBUTE_CHAR002 IN (:p_badge) OR 'ALL' IN (SELECT NVL(MAX(:p_badge),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR022 IN (:P_INC_TYPE) OR 'ALL' IN (SELECT NVL(MAX(:P_INC_TYPE),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_NUMBER001 IN (:P_PAY_PERIOD3_0,:P_PAY_PERIOD3_1) OR 'ALL' IN (SELECT NVL(MAX(:P_PAY_PERIOD4_0,:P_PAY_PERIOD4_1),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR029 IN (:P_MPA_STAT) OR 'ALL' IN (SELECT NVL(MAX(:P_MPA_STAT),'ALL') FROM DUAL)) AND (zre.EXTN_ATTRIBUTE_CHAR011 IN (:P_PAYBATCH) OR 'ALL' IN (SELECT NVL(MAX(:P_PAYBATCH),'ALL') FROM DUAL)), Error Message = ORA-00909: invalid number of arguments at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:723) ... 40 more ====================================================================== End Datamodel diagnostic details.. ]]>

Comments

Popular posts from this blog

dev7 from eror

EPA

Unified Currency Report- Krithika