Click here for menu

How To Repair Po_actions.close_po Api Not Working (Solved)

Home > How To > Po_actions.close_po Api Not Working

Po_actions.close_po Api Not Working

Contents

Toolbox.com is not affiliated with or endorsed by any company listed at this site. Contributors Jyoti Mohanty Raghav Velicheti Ram Talluri Followers Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Purchasing System Configuration Use Of Pricing API (QP_PRICE_LIST_PUB.Process_Pric... Regards, -Anand Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving...

Quoting API Closing Purchase Orders in Batch/ Oracle API for Cancelling the PO Lines Not able to approve PO due to Currency rate_rate issue RCV interface transcation fail >> inv_lot_api_pub.auto_gen_lot is For the same I am trying with the API - po_actions.close_po Follwoing is the code I tried to close one PO, by simply hardcoding the values - DECLARE lv_result BOOLEAN; return_code Is it possible to have the release status to ‘Finally Closed' instead of ‘Closed' status?ReplyDeleteReddiApril 21, 2014 at 2:45 PMHI Sireesh,Does this script work for 11.5.10?I tried it and I am when i cancel the po order as apps user from schema B, the order is being cancelled but I cannot cancel the po order as user A in schema B.I running http://jyotioraapps.blogspot.com/2009/08/api-for-closingfinally-closing-po-using.html

Mass Close Of Purchasing Documents Oracle

Adding responsibility using fnd_user_pkg Script to Get Concurrent Request Details API To Cancel or Finally Close Requisition Manufacturing Strategies Manufacturing Concepts Reprocessing Period Close Pending Transactions API for Closing/Finally Closing PO The program is applicable to Standard Purchase Orders, Blanket Purchase Agreements, Planned Purchase Orders and Contract Agreement and Blanket Releases The program has an array of parameters that can be used, The Mass Close functionality applies to Purchase Orders that have been fully processed i.e. Use Of Oe_Order_Pub.Process_Order To Create Sale O...

  1. I did intiailze the apps env but still the return status is false and the po does not close..
  2. Newer Post Older Post Home Subscribe to: Post Comments (Atom) Search This Blog Loading...
  3. l_close_status := PO_ACTIONS.CLOSE_PO (p_docid => po_rec.po_header_id, p_doctyp => 'PA', p_docsubtyp => 'BLANKET', p_lineid => NULL, p_shipid => NULL, p_action => 'FINALLY CLOSE', p_return_code => l_return_code, p_auto_close => 'N', p_action_date => SYSDATE);The
  4. This status will not prevent you from matching an invoice to the purchase order or to the receipt.

Country Tracker Labels Apps Tech (12) Oracle Forms (7) SQL and PL/SQL (6) Tables (6) Flow cycles (4) Purchase Order(PO) (4) XML Publisher (4) Order Management(OM) (2) WorkFlow (2) 11i Vs Same way if shipment line has to be closed then header_id, line_id, line_location_id(shipment_id) has to be passed.

DECLARE
v_returned BOOLEAN;

If you close all of the line_locations of a po_line, then the po_line will be closed. Labels Accounts Payable (1) AOL (3) Inventory (7) Manufacturing (1) Oracle Pricing (1) Oracle Shipping Execution (4) Order Management (3) Purchasing (9) Blog Archive ► 2010 (2) ► April (2) ▼ You can not post a blank message. This tool uses JavaScript and much of it will not work correctly without it enabled.

What is the P_DOCSUBTYP parameter I must pass? It was really helpful.Currently we are using the PO_ACTIONS.CLOSE_PO to close blanket releases. I tried thru the interface tables where using UPDATE action and mentioning the line number as the same line number of the item and shipping number as the next available shipping Requisitions can only be Finally Closed To manually close a purchasing document from the Purchasing responsibility navigate to Purchase Order Summary or Requisition Summary form and navigate to the Control Document

How To Close Po In Oracle Apps

REGEXP_REPLACE function & SQL Query to remove Non-Numeric characters from a String REGEXP_REPLACE function replaces string with regular expression matching supports. http://udaysoma.blogspot.com/2010/11/finally-close-po-h-po-line.html Eg: If only line has to be closed then pass line_id along with header_id. Mass Close Of Purchasing Documents Oracle DECLARE x_return_code VARCHAR2(100); l_progress VARCHAR2(100); l_result BOOLEAN; BEGIN apps.fnd_client_info.set_org_context('81'); fnd_global.apps_initialize(6338,50258,201); l_result := PO_ACTIONS.CLOSE_PO( P_DOCID => 13811, P_DOCTYP => 'PO', P_DOCSUBTYP => 'STANDARD', P_LINEID => 0,--23152, P_SHIPID => 0,--22990, P_ACTION => 'CLOSE', How To Close Purchase Order In Oracle Apps R12 Oracle Time & Labor(OTL) - Timecard, Project detai... ► November (15) ► October (3) Visitors Wizpert About Me Raja Sekhar Atmakuri Sireesh Vishnubhatla Total Pageviews Sireesh Vishnubhatla.

This must be -- entered for Manual Closing and is used by the Funds Checker -- p_return_code : Return Status of PO Closing -- p_auto_close : Whether to Specify the action (CLOSE or FINALLY CLOSE) and the closed reason, call the below procedure to mass close PO. Powered by Blogger. Though I have not tested the program in 11.5.10.2, but I feel the program should over there as well.Rgds,JyotiReplyDeleteRepliesranjith kumarJune 12, 2014 at 10:50 PMHi Jyoti,I have used the below API How To Open A Closed Purchase Order In Oracle Apps

Daily used Apps scripts by Oracle AppsTechnical consultant SQL Query to find Parameters and Value Sets associated with a Concurrent Program SELECT fcpl.user_concurrent_program_name "Co... We have to pass P_ACTION parameter value as 'CLOSE'/'FINALLY CLOSE' depending on the requirement to close a Purchase Order --Sample wrapper procedure to close purchase order CREATE OR REPLACE xx_po_close_prc(p_header_id NUMBER) Then it works properly. Members Blog Archive ► 2014 (10) ► June (2) ► May (2) ► April (2) ► March (2) ► February (2) ► 2013 (14) ► December (3) ► November (1) ►

All rights reserved. This must be entered for Manual Closing -- p_calling_mode : Whether being invoked from 'PO', 'RCV' or 'AP'. The standard logic of this API will be the following : after closing the shipment line, the program will control the related po line, if all shipment line are closed or

Is it possible to have the release status to ‘Finally Closed' instead of ‘Closed' status?ReplyDeleteSridevi KoduruAugust 22, 2014 at 4:47 AMI am Sridevi Koduru, Senior Oracle Apps Trainer at Oracleappstechnical.com With

Glad to hear that your program is working fine.Rgds,JyotiReplyDeleteAnonymousMay 11, 2010 at 4:01 AMhiI applied the script on a PO and it is executed successfully. I was struggling with the parameters of this function. This parameter should be set to 'N'.-- R12 - PO - Script to Close / Finally Close PO using PO_ACTIONS CLOSE_PO API.sqlDECLAREx_action constant varchar2(20) := 'FINALLY CLOSE'; -- Change this parameter Home Technical Functional Documents Advanced Technologies About me Sunday, December 18, 2011 How to programmatically close PO using PO_ACTIONS API PO_ACTIONS.CLOSE_PO is the API used to programmatically close/final close Purchase Order.

Labels BOM/WIP (1) CUSTOM.PLL (1) General (7) Interface (2) Inventory (1) OAF (1) OM (7) PO (2) R12 (1) Useful Links (1) About Me Uday Somavarapu NY, United States View my Since you do not require or expect any further activity, Purchasing closes the purchase order. Newer Post Older Post Home Subscribe to: Post Comments (Atom) Useful Links Ask Tom E-Business Suite Know Oracle Apps Oracle Apps Documentation Oracle Apps Online Help Oracle Integration Repository Oracle Metalink Another Parameter which needs to set properly is "p_auto_close".