Wednesday, 18 October 2017

TEST



 pqh_ss_workflow.get_item_type_and_key (

                p_ntfId    => ntf_id

               ,p_itemType => l_itemType

               ,p_itemKey  => l_itemKey );



  l_activityId      :=

             pqh_ss_workflow.get_notified_activity(

                p_itemType  =>  l_itemType

               ,p_itemKey   => l_itemKey

               ,p_ntfId     => ntf_id );



   wf_engine.setItemAttrText (

            itemtype =>  l_itemType

           ,itemkey  => l_itemKey

           ,aname    => 'NOTE_FROM_APPR'

           ,avalue   => p_note );

Sunday, 27 September 2015

Oracle Apps Jobs, Oracle Apps Technical Jobs

Oracle Apps Jobs are one of the highly paid segment job.

Most of Engineers after completion of degree either go for .NET courses or JAVA courses, and are unaware of a powerful segment Oracle Apps.

Due to lack of knowledge many potential candidate overlook this segment click here for more information on Oracle.

Freshers can apply for certification in-order to make there CV strong and valuable in market. Every big MNC containing Oracle as a segment prefers an Oracle Certified Professional (OCP).

For more details on Oracle Apps Jobs click here

Under Oracle Apps there are below branches
- Oracle Technical Consultant
- Oracle Functional Consultant
- DBA

Thursday, 23 July 2015

Diagnostics Apps Check

APPLIES TO:

Oracle Payables - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Oracle Cost Management - Version 11.5.10.0 to 12.1.3 [Release 11.5 to 12.1]
Oracle Work in Process - Version 11.5.10.0 to 12.1.3 [Release 11.5 to 12.1]
Oracle Process Manufacturing Financials - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Oracle Order Management - Version 11.5.10.0 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

GOAL

The Diagnostics Apps Check is fundamental for Oracle Support to determinate customer file versions for specific products, most of known problems has patches and documentation associated that Oracle support will need to compare, so we encourage you to provide the Apps Check every time that you open a Service Request with Oracle Support.

This Report apply for versions 11i and R12, please see the instructions below.

SOLUTION

1) Log into your instance with user and password

2) Choose the Order Management or Purchasing responsibility

3) Go to Reports, Requests

4) Choose Run Requests > Single Request

5) At this point, you should be positionated in the Submit Request form, inside the frame Run this Request fill in Name field the value:

Diagnostics: Apps Check

6) Now you should get a Parameters window, now you can choose five application product to get the information. As an example we are using WIP, Inventory, Costing and Process manufacturing, you can use your own preferences:

7) Click in OK, Submit your request and get your Apps check and upload it to My Oracle Support (MOS) as required.

Convert Vertical records to Horizontal -Query

SQL> select * from test_table;
METRIC CURRENTVAL LASTVALUE AVERAGEVAL TREND
---------- ---------- ---------- ---------- ----------
Metric1 10% 20% 30% UP
Metric2 30% 20% 10% DOWN
Metric3 10% 10% 10% UNCHANGED
Metric4 10% 20% 10% Variable
Metric5 30% 60% 90% UP

SQL> with
2 lines as (select level line from dual connect by level <= 5),
3 cols as (select level col from dual connect by level <= 5)
4 select max(decode(col, 1,
5 decode(line, 1, metric,
6 2, CurrentValue,
7 3, lastvalue,
8 4, AverageValue,
9 5, trend))) col1,
10 max(decode(col, 2,
11 decode(line, 1, metric,
12 2, CurrentValue,
13 3, lastvalue,
14 4, AverageValue,
15 5, trend))) col2,
16 max(decode(col, 3,
17 decode(line, 1, metric,
18 2, CurrentValue,
19 3, lastvalue,
20 4, AverageValue,
21 5, trend))) col3,
22 max(decode(col, 4,
23 decode(line, 1, metric,
24 2, CurrentValue,
25 3, lastvalue,
26 4, AverageValue,
27 5, trend))) col4,
28 max(decode(col, 5,
29 decode(line, 1, metric,
30 2, CurrentValue,
31 3, lastvalue,
32 4, AverageValue,
33 5, trend))) col5
34 from lines, cols,
35 (select rownum rn, test_table.* from test_table)
36 where rn = col
37 group by line
38 order by line
39 /
COL1 COL2 COL3 COL4 COL5
---------- ---------- ---------- ---------- ----------
Metric1 Metric2 Metric3 Metric4 Metric5
10% 30% 10% 10% 30%
20% 20% 10% 20% 60%
30% 10% 10% 10% 90%
UP DOWN UNCHANGED Variable UP

