Monday, 27 March 2017

Jdev 12.1.3.0 Working with Export Collection Action Listener



Couple of days before i was working with Export Collection Action Listener component in Jdev 12.1.3 and face very weird issue which i am sharing with you as below, hope this may help you.


Problem :

One of the UI page in my application is having table under panel Collection layout and i added Export Collection Action Listener component on this table, Exporting data was working fine when i tested my application in integrated Weblogic server but when i deploy my application to stand alone WLS (Client server) Export button was throwing error says "Export is incomplete due to error". I tried all possible solution but only one worked successfully.

Solution:

for some of  the columns in table i set visible property to false and there was a field having LOV attached to it which was set visible to false, i changed this column's Visible property to true and tried to export and it worked fine. Its Strange but worked !!

10 comments:

  1. hi i have table inside column i am using <f:facet header="name" because of this i am getting error in export excel is "Export is incomplete due to error" Please give me suggestion i am getting this error in jdeveloper 12c.

    ReplyDelete
  2. Hi,
    I posted the above solution based on one of my test case which I faced during my development,may be your scenario is different. Please provide some more details on issue which you are facing.

    ReplyDelete
    Replies
    1. Hi i have <af:exportCollectionActionListener component in 12c but i am not able to get export data in excel it is showing error "Export is incomplete due to error" here i removed facet header="name" then it is working fine.but here i have to use acet header="name" inside select check box ihave .how to solve this problem any idea?

      Delete
    2. refer this url once u will get clarity sudarsan.
      https://community.oracle.com/thread/4043079

      Delete
  3. we are getting the problem 11.1.1.9.0 to migration the project in Studio Edition Version 12.2.1.2.0
    Hi i have <af:exportCollectionActionListener component in 12c but i am not able to get export data in excel it is showing error "Export is incomplete due to error" here i removed facet header="name" then it is working fine.but here i have to use table in column inside using facet header="name" inside select check box i have .how to solve this problem any idea?

    ReplyDelete
    Replies
    1. your requirement seems to be confusing, still not able to get what you are trying to do.
      What is the use case of having facet inside table column ?
      Are you trying to put table inside Facet which is already inside parent table's column ?

      Delete
    2. I tried the same thing which you posted on community (https://community.oracle.com/thread/4043079) and i did not get any error while exporting data of table into excel with one of the table column has facet header and put output text inside facet header. Please reach out to me at sudarshansharma.arav@gmail.com if you are still facing this issue.

      Delete
    3. try in 12.2.1.2.0 its not working you checked which version please let me know

      Delete
    4. Hello sir u told sent mail i will check like that you told .later no response

      Delete
    5. Hi,
      sorry for the late response, i have replied to your email please check and let me know.

      Delete

Select Multiple values from LOV component (Choice List) on UI

There are scenarios where user wants to select multiple values from Input List of Values (LOV) component and store in DB column as comma se...