Join between PO and PA modules -- Oracle Apps R12

 SELECT PHA.SEGMENT1, PT.Task_name , PT.TASK_ID, PLA.UNIT_PRICE
FROM   PA_PROJECTS_ALL PA,
    PA_TASKS PT,
    PO_DISTRIBUTIONS_ALL PDA,
    PO_LINE_LOCATIONS_ALL PLLA,
    PO_LINES_ALL PLA,
    PO_HEADERS_ALL PHA,
    PO_REQ_DISTRIBUTIONS_ALL PRDA,
    PO_REQUISITION_LINES_ALL PRLA,
    PO_REQUISITION_HEADERS_ALL PRHA
WHERE  PA.PROJECT_ID = PT.PROJECT_ID
AND    PT.TASK_ID = PDA.TASK_ID
AND    PDA.LINE_LOCATION_ID = PLLA.LINE_LOCATION_ID
AND    PLLA.PO_LINE_ID = PLA.PO_LINE_ID
AND    PLA.PO_HEADER_ID = PHA.PO_HEADER_ID
AND    PDA.REQ_DISTRIBUTION_ID = PRDA.DISTRIBUTION_ID(+)
AND    PRDA.REQUISITION_LINE_ID = PRLA.REQUISITION_LINE_ID(+)
AND    PRLA.REQUISITION_HEADER_ID = PRHA.REQUISITION_HEADER_ID(+)
AND   (PHA.CANCEL_FLAG IS NULL OR PHA.CANCEL_FLAG = 'N')
AND   (PLA.CANCEL_FLAG IS NULL OR PLA.CANCEL_FLAG = 'N')
AND   (PLLA.CANCEL_FLAG IS NULL OR PLLA.CANCEL_FLAG = 'N')
AND PA.PROJECT_ID = 3109;

Create custom form and integrate with EBS R12

In Order to Create Custom Form n integrate it with EBS

• First Create the form on Form builder Run it on local machine.

• Then copy    APPSTAND.fmb, TEMPLATE.fmb

                 From   $AU_TOP /form/US

And Copy  ALL  .plls  from  $AU_TOP /Resource

In same directory on local machine then

• Set form path      i.e. (the directory of these forms and .plls) in registory

       Go in RUN => Regedit => HKEY_LOCAL_MACHINE  => SOFTWARE=>ORACLE =>

       FORM_PATH
       E:\DevSuiteHome_2\cgenf61\admin;E:\DevSuiteHome_2\forms;C:\Documents and Settings\aff- 
       functional\Desktop\EBS_FORM_integration 
       
      (Path can be changed but does not contain spaces, can be set as environment variable also)
      

• Then Open Template.fmb and APPSTAND.fmb in Oracle Form Builder compile then must
   compile successfully.

• Create Canvas and a window   give reference of window in canvas properties      
   window in canvas properties and canvas in window   properties.

• Set module level properties i.e. change name, first Navigation Block.

• Make sure that all fields, canvases, window , all other objects should inherit the respective

property classes.

• Now put the .fmb  files in $AU_TOP  then

• Make a compile.sh file  with this  code
 

• put  The file in     /home/oracle/developer/Scripts

• connect to  APPS Server  by using putty

set form path

. /u01/oracle/PROD/apps/EBSapps.env run

 
export:

export FORMS_PATH=$AU_TOP/resource:$AU_TOP/forms/US:$AU_TOP/resource/US

• Then  go the path of  . compile.sh

frmcmp_batch userid=apps/apps_password module=/u01/oracle/TEST/apps/fs2/EBSapps/appl/ap/12.0.0/forms/US/XX_CUSTOM_FORM.fmb 
            output_file=/u01/oracle/TEST/apps/fs2/EBSapps/appl/ap/12.0.0/forms/US/XX_CUSTOM_FORM.fmx module_type=form batch=no compile_all=special

For eg: /home/oracle/developer/Scripts

Execute compile.sh

This should return       no compilation Error.

And with file creation message message for Eg:

Created form file /d01/oracle/TEST/apps/apps_st/appl/au/12.0.0/forms/US/
XX_CUSTOM_FORM.fmx

• Copy File from path and put it in directory where u want to see the Form

• Now login to Application

• Switch Responsibility Of Oracle application Developer

Register form with  Module

Assign form form to Function

Assign Function to menu of Specific Responsibility.(Do this from System administrator also)

• Switch to Responsibility  where u register the form.

Change The Title of the Forms MDI Window of Oracle Applications

The title for the main, Multiple Document Interface (MDI) window within the forms interface is stored in the profile option "Site Name".

From the System Administrator Responsibility, navigate to Profile -> System and enter an appropriate value for "Site Name".

This profile is settable only at the Site level and will appear in the title bar after logging out and then back in .