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.

Can not open GSASECR when login with BANSECR

You are logging into Banner as BANSECR and calling the GSASECR form and getting the error

  *ERROR* User BANSECR not authorized to access GSADBAP
  *ERROR* Access denied, exiting form

As a result you can not get into the GSASECR form to adjust user permissions etc.

Fix
---
Since you can not get into GSASECR to fix the issue you can run this from SQLPLUS to fix the issue

  sqlplus bansecr/u_pick_it
  insert into bansecr.gurucls values ('BANSECR','BAN_FULL_SECURITY_C',SYSDATE,'BANSECR',NULL,NULL);
  commit;

Now retest the GSASECR form as BANSECR to confirm it can be accessed.


Note: Normally you would fix this issue by doing this
  As BANSECR open form GSASECR and enter 
  User ID = BANSECR
  Click "Modifiy"
  Click "User Classes"
  Click on the class "BAN_FULL_SECURITY_C"