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

    Oracle SCM


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




      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



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



          • 2. Re: Oracle SCM

            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 :
            Form Last Modified : $Date: 2010/03/30 12:18  $