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 );

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

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);