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
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...
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.
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
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 18.104.22.168, 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
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".