Java, SpringBoot, React, Angular, Oracle, PL/SQL, Ellucian Banner, Puppet, Docker, Terraform technical notes
Tuesday, February 19, 2019
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();
}
Wednesday, January 23, 2019
how to access virtualbox share folder in Linux
how to access virtualbox share folder in Linux
sudo mount -t vboxsf -o uid=1000,gid=1000 development ~/share
Monday, January 21, 2019
Resize VirtualBox disk , change virtual machine disk of Ubuntu/Windows
Resize VirtualBox disk , change virtual machine disk
ex: change vm disk to 40000mb
C:\Program Files\Oracle\VirtualBox>vboxmanage modifyhd "C:\Users\oracle\VirtualBox VMs\Ubuntu18\Ubuntu18.vdi" --resize 40000
Then
Start VM
Login to Ubuntu
Run DiskUtility
Resize Linux partition
Same with Windows
Start VM
Login to Windows
Run DiskManager
Resize Windows partition
ex: change vm disk to 40000mb
C:\Program Files\Oracle\VirtualBox>vboxmanage modifyhd "C:\Users\oracle\VirtualBox VMs\Ubuntu18\Ubuntu18.vdi" --resize 40000
Then
Start VM
Login to Ubuntu
Run DiskUtility
Resize Linux partition
Same with Windows
Start VM
Login to Windows
Run DiskManager
Resize Windows partition
Tuesday, November 6, 2018
Uninstall Oracle 12c database completely in easiest way
Uninstall Oracle 12c database completely in easiest way
If you have 12c installer package available or you can download from Oracle.com
Navigate to that folder where setup file is
run command line
cd C:\Users\xxx\Downloads\winx64_12201_database\database
setup.exe -deinstall -home C:\app\oracle\product\12.1.0\dbhome_1
Answer some questions:
LISTENER is LISTENER
Dataabase name is ORCL by default
ASM / FS : ASM
final process is Y
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...