This discussion is archived
3 Replies Latest reply: Sep 2, 2013 4:41 AM by 1001647 RSS

WebADI Read Only fields

Oracle Payroll Systems Support Newbie
Currently Being Moderated

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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points