1 Reply Latest reply: Oct 8, 2013 4:30 AM by 994170 RSS

    Getting error after submitting import standard purchase order from localization responsibility

    994170

      Hi All,

      I have manully inserted data in header,line,distribution interface table like below

      INSERT INTO po_headers_interface

      (interface_header_id,process_code,action,org_id,document_type_code,document_num,currency_code,vendor_name,vendor_id,vendor_site_code,vendor_site_id,comments,

      vendor_doc_num,amount_agreed,effective_date,expiration_date,vendor_contact,approval_status,terms_id,agent_id,creation_date,created_by,last_update_date,last_updated_by)

      VALUES  

      (po_headers_interface_s.NEXTVAL,'PENDING','ORIGINAL','7046','STANDARD','454545','INR','Madhura Enterprises','40179',NULL,'13922','XYZ',null,null,sysdate,sysdate+10,null,

      'Approved',13922,25,SYSDATE,fnd_global.user_id,SYSDATE,fnd_global.user_id);

       

      INSERT INTO po_lines_interface

      (interface_line_id,interface_header_id,process_code,line_num,item_id,item_description,uom_code,unit_of_measure,quantity,unit_price,ship_to_organization_id,ship_to_location_id,

      need_by_date,promised_date,last_update_date,last_updated_by,creation_date,created_by,line_type_id,vendor_product_num,note_to_vendor,shipment_num,closed_code,closed_reason,CATEGORY_id,tax_code_id)

      VALUES

      (po_lines_interface_s.NEXTVAL,po_headers_interface_s.CURRVAL,'PENDING',1,'208956','ESSEL CAPITAL ITEM','Ea','Each',2,100,'7087',

      '22885',SYSDATE+1,SYSDATE+1,SYSDATE,fnd_global.user_id,SYSDATE,fnd_global.user_id,'1',NULL,'aaaaaa','1',NULL,NULL,'1','1000');

       

      INSERT INTO po_distributions_interface

      (interface_header_id,interface_line_id,interface_distribution_id,distribution_num,quantity_ordered,quantity_delivered,quantity_billed,quantity_cancelled,destination_type_code,deliver_to_location_id,

      deliver_to_person_id,charge_account,charge_account_id,creation_date,created_by,project_id,expenditure_item_date)

      VALUES

      (po_headers_interface_s.CURRVAL,po_lines_interface_s.CURRVAL,po_distributions_interface_s.NEXTVAL,'1','2',NULL,NULL,NULL,

      'INVENTORY','22885','24',NULL,'134793',SYSDATE,fnd_global.user_id,NULL,NULL);

       

       

      When i am submitting the standard program then i am getting following error---

       

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_ERR_UTL. Procedure add_fatal_error.0

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_ITEM_PROCESS_PVT. Procedure update_master_item.60

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_ITEM_PROCESS_PVT. Procedure create_items.60

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_lines_add.70

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_lines.10

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process.10

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_PVT. Procedure start_process.110

      User-Defined Exception in Package po.plsql.PO_PDOI_Concurrent. Procedure POXPDOI.30

       

       

      Please help me in this issue.. when i am running this on vision without tax code it is working fine.

      But in localization its not working. Basically i need to do scripting for india localization for Open PO.

       

      The application Details -

      RDBMS : 11.1.0.7.0

      Oracle Applications : 12.1.3