3 Replies Latest reply: Sep 2, 2013 6:41 AM by 1001647 RSS

    WebADI Read Only fields

    Oracle Payroll Systems Support

      Hi,

       

      We are developing a custom WebADI interface of UPLOAD type.

      There are 3 fields in the layout, out of which 2 are read only. These 2 fields will contain the downloaded data from a view.

      The 3rd field is user enterable.

      We have a custom wrapper that gets called during the upload process.

       

      Whenever we start the Upload process, it goes into error - SQL exception occurred during the PL/SQL upload.

       

      Upon checking the bne.log file, I found that values for the 2 read only fields is being passed as NULL to the package even though the spreadsheet has values in those 2 fields.

       

      Upon, Googling, I found that this is something to do with the fields being read only. Is this true ?

       

      Can someone help me understand if this is expected behavior and why ?

      Is there any workaround for this issue ?

      We need to have those 2 fields as read only as per Business requirement.

       

      We are on EBS 12.1.3

      Appreciate your help.

       

      Thanks.

        • 1. Re: WebADI Read Only fields
          Oracle Payroll Systems Support

          Hi,

           

          We are developing a custom WebADI interface of UPLOAD type.

          There are 3 fields in the layout, out of which 2 are read only. These 2 fields will contain the downloaded data from a view.

          The 3rd field is user enterable.

          We have a custom wrapper that gets called during the upload process.

           

          Whenever we start the Upload process, it goes into error - SQL exception occurred during the PL/SQL upload.

           

          Upon checking the bne.log file, I found that values for the 2 read only fields is being passed as NULL to the package even though the spreadsheet has values in those 2 fields.

           

          Upon, Googling, I found that this is something to do with the fields being read only. Is this true ?

           

          Can someone help me understand if this is expected behavior and why ?

          Is there any workaround for this issue ?

          We need to have those 2 fields as read only as per Business requirement.

           

          We are on EBS 12.1.3

          Appreciate your help.

           

          Thanks.

          • 2. Re: WebADI Read Only fields
            1001647

            Hi,

            what ever you said is true.

            Firstly in webadi any fields which are marked as read only passes null to the package and instead of updating the row it will be inserting a new row.

             

            i too faced the same problem in webadi.

            • 3. Re: WebADI Read Only fields
              1001647

              Hi,

              what ever you said is true.

              Firstly in webadi any fields which are marked as read only passes null to the package and instead of updating the row it will be inserting a new row.

               

              i too faced the same problem in webadi.