My Oracle Support Banner

BICCC Extract Is Failing On Expense PVOs Such As FscmTopModelAM.FinExmEntrySharedAM.ExpenseDistributionPVO With Error ORA-00936: missing expression (Doc ID 2268830.1)

Last updated on MAY 31, 2017

Applies to:

Oracle Transactional Business Intelligence Enterprise for Human Capital Management Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

BICCC Extract Is Failing On Expense PVOs Such As FscmTopModelAM.FinExmEntrySharedAM.ExpenseDistributionPVO With Error ORA-00936: missing expression.

biee-extractor.log

[2017-05-22T11:36:10.412+00:00] [bi_server1] [ERROR] [] [oracle.obiacm.dataExtract.BIVOExtractTask] [tid: 1136] [userId: OBIA_ETL] [ecid: 0000LkjvOpi6QP_LlQc9yZ1P7vJM0000CM,1:24474] [APP: oracle.biacm#11.1.11.1.0] [ESS_JobMetadataID: JobDefinition://oracle.apps.ess.biccc/BICloudConnectorJobDefinition] [ESS_RequestID: 62262] [ESS_Module: Processor] Failed DataExtractQuery: select_physical t.ExpDistCodeCombinationId,t.ExpDistCreatedBy,t.ExpenseDistId,t.ExpDistLastUpdatedBy,t.ExpDistPjcExpenditureTypeId,t.ExpDistPjcOrganizationId,t.ExpDistPjcProjectId,t.ExpDistPjcTaskId,t.ExpDistReimbursableAmount,t.ExpDistSequenceNum,t.ExpDistCreationDate,t.ExpDistLastUpdateDate,t.ExpEmpDefaultCostCenter,t.ExpAuditAdjustmentReasonCode,t.ExpDescription,t.ExpEndDate,t.ExpExchangeRate,t.ExpExpenseCategoryCode,t.ExpExpenseId,t.ExpExpenseReportId,t.ExpExpenseSource,t.ExpExpenseTypeCategoryCode,t.ExpExpenseTypeId,t.ExpItemizationParentExpenseId,t.ExpLastUpdateDate,t.ExpLocationId,t.ExpMerchantName,t.ExpOrgId,t.ExpOrigReimbursableAmount,t.ExpReceiptCurrencyCode,t.ExpReceiptMissingFlag,t.ExpReceiptRequiredFlag,t.ExpReceiptVerifiedFlag,t.ExpReimbursableAmount,t.ExpReimbursementCurrencyCode,t.ExpSequenceNum,t.ExpStartDate,t.ExpHdrCashExpensePaidDate,t.ExpHdrFinalApprovalDate,t.ExpHdrCurrentApproverId,t.ExpHdrExchangeRateType,t.ExpHdrExpenseReportId,t.ExpHdrExpenseReportNum,t.ExpHdrExpenseReportTotal,t.ExpHdrExpenseStatusCode,t.ExpHdrExpenseStatusDate,t.ExpHdrLastUpdateDate,t.ExpHdrOrgId,t.ExpHdrOverrideApproverId,t.ExpHdrParentExpenseReportId,t.ExpHdrPersonId,t.ExpHdrPurpose,t.ExpHdrReportSubmitDate,t.ExpHdrPrntLastUpdateDate,t.InvoiceInvoiceDate,t.InvoiceInvoiceNum,t.InvoiceLastUpdateDate,t.InvoiceSetOfBooksId,t.InvoiceBatchLastUpdateDate,t.RateTypeLastUpdateDate,t.WithholdingTaxGrpExpLastUpdateDate,t.WithholdingTaxGrpExpRptLastUpdateDate,t.PurchaseOrderLastUpdateDate,t.QuickPurchaseOrderLastUpdateDate,t.InvoiceConversionTypeLastUpdateDate,t.PaymentConversionTypeLastUpdateDate,t.WithholdingTaxGrpInvLastUpdateDate,t.DistributionSetLastUpdateDate,t.PayDelcodeLastUpdateDate,t.PayReacodeLastUpdateDate,t.InvExtBnkAcctLastUpdateDate from "FscmTopModelAM.FinExmEntrySharedAM.ExpenseDistributionPVO" as t[[
java.sql.SQLException: java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS.
[nQSError: 43119] Query Failed:
[nQSError: 17001] Oracle Error code: 936, message: ORA-00936: missing expression
at OCI call OCIStmtExecute.
[nQSError: 17010] SQL statement preparation failed.
at oracle.bi.jdbc.AnaJdbcStatementImpl.executeQuery(AnaJdbcStatementImpl.java:387)
at oracle.obiacm.queryprocessing.BIServerQuery.runDataExtractQuery(BIServerQuery.java:321)
at oracle.obiacm.dataExtract.BIVOExtractTask.doDataExtract(BIVOExtractTask.java:125)
at oracle.obiacm.dataExtract.BIVOExtractTask.run(BIVOExtractTask.java:105)
at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:346)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:280)

]]

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.