Java, SpringBoot, React, Angular, Oracle, PL/SQL, Ellucian Banner, Puppet, Docker, Terraform technical notes
Friday, June 1, 2018
Ellucian Banner 9: Disable Save function
Banner 9: Disable Save function
- - comment out Save event in controller
Banner 9 Admin: Error Invalid Object Name fix
Banner 9 Admin: Invalid Object Name fix
do steps:
A record in GUBOBJS with a UI Version of D.
• Records in GURAOBJ to define the default rule and the version and add the page to a Banner Security
Class, such as BANNER_GENERAL_C.
• Insert the page into GUBPAGE, you can use the form GUAPAGE. The GUBPAGE_GUBMODU_CODE
should be the one for the product admin pages.
• Insert Menu XML in the Banner Administrative Page Common common-libraries project, Main.Menu.Def.xml
file. The entry in the menu xml allows you to run the page without Application Navigator.
Insert a menuEntry for the new page so it can be run outside of Application Navigator:
Insert into BANSECR.GURUOBJ (GURUOBJ_OBJECT, GURUOBJ_ROLE, GURUOBJ_USERID, GURUOBJ_ACTIVITY_DATE, GURUOBJ_USER_ID)
Values ('Form Name....', 'BAN_DEFAULT_M', 'banner login user....', SYSDATE, 'BANSECR_NUTTCS');
do steps:
A record in GUBOBJS with a UI Version of D.
• Records in GURAOBJ to define the default rule and the version and add the page to a Banner Security
Class, such as BANNER_GENERAL_C.
• Insert the page into GUBPAGE, you can use the form GUAPAGE. The GUBPAGE_GUBMODU_CODE
should be the one for the product admin pages.
• Insert Menu XML in the Banner Administrative Page Common common-libraries project, Main.Menu.Def.xml
file. The entry in the menu xml allows you to run the page without Application Navigator.
Insert a menuEntry for the new page so it can be run outside of Application Navigator:
Insert into BANSECR.GURUOBJ (GURUOBJ_OBJECT, GURUOBJ_ROLE, GURUOBJ_USERID, GURUOBJ_ACTIVITY_DATE, GURUOBJ_USER_ID)
Values ('Form Name....', 'BAN_DEFAULT_M', 'banner login user....', SYSDATE, 'BANSECR_NUTTCS');
Tuesday, May 29, 2018
Banner 9: Add more key to keyblock
- add new key into keyblock business
- copy all functions of ID , event in keyblock controller
- Add relationship in model xml
<manager id="xxxxL.Manager.Config" name="xxxx">
<items>
<item name="xxxL_AREA" logicalName="burarclArea" type="java.lang.String" physicalName="xxx_AREA">
<value>
<item name="AREA" businessObject="KEY_BLOCK"/>
</value>
</item>
------
<defaultWhereClause><![CDATA[WHERE XXXX_AREA =:ID]]></defaultWhereClause>
- Add BeforeQuery event into Block controller
@BeforeQuery
public void xxxx_BeforeQuery(QueryEvent args) {
//ID
((IDBBusinessObject)args.getSource()).getSelectCommandParams().
add(DbManager.getDataBaseFactory().createDataParameter("ID",
this.getFormModel().getKeyBlock().getId()));
//Area
((IDBBusinessObject)args.getSource()).getSelectCommandParams().
add(DbManager.getDataBaseFactory().createDataParameter("AREA",
this.getFormModel().getKeyBlock().getId()));
}
Banner 9: Tabs UI
Banner 9: Tabs UI
Banner 9: Tabs UI
- Windows
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<window xmlns="urn:schemas:morphis:frames:view" xmlns:xl="urn:schemas:morphis:frames:logic" layout="horizontal" name="MAIN_WINDOW" title="mainWindow.title">
<include src="net/hedtech/banner/student/..../views/PanelKeyBlockCanvas"/>
<tabpanel style="ui-panel-view-container ui-notabs" width="100%">
<tab label="main">
<!--
<include src="net/hedtech/banner/student/...../views/PanelMainCanvas"/>
-->
<include src="net/hedtech/general/common/libraries/Goqolib/views/PanelGWelcomeCanvas"/>
<include src="net/hedtech/banner/student/...../views/Panel.....TabCanvas"/>
</tab>
</tabpanel>
</window>
- Create Tab canvas from Task Outline
- Create Page when creating tab canvas
- Tab change event in Tab canvas xvc
<?xml version="1.0" encoding="UTF-8"?>
<config xmlns="urn:schemas:morphis:frames:view" xmlns:xl="urn:schemas:morphis:frames:logic" layout="positional">
<tabpanel name="xxxx_TAB_CANVAS" width="100%" height="100%" >
<xl:event action="WHEN-TAB-PAGE-CHANGED" name="change"/>
<tab id="page_AREA" name="AREA" label="AREA" >
<include src="net/hedtech/banner/student/xxxx/views/TabxxxxxTabCanvasArea" />
</tab>
<tab id="page_CLASSIFICATION" name="CLASSIFICATION" label="CLASSIFICATION" >
<include src="net/hedtech/banner/student/xxxx/views/TabxxxxTabCanvasClassification" />
</tab>
<tab id="page_ADVISOR" name="ADVISOR" label="ADVISOR" >
<include src="net/hedtech/banner/student/xxxx/views/TabxxxxTabCanvasAdvisor" />
</tab>
</tabpanel>
</config>
- Form Controller
@ActionTrigger(action="WHEN-TAB-PAGE-CHANGED")
public void XXXX_tabChange()
{
{
NString tabTopmost = getCanvasTopMostTabPage("XXX_TAB_CANVAS");
// F2J_WARNING : Please validate if you need to surround the message level manipulation with a try/finally block
try{
MessageServices.setMessageLevel(FormsMessageLevel.decodeMessageLevel("5"));
if ( tabTopmost.equals("AREA") )
{
goBlock(toStr("XXX"));
executeQuery();
}
else {
}
}finally{
// F2J_WARNING : Please validate if you need to surround the message level manipulation with a try/finally block
MessageServices.setMessageLevel(FormsMessageLevel.decodeMessageLevel("0"));
}
}
}
Banner 9: Tabs UI
- Windows
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<window xmlns="urn:schemas:morphis:frames:view" xmlns:xl="urn:schemas:morphis:frames:logic" layout="horizontal" name="MAIN_WINDOW" title="mainWindow.title">
<include src="net/hedtech/banner/student/..../views/PanelKeyBlockCanvas"/>
<tabpanel style="ui-panel-view-container ui-notabs" width="100%">
<tab label="main">
<!--
<include src="net/hedtech/banner/student/...../views/PanelMainCanvas"/>
-->
<include src="net/hedtech/general/common/libraries/Goqolib/views/PanelGWelcomeCanvas"/>
<include src="net/hedtech/banner/student/...../views/Panel.....TabCanvas"/>
</tab>
</tabpanel>
</window>
- Create Tab canvas from Task Outline
- Create Page when creating tab canvas
- Tab change event in Tab canvas xvc
<?xml version="1.0" encoding="UTF-8"?>
<config xmlns="urn:schemas:morphis:frames:view" xmlns:xl="urn:schemas:morphis:frames:logic" layout="positional">
<tabpanel name="xxxx_TAB_CANVAS" width="100%" height="100%" >
<xl:event action="WHEN-TAB-PAGE-CHANGED" name="change"/>
<tab id="page_AREA" name="AREA" label="AREA" >
<include src="net/hedtech/banner/student/xxxx/views/TabxxxxxTabCanvasArea" />
</tab>
<tab id="page_CLASSIFICATION" name="CLASSIFICATION" label="CLASSIFICATION" >
<include src="net/hedtech/banner/student/xxxx/views/TabxxxxTabCanvasClassification" />
</tab>
<tab id="page_ADVISOR" name="ADVISOR" label="ADVISOR" >
<include src="net/hedtech/banner/student/xxxx/views/TabxxxxTabCanvasAdvisor" />
</tab>
</tabpanel>
</config>
- Form Controller
@ActionTrigger(action="WHEN-TAB-PAGE-CHANGED")
public void XXXX_tabChange()
{
{
NString tabTopmost = getCanvasTopMostTabPage("XXX_TAB_CANVAS");
// F2J_WARNING : Please validate if you need to surround the message level manipulation with a try/finally block
try{
MessageServices.setMessageLevel(FormsMessageLevel.decodeMessageLevel("5"));
if ( tabTopmost.equals("AREA") )
{
goBlock(toStr("XXX"));
executeQuery();
}
else {
}
}finally{
// F2J_WARNING : Please validate if you need to surround the message level manipulation with a try/finally block
MessageServices.setMessageLevel(FormsMessageLevel.decodeMessageLevel("0"));
}
}
}
Banner 9 : add checkbox into table
Banner 9 : add checkbox into table
<panel class="Canvas" height="800px" id="AAA" name="AAA" width="1800px">
<interactionBlock name="BA"/>
<gridlayout cols="1" orientation="horizontal">
<gridcell>
<gridview block="BA" height="800px" name="BA" width="1800px">
<viewheader>
<viewcolumn label="User Info" member="BA_INFO" name="baInfoInd" width="50px">
<editor>
<checkbox falsevalue="N" value="Y" othervaluestate="unchecked"/>
</editor>
</viewcolumn>
</viewheader>
</gridview>
</gridcell>
</gridlayout>
</panel>
Wednesday, May 23, 2018
GIT force checkout overwrite local files
GIT force checkout overwrite local files
- reverting changes
- removing new files
- get latest from remote repository
git reset HEAD --hardgit clean -f -dgit pull origin master
Friday, May 4, 2018
PL/SQL calls REST webservice
PL/SQL calls REST webservice
Function f_rest_call( stringjson )
req utl_http.req;
res utl_http.resp;
url varchar2(2000) := 'REST url';
buffer varchar2(1000);
content varchar2(4000) := stringjson ;
begin
req := utl_http.begin_request(url, 'POST','
HTTP/1.1');
utl_http.set_header(req, 'user-agent',
'mozilla/4.0');
utl_http.set_header(req, 'content-type',
'application/json');
utl_http.set_header(req, 'Content-Length',
length(content));
----//SYS.utl_http.write_raw(req, contentgetStringVal());
utl_http.write_text(req, content);
res := utl_http.get_response(req);
begin
loop
utl_http.read_line(res, buffer);
end loop;
utl_http.end_response(res);
exception
when utl_http.end_of_body
then
utl_http.end_response(res);
end;
end
Subscribe to:
Posts (Atom)
AWS how to delete VPC when it has error with Network interface , Gateway decencies
how to delete VPC when it has error with Network interface , Gateway decencies in AWS 1. Check if it is running on EC2 instance then Sto...
-
ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1525 ORA-29261: bad argument ORA-29273: HTTP request failed ...
-
Banner 9 Admin: Invalid Object Name fix do steps: A record in GUBOBJS with a UI Version of D. • Records in GURAOBJ to define the defau...
-
chown root $ORACLE_HOME/bin/extjob chmod 4750 $ORACLE_HOME/bin/extjob chown root $ORACLE_HOME/rdbms/admin/externaljob.ora chmod 640 $ORA...