Wrong Datatype for Column INVOICE_RECEIVED_DATE for RMS_BDI_INT SCHEMA
(Doc ID 2983277.1)
Last updated on OCTOBER 30, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 to 19.3 [Release 19.3]Information in this document applies to any platform.
Symptoms
Wrong DataType For Column INVOICE_RECEIVED_DATE FOR RMS_BDI_INT SCHEMA.
Steps To Recreate:
1.Execute the DT batch but it failed with mismatched column issue for the invoice_received date column.
2.This column datatype needs to be date on both RMS_BDI_INT schema and CFIN_RFI_INT schema but its timestamp on RMS side.
3.Here is the receiver log with error:
2023-05-23T14:08:16,964 [[ACTIVE] ExecuteThread: '14' for queue:'weblogic.kernel.Default (self-tuning)'] ERROR UploaderInterfaceItemWriter -Column types don't match. Source column name(INVOICE_RECEIVED_DATE), source column type(TIMESTAMP(6)), destination column type(DATE).
2023-05-23T14:08:16,992 [[ACTIVE] ExecuteThread: '14' for queue:'weblogic.kernel.Default (self-tuning)'] ERROR ReceiverResource - EJB
Exception:2023-05-23T14:08:17,063 [[ACTIVE] ExecuteThread: '13' for queue:'weblogic.kernel.Default (self-tuning)'] DEBUG ReceiverResource - Receiver
transmission completed for TRANSMISSION_ID(T1of1#86b4c57e-2666-4358-8f4d-28e9606fcd83).
2023-05-23T14:08:20,429 [[ACTIVE] ExecuteThread: '14' for queue:'weblogic.kernel.Default (self-tuning)'] ERROR ReceiverResource - Number of blocks didn't match for
TRANSMISSION_ID(T1of1#61a9f11a-b06c-4743-9409-11705ca69b9d).
Changes
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 |
Changes |
Cause |
Solution |
References |