Learn Oracle Fusion, OAF and ADF by Raju Bandam

Monday, 9 October 2017

Date formatting in OAF

Convert the String object to java.sql.Date object using stringToDate() function from oracle.apps.fnd.framework.OANLSServices class like below.

java.sql.Date getClientSysdate(){
OADBTransaction trx =
(OADBTransaction)getApplicationModule().getTransaction();
OANLSServices nls = trx.getOANLSServices();
oracle.jbo.domain.Date serverDate = trx.getCurrentDBDate();

java.util.Date javaClientDate = nls.getUserDate(serverDate);
long longDate = javaClientDate.getTime();
return new java.sql.Date(longDate);
}

if (gRow.getAttribute("PromisedDate")!=null)
{
ReferenceId= gRow.getAttribute("PromisedDate").toString();//.substring(0,19);
pageContext.writeDiagnostics(this, " Promisedate :"+ReferenceId, 1);
// Calendar calendar = Calendar.getInstance();
//SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");
//String today = dateFormat.format(ReferenceId);
//pageContext.writeDiagnostics(this, " Promised DATE WITh FORMAT "+today,1);
if(result==0)
{
pageContext.writeDiagnostics(this, "Setting PO date to DFF",1);
SimpleDateFormat dt = new SimpleDateFormat("yyyy/mm/dd hh:mm:ss");

gRow.setAttribute("Attribute1",dt.format(ReferenceId));
// gRow.setAttribute("Attribute1","2015/02/15 12:01:10");
gRow.setAttribute("AttributeCategory","28385");
}

}

Monday, 11 September 2017

Fusion Related stuff: How to find the role of a user in fusion

SELECT r.*
FROM fusion.per_users u,
fusion.per_roles_dn_tl r,
fusion.per_user_roles ur,
fusion.per_all_people_f f
JOIN fusion.per_email_addresses e
ON e.person_id = f.person_id
AND e.email_address_id = f.primary_email_id
AND e.email_type = 'W1'
WHERE TRUNC(SYSDATE) BETWEEN f.effective_start_date AND f.effective_end_date
AND u.person_id = f.person_id
AND u.active_flag = 'Y'
AND r.role_id = ur.role_id
AND ur.active_flag = 'Y'
AND ur.terminated_flag != 'Y'

Friday, 24 March 2017

Attribute Level validation in AM and CO:

exceptions.add(new OAAttrValException(111, "XxdhPaContValueWorkDoneVO1", row.getKey(), "Description", row.getAttribute("Description"), "XXDH", "XXDH_PO_CLAIM_AMOUNT_MSG"));

Monday, 29 August 2016

How to get the data from different environments:

public void getDatafromApps(){
ResultSet resultset=null;

try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:user_name/password@//Host:port:SID");
Statement statement = conn.createStatement();
String sql="select segment1,type_lookup_code from apps.po_headers_all where po_header_id=117";
resultset = statement.executeQuery(sql);
if(resultset.next())
{
System.out.println("-----------------------");
System.out.println(resultset.getString(1));
Segment1=resultset.getString(1);
System.out.println(resultset.getString(2));
System.out.println("-----------------------");

}
}
catch (SQLException e) {
System.out.println(e.getMessage());
}

}

//get the SOA details

public void getSOAData(){

char quotes ='"';
ResultSet resultset=null;
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:user_name/password@//Host:port/serviceName");
Statement statement = conn.createStatement();

String sql= "select count(*) countOfrec from SOA."+quotes+"_SAPTable"+quotes;
System.out.println(sql);
resultset = statement.executeQuery(sql);
if(resultset.next())
{
System.out.println("-----------------------");
System.out.println(resultset.getString(1));
countrec=resultset.getString(1);

System.out.println("-----------------------");

}
}

catch (SQLException e) {
System.out.println(e.getMessage());
}

}

How to get the data from different environments:

//get the prod details
public void getDatafromApps(){
ResultSet resultset=null;

try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:user_name/password@//Host:port:SID");
Statement statement = conn.createStatement();
String sql="select segment1,type_lookup_code from apps.po_headers_all where po_header_id=117";
resultset = statement.executeQuery(sql);
if(resultset.next())
{
System.out.println("-----------------------");
System.out.println(resultset.getString(1));
Segment1=resultset.getString(1);
System.out.println(resultset.getString(2));
System.out.println("-----------------------");

}
}
catch (SQLException e) {
System.out.println(e.getMessage());
}

}

//get the SOA details

public void getSOAData(){

char quotes ='"';
ResultSet resultset=null;
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:user_name/password@//Host:port/serviceName");
Statement statement = conn.createStatement();

String sql= "select count(*) countOfrec from SOA."+quotes+"_SAPTable"+quotes;
System.out.println(sql);
resultset = statement.executeQuery(sql);
if(resultset.next())
{
System.out.println("-----------------------");
System.out.println(resultset.getString(1));
countrec=resultset.getString(1);

System.out.println("-----------------------");

}
}

catch (SQLException e) {
System.out.println(e.getMessage());
}

}

Saturday, 27 August 2016

to add fire action with param from controller:

Hashtable params = new Hashtable (1);
params.put ("param1", pageName);
Hashtable paramsWithBinds = new Hashtable(3);

paramsWithBinds.put ("param2", new OADataBoundValueFireActionURL(bandamActualFlag, "{$PoHeaderId}"));
paramsWithBinds.put ("param3", new OADataBoundValueFireActionURL(bandamActualFlag, "{$LINE_LOCATION_ID}"));

paramsWithBinds.put ("param4", new OADataBoundValueFireActionURL(bandamActualFlag, "{$bandamActualFlag}"));
FireAction fireAction = OAWebBeanUtils.getFireActionForSubmit (bandamMHDDate, "bandamMHDDateEvent", params, paramsWithBinds,false, false);
bandamActualFlag.setFireActionForSubmit("bandamActualFlagEvent",params, paramsWithBinds,true,true);
bandamMHDDate.setPrimaryClientAction(fireAction);