2 Replies Latest reply on Aug 1, 2019 7:53 AM by John_K

    Oracle SCM

    4051611

      My Objective is "Oracle to prevent a tag from being entered twice when entering in counts during Physical Inventory Tag Counts for CCH OU"

       

      PHY INV.PNG

       

      Can you please give some idea about this and I want to know how to create the duplicate tag in physical inventory.

       

      I want to check the condition whether the tag number is repeated or not in physical inventory using plsql query through Form personalization.

       

      I don't know much about this topics. please give some hints

       

        • 1. Re: Oracle SCM
          Kanda-Oracle

          Hi

           

          can you check the form name (.fmb) and version.

           

          Thanks!

          • 2. Re: Oracle SCM
            John_K

            You don't need to - the standard functionality of the physical inventory tag entry is to use the newest record for the value. Try it - re-query the form for tag 1119 and you should see only a single value. If not, check your version - this is mine:

             

            ----------------------------------------
            Current Form
            ----------------------------------------
            Form Application : Inventory
            Form Name : INVADPTE
            Form Path : /ebshome/apps/apps_st/appl/inv/12.0.0/forms/US/INVADPTE.fmx
            Form Version : 12.0.7.12010000.13
            Form Last Modified : $Date: 2010/03/30 12:18  $