OAF Creating Child Page (Data Entry) in different page

1. To Create OAF Master-Child (Detail) page in the same screen chk the below link.
http://mogalafzal.blogspot.ae/2016/03/17-oaf-entry-master-detail-page.html

2. To create OAF Master in Single Page and Child (Detail)  in another page, then

Create a Master Page as a Normal Data Entry Page then do the below steps.

Creating Child Page
Xxchild --> Table Name (make sure you have foreign key directing to the master table, and keep the both columns same )
1. right click>/xxmasdet/oracle/apps/per/md/server package>new
ADF Business components >Business components from Tables.
2.
Give your new child table name>next>Change the package path for View>next>Select your AM which is already existing in last window.
Created automatically:
EO: Xxchild
EOLink: (Association) XxchildFkAssoc
View: XxchildView
3.
Create ViewLink
go to the views path>right click> view link
Give viewlink name>XxchildFkLink
left window> Expand the master table View> select the select  XxchildFkAssoc
Right window> Expand the child table View> select the select  XxchildFkAssoc
yes both tables select the same field.

4.
Right click the EO Xxchild>Edit> java> Enable 'Create Method'

5.
Right Click XxchildFkAssoc> Edit>Association Properties> Enable 'Composition Association'

6.
Right Click XXAM (Application Module)> Edit>
6.1 Move first your View Object> XxChildView> to right side
6.2 Move under 'XxMasterView' left side  record  'XxchildView via  XxchildFkLink' --> to as child record under 'XxMasterView'


7.
Under AMImpl java file add create row method as below

    public void AddXxChild() {
            OAViewObject vo = (OAViewObject)getXxChildView2();
           // if (!vo.isPreparedForExecution()) {
                    vo.executeQuery();
           // }
            Row row = vo.createRow();
            vo.insertRow(row);
            row.setNewRowState(Row.STATUS_INITIALIZED);
    }

8.
Open EOImpl java file   
Under   
        public void create(AttributeList attributeList) {
        super.create(attributeList);
        /* add your logic from here to get default values*/
        OADBTransactionImpl transaction = (OADBTransactionImpl)getOADBTransaction();
                 Number FileNumberseq = transaction.getSequenceValue("FFRD_FILE_NO_S"); //Sequence to get into field FileNumeber
                //String FiileNumberStr = FileNumberseq;
                String getNum = FileNumberseq.toString();
                setFileNumber(getNum);       
               setFileDate(transaction.getCurrentDBDate());//sysdate to get into field FileDate
 
    }

9. Invoking above method or invoking row initialize using the below in ProcessFormRequest

      else if (pageContext.getParameter("Child") != null) { //Child is the item id of type Submitbutton
          am.invokeMethod("addPlayerAction");
          pageContext.setForwardURL("OA.jsp?page=/xxmasdet/oracle/apps/per/md/webui/ChildPG",
                                     null,
                                     OAWebBeanConstants.KEEP_MENU_CONTEXT,
                                     null,
                                     null,
                                     true, // Retain AM
                                     OAWebBeanConstants.ADD_BREAD_CRUMB_YES,
                                     OAWebBeanConstants.IGNORE_MESSAGES);
      }

10.
Creat items as buttons from Master to Child and check the Master Primary_column should be defaulted into Child Foregin_key Column automatically
Else something is wrong.
   

Query find Custom Reports/Programs and Custom Forms registered in the EBS

1.
Query find Custom Reports/Programs

SELECT CONCURRENT_PROGRAM_ID,CONCURRENT_PROGRAM_NAME,
USER_CONCURRENT_PROGRAM_NAME,DESCRIPTION, APPLICATION_ID
 FROM FND_CONCURRENT_PROGRAMS_VL
  WHERE CREATED_BY NOT IN ( -1,1,2,120,121,0)
--('AUTOINSTALL','INITIAL SETUP','ORACLE12.0.0','SYSADMIN','ANONYMOUS','ORACLE12.1.0')
 AND ENABLED_FLAG = 'Y'
 AND SRS_FLAG = 'Y'


2.
Query to find Custom Forms

 SELECT APPLICATION_ID, FORM_ID, FORM_NAME,DESCRIPTION FROM FND_FORM_VL
 WHERE CREATED_BY NOT IN ( -1,1,2,120,121,0)

Oracle SSHR How To Add More Detailed Information In FYI Notifications?

How To Add More Detailed Information In FYI Notifications?
Notification recipients can view transaction changes on the FYI Notification page after transactions are either approved or rejected.
The system administrator must add the parameter &pNtfFyiDetails=Y to the _SS functions.

1. System Administrator responsibility
2. Application > Function
3. Add &pNtfFyiDetails=Y into form parameters to both functions: HR_LOA_SS and HR_LOA_MGR_SS
4. Save

To submit Concurrent Request using the (SSHR) OAF Page:

To submit Concurrent Request using the SSHR Page:

1. 
   

2.

SSWA jsp function

3.

For a Particular Program:

