All of a sudden I was getting the error "ORA-24345: A Truncation or null fetch error occurred" in one of EBC based view. I tried loading the same record by having a different and criteria and made sure that the record is also a part of my query condition. This time I drill down on the record for which it didn't have any problem and then I navigated to the problematic record and the view loaded without any issue but I was not able to see the detail record even though it had few records to be shown. Finally after doing a research in Support web I come to understand the following:
The field length mentioned in the EBC is different from the actual field length mentioned in the Table. Since its a EBC an external application accessing the application has accessed this field and updated with a greater length of data that is mentioned in the BC. Hence the above error occured. After correcting the BC field's length and compiled the EBC into SRF the above issue is resolved.
No comments:
Post a Comment