Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-22304

RDS -> Difference between Safety Stock XML and Vault (RDS) endpoint

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: CFA 2022R5
    • Component/s: Reports
    • Labels:
      None
    • VTask #:
      VTASK0501764
    • Root cause - Reason:
      Configuration
    • Root Cause:
      date ranges have been removed from the sp to make it same with the inform version.

      Description

      CFA business consumer is working to get connected to our Safety Stock endpoint in Vault (RDS) so they can stop using the XML from InFORM. They noticed a difference in the data between the current XML in prod, and the Vault JSON endpoint. For one example, a vendor is showing 13 items in the XML, but the JSON has 30 items.

      (Location: 04401, Date: 10/2/2022, Vendor Id: 139)

       The XML and JSON are attached for reference.

       

       I think I found the issu, the XML file includes only items without a discontinue date  (Active items only), while the RDS export includes all items.

       

      Select * from tbVendorEntityItem where EntityID = 5166 and VendorID = 139

       

       

        Attachments

        1. Vault Safety Stock Payload.json
          298 kB
        2. sp_getsafetystockexportdata.sql
          2 kB
        3. screenshot-4.png
          screenshot-4.png
          123 kB
        4. screenshot-3.png
          screenshot-3.png
          156 kB
        5. screenshot-2.png
          screenshot-2.png
          33 kB
        6. screenshot-1.png
          screenshot-1.png
          14 kB
        7. Safety_04401_PRODUCE PROGRAM_20221002.xml
          8 kB
        8. image-2022-10-11-11-23-08-226.png
          image-2022-10-11-11-23-08-226.png
          115 kB

          Issue Links

            Activity

              People

              • Assignee:
                wesam.el-gendy Wesam El-Gendy
                Reporter:
                wesam.el-gendy Wesam El-Gendy
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.