Datatype Conversions

String to Int

String get_user_id_count = '123';
Number get_user_id_count_n = new Number(get_user_id_count);
int count=(get_user_id_count_n).intValue();

---------------------------------

Int to Number

int value = 0;
oracle.jbo.domain.Number num = new oracle.jbo.domain.Number(value);

---------------------------------

Compile CUSTOM.pll and Oracle FORM

To Compile CUSTOM.pll

PREQUISIT:
1) Set Environment variable
2) Run above command in $AU_TOP/resource

Use below command:
frmcmp_batch module=CUSTOM.pll userid=apps/<pwd> output_file=CUSTOM.plx module_type=LIBRARY batch=yes compile_all=special

----------------------------------------------------

To Compile FORM
Go to path where .fmb is present

Use below command:
frmcmp_batch userid=apps/apps module=<FORM_NAME.fmb> output_file=<FORM_NAME.fmx> module_type=form compile_all=special

or

frmcmp_batch module=<FORM_NAME.fmb> userid=apps/apps output_file=<FORM_NAME.fmx> module_type=form batch=yes compile_all=special

CO code to remove links on OAF page - Like Home,Logout

In PR

OAPageLayoutBean page = pageContext.getPageLayoutBean();
page.prepareForRendering(pageContext);
OAGlobalButtonBarBean buttons =(OAGlobalButtonBarBean)page.getGlobalButtons();
buttons.setRendered(false);

CEMLI performance checker

Concurrent Program: CEMLI performance checker
Its output is the report containing result based on performance of all the concurrent program with Trace enable (Result is PASS/FAIL).

1. create any (say 5) concurrent program whose performance needs to be checked make it (all)Trace enable
2. Run those concurrent programs one-by-one
3. Now at end run the CEMLI performance checker
4. view the log file, in that log file at end their is an URL where we can find the Performance report of our concurrent programs
5. copy-paste the URL in Browser (We have the required report)

Set FORMS_PATH in putty

applprod@xxo00005:/u02/R12/EBSPRD/fs1/EBSapps/appl/xxcustom_top/12.0.0/forms/US$ export FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US

Bouncing Appache

This is specially for OAF Developers, who frequently needs to bounce appache / oacore to refresh OAF pages

Set environment variable, use below command in putty
ps -ef | grep tns
Command output will be like
/u02/R12/EBSPRD/fs1/EBSapps/10.1.2/bin/tnslsnr APPS_EBSPRD -inherit

cd /u02/R12/EBSPRD/

. EBSapps.env run

This would set environment variable

------

In R12.2.X We need to bounce oacore, below commands to be executed from putty,
admanagedsrvctl.sh stop oacore_server1
admanagedsrvctl.sh start oacore_server1
(here we would need Weblogic password)

or we can bounce oacore from front end by login as weblogic user in console
http://<host_name>:7002/console/

Environment-->Servers-->Control-->click on oacore_server1-->Shutdown(Force Shutdown Now)-->ok
Environment-->Servers-->Control-->click on oacore_server1-->Start-->ok

------

In R12.1.X We need to start stop 2 scripts
adapcctl.sh
adoacorectl.sh

search below tops in putty to find above 2 scripts
$APPL_TOP
$CUSTOM_TOP
$ADMIN_SCRIPTS_HOME
$INST_TOP

