3 Replies Latest reply on Jul 31, 2018 1:26 PM by Michael Ferrante-Oracle

    Upload a Document Or Pdf File in a 1st form and Retrieve it in 2nd form(10g forms)

    1002933

      Hi All,

       

      My new requirement is upload a document or PDF File in 1st form and Retrieve same in 2nd form am using 10g forms , i created two different forms (different tables also)

       

      Form 1  xx_form_one  common field  doc_number,

      Form 2  xx_form_two   common field  doc_number,

       

      both forms having common field doc_number;

      please suggest

        • 1. Re: Upload a Document Or Pdf File in a 1st form and Retrieve it in 2nd form(10g forms)
          Michael Ferrante-Oracle

          Please clarify a few points:

           

          1.  Exactly which Forms version are you using?

           

          2.  Note that "Forms" doesn't store documents.  Actually, "Forms" doesn't store anything.  Forms simply allows you to manage data that is stored in the database.  So, given that, where are these "documents" located before touched by "Forms"?  Do they originate on the user's machine, middle tier server, or in the db?

           

          3.  What is the actual destination for these documents?  User's machine, middle tier machine, in db?

           

          4.  Are you familiar with WebUtil?

           

          5.  Is the application part of or an extension of Oracle EBusiness Suite or other Oracle build application?

          • 2. Re: Upload a Document Or Pdf File in a 1st form and Retrieve it in 2nd form(10g forms)
            1002933

            Hi  Mr. Michael we are using Oracle E-Business Suite, those are scan copies of documents one or two pages ..we want to save those in oracle database we have oracle default attachment  functionality in form one that is master form and in second form we need to show download option to users at least url of attached document of form one. ? we are using  

            Oracle Applications : 12.1.3  ,

            Forms Version : 12.0.15.12010000.10 

            APPSTAND : 12.0.6.12010000.6

            FNDSCSGN : 12.0.15.12010000.10

            TEMPLATE : 12.0.0

             

            Forms PL/SQL

            ----------------------------------------

            APPCORE : 12.0.29.12010000.22

            CUSTOM : 12.0.0

            FNDSQF : 12.0.3.12010000.8

            GHR : 12.0.46.12010000.81

            GLOBE : 12.0.62.12000000.11

            GMS : 12.0.51.12010000.8

            IGILUTIL2 : 12.0.32

            IGILUTIL : 12.0.3

            OPM : 12.0.7.12010000.2

            PQH_GEN : 12.0.7

            PSA : 12.0.17

            PSAC : 12.0.5

            PSB : 12.0.2

            VERT1 : 12.0.0

            VERT2 : 12.0.0

            VERT3 : 12.0.0

            VERT4 : 12.0.0

            VERT5 : 12.0.0

            VERT : 12.0.0

            • 3. Re: Upload a Document Or Pdf File in a 1st form and Retrieve it in 2nd form(10g forms)
              Michael Ferrante-Oracle

              Likely something like this would need to be done with Java Beans and/or WebUtil.  However, I'm not sure exactly how EBS uses WebUtil.  This question may be best handled in the EBS area, therefore I will move it there.