Procurement - EBS (MOSC)

MOSC Banner

PO_REQUISITION_UPDATE_PUB to update requisition status to APPROVED

EBS 12.2.10

Database 19c (19.18.0.0.0)

I want to update requisition status from INCOMPLETE to APPROVED I am using below script. but it is not working although there is no error message and api returned S status.

DECLARE
l_req_hdr PO_REQUISITION_UPDATE_PUB.req_hdr;
l_req_line_tbl PO_REQUISITION_UPDATE_PUB.req_line_tbl;
l_req_dist_dtl PO_REQUISITION_UPDATE_PUB.req_dist_tbl;
l_return_status VARCHAR2(1);
l_msg_count NUMBER;
l_msg_data VARCHAR2(2000);
BEGIN
fnd_global.APPS_INITIALIZE(0, 21248, 178);

l_req_hdr.requisition_header_id := 2105033;
l_req_hdr.org_id := 103;
l_req_hdr.authorization_status := 'APPROVED';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center