>adapcctl.sh stop
>adoacorectl.sh stop
>adoacorectl.sh start
>adapcctl.sh start
--------

In 11i we only need to bounce appache
>adapcctl.sh stop
>adapcctl.sh start

Arabic_to_unicode in Java

String to Unicode Converter Sites:
http://www.arabunic.free.fr/
http://snible.org/java2/uni2java.html

Requirement was, if attachment is missing we should show error message
Complication was in Arabic Interface when attachment is missing it has value as "لا شيء " which is , "None " in English Interface.

so to store "لا شيء "(directly) in some variable was an issue in Java

Solution was to obtain the unicode for "لا شيء " from the above sites

and then,
String uni = "\u0644\u0627\u0020\u0634\u064A\u0621\u0020" <-------unicode for "لا شيء"

so now we can use variable "uni" in condition to show error message.

Alert - goes into exception

Alert goes in to exception but the query inside Alert is right also complete Alert setup is correct
then check if Workflow mailer is off, make it ON

System Administrator -> Oracle Applications Manager -> Workflow -> Notification Mailers = 'Up'

Monday, 29 December 2014

ADF Mobile - attached device not being recognised

Seemingly randomly I started having errors trying to deploy an ADF Mobile application to my MicromaxA210 mobile. I was getting

[11:26:02 AM] ---- Deployment started. ----

[11:26:02 AM] Target platform is (Android).

[11:26:02 AM] Beginning deployment of MAF application "SigCap" to Android using profile "run1".

[11:26:03 AM] Checking state of Android Debug Bridge server...

[11:26:03 AM] Android Debug Bridge server already running.

[11:26:23 AM] Verifying a single Android device is online and connected to the ADB server...

[11:26:23 AM] Deployment cancelled.

[11:26:23 AM] ---- Deployment incomplete ----.

[11:26:23 AM] Failed to detect a connected Android device. Make sure the device is connected. Otherwise, manually restart the ADB server. The following results were provided by ADB:

List of devices attached

emulator-5554 offline

(oracle.adfmf.framework.dt.deploy.android.deployers.CheckAttachedDevicesDeployer)

What I did to fix this was the following

1) From the Windows Start I ran devmgmt.msc and from here I found "Android Composite ADB Device" - I double clicked on this to chose to uninstall AND delete the driver.

2) I then re-connected the MicromaxA210 mobile and it started to install the driver. I got an error here but I pressed on regardless since now at least Windows Explorer could see the device although JDeveloper couldn't

3) I made sure USB Debugging was ON on the MicromaxA210 mobile AND I also switch off Media Device (MTP) which is a USB connection option.

The combination of the above and the luck of the gods seemed to have got things working.

Sunday, 30 November 2014

API - Supplier & Supplier Site Creation

declare
        l_vendor_rec AP_VENDOR_PUB_PKG.r_vendor_rec_type;
        l_vendor_site_rec AP_VENDOR_PUB_PKG.r_vendor_site_rec_type;
        x_return_status VARCHAR2(2000);
        x_msg_count NUMBER;
        x_msg_data VARCHAR2(2000);
        l_upd number := 0;
        x_vendor_id number;
        x_party_id number;
        x_vendor_site_id number;
        x_party_site_id number;
        x_location_id number;
        l_party_site_id number;
        l_organization_id number;
