Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI NLS settings issue

4049330Nov 2 2019 — edited Nov 6 2019

Hello ,

We have installed ODI 11.1.1.9.0 on Reh hat Linux. When we are executing packages getting below errors. If I take ODI code and executed directly in the database and code is working fine without any issue.

After lof to search, I have added alter nls query in topology--> data server --> on-connect/Disconnect tab and it is working fine.

Now , we are getting a lot of NLS issues in all the mappings like Invalid number and date format and data type conversion, etc.. As per oracle we can add only one alter script in topology on data server

pastedImage_0.png

Errors:-

1.: ORA-01861: literal does not match format string

2. Invalid number due to NLS settings issue.

After adding NLS alter command in topology and all working fine but only issue he we can add only one alter script in topology not more like below.

pastedImage_1.png

Can someone help on this issue. My worry here was why database NLS settings are not taking while executing packages through ODI ?

Any inputs?

Thanks

RR

Comments
Post Details