Posts

Showing posts from May, 2021

Access rows through Check box in OAF

 Here is the code snippet for accessing rows through check box in OAF   OAViewObject oaviewobject (OAViewObject)pageContext.getApplicationModule(webBean).findViewObject("XXOrderLinVO1");              Row[] CheckedRowSet = oaviewobject.getFilteredRows("CheckBox", "Y");              if (CheckedRowSet != null && CheckedRowSet.length > 0)              {                              for (int i = 0; i < CheckedRowSet.length; i++)                {   XXOrderLinVORowImpl ChksourceRow = (XXOrderLinVORowImpl )CheckedRowSet[i]; System.out.println("Checked Records Header Id"+ChksourceRow.getAttribute("HeaderId")); System.out.println("Checked Records OrderNumber "+ChksourceRow.getAttribute("OrderNumber"));  System.out.println("Checked Records LineNumber"+ChksourceRow.getAttribute("LineNumber"));                               }

Integration of Java Cloud services with Jdeveloper tool

Image
  Java Cloud Service (JCS) provides a platform to develop and deploy business applications in the cloud. In Fusion Applications Cloud deployments customers do not have the option to deploy custom applications developed with JDeveloper to ensure the integrity and supportability of the hosted application service. Instead, the custom applications can be deployed to the JCS and integrated into the Fusion Application Cloud instance.    JDeveloper Integration required with JCS for the deployment of ADF applications. Integration with JCS is mostly wizard-based. To access Java service details, we need to log on to Oracle Cloud account with credentials  After successful login we will find the services assigned to the respective account. E.g. here we have apex2 as DBCS (Database Cloud Service), java2 as Java Cloud Service, and ERP(SaaS).   Configuring Database Cloud service Jdeveloper will provide a list of objects and also can used for Database Carting. All DBCS details need to be co

User and Responsibilty creation through API in Oracle R12.2.X

API to create users in Oracle APPS  SET SERVEROUTPUT ON; DECLARE    lc_user_name                      NUMBER    := 000;    v_user_name varchar2(200);    lc_user_password                  VARCHAR2(100)   := 'Welcome123';    ld_user_start_date                DATE := sysdate;    ld_user_end_date                  VARCHAR2(100)   := NULL;    ld_password_date                  VARCHAR2(100)   := sysdate;    ld_password_lifespan_days  NUMBER          := 90;    ln_person_id                      NUMBER          := 3164;    --This is the employee id which will get assigned, please change this.    lc_email_address                  VARCHAR2(100) := null; BEGIN LOOP  v_user_name :='PRANAY';   fnd_user_pkg.createuser (x_user_name                => v_user_name, x_owner                    => NULL, x_unencrypted_password     => lc_user_password, x_start_date => ld_user_start_date, x_end_date                 => ld_user_end_date,