begin
     --mo_global.set_policy_context('S',1650);
          l_vendor_rec.SEGMENT1     := '1234577';
          l_vendor_rec.VENDOR_NAME  := 'TESTSUPPLIER';
          l_vendor_rec.SUMMARY_FLAG := 'N';
          l_vendor_rec.ENABLED_FLAG := 'Y';
         

            AP_VENDOR_PUB_PKG.Create_Vendor
            ( p_api_version    => 1,
              x_return_status  => x_return_status,
              x_msg_count      => x_msg_count,
              x_msg_data       => x_msg_data,
              p_vendor_rec     => l_vendor_rec,
              x_vendor_id      => x_vendor_id,
              x_party_id       => x_party_id
            );

            if (x_return_status <> 'S') then
                    dbms_output.put_line('Encountered ERROR in supplier creation!!!');
                    dbms_output.put_line('--------------------------------------');
                    dbms_output.put_line(x_msg_data);

                    IF x_msg_count > 1 THEN
                        FOR i IN 1..x_msg_count LOOP
                             dbms_output.put_line(substr(FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ),1,255));
                        END LOOP;
                    END IF;
            else
           
           
           
            l_vendor_site_rec.vendor_id            := x_vendor_id;
            l_vendor_site_rec.VENDOR_SITE_CODE     := 'HOME';
            l_vendor_site_rec.org_id               := 1650;
            l_vendor_site_rec.COUNTRY              := 'AE';                
            l_vendor_site_rec.ADDRESS_LINE1        :='Abu Dhabi';
            l_vendor_site_rec.PURCHASING_SITE_FLAG := 'Y';   
            l_vendor_site_rec.PAY_SITE_FLAG        := 'Y';   
             

            AP_VENDOR_PUB_PKG.Create_Vendor_Site
            ( p_api_version    => 1,
            x_return_status    => x_return_status,
            x_msg_count        => x_msg_count,
            x_msg_data         => x_msg_data,
            p_vendor_site_rec  => l_vendor_site_rec,
            x_vendor_site_id   => x_vendor_site_id,
            x_party_site_id    => x_party_site_id,
            x_location_id      => x_location_id
            );

            if (x_return_status <> 'S') then
                    dbms_output.put_line('Encountered ERROR in supplier site creation!!!');
                    dbms_output.put_line('--------------------------------------');
                    dbms_output.put_line(x_msg_data);
                            IF x_msg_count > 1 THEN
                                FOR i IN 1..x_msg_count LOOP
                                        dbms_output.put_line(substr(FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE ),1,255));
                                END LOOP;
                            END IF;
            ELSE
                        dbms_output.put_line('Supplier Site Created!!!');

            end if; 
           end if;  
end;

Tuesday, 25 November 2014

Create XML Publisher report without RDF

Create Oracle Report in just 4 simple easy steps.

1. Create Concurrent Program by using standard Executable ‘XDODTEXE’
Pls note: XDODTEXE is XML Publisher Data Template Executable

2. Create XML file based on below sample layout
Pls note: It will be used as Data Template File for XML Publisher Data Definition

3. Create Data Definition using XML Publisher Administrator Responsibility.

Pls note:

- Data Definition Code should be same as Concurrent program Short name

- Upload the XML File as Data Template

4. Create and upload RTF file as Template under XML Publisher Administrator Responsibility.

Pls note: Template code should be same as Data Definition code

Finish !!
-----------------------------------------------------------------------------------------------------------------------

Sample XML file for Data Template

-----------------------------------------------------------------------------------------------------------------------

<?xml version="1.0" encoding="UTF-8" ?>

- <dataTemplate name="XXADLQ_PR" version="1.0">

- <properties>

</properties>

- <parameters>

</parameters>

- <dataQuery>

