Yearly Archives: 2020

Oracle Database Vault

The Oracle Database Vault security controls protect application data from unauthorized access and comply with privacy and regulatory requirements. We can deploy controls to block privileged account access to application…

Read More

Object Storage vs Block Storage

Block storage is the oldest and simplest form of data storage. Block storage stores data in fixed-sized ‘blocks’. By itself, a block typically only houses a portion of the data.…

Read More

How is Oracle Autonomous Data Warehouse different from the rest of Cloud Database Services

Cloud Database is not new. There are several options from various technology vendors to choose from. However, Oracle Autonomous Data Warehouse is a perfect fit for enterprise business analysts, and…

Read More

Oracle Analytics Server (OAS) vs Oracle Analytics Cloud (OAC)

OAC and OAS are congruent products and therefore enable organizations to leverage both deployments simultaneously. Going from OAS to OAC or vice-versa is as simple as creating a snapshot from…

Read More

VO Row Iterator in OAF

OAApplicationModule am = oapagecontext.getApplicationModule(oawebbean); OADBTransaction oadbtransaction = am.getOADBTransaction(); OAViewObject XXDraftASNLineEOVO = (OAViewObject)am.findViewObject(“XXDraftASNLineEOVO1”); if (XXDraftASNLineEOVO!= null) XXDraftASNLineEOVO.reset(); while (XXDraftASNLineEOVO.hasNext()) { OARow XXDraftASNLineEOVORow = (OARow)XXDraftASNLineEOVO. next (); XXDraftASNLineEOVORow.setAttributes String XXAsn=(String)XXDraftASNLineEOVORow.getAttribute(“XXASN”); XXDraftASNLineEOVORow.setAttribute(“XXASN”,”ASN”); }

Read More

Customall.jar file for OAF

After deploy the code to server we need to generate “customall.jar” file from $JAVA_TOP by using “adcgnjar customall.jar” from the R12.2

Read More

Adding new row at bottom of the where have clicked Through OAF

public void processFormRequest(OAPageContext pageContext, OAWebBean webBean) { super.processFormRequest(pageContext, webBean); OAApplicationModule am=(OAApplicationModule)pageContext.getApplicationModule(webBean); OAViewObject vo = (OAViewObject)am.findViewObject(“XXAddRowVO1″); String refpono=””; if(“AddRowEvent”.equals(pageContext.getParameter(“event”))) { int rs=0; String rowRef1 = pageContext.getParameter(“evtSrcRowRef”); OARow Porowref = (OARow)am.findRowByRef(rowRef1); refpono=Porowref.getAttribute(“Segment1”).toString();…

Read More

Life At Doyensys – Rajan Chandru

Employees are the backbone of an organisation. With the right people, a company can not only achieve its goals but also surpass them. We want to thank our employees and…

Read More

Life At Doyensys – Sasi Anandh NM

Employees are the backbone of an organisation. With the right people, a company can not only achieve its goals but also surpass them. We want to thank our employees and…

Read More

Deleting Lines based on conditions through OAF

if (“DeleteEvent”.equals(oapagecontext.getParameter(“event”))) { String rowReference = oapagecontext.getParameter(EVENT_SOURCE_ROW_REFERENCE); OARow currRow = (OARow)oaapplicationmodule.findRowByRef(rowReference); String QuantityShipped =(new StringBuilder()).append(currRow.getAttribute(“QuantityShipped”)).append(“”).toString(); System.out.println(“QuantityShipped in DeleteEvent”+QuantityShipped); if(QuantityShipped.equals(“null”)) { currRow.remove(); oadbtransaction.commit(); throw new OAException(“Record Sucessfully Deleted”, OAException.CONFIRMATION); } else…

Read More