OTBI is Oracle Transactional Business Intelligence and uses subject areas(whatever fields are exposed) to create reports/ answers. BIP is a Business intelligence publisher in which custom SQL can be written to required fetch fields.