<sqlStatement name="Q_PAYROLL">SELECT TO_CHAR(PPA.EFFECTIVE_DATE,'MON-YYYY') TIME_PERIOD, EMPLOYEE_NUMBER, FULL_NAME, PAP.NAME "POSITION_NAME", NATIONALITY, HAOU.NAME "DEPARTMENT",to_char(ORIGINAL_DATE_OF_HIRE,'DD-MM-RRRR')ORIGINAL_DATE_OF_HIRE, PETF.ELEMENT_NAME,SUM(ROUND(RESULT_VALUE,0)) RESULT_VALUE FROM PER_ALL_PEOPLE_F PAPF, PER_ALL_POSITIONS PAP, HR_ALL_ORGANIZATION_UNITS_TL HAOU, PER_ALL_ASSIGNMENTS_F PAAF, PAY_ASSIGNMENT_ACTIONS PAA, PAY_ELEMENT_TYPES_F PETF, PAY_INPUT_VALUES_F PIVF, PAY_RUN_RESULTS PRR, PAY_RUN_RESULT_VALUES PRRV, PAY_PAYROLL_ACTIONS PPA, PAY_ELEMENT_CLASSIFICATIONS PEC WHERE PAPF.PERSON_ID = PAAF.PERSON_ID AND PAAF.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID AND PAAF.ORGANIZATION_ID = HAOU.ORGANIZATION_ID AND PEC.CLASSIFICATION_ID = PETF.CLASSIFICATION_ID AND PETF.ELEMENT_TYPE_ID = PIVF.ELEMENT_TYPE_ID AND PIVF.ELEMENT_TYPE_ID = PRR.ELEMENT_TYPE_ID AND PIVF.INPUT_VALUE_ID = PRRV.INPUT_VALUE_ID AND PRR.RUN_RESULT_ID = PRRV.RUN_RESULT_ID AND PAA.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID AND TRUNC(SYSDATE) BETWEEN PAAF.EFFECTIVE_START_DATE AND PAAF.EFFECTIVE_END_DATE AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE AND PAPF.EMPLOYEE_NUMBER = nvl(:P_EMP_NUMBER,PAPF.EMPLOYEE_NUMBER) --AND PPA.EFFECTIVE_DATE BETWEEN :P_FROM_DATE and :P_TO_DATE AND PPA.EFFECTIVE_DATE = (select max(EFFECTIVE_DATE) from PAY_PAYROLL_ACTIONS where to_char(effective_date,'MON-RRRR') like :P_TIME_PERIOD) AND RESULT_VALUE IS NOT NULL AND PIVF.NAME LIKE 'Pay Value%' AND PEC.CLASSIFICATION_NAME LIKE 'Earning%' AND PAAF.POSITION_ID = PAP.POSITION_ID AND HAOU.NAME = nvl(:P_DEPARTMENT,HAOU.NAME) AND HAOU.LANGUAGE = 'US' GROUP BY EMPLOYEE_NUMBER, PETF.ELEMENT_NAME, FULL_NAME,NATIONALITY, PAP.NAME, HAOU.NAME, ORIGINAL_DATE_OF_HIRE, PPA.EFFECTIVE_DATE ORDER BY EMPLOYEE_NUMBER</sqlStatement>

</dataQuery>

-----if we want one more sql query we add here......

- <dataStructure>

- <group name="G_PAYROLL" source="Q_PAYROLL">

-----if we have one more group we can add here.....

</group>

</dataStructure>

</dataTemplate>

Tuesday, 18 November 2014

How to set where clause programmatically in OAF?

Imagine this is the query in your VO:

select  empno,name from Employee;

So in this query you want to set the where clause programatically run time. So what you do is in your VOImpl.java file where you are writing the initQuery method use the below code:

vo.setWhereClause(null);

vo.setWhereClauseParams(null);

vo.setWhereClause("employee_number = :1 and Person_id = :2");

vo.setWhereClauseParam(1,empno);

vo.setWhereClauseParam(2,personid);

vo.executeQuery();

Below example shows coding handled in CO

public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)

