Solved

PURCHASE_ORDER_LINE_API.New__ not working

  • 17 November 2023
  • 3 replies
  • 179 views

Badge +2

I want to create Purchase order line via  PURCHASE_ORDER_LINE_API.New__.

when I pefrom  “PURCHASE_ORDER_LINE_API.New__(info_,objid_,objversion_,attr_,'CHECK');” no error message. but I change to  “PURCHASE_ORDER_LINE_API.New__(info_,objid_,objversion_,attr_,'DO');” it dispaly  “4246591008” is not a valid integer value.

my script as beolow

DECLARE
          info_ VARCHAR2(32000);
          objid_ VARCHAR2(2000);
          objversion_  varchar2(300);
          attr_ VARCHAR2(32000);   
       BEGIN   
     -- TBOOLENSTRING:=TRUE;   
      Client_SYS.Clear_Attr(attr_);
      --Client_SYS.Add_To_Attr('BUYER_CODE','3HB03', attr_);-
      Client_SYS.Add_To_Attr('ORDER_NO','10112', attr_);
      Client_SYS.Add_To_Attr('BUY_QTY_DUE','100', attr_);
      Client_SYS.Add_To_Attr('DATE_ENTERED',sysdate, attr_);
      Client_SYS.Add_To_Attr('LAST_ACTIVITY_DATE',sysdate, attr_);
      Client_SYS.Add_To_Attr('PLANNED_DELIVERY_DATE',sysdate, attr_);
      Client_SYS.Add_To_Attr('PLANNED_ARRIVAL_DATE',sysdate, attr_);
      Client_SYS.Add_To_Attr('PROMISED_DELIVERY_DATE',sysdate, attr_);
      Client_SYS.Add_To_Attr('WANTED_DELIVERY_DATE',sysdate, attr_);
      Client_SYS.Add_To_Attr('PLANNED_RECEIPT_DATE',sysdate+2, attr_);
      Client_SYS.Add_To_Attr('CONTRACT','S01', attr_);
     -- Client_SYS.Add_To_Attr('ORIGINAL_QTY','100', attr_);
     -- Client_SYS.Add_To_Attr('COMPANY','S01', attr_);
      --Client_SYS.Add_To_Attr('REVISED_QTY','100', attr_);
      Client_SYS.Add_To_Attr('PURCHASE_SITE','S01', attr_);
      Client_SYS.Add_To_Attr('PART_NO','101000160016', attr_);
      Client_SYS.Add_To_Attr('CURRENCY_TYPE','1', attr_);
      Client_SYS.Add_To_Attr('BUY_UNIT_MEAS','根', attr_);
      Client_SYS.Add_To_Attr('LINE_NO',1, attr_);
      Client_SYS.Add_To_Attr('RELEASE_NO',1, attr_);
      Client_SYS.Add_To_Attr('ADDITIONAL_COST_AMOUNT','0', attr_);
      Client_SYS.Add_To_Attr('BUY_UNIT_PRICE','0.94', attr_);
      Client_SYS.Add_To_Attr('ADDITIONAL_COST_INCL_TAX',0, attr_);
      Client_SYS.Add_To_Attr('BUY_UNIT_PRICE_INCL_TAX','1.06', attr_);
      Client_SYS.Add_To_Attr('CONV_FACTOR',1, attr_);
      Client_SYS.Add_To_Attr('CURRENCY_RATE',1, attr_);
      Client_SYS.Add_To_Attr('FBUY_UNIT_PRICE','0.94', attr_);
      Client_SYS.Add_To_Attr('FBUY_UNIT_PRICE_INCL_TAX','1.06', attr_);
      Client_SYS.Add_To_Attr('CLOSE_CODE','Automatic', attr_);
      Client_SYS.Add_To_Attr('PRICE_CONV_FACTOR',1, attr_);
      Client_SYS.Add_To_Attr('DEMAND_CODE','Invent Order', attr_);
      Client_SYS.Add_To_Attr('ORD_CONF_REMINDER','No Order Reminder', attr_);
      Client_SYS.Add_To_Attr('DELIVERY_REMINDER','No Delivery Reminder', attr_);
      Client_SYS.Add_To_Attr('RECEIVE_CASE','Receive into Arrival, Inspect at Arrival', attr_);
      Client_SYS.Add_To_Attr('PURCHASE_PAYMENT_TYPE','Normal', attr_);
      Client_SYS.Add_To_Attr('AUTOMATIC_INVOICE','Manual Invoicing', attr_);
      Client_SYS.Add_To_Attr('ADDR_FLAG','No', attr_);
      Client_SYS.Add_To_Attr('DEFAULT_ADDR_FLAG','Yes', attr_);
      Client_SYS.Add_To_Attr('INVOICING_SUPPLIER','S00042', attr_);
      Client_SYS.Add_To_Attr('TAXABLE','True', attr_);
      Client_SYS.Add_To_Attr('INVENTORY_PART','True', attr_);
      Client_SYS.Add_To_Attr('PROJECT_ADDRESS','No', attr_);
      Client_SYS.Add_To_Attr('INTRASTAT_AFFECTED','False', attr_);
      Client_SYS.Add_To_Attr('TAX_LIABILITY','TAX', attr_);
      Client_SYS.Add_To_Attr('TAX_LIABILITY_TYPE','Taxable', attr_);
      --Client_SYS.Add_To_Attr('ORD_CONF_REM_NUM',0, attr_);
      --Client_SYS.Add_To_Attr('DELIVERY_REM_NUM',0, attr_);
      PURCHASE_ORDER_LINE_API.New__(info_,objid_,objversion_,attr_,'DO');
      END;
      
      
      

 

icon

Best answer by hhy38 17 November 2023, 12:54

View original

3 replies

Userlevel 5
Badge +14

Hi @rosicky.gui 

 

First of all, start with mandatory columns. After that, add columns one by one. And use the API below.

 

ifsapp.purchase_order_line_part_api.new__(info_,objid_,objversion_,attr_,'DO');
Badge +2

thank you very much. can you also inform me how to check restful API list?

Userlevel 5
Badge +14

@rosicky.gui 

You can find all the handlings with this query.

 

SELECT * FROM ifsapp.FND_PROJECTION t WHERE upper(t.projection_name) LIKE UPPER('%purchase%order%line%')

 

To see methods of the service. You can use the URL below. It includes the handling name.

 

https://url:port/main/ifsapplications/projection/v1/PurchaseOrderLinesHandling.svc/$openapi?V3

Reply