IJ36064: DATA IMPORT VIA MIF DE-LINKS THE EXISTING PO (PURCHASE ORDER) RELATIONSHIP FROM A PR (PURCHASE REQUISITION).

APAR status

• Closed as program error.

Error description

• DESCRIPTION:
  
  Data Import of POLINE with action="DELETE", delinks the
  relationship of existing Purchase Order from a closed Purchase
  Requisition.
  
  
  STEPS TO REPRODUCE:
  1) Go to Purchasing -> Purchase Requisitions
  i) Create a new PR: 1_TESTPR;
  ii) Switch to PR Lines; Under PRLines, Click on New Row;
  (a) Add an Item for Line1; 0-0031; Quantity: 20; Order Unit:
  EACH; Unit Cost: 10;
  (b) Line Cost: 10; Charge To Storeroom: CENTRAL; Conversion
  Factor:1;
  iii) Save; Approve Purchase Requisition;
  iv) From More Actions; Create PO: 1_TESTPO
  v) Observe the PR is in CLOSE status and the status is not
  allowed to be changed from the UI.
  vi) Under View Related records, we can see the relationship for
  PO: 1_TESTPO
  
  
  2) Go to Purchase Orders; PO: 1_TESTPO;
  i) Observe the PO is in WAPPR status.
  ii) Add Company: SKF; Switch to POLines Tab; Change the Quantity
  to: 5; Save; Approve the Purchase Order
  
  
  3) Create an xml file for data import with a new PO Number(say:
  2_TESTPO), but the same PR: 1_TESTPR (which is closed earlier)
  and include <POLINE action="Delete"> in the xml content.
  
  
  4) Go to Integrations; External Systems;
  i) System: EXTSYS1; Switch to Enterprise Services; Filter for
  MXPOInterface Enteprise Service
  ii) Perform Data Import of the xml file.
  
  
  5) Contents of the sample xml file used to reproduce the issue
  are shown here:
  <?xml version="1.0" encoding="UTF-8"?>
  <SyncMXPO xmlns="http://www.ibm.com/maximo">
  <MXPOSet>
  <PO action="AddChange">
  <CURRENCYCODE>USD</CURRENCYCODE>
  <HISTORYFLAG>0</HISTORYFLAG>
  <ORDERDATE>2021-09-21T00:00:00+02:00</ORDERDATE>
  <ORGID>EAGLENA</ORGID>
  <PONUM>2_TESTPO</PONUM>
  <POTYPE>STD</POTYPE>
  <PRIORITY>0</PRIORITY>
  <RECEIPTS>NONE</RECEIPTS>
  <SITEID>BEDFORD</SITEID>
  <STATUS>APPR</STATUS>
  <STATUSDATE>2021-09-21T08:01:59.419262+02:00</STATUSDATE>
  <VENDOR>SKF</VENDOR>
  
  <POLINE action="Delete">
  <CATALOGCODE />
  <ENTERBY>MXINTADM</ENTERBY>
  <DESCRIPTION>TEST POLINE</DESCRIPTION>
  <ENTERDATE>2021-09-21T08:01:59.419262+02:00</ENTERDATE>
  <ITEMNUM>0-0031</ITEMNUM>
  <ITEMSETID>SET1</ITEMSETID>
  <LINETYPE>ITEM</LINETYPE>
  <ORDERQTY>5.00</ORDERQTY>
  <ORDERUNIT>EACH</ORDERUNIT>
  <ORGID>EAGLENA</ORGID>
  <CONVERSION>1</CONVERSION>
  <POLINENUM>1</POLINENUM>
  <STORELOC>CENTRAL</STORELOC>
  <PL1/>
  <PRLINENUM>1</PRLINENUM>
  <PRNUM>1_TESTPR</PRNUM>
  <SITEID>BEDFORD</SITEID>
  <TOSITEID>BEDFORD</TOSITEID>
  <UNITCOST>10</UNITCOST>
  </POLINE>
  </PO>
  </MXPOSet>
  </SyncMXPO>
  
  
  
  RESULT:
  
  Observe the import is successful and
  1) PO Reference of Old PO: 1_TESTPO is removed from the CLOSED
  PR: 1_TESTPR
  2) 1_TESTPR which was closed earlier shows the status as APPR.
  
  
  EXPECTED RESULT:
  1) MIF to throw an error that the import cannot be performed
  against the PR which is already having a PO.
  2) Delinking of PO should not happen. In this case, delinking of
  PO: 1_TESTPO from the closed PR: 1_TESTPR should not happen.
  3) POLINE with action="DELETE" should give an error as the
  POLINE doesn't exist yet as it?s a new PO which is created as
  part of the Import.
  
  
  REPORTED IN VERSION: Tivoli's process automation engine 7.6.1.1
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Data Import of POLINE with action="DELETE", delinks the      *
  * relationship of existing Purchase Order from a closed        *
  * Purchase Requisition.                                        *
  ****************************************************************
  

Problem conclusion

• _The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 7.6.1.3 Product_
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INTEGRATION

• Fixed component ID

  5724R46I1

Applicable component levels