OA.jsp?akRegionApplicationId=0&akRegionCode=FNDCPPROGRAMPAGE&programApplName=XXCUST&programName=XXEMPNOC&programRegion=Hide&scheduleRegion=Hide&notifyRegion=Hide&printRegion=Hide

For any Program:

OA.jsp?akRegionApplicationId=0&akRegionCode=FNDCPPROGRAMPAGE&scheduleRegion=Hide&notifyRegion=Hide&printRegion=Hide

4. Attach the function to the Responsibility Menu of Self service.

5. it will not show directly to the Selfservice Menu we need to add under Custom Menu named

AE Self Service Functions Custom

6. Set the Profile Option at Site Level “MO: Operating Unit” , if not set will get an error in the page. (Doc ID 393560.1)

For Parameters:

Payroll_id :

Default Type: SQL Statement

SELECT PAAF.PAYROLL_ID FROM PER_ALL_ASSIGNMENTS_F PAAF, PAY_ALL_PAYROLLS_F PPF WHERE TRUNC(SYSDATE) BETWEEN PAAF.EFFECTIVE_START_DATE AND PAAF.EFFECTIVE_END_DATE AND PAAF.PRIMARY_FLAG = 'Y' AND PERSON_ID IN (SELECT EMPLOYEE_ID FROM FND_USER WHERE USER_ID = fnd_profile.value('USER_ID')) AND ROWNUM =1AND PAAF.PAYROLL_ID = PPF.PAYROLL_ID

Person Id: (hidden)

Default Type SQL Statement

SELECT EMPLOYEE_ID FROM FND_USER WHERE USER_ID = fnd_profile.value('USER_ID') AND ROWNUM = 1

Payroll_Action_id: (in rdf report AFTER PARAMETER FORM)

select distinct paa.payroll_action_id--, ptp.time_period_id

  into :p_payroll_action_id

from

per_all_assignments_f paaf,

pay_payroll_actions ppa,

per_time_periods ptp,

pay_assignment_actions paa

where

ptp.time_period_id = ppa.time_period_id

and paaf.assignment_id = paa.assignment_id

and paa.payroll_action_id = ppa.payroll_action_id

--and paa.payroll_action_id = 2035382

and paaf.person_id = :p_person_id--26876

and ptp.time_period_id = :p_time_period_id-- 5010

 

Adding report in the menu as a function R12 (not submitting from request, not adding to request group)

Adding report in the menu as a function (not submitting from request, not adding to request group):

1. Create form Function
2. Add the form function to the desired Menu.

Image1:

Image2:

Image3:

CONCURRENT_PROGRAM_NAME="XXPROGRAMS" PROGRAM_APPL_SHORT_NAME="XXCUST"

CONCURRENT_PROGRAM_NAME = Program Short Name

How to Enable attachment link in the form

How to Enable attachment link in the form:

Doc ID: 369215.1

0.
Register your custom table with minimum Primary key column mandatory.

----------------------------Registering Table optional--------------------------------

declare

p_appl_short_name varchar2(20) :='FND';

            p_tab_name varchar2(240):= 'XX_CUSTOM_TABLE';

            p_tab_type   varchar2(2) :='T';

            p_next_extent number := 512;

            p_pct_free     number :=  10;

            p_pct_used     number := 70;

begin

ad_dd.register_table

           (p_appl_short_name ,

            p_tab_name         ,

            p_tab_type        ,

            p_next_extent    ,

            p_pct_free    ,

            p_pct_used );

end;

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

--------------------------Registering Column optional-----------------------------

 declare

           p_appl_short_name VARCHAR2(20) := 'FND';

            p_tab_name      varCHar2(20):= 'XX_CUSTOM_TABLE';

            p_col_name     varCHar2(20) := 'XX_COLUMN1';

            p_col_seq      number := 1;

            p_col_type     varCHar2(20) := 'VARCHAR2';

            p_col_width    number := 20;

            p_nullable     varCHar2(20) := 'N';

            p_translate    varCHar2(20) := 'Y';

            p_precision    varCHar2(20) := '';

            p_scale       varCHar2(20) := '';

            begin

ad_dd.register_column

           (p_appl_short_name  ,

            p_tab_name       ,

            p_col_name    ,

            p_col_seq      ,

            p_col_type    ,

            p_col_width    ,

            p_nullable    ,

            p_translate   ,

            p_precision    ,

            p_scale    );

            end;

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

go to > Application Developer>Attachments>

1.

Entity Id/Entity name/Prompt: give meaningful which wil be appeared viewed by the end user.

2.

3.

4.

5.

6.

7.

Known Issues:

1. Error: FRM-40815:  Variable Global.A7_1_PK1 does not exist.

Solution: give Primary key correctly with block.column as in point 5.

2. if the link not appars then add this code before data block when_new_block_instance trigger.

 add When_new_block_instance trigger and put the  APP_STANDARD.EVENT('WHEN-NEW-BLOCK-INSTANCE'); 

Testing:

1.

2.

Click the attachment link

Give Meaningful Title, Description.

If ‘File’ selected it wil direct to oaf page others will be entered down.

Select File and click submit.

Go to the form, click yes as below.

Click Open document to view the same.