Tuesday, January 2, 2018

How do we find the Current Form Function name in Oracle EBS 11i/R12 Form Name

How do we find the Current Form Function name in Oracle EBS 11i/R12

Form Name :






Form Name = CSTFITCT





Function Name :



Function Name = CST_CSTFITCT

Query to identify the form name base on function name

 SELECT   ff.FORM_NAME,
         ff.USER_FORM_NAME,
         ff.DESCRIPTION form_description,
         fff.FUNCTION_NAME,
         fff.USER_FUNCTION_NAME
  FROM   fnd_form_vl ff, FND_FORM_FUNCTIONS_VL fff
 WHERE   ff.FORM_ID = fff.FORM_ID AND ff.form_name = 'FROM_NAME' 

Global Variable FND_CUSTOM_FUNCTION_NAME stores the Current Function Name of the forms session.

How Does Hide The Picture Tab That Is Available On The “People and maintain “ Form From “SA HR Manager Responsibility”?

How Does Hide The Picture Tab That Is Available On The “People and maintain “ Form From “SA HR Manager Responsibility”?

How Does  Hide The Picture Tab That Is Available On The “People and maintain “ Form From
“SA HR Manager Responsibility”?



Steps:
1.Using the “SA HRMS Manager” Responsibility
Navigate to Security -> Taskflow Definitions.
Query the “SA HRMS PERSON TASKFLOW”, hit the copy button and name your new taskflow “VION SA HR PERSON TASKFLOW”.


 In the Node Region of the window, in the name field query the node “NPERSON”

Now Delete PICTURE,and Save it.
2.Using the System Administrator Responsibility create a custom function to call this new taskflow and add to your menu.
Navigate -> Application -> Function
Create a new function
Funtion                         =   PERWSHRG-XX
User Function Name =  Combined Person & Assignment Form WF="XX HR TSKFLW"
Description                  =  Enter a description for your new function

On the forms tab, enter the following
Form= Combined Person & Assignment Form
The application would default to Human resources
In the Parameters field enter  WORKFLOW_NAME="VION SA HR PERSON TASKFLOW"
You have now created a new function to call the taskflow without the  Picture option.

3.Now add this to your menu,

Navigate to Application -> Menu
Query the menu attached to your responsibility.
Add a relevant prompt and in the function column , choose the Combined Person & Assignment Form WF="XX HR TSKFLW" function.

Remove the seeded entry for the People Enter & Maintain form.

Find Responsibility Name attached with Profile

SELECT DISTINCT tr.responsibility_name,

  r.RESPONSIBILITY_KEY,
  r.end_date,
  fpotl.user_profile_option_name,
  fpov.profile_option_value,
  psp.SECURITY_PROFILE_NAME
FROM applsys.fnd_responsibility_tl tr,
  applsys.fnd_responsibility r,
  hr.per_security_profiles psp,
  apps.per_business_groups pbg,
  fnd_profile_options_vl fpovl,
  applsys.fnd_profile_option_values fpov,
  applsys.fnd_profile_options fpo,
  applsys.fnd_profile_options_tl fpotl
WHERE r.responsibility_id          = tr.responsibility_id
AND r.application_id               = tr.application_id
AND fpov.PROFILE_OPTION_ID         = fpovl.PROFILE_OPTION_ID
AND fpov.level_value               = r.responsibility_id
AND psp.BUSINESS_GROUP_ID          = pbg.BUSINESS_GROUP_ID (+)
AND fpov.profile_option_value      = TO_CHAR(psp.SECURITY_PROFILE_id)
AND fpov.level_id                  = 10003
AND fpo.profile_option_id          = fpov.profile_option_id
AND fpotl.profile_option_name      = fpo.profile_option_name
AND fpotl.user_profile_option_name = 'HR: Security Profile'
AND psp.security_profile_name      ='US Federal Government';

Form Personalization : Restrict LOV in People and Maintain

Form Personalization : Restrict LOV in People and Maintain

Form Personalizations:

Restrict Lov Value through Form Personalization.

The below steps are changing the LOV in “Title” field in the “People and maintain” form using Form Personalization (just want to list the Title  in ‘Mr.’,’Doctor’ on Oracle Apps R12:

  1. Open the Define User Form on Human Resourse Vision Operations (People and Maintain  
  2. Open the Personalization form using the navigation “Help > Diagnostics > Custom Code > Personalize”
  3. Enter the sequence number as 10 and description “Change Value of  Title LOV”
  4. Select the Trigger Event as “WHEN-NEW-FORM-INSTANCE” and save the changes
  5. On Actions tab, enter or select the following values
    • Sequence = 10
    • Type = Builtin
    • Description = Create New Record Group
    • Language = All
    • Enabled = Yes
  6. On the right side of Actions tab, enter or select the following values
    • Builtin Type = Create Record Group from Query
    • Arguments =     SELECT lookup_code,meaning FROM HR_LOOKUPS
  7.   WHERE LOOKUP_TYPE='TITLE'
  8.   and lookup_code in ('DR.','MR.')Group Name = XX_TITLE__GROUP
  9. Click on the “Validate” button, then click on “Apply Now” button
  10. On next Actions tab, enter or select the following values
    • Sequence = 20
    • Type = Property
    • Description = Assign New Record Group
    • Language = All
    • Enabled = Yes
  11. On the right side of Actions tab, enter or select the following values
    • Object Type = LOV
    • Target Object = TITLE_LOV
    • Property Name = GROUP_NAME
    • Value = 
    XX_TITLE__GROUP
  12. Validate All (Menu Tool > Validate All), Apply and Save the changes
13.  Close the Define User form and open it again. 

Form Personalization : To Disable the Approve Button From Inventory At User Level

Form Personalization : To Disable the Approve Button From Inventory At User Level

Hide approve Button From user level through personalization.

User: OPERATION

Steps:
-------

Navigations: 

Inventory Ã  Move Orders Ã  Move Orders


Enter the Form Personalization form.

Navigations: 

(M) Help Ã  Diagnostics Ã  Custom Code Ã  Personalize. 

Rules Sequence               : 10
Description                        : Disable Approve button
Leve                                      : Function
Enabled                               : Yes
Trigger Event                     : WHEN-NEW-FORM-INSTANCE
Trigger Object                   :
Processing Mode             : Not in Enter-Query Mode
Context                                                : User level and set value to your user name.--i.e "OPERATIONS"  User


Save your work.



Select the Actions tab.
Actions Sequence           : 10
Type                                      : Property
Object Type                       : Item
Target Object                    : 
TOMAI_MAIN_HEADER_BLK.DONE
Property Name                 : DISPLAYED
Value                                    : FALSE





Save your work and exit all form and re-enter and see the result. You will notice the the "Approve" button at the bottom of the form is no longer displayed from 
"OPERATION" Login

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...