Java, SpringBoot, React, Angular, Oracle, PL/SQL, Ellucian Banner, Puppet, Docker, Terraform technical notes
Tuesday, February 19, 2019
Ellucian banner : Search by name in keyblock
Ellucian banner : Search by name in keyblock
Order of struct is for Next item default, and search by name need ID next to Name
Ellucian Banner: Put activity_date at status bar
Ellucian Banner: Put activity_date at status bar
Put activity_date at status bar
<Item CanvasName="MAIN_CANVAS" Id="SZRRECM_ACTIVITY_DATE" Required="true" Type="TextItem" Enabled="false">
<Extension Name="CopyTo" Value="BANNER_FOOTER_DATA.ACTIVITY_DATE"/>
</Item>
Error LOV error outside of block in Ellucian Banner 9
Error LOV error outside of block in Ellucian Banner 9
LOV error outside of block : key ibt need same name with id key
ex: ID and ID_IBT
LOV error outside of block : key ibt need same name with id key
ex: ID and ID_IBT
Ellucian banner: how to get rid of the warning Query Caused No records to be retrieved
Ellucian banner: how to get rid of the warning Query Caused No records to be retrieved
how to get rid of the warning Query Caused No records to be retrieved -- Re-enter?
MessageServices.setMessageLevel(FormsMessageLevel.decodeMessageLevel("5")); // 5-USER's Msg
But have to set it back to default after the action is done:
MessageServices.setMessageLevel(FormsMessageLevel.decodeMessageLevel("0")); // 0--ALL
how to get rid of the warning Query Caused No records to be retrieved -- Re-enter?
MessageServices.setMessageLevel(FormsMessageLevel.decodeMessageLevel("5")); // 5-USER's Msg
But have to set it back to default after the action is done:
MessageServices.setMessageLevel(FormsMessageLevel.decodeMessageLevel("0")); // 0--ALL
Ellucian Banner : Pagination
Ellucian Banner : Pagination
in model xml
<pagination maximumRows="3" enabled="true"/>
in model xml
<pagination maximumRows="3" enabled="true"/>
Ellucian banner: Dialog box, message box
Ellucian banner: Dialog box, message box
with OK
getTask().getGoqrpls().gDisplayErrMsg(
toStr("Income Type on all accounting records must be equal to"
+ " the Income Type on Header. Change Header Income Type"
+ " via Header Additional Information on Tools Menu") );
No OK
errorMessage(GNls.Fget(toStr("FYAINVE-0517"), toStr("FORM"), toStr("Document Text must exist for Direct Pay Invoices. Completion not allowed.")));
Banner : append before="*" after="rect67"
<x:append before="*" after="rect67">
<v:component label="* Press F3 for Transaction Detail(FGITRND); Shift+F2 for Budget Status(FGIBSUM); F4 for Encumbrance List(FGIOENC)">
</v:component>
</x:append>
Ellucian Banner: set record status, get record status
Ellucian Banner: set record status, get record status
System.out.println(" getRecordStatus 2 " + getRecordStatus());
TaskServices.setRecordStatus("", "");
System.out.println(" getRecordStatus 2 " + getRecordStatus());
//TaskServices.setRecordStatus("", "");
//fabinvhElement.acceptChanges();
//GbCommon.pCommit();
//fabinvhElement.acceptChanges();
setBlockRecordStatus("FABINVH", getCursorRecord(), Status.NEW);
BlockServices.setBlockRecordStatus("FTVVEND", BlockServices.getCurrentRecord(), Status.NEW);
getGlobal("QUERY_MODE").equals("1"))
setGlobal("QUERY_MODE", toStr("0"));
System.out.println(" getRecordStatus 2 " + getRecordStatus());
TaskServices.setRecordStatus("", "");
System.out.println(" getRecordStatus 2 " + getRecordStatus());
//TaskServices.setRecordStatus("", "");
//fabinvhElement.acceptChanges();
//GbCommon.pCommit();
//fabinvhElement.acceptChanges();
setBlockRecordStatus("FABINVH", getCursorRecord(), Status.NEW);
BlockServices.setBlockRecordStatus("FTVVEND", BlockServices.getCurrentRecord(), Status.NEW);
getGlobal("QUERY_MODE").equals("1"))
setGlobal("QUERY_MODE", toStr("0"));
Ellucian Banner: Default load value
Ellucian Banner: Default load value
<item name="FTVVEND_COLLECT_TAX" logicalName="ftvvendCollectTax" type="String" physicalName="FTVVEND_COLLECT_TAX" >
<value>
<constant>A</constant>
</value>
</item>
<item name="FTVVEND_TAX_FORM_STATUS" logicalName="ftvvendTaxFormStatus" type="String" physicalName="FTVVEND_TAX_FORM_STATUS">
<value>
<constant>A</constant>
</value>
</item>
<item name="FTVVEND_TAX_FORM_DATE" logicalName="ftvvendTaxFormDate" type="java.util.Date" physicalName="FTVVEND_TAX_FORM_DATE" >
<value>
<systemVariable name="DBDATE"/>
</value>
</item>
<item name="FTVVEND_COLLECT_TAX" logicalName="ftvvendCollectTax" type="String" physicalName="FTVVEND_COLLECT_TAX" >
<value>
<constant>A</constant>
</value>
</item>
<item name="FTVVEND_TAX_FORM_STATUS" logicalName="ftvvendTaxFormStatus" type="String" physicalName="FTVVEND_TAX_FORM_STATUS">
<value>
<constant>A</constant>
</value>
</item>
<item name="FTVVEND_TAX_FORM_DATE" logicalName="ftvvendTaxFormDate" type="java.util.Date" physicalName="FTVVEND_TAX_FORM_DATE" >
<value>
<systemVariable name="DBDATE"/>
</value>
</item>
Ellucian Banner 9: Missing IN or OUT parameter. Add new item field
Ellucian Banner 9: Missing IN or OUT parameter, Add new item field
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();
}
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();
}
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...