Please tell me the scenario in which extension to VO is not upgrade safe in OAF

If the original VO is created in Expert mode, then you will have to copy the original VO Query and then you will paste that Sql statement and query into extended VO.

Now , if in future oracle is going to change the original SQL Statement (against Original VO) , then those changes will not be reflected in extended VO.