{

super.processFormRequest(pageContext, webBean);

if(pageContext.getParameter("item3")!=null)

{

/* The below code line is used to initialize the application module */

OAApplicationModule am=(OAApplicationModule)pageContext.getApplicationModule(webBean);

/* The below code line is used to initialize VO*/

XxepmVOImpl vo=(XxepmVOImpl)am.findViewObject("XxepmVO1");

String from_date = pageContext.getParameter("item1");

String to_date = pageContext.getParameter("item2");

vo.setWhereClause(null);

vo.setWhereClauseParams(null);

vo.setWhereClause("to_date(XxepmEO.START_DATE,'DD-MM-RRRR') between to_date(:1,'DD-MON-RRRR') and to_date(:2,'DD-MON-RRRR')");

vo.setWhereClauseParam(0,from_date);

vo.setWhereClauseParam(1,to_date);

vo.executeQuery();

// String message = String.valueOf(am);

// String message = String.valueOf(vo);

//throw new OAException(from_date, OAException.INFORMATION);

/* DataDisplayVO1 is the instance name in AM which is the original name of the VO */

// vo.executeQuery();

}

Thursday, 19 January 2012

Diffrence between Personalization, Extension and Customization

In Oracle EBS development, the terms Personalization, Customizations & Extensions are often used interchangeably. It often creates confusion among developers regarding the meaning of these terms. These terms are critically important terms that developers must understand and use properly. Let’s discuss them briefly here to simply understand what they are.

What is Personalization?
Personalization is the process of making changes to the User Interface (UI) from within an Oracle E-Business Suite Form/Page. It is possible to make personalization to both Form-based and OA Framework based pages.
Simply it can be stated as Enabling or Disabling some fields on User Interface is personalization.

What is Extension?
Extension is the process of making changes to the programmatic (i.e., PL/SQL or Java) elements of an E-Business Suite form/page. It is possible to extend both Forms based and OA Framework-based pages.
Simply it can be stated as adding Enhancement over previous is extension.

What is Customization?
Customization is the process of creating new forms/pages. While Oracle does provide tools to do this (i.e., Oracle Forms and JDeveloper 10g with OA Extension), this is the least supported option.

Tuesday, 27 September 2011

Setting Up Your First Ext GWT Project in Eclipse

For those of you just entering the Ext GWT world, this is a quick guide for setting up your first project in Eclipse.

Prerequisites

It is assumed you already have a working Eclipse install with a recent JDK on your computer. This guide was made using Eclipse 3.6 and JDK 6.

GWT

Follow the GWT setup: http://code.google.com/eclipse/docs/getting_started.html

Ext GWT

Download the latest Ext GWT release (currently 2.2.0).http://www.sencha.com/products/gwt/download.php

Create User Defined Library

Select Windows > Preferences and select Java > Build Path > User Libraries in the preference tree. Click New and type "GXT" into the User library name field. Make sure your new library is selected and click Add JARs. Navigate to the root folder of the Ext GWT download and add the "gxt.jar" file. Click OK.

Create Project

Click the New Web Application Project button in Google toolbar to create a new GWT project. Alternatively, if you don't see the button in the toolbar, you can click File > New > Other and select Web Application Project under the Google folder and click Next. In the Project name field, write "HelloGXT". In the Package field, write "com.hello.gxt". Make sure under Google SDKs the "Use Google Web Toolkit" box is checked. Click Finish.

Build Path

In the Project Explorer, you will see a new folder with your project's name. Right click that folder and click Build Path > Configure Build Path. This takes you to the Properties of your project under the Java Build Path settings. Click Add Library and then select User Library and click Next. Make sure the check box for your Ext GWT library is checked and click Finish. Your Ext GWT library should now appear in your build path.

Resources

Copy the resources folder from the Ext GWT download into your war folder. 20100920-gxt2

HTML

Open HelloGXT.html in Eclipse and delete the table and h1 data in the body tag. Add the following lines to the head tag.

<link rel="stylesheet" type="text/css" href="resources/css/gxt-all.css" />
<script language='javascript' src='resources/flash/swfobject.js'></script>

XML

Open HelloGXt.gwt.xml in Eclipse. Add the following line under the Other module inherits line.

<inherits name="com.extjs.gxt.ui.GXT" />

Hello World

To test that you have properly setup Ext GWT, try running this sample program. Replace the EntryPoint class in HelloGXT.java with the sample below.

public class HelloGXT implements EntryPoint{
	@Override
	public void onModuleLoad() {
		MessageBox.info("Message", "Hello World!!", null);
	}
}

Run your program like any GWT project (seehttp://code.google.com/eclipse/docs/getting_started.html). If you setup Ext GWT correctly, you should see a message box with the words Hello World!! Congratulations! You have created your first Ext GWT project. 20100920-gxt3