Dynamic Train Region Handling in OAF

I got the codepack from my colleague and I will replacing him in the project. Then I got this requirement to show Train Region with 3 pages and for another one 2 pages. Initially it was three train pages for two individual pages. When I checked the code both the pages were same and they were dynamically populating the regions based on registered function.

Logical Page Structure

Current Setup(From User side) Page-A TrainPG-1 TrainPG-2 TrainPG-3 Page B TrainPG-1 TrainPG-2 TrainPG-3 Requirement Given(From User side) Page-A TrainPG-1 TrainPG-2 TrainPG-3 Page-B TrainPG-1 TrainPG-2 Current Setup(Actual Underlying Code) Page-A TrainPG-1 TrainPG-2 TrainPG-3 Page-A TrainPG-1 TrainPG-2 TrainPG-3 Requirement Given(Actual Underlying Code) Page-A TrainPG-1 TrainPG-2 TrainPG-3 Page-A TrainPG-1 TrainPG-2

With the given requirement I need to dynamically change the Train Page and footer regions for the pages that they have selected.

Approach – 1

First I have tried to create 2 regions one for Page-A Function-1 and next for Page-A Function-2. Here I tried to dynamically enable the region using SPEL. This approach worked for Train Region but did not work for Footer.

Approach -2 – Limitation -1

Now I tried to have only one region but disable the TrainPG-3 link in Train Region. The same I have tried for Footer Region. Here there were some Issues. Problem was the submit button was properly working for Page-A Function-1 but not working for Page-A Function-2.

Approach -2 – Limitation -2

To overcome the above limitation, I tried to take the Disable button by taking the bean. But I was not able to get the bean.

So to overcome the above limitation I have wrote logic based on page and function to restrict the button. Now I was able to accomplish the requirement given.

Below is the sample code which is a part of this requirement.

public void processRequest(OAPageContext pageContext, OAWebBean webBean)
{
super.processRequest(pageContext, webBean);
iSupplierUpdateAMImpl isupplierupdateamimpl = (iSupplierUpdateAMImpl) pageContext.getRootApplicationModule();
OAViewObject ttvo = (OAViewObject)isupplierupdateamimpl.findViewObject("TransientTrainVO");
isupplierupdateamimpl.createRow(ttvo,null,null);
String OAFunction = pageContext.getSessionValue("SOAFunc").toString();
if ("xx_ISUPPLIER_UPDATE_GEN".equalsIgnoreCase(OAFunction)){ //Function Restriction
ttvo.getCurrentRow().setAttribute("HideContactRegion",Boolean.TRUE);
ttvo.getCurrentRow().setAttribute("ShowHideNextButton",Boolean.FALSE);
OAPageButtonBarBean trainfooterRN = (OAPageButtonBarBean)webBean.findChildRecursive("TrainFooterRN");
OAButtonBean pgButton = (OAButtonBean)webBean.findChildRecursive("submitBTN");
// pgButton.setText("Nothing to Submit"); // Not working getting Error
}
else{
ttvo.getCurrentRow().setAttribute("HideContactRegion",Boolean.FALSE);
if(pageContext.getParameter("page").equals("/xx/oracle/apps/pos/isupplier/webui/XXaddressPG")) //Page Restriction
{
ttvo.getCurrentRow().setAttribute("ShowHideNextButton",Boolean.TRUE);
}
else
{
ttvo.getCurrentRow().setAttribute("ShowHideNextButton",Boolean.FALSE);
}
}
}

I welcome your Suggestions

Changing columns to rows in oracle using unpivot

I got a requirement to join two tables and to get the desired rows that is to get the Enabled rows. One table is from the lookups and another from a custom table.

As there is no relationship between the two there is no possibility to join the tables. I now thought for some time to establish a relationship and started.

I first gave the same column names in custom table to the lookup values in description column. Now I have to transpose the columns to rows , In order to accomplish this I have used unpivot to match the values.

select * from ( SELECT lookup_code,meaning, description, enabled_flag
FROM fnd_lookup_values_vl
WHERE lookup_type = 'XX_POS_ISUP_ATACH_CAT'
AND enabled_flag = 'Y'
and trunc(sysdate) between trunc(START_DATE_ACTIVE) and trunc(nvl(END_DATE_ACTIVE,sysdate))) flv,
(SELECT * FROM (select bc_code, ec_attachment, TAXCARDEXPIRYDATEITM, cr_no_att, CLD_ATTACHMENT from XX_POS_ISUP_BUSCLASF_INFO_T where bc_code = 'OP')
UNPIVOT(
enabled_flag -- unpivot_clause
FOR attachment_columns -- unpivot_for_clause
IN ( -- unpivot_in_clause
ec_attachment AS 'ec_attachment',
TAXCARDEXPIRYDATEITM AS 'TAXCARDEXPIRYDATEITM',
cr_no_att AS 'cr_no_att',
CLD_ATTACHMENT as 'CLD_ATTACHMENT'
)
)) man_attach
where man_attach.attachment_columns = flv.desciption
and man_attach.enabled_flag = flv.enabled_flag

Here in the above query flv alias is fnd_lookup_values and man_attach alias is custom table.

Here I have used UNPIVOT and Im breakind down the elements in the query.

enabled_flag – the enabled field is the name used for values column

FOR attachment_columns – Name for column of the columns in table

IN ( — unpivot_in_clause
ec_attachment AS ‘ec_attachment’,
TAXCARDEXPIRYDATEITM AS ‘TAXCARDEXPIRYDATEITM’,
cr_no_att AS ‘cr_no_att’,
CLD_ATTACHMENT as ‘CLD_ATTACHMENT’
) – table column names to replaced to the same names.

I did not use any aggregate function as it is a straight foward transpose.

Source of Learning

Configuring DFF Read Only by OAF Personalization

To make certain fields read only and some fields as updatable do the below steps by personalization.

Personalize the DFF Item

Here as shown in the above picture select your segments and make as a text like the below line

Global Data Elements|CODE_OF_CONDUCT|AGREED_USER($RO$)|AGREED_DATE_TIME($RO$)

Global Data Elements stands for Context Field Values Code

CODE_OF_CONDUCT Individual DFF Segments which will be updatable

AGREED_USER($RO$) Individual DFF Segments which will be Read Only due to ($RO$)

AGREED_DATE_TIME($RO$) Individual DFF Segments which will be Read Only due to ($RO$)

Once we save it and go back the segments which has ($RO$) will be readonly in OAF.

Below is the metalink ID for making ReadOnly DFF Segment.

How To Make DFF Segments Read Only Using OAF Personalise (Doc ID 438215.1)