This discussion is archived
2 Replies Latest reply: Nov 8, 2013 9:43 AM by VenkyT RSS

Getting 'RegionException' while using custom AK region

944726 Newbie
Currently Being Moderated
Hi,

We are implementing iStore R12 (12.1.3)

We have created a custom jsp as per business requirement. In this custom jsp we need to use some of the region items in seeded regions "IBE_ORD_HDR_R" and "IBE_ORD_DTL_R". Also we need to use some custom region items.

So we copied the seeded AK regions to create custom regions "XXIBE_ORD_HDR_R" and "XXIBE_ORD_DTL_R" respectively.
We defined the custom attributes and added them these custom regions.

However when we refer the custom regions in the custom jsp, getting following error:
Message: RegionException caught while initializing region XXIBE_ORD_HDR_R
Stack:
oracle.apps.jtf.base.resources.FrameworkException: RegionException caught while initializing region XXIBE_ORD_HDR_R
     at oracle.apps.ibe.postsales.AkRegion.initialize(AkRegion.java:225)
     at oracle.apps.ibe.postsales.AkRegion.getAkRegion(AkRegion.java:278)
     at oracle.apps.ibe.postsales.AkQuery.connect(AkQuery.java:805)
     at xxibeCOOrdShipInfo.jspService(_xxibeCOOrdShipInfo.java:1408)
...
Caused by: oracle.apps.jtf.base.resources.FrameworkException: JTF-1400: Region regionCode=XXIBE_ORD_HDR_R, respId=22372, appId=671, lang=USoracle.apps.jtf.base.resources.FrameworkException: Failure in CacheLoader: oracle.apps.jtf.base.resources.FrameworkException: RegionLoader.load()- error in loading.
     at oracle.apps.jtf.cache.IASCacheProvider.get(IASCacheProvider.java:830)
     at oracle.apps.jtf.cache.CacheManager.getInternal(CacheManager.java:4802)
     at oracle.apps.jtf.cache.CacheManager.get(CacheManager.java:2952)
     at oracle.apps.jtf.cache.CacheManager.get(CacheManager.java:2900)
     at oracle.apps.jtf.region.RegionLoader.get(RegionLoader.java:92)
...
Caused by: oracle.apps.jtf.base.resources.FrameworkException: JTF-1400: Region XXIBE_ORD_HDR_R causes JTF RegionException because of java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.JTF_REGION_PUB", line 300
ORA-06512: at "APPS.JTF_REGION_PUB_W", line 1226
ORA-06512: at line 1
...
(Please note that I have uploaded mainly the error messages from the stack trace. Entire stack trace is quite big. I can upload it if needed.)

We tried bouncing apache and clearing jsp cache. Still getting same error.

Are we missing some step? Please let us know.
Any prompt help/suggestion in this regard is appreciated.

Thanks,
Vivek
  • 1. Re: Getting 'RegionException' while using custom AK region
    DeborahCRM-Oracle Journeyer
    Currently Being Moderated
    Hi Vivek,

    The failure for the JTF_REGION_PUB looks to be for this -

    if((not t_punt_column_names) and c1.object_attribute_flag = 'Y' ) then
    begin
    select column_name into p_column_name from ak_object_attributes
         where attribute_code = c1.attribute_code;



    You will need to check the OBJECT_ATTRIBUTE_FLAG for your region. This can be value of Y for Object Attribute attribute type or value of N for Attribute.
    Query to run:

    Select OBJECT_ATTRIBUTE_FLAG ,REGION_CODE,ATTRIBUTE_CODE,NODE_DISPLAY_FLAG,ITEM_STYLE,DATA_TYPE
    from AK_REGION_ITEMS_VL where REGION_CODE ='XXIBE_ORD_HDR_R'
    order by ATTRIBUTE_CODE;



    In the seeded region 'IBE_ORD_DTL_R the attribute IBE_SHP_DTL_LINK is set with OBJECT_ATTRIBUTE_FLAG = N.
    You can see that this must be N by running this query which returns null -
    select column_name from ak_object_attributes
    where attribute_code = 'IBE_SHP_DTL_LINK';


    You can change the Attribute Type in the form -
    - Login as the Application Developer Common Modules
    - Choose Define Regions
    - Query on Region Name and enter your custom region
    - Choose Region Items button and this will allow you to change the value for the Attribute Type - dropdown box has values for Object Attribute or Attribute


    Confirm that those attributes in your region with attribute type of Attribute Object are setup properly and have row returned in ak_object_attributes.



    Regards,
    Deborah Bourgeois
    Oracle Customer Support
  • 2. Re: Getting 'RegionException' while using custom AK region
    VenkyT Newbie
    Currently Being Moderated

    Vivek/Deborah,

     

    I am new to istore and AK developer customizations. I need your help.

     

    I am developing Renewals menu very similar to Track Orders menu in istore.

    Could you please let me know the steps to proceed?

     

    I did the following steps as of now.

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

    1) Enabled menu "Renewals" by adding code in standard ibeCCtdMenu.jsp file, attached new jsp to template.

    2) Created search screen with 2 fields a) quote number text field b) GO button. When i click on "Renewals" menu search page is being displayed properly.

    3) I created results page(xxbcibeCOtdOrdSum.jsp) by copying TRACK ORDERS results pag(ibeCOtdOrdSum.jsp).

    4) I defined the new database view for new quotes(means contracts in ENTERES status)

    5) Now i need your help to to display the results.

          i) How to define regions in AK Developer

         ii) sample java code to connect to DB, get the results and display in RESULTS page

         iii) Any function in application developer or AK HTML reason needs to be defined?

         iv) how can i refer the new region in the my renewals jsp file to get the results?

         v) How to pass the region name to java class to execute the query

        vi) how to pass the parameters to custom_AKQuery java class file?

        vii) Sample code to call the function in java class when i click on "GO" button on search page.

     

    Could you please let me know the step by step and also screen shots if possible.

     

    I am looking for you guys help very badly.

    You can email me the steps and screen shots to my email id; tvenkymca@gmail.com.

     

    Thanks

    Venky...

Legend

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