API for Closing/Finally Closing PO Using po_actions.close_po API for closing or finally closing the POs. In this API, there is a parameter "p_action" which we need to set as either CLOSE (if we want to close the PO) or FINALLY CLOSE (If we want to Finally Close) the PO. Another Parameter which needs to set properly is "p_auto_close". This parameter should be set to 'N'. /*oracle R12 : PO - Script to Close / Finally Close PO using PO_ACTIONS CLOSE_PO API.sql*/ DECLARE x_action constant varchar2(20) ...
Initializing the session oracle Apps R-12 FND_GLOBAL.APPS_INITIALIZE is used for initializing the session before calling any public or private API’s in Oracle EBusiness suite. Its not required for all the API’s but its recommended that you set this profile before making any calls to either private or public API. Listed below is a sample call to FND_GLOBAL.APPS_INITIALIZE function fnd_global.APPS_INITIALIZE(user_id=>l_user_id, ...
concurrent program parameter
Query to find concurrent request,requester,parameter and completion time
posted on , by Unknown
Query to find concurrent request,requester,parameter and completion time Sharing query to find all the information while running concurrent program like its parameter, who have run the program,actual start and completion time,current status and responsibility etc. SELECT REQUEST_ID, PHASE_CODE, STATUS_CODE, RESPONSIBILITY_ID, ...
Query to find Employee details,location and user Sharing query to find employee details based on its location.You can get user name,employee id etc. SELECT DISTINCT PER.FULL_NAME, PER.EMAIL_ADDRESS, FU.USER_NAME, PER.NATIONAL_IDENTIFIER, ...
