R12 - To check which server your browser is connecting to

http://ebs.server.com/cgi-bin/which.cgi

Disable DFF Attributes in OAF Page

Diable DFF Attributes in OAF Page

Create a raw text item and give below java script.  Add 

SCRIPT type="text/javascript"

     var elementInDocument = function (element) {         while (element = element.parentNode) {             alert('ele ' + element);             alert('doc ' + document);             if (element == document) {                 return true;             }         }         return false;     };     if (elementInDocument("xxswCACPageNewFlag") == false) { if (document.getElementById("salesChannel").value != '') { document.getElementById("salesChannel").disabled = true; }if (document.getElementById("ActFlexField1").value != '') {             document.getElementById("ActFlexField1").disabled = true;             document.getElementById("ActFlexField2").disabled = true;             document.getElementById("ActFlexField3").disabled = true;             var cacGroup = document.getElementById("ActFlexField1__xc_0");             var cacGroupImg = cacGroup.getElementsByTagName("a");             cacGroupImg[0].style.visibility = 'hidden';             cacGroupImg[0].onclick = function () {                 return false;             } ;  var cacCode = document.getElementById("ActFlexField2__xc_0");             var cacCodeImg = cacCode.getElementsByTagName("a");             cacCodeImg[0].style.visibility = 'hidden';             cacCodeImg[0].onclick = function () {                 return false;             }       }        } 

SCRIPT

Menu - Sub Menu - Function (as tree structure) for a given Menu

SELECT LPAD(' ', 6*(LEVEL-1)) || menu_entry.entry_sequence sequence
, LPAD(' ', 6*(LEVEL-1)) || menu.user_menu_name SubMenu_Description
, LPAD(' ', 6*(LEVEL-1)) || func.user_function_name Function_Description
, menu.menu_id
, func.function_id
, menu_entry.grant_flag Grant_Flag
, DECODE( menu_entry.sub_menu_id
, null, 'FUNCTION'
, DECODE( menu_entry.function_id
, null, 'SUBMENU'
, 'BOTH')
) Type
FROM fnd_menu_entries menu_entry,
fnd_menus_vl menu,
fnd_form_functions_vl func
WHERE menu_entry.sub_menu_id = menu.menu_id(+)
AND menu_entry.function_id = func.function_id(+)
AND grant_flag = 'Y'
START WITH menu_entry.menu_id = (SELECT menu_id
FROM fnd_menus_tl menu2
WHERE menu2.user_menu_name = :Parent_Menu_User_Name)
CONNECT BY menu_entry.menu_id = PRIOR menu_entry.sub_menu_id
ORDER SIBLINGS BY menu_entry.entry_sequence 

NLS_LANGUAGE

To set in unix / linux

To download concurrent program ldt with translations we have to take 2 ldt files for each language
first take english file

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP_us.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM"

To change language use below

export NLS_LANG="BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1"

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP_br.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM".

To change language in Database use
alter session

Ex -
ALTER SESSION SET NLS_LANGUAGE='BRAZILIAN PORTUGUESE';

Useful queries

Fnd concurrent requests for request set

select fc.* from fnd_amp_requests_v fc start with parent_request_id = 39432608 connect by prior request_id = parent_request_id and level = 2;

Make DFF Segment readonly through Security Rules

Found good blog post

http://erpschools.com/articles/make-dff-segment-readonly-through-security-rules

Just copying it here for my records -

Goal: Define new DFF segment in Transactions Form and make it read only to Receivables Manager responsibility. All other responsibilities will have access to enter and edit the values and Receivables Manager will have access to only read but not edit and enter the value.

You cannot make DFF segment read-only through personalization but you can restrict users from changing the value in DFF segment through personalization by displaying error message when they try to save the form.

Steps:
1. Define New Segment for DFF in Transactions forms.
2. Define Security Rules
3. Test it.

If you are not familiar with enabling the DFF (Descriptive FlexFields) click here

Define new SEGMENT for DFF in Transactions Form

Navigation: Receivables Manager >> Transactions >> Transactions

click on the box which is enclosed in []

So we have already one segment Available.

DFF that I have in this form is

Title	Transaction Information
Application	Receivables

And it has one segment enabled and displayed.

Navigation: Application Developer >> Flexfield >> Descriptive >> Segments

Enter F11 and then fill the information

: Receivables

Title: Transaction Information

Do CTL + F11

uncheck the “Freeze Flexfield Definition”

Click OK

Now the screen looks like this.

Add New Segment by clicking + Icon on the toolbar and enter the following information

Number	10
Name	DEMO
Window Prompt	ERP DEMO
Column	ATTRIBUTE11

Value Set: erp_demo (click here to see how to define value set)

Click open

Check Security Enabled Flag and uncheck the Required flag

save (CTL+S)

Close it.

Close Segments Screen.

Check the Freeze Flexfield Definition check box

Click OK.

Save it.

Click OK.

Close this Form.

Define Security Rules

Navigation: System Administrator Responsibility >> Security >> Responsibility >> ValueSet >> Define

Click to open

Enter existing value set name erp_demo which we assigned to DFF segment that we defined above.

Click Find

Enter the following information

Name	erpschools
Description	erpschools.com
Message	erpschools.com demo

In Security Rile Elements

Type	Exclude
From	A
To	D

Add New record and enter

Type	Include
From	Don’t fill anything
To	Don’t fill anything

Save it.

Click on Assign Button to restrict this functionality to a specific responsibility. This is optional.

Enter the following information

Application	Receivables
Responsibility	Receivables Manager
Name	erpschools

Save and close.

Testing:

To test the changes Navigate to any Receivables Responsibility like US Receivables Manager which has access to Transactions form and query up any record.

Then navigate to DFF and enter some value for ERP DEMO and save the record.

Come back to Receivables Manager responsibility and query up the same transaction which you saved above.

Define New ValueSet:

To assign values to this value set follow the navigation path below and do accordingly

Navigation: Application Developer >> Flexfield >> Descriptive >> Values

XMl syntaxes

To display number in words

xdofx:to_check_number(12345.67, 'USD') 

Good link - https://blogs.oracle.com/xmlpublisher/entry/numbers_to_words_update

format-number:PaymentAmount/Value;'999G999D99'
xdofx:lpad(PaymentAmount/Value,12,'*')

xdoxslt:lpad(format-number(number(PaymentAmount/Value),’###,##0.00’),13,’*’)
https://community.oracle.com/thread/634899?tstart=0

Exponential number fix
fo:bidi-override direction="ltr" unicode-bidi="bidi-override">

Ref issue
----------

In MS Word, under BI Publisher-> Options, set Form Field Size to Backward Compatible instead of removing tags

------------
Change decimal format in RTF template

Create a field on top of RTF file like below.  Create some dummy field.



In field use like below


----