Best practice to execute Oracle API by using a db custom user
HI, Thanks in advance.The issue is related with using Order Management Shipping Execution API.
Due to our shipping process, we have to run the Delivery by using "WSH_DELIVERIES_PUB.CREATE_UPDATE_DELIVERY" api. The problem is when we try to execute it by CUSTOM DB USER (other different from APPS). If i we execute same code using APPS db user it woks fine.
Is important clarify that the PKG is was created as APPS owner and a line before executes the api, we initialize the environment using the FND_GLOBAL.APPS_INITIALIZE giving User_id, Resonsibility_id and the Application_id.
Due to our shipping process, we have to run the Delivery by using "WSH_DELIVERIES_PUB.CREATE_UPDATE_DELIVERY" api. The problem is when we try to execute it by CUSTOM DB USER (other different from APPS). If i we execute same code using APPS db user it woks fine.
Is important clarify that the PKG is was created as APPS owner and a line before executes the api, we initialize the environment using the FND_GLOBAL.APPS_INITIALIZE giving User_id, Resonsibility_id and the Application_id.
0