on 05-15-2006 8:15 AM
Time conversion from 0CALDAY to 0FISCPER (fiscal year GL ) failed with value 10060512.
data loaded successfully from all clusters to ODS level, after that loaded from ODS to CUBE ,there i got this type of error.
pls help me how to solve?
regards
reddy
Hello Reddy,
In case , if the incoming data for field date from the source itself is wrong/invalid , then you can write the piece of code for essential conversions of date in the start routine of the update rules.
Hope it helps..
Thanks,
Asha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
dear reddy,
It seems you r mapping 0CALDAY ( it is of data type: DATS) to 0FISCPER (data type: NUMC). so due to mismatching of data types, error data will come.
pls check it once.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Value of year does not look right 1006 you can address this problem by writing routine in transfer rules and make changes to the value of 0CALDAY to appropriate values.
Usually such problem comes when users enter wrong values in transaction on source system side.
Hope it helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.