In out application we want to separate data access from tables in a separate DA packages which would be called from API packages later on, so that no direct data access would be done form API packages. To get all the rows from one configuration table a pipelined function was created in DA package. Everything seemed to be working fine until we decided to implement a ACCESSIBLE BY clause in our DA package. Once we tried to call PIPELINED function in API package, we got error "PLS-904: insufficient privilege to access object"
I have created a small demo for this problem on Oracle Live SQL - https://livesql.oracle.com/apex/livesql/file/content_E16S1I95O85AURPDKVKNDQSOR.html
Is there any workaround (except for removing ACCESSIBLE BY clause or changing function form PIPELINED to normal one) to this issue?