Ellucian Banner : Input text into 2 text boxes continuously when typing extra characters

Ellucian Banner : Input text into 2 text boxes continuously when typing extra characters

Ex

Struct

<Item AllowSearch="true" CanvasName="FABINVH_HEADER" Id="FABINVH_VEND_INV_CODE" MaxLength="15" Type="TextItem"/>


XVC

<textbox autoskip="true" block="FABINVH" case="upper" datatype="String" height="23px" keyactions="NEXT_ITEM" label="fabinvh.fabinvhVendInvCode.prompt" maxlength="15" member="FABINVH_VEND_INV_CODE" name="fabinvhVendInvCode" validation="server" width="120px" style="ui-hidelabel">


FORM

@ActionTrigger(action="HOLD_LAST_ITEM_LOC")
public void Fyainve_HoldLastItemLoc()
{

// DECLARE
//  hold_last_text_item VARCHAR2(30);
// BEGIN
// DECLARE
//  hold_last_text_item VARCHAR2(30);
// BEGIN
getFormModel().getFormHeader().setHoldLastTextItem(toStr(getCursorItem()));


CONTROLLER

@ActionTrigger(action="POST-TEXT-ITEM", item="FABINVH_VEND_INV_CODE", function=KeyFunction.ITEM_OUT)
public void fabinvhVendInvCode_itemOut()
{
    System.out.println(" fabinvhVendInvCode_itemOut");

    executeAction("HOLD_LAST_ITEM_LOC");
}



@ActionTrigger(action="KEY-NEXT-ITEM", item="FABINVH_VEND_INV_CODE", function=KeyFunction.NEXT_ITEM)
public void fabinvhVendInvCode_keyNexItem()
{
System.out.println(" fabinvhVendInvCode_keyNextItem ");
nextItem();
//    GO_FIELD( 'FABINVH_ACH_OVERRIDE_IND' ) ;
getTask().getGoqrpls().gCheckFailure();
}

Banner 9 Eclipse - Unable to Open Task Outline

Eclipse - Unable to Open Task Outline in Banner 9


Close Eclipse
navigate to the Eclipse workspace directory in the file system c:\admin_page\dev90workspace
Drill into the following path under that folder: .metadata\.plugins\morphis.foundations.plugin.core\
Delete the tasksRegistry.xml file (or rename it).
Then restart Eclipse and wait for it to finish rebuilding the task registry.
Note: you may have to run Maven update

Ellucian
explanation:

The tasksRegistry is created and maintained by the Morphis plugins. We've been seeing strange problems like you described that are caused by bad data in the tasks registry, but thus far haven't been able to track down the root cause other than that letting Eclipse rebuild it often helps. There is nothing you did wrong per se that would cause this. At this point we don't know if there is something invalid in the Banner code or with how the Morphis plugins work that causes this to happen but are actively working with Morphis to try and narrow it down.

Banner 9: Fix for Missing IN or OUT parameter

Ellucian Banner 9: Fix for Missing IN or OUT parameter

Find Queries in controller to make sure no missing addParametter

Notes param will start with :
ex   pidm= :id

Banner 9: After, Before event for extended function of controller in extension

Banner 9: After, Before event for extended function of controller in extension page

Banner 9: Overwrite struct xml, function of controller in extension

Banner 9: Overwrite struct xml, function of controller in extension

Banner 9 Extend page with different name

Banner 9 Extend page with different name

Banner 9: Warning error alert message box

Banner 9: Info message, error message, alert message boxes


MessageServices.message("This is info");


MessageServices.setAlertMessageText("aa", "This is xxx.");
MessageServices.showAlert("aa");

/MessageServices.message("sss", userResponse);
//OutputMessageUserResponse

getTask().getGoqrpls().gDisplayAlert(toStr("G$_WARNING_ALERT"), GNls.Fget(toStr("GUAGMNU-0007"), toStr("FORM"), toStr("aaaaaaaaaaaaaaaaaaaaa.")) );

getTask().getGoqrpls().gDisplayAlert(toStr("G$_WARNING_ALERT"), new NString("This is aalert.") );

Banner 9 clear Global, setGlobal variables

Banner 9 clear Global, setGlobal variables

setGlobal (key, value);

removeGlobal (key);

Oracle index hint syntax

select /*+ index(customer cust_primary_key_idx) */ * from customer;

Also note that of you alias the table, you must use the alias in the index hint:
select /*+ index(c cust_primary_key_idx) */ * from customer c;

Also, be vary of issuing hints that conflict with an index hint.  In this index hint example, the full hint is not consistent with an index hint:
select /*+ full(c) index(c cust_primary_key_idx) */ * from customer c;

https://docs.oracle.com/cd/B19306_01/server.102/b14211/hintsref.htm#i8327

https://logicalread.com/using-index-hints-to-tune-oracle-performance-h01/#.W3zv984zbIU

weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: null in Weblogic 10.3

weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: null  in Weblogic 10.3


1. Check DataSource xml It's in the domain's

config/jdbc directory. 

2.     Check DB Port 

3. Check user=xxx in properties

4. Some times JRF template causing issue due to ojdbcdms.jar is loaded first 

       Solution: - remove JRF

                      - or exclude ojdbcdms.jar from CLASSPATH

                      - or Upgrade to Weblogic12c

SQLPlus output to a file

SQLPlus output to a file

spool c:/output.txt

turn off:

spool off

Oracle PLSQL Cursor Duplicate of final Record

Oracle PLSQL Cursor Duplicate of final Record

loop
 fetch s_cur into s_rec;
 exit  when s_cur%notfound;
  dbms_output.put_line('id:'||s_rec.id||':name:'||s_rec.name);
end loop;

When you have fetched the last record and trying to fetch the next s_cur%notfoundbecomes true but before it has a chance to exit from loop you are outputting the last record once again.

Connect Oracle DB remotely by sqlplus

How to Connect Oracle DB remotely by sqlplus

1. Update tnsnames.ora with Oracle server you want to connect

C:\Oracle\Middleware\Oracle_Home\network\admin\tnsnames.ora


ex
OraServer1=

(DESCRIPTION =

  (ADDRESS = (PROTOCOL = TCP)(HOST = 203.292.222.1)(PORT = 1521))

  (LOAD_BALANCE = YES)

  (CONNECT_DATA =

   (SERVER = DEDICATED)

   (SERVICE_NAME = DEV1

   (FAILOVER_MODE =

   (TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5)

   )

  )

)


2. Command line

sqlplus username/passs@OraServer1

How To Create Oracle ORDS REST webservice - APEX PLSQL

How To Create Oracle ORDS REST webservice - APEX PLSQL

• Schema: EMPLOYEE
• Module: restws
• Template: transfer

Handler: POST

Enable ORDS Schema

BEGIN

ORDS.ENABLE_SCHEMA(

     p_enabled             => TRUE,

     p_schema              => 'EMPLOYEE',

     p_url_mapping_type    => 'BASE_PATH',

     p_url_mapping_pattern => 'restws',

     p_auto_rest_auth      => FALSE);

END;

/

Create ORDs Module

BEGIN

ORDS.DEFINE_MODULE(

     p_module_name    => 'emp.v1',

     p_base_path      => '/emp.v1/',

     p_items_per_page =>  25,

     p_status         => 'PUBLISHED',

     p_comments       => NULL);

END;

/

Create ORDS Templates

BEGIN

ORDS.DEFINE_TEMPLATE(

     p_module_name    => 'emp.v1',

     p_pattern        => ‘create’,

     p_priority       => 0,

     p_etag_type      => 'HASH',

     p_etag_query     => NULL,

     p_comments       => NULL);

END;

Create ORDS Handler

BEGIN

 ORDS.DEFINE_HANDLER(

     p_module_name    => 'emp.v1',

     p_pattern        => 'update',

     p_method         => 'POST',

     p_source_type    => 'plsql/block',

     p_items_per_page =>  0,

     p_mimes_allowed  => '',

     p_comments       => NULL,

     p_source         =>

'BEGIN

  

- call any plsql package or do insert/update .....

status := 'OK';

END;'

END;

/

Add Response Params

BEGIN

ORDS.DEFINE_PARAMETER(

  p_module_name        => 'asset.track.v1',

     p_pattern            => 'transfer',

     p_method             => 'POST',

     p_name               => 'X-APEX-STATUS-CODE', -- or any Name

     p_bind_variable_name => 'status',

     p_source_type        => 'RESPONSE',

     p_param_type         => 'INT',

     p_access_method      => 'OUT',

     p_comments           => NULL);

END;/

X-APEX-STATUS-CODE Rest response in PLSQL

X-APEX-STATUS-CODE Rest response in PLSQL

BEGIN

ORDS.DEFINE_PARAMETER(

  p_module_name        => 'assetws',

     p_pattern            => 'transfer',

     p_method             => 'POST',

     p_name               => 'X-APEX-STATUS-CODE',

     p_bind_variable_name => 'status',

     p_source_type        => 'RESPONSE',

     p_param_type         => 'INT',

     p_access_method      => 'OUT',

     p_comments           => NULL);

 ORDS.DEFINE_PARAMETER(

     p_module_name        => 'assetws',

     p_pattern            => 'transfer',

     p_method             => 'POST',

     p_name               => 'alert',

     p_bind_variable_name => 'alert',

     p_source_type        => 'HEADER',

     p_param_type         => 'STRING',

     p_access_method      => 'IN',

     p_comments           => NULL);

END;

Maven update project dependencies

Maven update project dependencies

mvn dependency:resolve

Or  single dependency:
mvn dependency:get -Dartifact=groupId:artifactId:version




mvn clean install -U

-U means force update of dependencies.

can not create Oracle user ORA-65096: invalid common user or role name in oracle

ORA-65096: invalid common user or role name in oracle

can not create Oracle user 

Fix

alter session set "_oracle_script"=true;

How to Stop firewall in Linux, Oracle Linux

How to Stop firewall in Linux, Oracle Linux

Oracle Linux 7, Redhat 7

service firewalld stop
systemctl disable firewalld

Oracle linux 7, Redhat 6

chkconfig iptables off