Po_change_api1_s.update_po Error
Contents |
following columns can be updated in a Purchase Order.- Promised_date- Need_by_date- Quantity- api for purchase order in oracle apps Unit_priceImportance of LAUNCH_APPROVALS_FLAG=================================- Indicates if you want to
Api To Create Purchase Order In Oracle Apps
launch APPROVAL workflow after the update. Its value could be either 'Y' or 'N'.
Api To Update Po_distributions_all
If not provided, the default value is 'N'.- If we are passing launch_approvals_flag =>'N', the PO is remaining in the Requires Reapproval
Po_document_update_grp
status.Post Update PO Validation: ====================1. Set the PO status to REQUIRES REAPPROVAL.2. Increment revision number if the PO was in APPROVED status before the update.3. Launch the PO Approval workflow if LAUNCH_APPROVALS_FLAG = 'Y'.4. If the quantity was adjusted down to be equal to the po_change_api1_s.update_po in 11i total quantity received or billed, then set the appropriate closed code and roll up the closed code to line and header levels.-- R12 - PO - Sample Script to Update PO Using po_change_api1_s--=================================================DECLARECURSOR po_date_updateISSELECT pha.segment1 po_number, pha.revision_num,pha.po_header_id,pha.authorization_status, pla.po_line_id, pla.line_num, pha.org_id,pla.unit_price, pola.line_location_id, pola.shipment_num,pola.quantity, pola.promised_date, pola.need_by_date,pha.closed_codeFROM po_headers_all pha, po_lines_all pla,po_line_locations_all polaWHERE pha.po_header_id = pla.po_header_idAND pla.po_line_id = pola.po_line_idAND NVL (pha.approved_flag, 'N') = 'Y'AND NVL (pola.cancel_flag, 'N') <> 'Y'AND NVL (pola.closed_code, 'OPEN') = 'OPEN'AND NVL (pola.quantity_received, 0) = 0AND NVL (pola.quantity_billed, 0) = 0AND pha.segment1 = '11170007326'AND pla.line_num = 1AND pha.type_lookup_code = 'STANDARD'AND pha.org_id = 308;l_user_id NUMBER;l_resp_id NUMBER;l_appl_id NUMBER;l_result NUMBER;l_api_errors po_api_errors_rec_type;l_revision_num NUMBER;l_promised_date DATE;l_need_by_date DATE;l_price po_lines_all.unit_price%TYPE;l_quantity po_line_locations_all.quantity%TYPE;BEGINSELECT user_idINTO l_user_idFROM fnd_userWHERE user_name = 'CONVERSION';SELECT responsibility_id, application_idINTO l_resp_id, l_appl_idFROM fnd_responsibility_vlWHERE responsibility_name = 'Purchasing Super User';fnd_global.apps_initialize (l_user_id, l_resp_id, l_appl_id);FOR i IN po_date_updateLOOPmo_global.set_policy_context ('S', i.org_id);mo_global.init ('PO');l_promised_date := i.promised_date + 30;l_need_by_date :
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP api to update po in oracle apps SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows "po_distributions_pkg1 < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant api to create purchase order in oracle apps r12 DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi http://jyotioraapps.blogspot.com/2009/10/updating-po-using-pochangeapi1supdatepo.html Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES Wave Direct Avaya Pivotal CRM SendGrid View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Applications Your premier resource for objective technical discussion and peer-to-peer support on Oracle Applications. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed http://oracle.ittoolbox.com/groups/technical-functional/oracle-apps-l/po_change_api1_s-and-update_po-1188180 in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. PO CHANGE API1 S and UPDATE PO Jawa2006 asked Sep 27, 2006 | Replies (1) Does anyone have an example of a call to PO_CHANGE_API that successfully updates the promised date? I can update quantity and price when promised date is null, but if I make the date equal to_date('09/27/06','mm/dd/yy') or any other date it does not do anything. Idea anyone? Join this group Popular White Paper On This Topic Business Intelligence with SharePoint 2010 1Reply Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... San
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your https://community.oracle.com/thread/3878972 message and try again. More discussions in Procurement All PlacesOracle ApplicationsE-Business SuiteEnterprise Resource Planning https://community.oracle.com/thread/2135297 (ERP)Procurement This discussion is archived 4 Replies Latest reply on Mar 3, 2016 8:07 AM by 885148 Purchasing API 885148 Dec 21, 2015 4:56 AM Deal All,I have a requirement to - (a) Bulk update some PO data (like Need By Date, promise Date etc).(b) Auto-increment the revision.(c) Auto-approve the PO.Could you please help me with points b in oracle and c as how I am auto increment the PO Revision after the updates are done and how I can auto approve the PO (the new approver should be same as last approver).Thanks,Amit 726Views Tags: none (add) po mass updateContent tagged with po mass update This content has been marked as final. Show 4 replies 1. Re: Purchasing API Jignesh Makwana Dec 21, 2015 5:33 AM (in response to 885148) Hi Amit,You can in oracle apps try with Data Loader software ? Regards,Jignesh Like Show 0 Likes(0) Actions 2. Re: Purchasing API 885148 Dec 21, 2015 5:44 AM (in response to Jignesh Makwana) Hi Jignesh,This will be a new application which will give the users the facility to mass update the PO dates (and attachments).Hence we cant use data loader.Basically the proposed design is as under - User uploads the data from an excel into a OAF page.From this excel the data is inserted into a staging table.Then there will be an Oracle concurrent program (custom) which will read data from the staging table and update into standard tables along with revision increment and approval.Thanks,Amit Like Show 0 Likes(0) Actions 3. Re: Purchasing API Vanha.L-Oracle Dec 30, 2015 6:43 PM (in response to 885148) Hello Amit,You should be able to update existing PO and automatically increase revision. This is standard revision control for PO document.This is per standard documentation:"For the Update action code, the document revision number is increased every timethe unit Price, item Description, UOM, or Expiration Date is updated, or when anew line is added (unless Archive on Approval is chosen in the Document Typeswindow and PO: Archive Catalog on Approval is set to No)."To approve the update, you can pass LAUNCH_APPROVALS_FLAG = 'Y' for the API.The following notes hav
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Procurement All PlacesOracle ApplicationsE-Business SuiteEnterprise Resource Planning (ERP)Procurement This discussion is archived 2 Replies Latest reply on Dec 1, 2010 1:20 PM by 806776 How to update amount for Complex PO (Contracts) 794899 Nov 21, 2010 11:10 AM We have a requirement where in we need to update the line amount or shipment (pay item) amount for complex PO (contracts) through an api we find that the PO update api PO_CHANGE_API1_S.update_po does not have the amount field as a parameter,it only has price and quantity, neither does the PO Interface allow updating the existing line information. PO Interface only allows adding new lines to standard PO. In this scenario, what is the best approach to update the line amount and the shipment amount in the PO? I have the same question Show 0 Likes(0) 252Views Tags: none (add) contractsContent tagged with contracts, poContent tagged with po, updateContent tagged with update This content has been marked as final. Show 2 replies 1. Re: How to update amount for Complex PO (Contracts) 813340 Nov 26, 2010 8:42 AM (in response to 794899) The API PO_CHANGE_API1_S is a backward compatible API. This does not support all the attributes. You can try using the new API "PO_DOCUMENT_UPDATE_PVT" directly. This new API accepts the Change Objects which can even support amount also. Like Show 0 Likes(0) Actions 2. Re: How to update amount for Complex PO (Contracts) 806776 Dec 1, 2010 1:20 PM (in response to 794899) Not very sure if the API might be capable of handling the changes for Complex Work POs. if that works, very good. Else, I would suggest you to write a datafix script and run it thru Oracle support for review. This should be done only to rectify errors. If you are looking for a regular solution, this does not work. Like Show 0 Likes(0) Actions Go to original post Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , r