NAME: ZPB: Enable Open SQL Access
SHORT CODE: ZPB_ENABLE_OSQL
MODULE: Oracle Enterprise Planning and Budgeting

Description: Enable Open SQL Access for non-APPS Schema
Navigation: Oracle Enterprise Planning and Budgeting Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• SchemaName : Schema Name
• BusinessAreaId : Business Area Id

NAME: ZPB: DVAC Writeback
SHORT CODE: ZPB_DVAC_WRITEBACK
MODULE: Oracle Enterprise Planning and Budgeting

Description: Data View Access Control Writeback
Navigation: Oracle Enterprise Planning and Budgeting Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• p_task_seq : Task Seq
• p_business_area_id : Business Area ID

NAME: ZPB: DVAC Task
SHORT CODE: ZPB_DVAC_TASK
MODULE: Oracle Enterprise Planning and Budgeting

Description: Data View Access Control Task Program
Navigation: Oracle Enterprise Planning and Budgeting Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• BP_ID : Business Process Definition Id
• instanceId : Business Process Run Id
• p_business_area_id : Business Area ID
• p_task_id : Task ID