Fusion Applications: BICCC Extract Got Failed (Doc ID 2560347.1)

Last updated on JUNE 28, 2022

Applies to:

Symptoms

On : 11.13.19.01.0 version, Technology Management - Reports/Analytics

When attempting to do an incremental extract for PVO FscmTopModelAM.ReceiptAccountingAM.ReceiptAccountingPVO, the following error occurs.

ERROR
-----------------------

[2019-06-14T03:56:57.193+00:00] [bi_server1] [ERROR] [] [oracle.obiacm.dataExtract.BIVOExtractTask] [tid: 33] [ecid: 005YnWxDfQz3z0^5PVO5yd0004tf00011J,1:65671] [APP: oracle.biacm#11.1.1] [ESS_JobMetadataID: JobDefinition://oracle.apps.ess.biccc/BICloudConnectorJobDefinition] [ESS_RequestID: 4331527] [ESS_Module: Processor] Error occurred - FscmTopModelAM.ReceiptAccountingAM.ReceiptAccountingPVO[[
query - set variable DISABLE_RIGHTTRIM_FOR_VARCHAR=1;select_physical t.ReceivingDistributionsEOAccountedQty,t.ReceivingDistributionsEOAccountingLineType,t.CmrSubLedgerId,t.ReceivingDistributionsEOCodeCombinationId,t.ReceivingDistributionsEOCreatedBy,t.ReceivingDistributionsEOCreationDate,t.ReceivingDistributionsEOEnteredCurrencyAmount,t.ReceivingDistributionsEOEnteredCurrencyCode,t.ReceivingDistributionsEOLastUpdateDate,t.ReceivingDistributionsEOLedgerAmount,t.ReceivingDistributionsEOLedgerCurrencyCode,t.ReceivingAccountingEventsEOAccountedFlag,t.ReceivingAccountingEventsEOCreatedBy,t.ReceivingAccountingEventsEOCreationDate,t.ReceivingAccountingEventsEOEnteredCurrencyCode,t.ReceivingAccountingEventsEOEventClassCode,t.ReceivingAccountingEventsEOEventTypeCode,t.ReceivingAccountingEventsEOGlDate,t.ReceivingAccountingEventsEOLastUpdateDate,t.ReceivingAccountingEventsEOLastUpdateLogin,t.ReceivingAccountingEventsEOLastUpdatedBy,t.ReceivingAccountingEventsEOLegalEntityId,t.ReceivingAccountingEventsEONonrecoverableTax,t.ReceivingAccountingEventsEOPoUnitPrice,t.ReceivingAccountingEventsEOPrimaryQty,t.ReceivingAccountingEventsEOPrimaryUomCode,t.ReceivingAccountingEventsEOSourceDocQty,t.ReceivingAccountingEventsEOSourceDocUomCode,t.ReceivingAccountingEventsEOTransactionAmt,t.ReceivingAccountingEventsEOTransactionDate,t.ReceivingAccountingEventsEOTransactionQty,t.ReceivingAccountingEventsEOTransactionUomCode,t.ReceivingAccountingEventsEOTransferPrice,t.EventTypeTranslationPEOName,t.EventTypeTranslationPEOEventClassCode,t.EventTypeTranslationPEOEventTypeCode,t.EventTypeTranslationPEODescription,t.AcctLineTypeLookupPEOMeaning,t.PurchaseOrderDtlsPEOPoNumber,t.RcvEventTypesPEOTransactionType,t.CmrRcvTransactionRptPEOReceiptNumber,t.ReceivingAccountingEventsEOSourceDocNumber,t.ReceivingAccountingEventsEOSlaTransactionNumber,t.CmrRcvEventCostsPEOEventUnitCost,t.CmrRcvEventCostsPEOEventCostSourceType,t.CmrRcvEventCostsPEODestinationTypeCode,t.PurchaseOrderDtlsPEODistributionNumber,t.CmrRcvTransactionRptPEOTransactionDate,t.PurchasingDocumentHeaderSegment1,t.PurchasingDocumentHeaderComments,t.PurchasingDocumentHeaderConfirmingOrderFlag,t.PurchasingDocumentHeaderVendorOrderNum,t.PurchasingDocumentHeaderReferenceNum,t.PurchasingDocumentLineFromHeaderId,t.PurchasingDocumentLineUomCode,t.PurchasingDocumentHeaderCurrencyCode,t.PurchasingDocumentLineLineNum,t.PurchasingDocumentLineItemRevision,t.PurchasingDocumentLineLineStatus,t.PurchasingDocumentLineCancelDate,t.PurchasingDocumentLineCancelReason,t.PurchasingDocumentLineCancelledBy,t.PurchasingDocumentLineLineReferenceNum,t.PurchaseOrderDistributionDistributionNum,t.PurchasingDocumentShipmentShipmentNum,t.PurchaseOrderDistributionReqDistributionId,t.PurchaseOrderDistributionReqHeaderReferenceNum,t.PurchaseOrderDistributionReqLineReferenceNum,t.PurchaseOrderDistributionRate,t.PurchaseOrderDistributionRateDate,t.UomUnitOfMeasure,t.UomDescription,t.PersonNamePEOFullName,t.EffectiveStartDate,t.PersonNamePEOTitle,t.PersonNamePEODisplayName,t.PersonNamePEOFirstName,t.PersonNamePEOLastName,t.RequisitionHeaderPEORequisitionNumber,t.RequisitionLinePEOLineNumber,t.SupervisorNamePEOFullName,t.SupervisorNamePEOEffectiveStartDate,t.PurchasingDocumentLineContractId,t.FromBlanketHeaderSegment1,t.ContractHeaderSegment1,t.ReceivingAccountingEventsPEOBudgetaryControlFlag,t.ReceivingAccountingEventsPEOEncumbranceAccountingFlag,t.ReceivingAccountingEventsPEOFundReservationStatus,t.PurchaseOrderDtlsPEODestinationTypeCode from "FscmTopModelAM.ReceiptAccountingAM.ReceiptAccountingPVO" as t where (t.ReceivingAccountingEventsEOLastUpdateDate >= TIMESTAMP '2019-06-04 12:19:43' or t.ReceivingDistributionsEOLastUpdateDate >= TIMESTAMP '2019-06-04 12:19:43' or t.EffectiveStartDate >= TIMESTAMP '2019-06-04 12:19:43' or t.SupervisorNamePEOEffectiveStartDate >= TIMESTAMP '2019-06-04 12:19:43')
 oracle.obiacm.dataExtract.DataExtractException: FscmTopModelAM.ReceiptAccountingAM.ReceiptAccountingPVO - Error read results - Error while fetching rows from server: java.io.IOException: end of file
at oracle.obiacm.utils.WriterUtils.readResults(WriterUtils.java:289)
at oracle.obiacm.utils.WriterUtils.extractConcurrent(WriterUtils.java:195)
at oracle.obiacm.dataExtract.BIVOExtractTask.extractConcurrent(BIVOExtractTask.java:643)
at oracle.obiacm.dataExtract.BIVOExtractTask.extractData(BIVOExtractTask.java:539)
at oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract(BIVOExtractTask.java:199)
at oracle.obiacm.dataExtract.BIVOExtractTask.doDataExtract(BIVOExtractTask.java:109)
at oracle.obiacm.dataExtract.BIVOExtractTask.doRun(BIVOExtractTask.java:93)
at oracle.obiacm.dataExtract.AbstractCancellableTask.run(AbstractCancellableTask.java:37)
at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:378)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:307)
Caused by: java.sql.SQLException: Error while fetching rows from server: java.io.IOException: end of file
at oracle.bi.jdbc.AnaJdbcResultSetImpl.fetchSomeRowsVersion2(AnaJdbcResultSetImpl.java:1591)
at oracle.bi.jdbc.AnaJdbcResultSetImpl.fetchSomeRows(AnaJdbcResultSetImpl.java:1253)
at oracle.bi.jdbc.AnaJdbcResultSetImpl.fetchMoreRows(AnaJdbcResultSetImpl.java:1871)
at oracle.bi.jdbc.AnaJdbcResultSetImpl.next(AnaJdbcResultSetImpl.java:766)
at oracle.obiacm.utils.WriterUtils.readResults(WriterUtils.java:269)
... 10 more

Changes

Cause

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