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 : 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>

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 --hard

git clean -f -d

git pull origin master

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));

  utl_http.set_header(req, 'Authorization', 'Basic d124553rpwYXNzd29yZA=='); --It Uses Basic Authorization 

  ----//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

*ERROR* User HRBATUSR not authorized access form in Banner 9

*ERROR* User HRBATUSR not authorized access form in Banner 9

ex:

Banner error : not authorized access SOAIDEN


Check GURUOBJ

select * from BANSECR.GURUOBJ where GURUOBJ_USERID = 'your userid'



Resolution:

Insert into BANSECR.GURUOBJ (GURUOBJ_OBJECT, GURUOBJ_ROLE, GURUOBJ_USERID, GURUOBJ_ACTIVITY_DATE, GURUOBJ_USER_ID)
  Values ('SOAIDEN', 'BAN_DEFAULT_M', 'your userid', SYSDATE, 'BANSECR');

BAN_ DEFAULT_M BAN_ DEFAULT_Q

BAN_ DEFAULT_ CONNECT

The role BAN_DEFAULT_CONNECT has limited privileges. Users can connect to a database, but cannot access tables. BAN_DEFAULT_CONNECT GRANT CONNECT TO BAN_DEFAULT_CONNECT Note: SCT Banner Security discourages direct grants of any kind.

BAN_ DEFAULT_Q
The role BAN_DEFAULT_Q gives the user privileges to execute all objects and select on all tables in the database GRANT SELECT ANY TABLE TO BAN_DEFAULT_Q GRANT EXECUTE ANY OBJECT TO BAN_DEFAULT_Q

BAN_ DEFAULT_M
The role


BAN_DEFAULT_M gives the user DBA privileges to all tables and all objects in the database. The BAN_DEFAULT_M role ensures access to all appropriate tables, etc. • INSERT ANY, • UPDATE ANY, • DELETE ANY, • SELECT ANY, and • EXECUTE ANY Each role is password-protected, and each password is encrypted.




Additional delivered roles • BAN_ARSYS_REP • BAN_FINANCE_REP • BAN_STUDENT_REP

These are sample roles for reporting, which can be created for each module or as needed.