How to Enable Personalization link for OAF Pages

Set the values of following profiles to enable Personalization Page link in OAF Page

Profile Name	Value
FND: Personalization Region Link Enabled	Yes
Personalize Self-Service Defn	Yes
Disable Self-Service Personal	No

How to remove bursting control file

Upon attaching a bursting control file to a data definition to test the functionality. Now there is no option to get rid of it, unfortunately there is no delete button or anything similar in XML Publisher Administrator. How can I delete the file?

Solution:

There is no option to set any inactive_date or delete the file on the whole. But you can, if you have access to the database the following option, to vanish the file:

DELETE
FROM XDO_LOBS
WHERE LOB_CODE=<DATA_DEFINITION_CODE>
AND LOB_TYPE='BURSTING_FILE';

How To Re Compile A Concurrent Program Parameter Descriptive Flexfield ( DFF)

Issue: The descriptive flexfield with application name XX(XX) and name $SRS$.XX ($SRS$.XX) is not compiled. Please contact your system administrator"

Solution:

We can retrieve and check the flexfield context definition by running the following SQL statement:

select *
from FND_DESCR_FLEX_CONTEXTS_VL
where descriptive_flexfield_name like '%IBY_FC_CREATE_SETTLE_BATCHES%'

To compile the parameter flexfield use the following steps:

1. System Administrator > Concurrent Request > Program > retrieve the concurrent program (e.g.XXABC_Report).

2. Click Parameters button.

3. Update description of one parameter e.g. add XX to description of P_CONC_PROGRAM_NAME parameter for example: Concurrent Program Name XX

4. This will trigger compilation of this DFF (internally it will run a PL/SQL package, not a concurrent request).

5. If you want the original description to remain, revert back the changes in step 3 and save.  This will force another recompilation and description will remain as seeded.

6. Test again the concurrent program.  It should not fail this time.