Inventory

Get Involved. Join the Conversation.

Topic

    Shravan Kumar Chelika
    REST Webservices to get Cycle Count items within a LocatorAnswered
    Topic posted July 19, 2018 by Shravan Kumar ChelikaRed Ribbon: 250+ Points, tagged Inventory Cloud, SCM 
    249 Views, 11 Comments
    Title:
    REST Webservices to get Cycle Count items within a Locator
    Summary:
    Looking for REST Webservice which would return cycle count items based on Cycle count name and Locator
    Content:

    Hi All,

    I am trying to get Cycle count items within a locator, is there a webservice available to get this information?

    Here is my process :

    I am using REST Webservices Rel 13 18 A for doing Cycle count.

    1. Get cycle count definitions information using : /fscmRestApi/resources/11.13.18.02/cycleCountDefinitions

    2.Get Cycle Count subinventories associated with the cycle count name selected above : /fscmRestApi/resources/11.13.18.02/cycleCountDefinitions/{CycleCountHeaderId}/child/countSubinventories

    3.Get all locator within the subinventory selected above : /fscmRestApi/resources/11.13.18.02/activeLocators?q=SubinventoryCode=Stores

    Once the locator is selected, I would like to show the cycle count items within that locator for that Cycle Count

    the existing webservice : /fscmRestApi/resources/11.13.18.02/cycleCountDefinitions/{CycleCountHeaderId}/child/countItems does not support it, the output would give you the items for that Cycle count but does not include locator/subinventory information in it.

    {
      "items" : [ {
        "CycleCountItemId" : 300100002756510,
        "InventoryItemId" : 663838,
        "ItemNumber" : "CYC01-100",
        "ItemDescription" : "Plain Item",
        "AbcClassId" : 42,
        "AbcClass" : "Class A",
        "IncludeInScheduleCode" : 1,

     

    Best Comment

    Lynn Warneka

    If you want to get Cycle Count Sequences, you are using the right service, Details for Cycle Count Sequences.   Yes, you will have to filter it for pending (open) count sequences.   Cycle Count Definition will only give you how the cycle count was defined originally.  It will not have the details of what/when to count that include locators.  

    For a given cycle count -  it's not certain that you count all locators within an existing subinventory.   That may be the case for your particular customer, but not all customers.    Cycle Count Sequences provides the definitive list of what to count based on how the cycle count was defined. 

    Comment

     

    • Lynn Warneka

      Can you please clarify what your business requirement is?   The REST resources you are using are for the Cycle Count Definition.   This is where you setup an initial cycle count.   After that, Count Sequences are generated that will give the specifics on what to count and where.  The Count Definition will not have locator/subinventory information in it which is what you are observing.  

    • Shravan Kumar Chelika

      Hello Lynn - Thanks for the response..

      Here is my requirement :

      1.Prompt user to select or Enter cycle count name                                                                                                  - REST Webservice Available

      2.Based on the Cycle count name selected, display the Sub inventories for the cycle count.                                 - REST Webservice Available

      3.If Subinventory selected is a Locator Controlled Subinventory – Display the Locators within the Sub inventory.  - REST Webservice Available

      4.Based on the Locator selected by the User, display all the items within the locator. (What is the webservice that can be used to get all the items within the locator for that Cycle count name?)

      5.Based on the item selected by User, prompt to enter the count for the item.

      6.Record the count entered.

      7.Submit the Transaction to completed cycle count.                                      - REST Webservice Available

    • Lynn Warneka

      I believe you are talking about Cycle Count Sequences and not Cycle Count Definition.  Please send a screen shot that is displaying the info you are looking for so I can be sure . 

    • Shravan Kumar Chelika

      Lynn - Please check the document (EBS Inventory Cycle Counting in DSI Mobile Client), this is a mobile app version screenshots for Oracle EBS Cycle count, we are trying to design the same process for Oracle Cloud Cycle counting.

      Also attached is the document which shows the screenshots of all the webservices we are using to complete the Cycle Count process.

    • Shravan Kumar Chelika
    • Lynn Warneka

      From the Inventory Management Cloud product, please get a screen shot of the screen(s)  you are referring to.  EBS and Cloud are very different when it comes to cycle counting.    Also, are you also working this issue via   SR 3-17925615691  ?  

    • Shravan Kumar Chelika

      Attached is the screenshot of the Record Count Sequences..

      We would like to implement the same screen..when the user enters the 'Cycle Count Name' and the Cycle count Subinventory and if it is a locator controlled subinventory, show them all the locators existing within the subinventory and then based on the combination of Cycle count name,Subinventory and locator we would like to show the items existing so they can record the count against the items.

      Yes, I have also logged the SR with Oracle support and waiting on their feedback.

       

    • Lynn Warneka

      Since you are looking for Cycle Count Sequences -  You'll want to look at the "Details for Cycle Count Sequences"  REST API.   

      https://docs.oracle.com/en/cloud/saas/supply-chain-management/18b/fasrp/api-details-cycle-count-sequences.html

    • Shravan Kumar Chelika

      Thanks for the response...I could see the data similar to the Cloud application screens using the webservice you mentioned...I had to filter the service to return the information I need, could you please check the document and see if it seems right.Attached is the document with screen shots..

    • Lynn Warneka

      If you want to get Cycle Count Sequences, you are using the right service, Details for Cycle Count Sequences.   Yes, you will have to filter it for pending (open) count sequences.   Cycle Count Definition will only give you how the cycle count was defined originally.  It will not have the details of what/when to count that include locators.  

      For a given cycle count -  it's not certain that you count all locators within an existing subinventory.   That may be the case for your particular customer, but not all customers.    Cycle Count Sequences provides the definitive list of what to count based on how the cycle count was defined. 

    • Shravan Kumar Chelika

      Thank you Lynn...Appreciate your responses...That was helpful..