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

Timecard in Submitted Status and Workflow Stuck

After user submits timecard for approval,the following error occurs.

Failed Activity Create Application Period Information
Activity Type Function
Error Name 100
Error Message ORA-01403: no data found ORA-01403: no data found
Error Stack HCAPPRWF.hxc_approval_wf_pkg.create_appl_period_info(HXCEMP, 9229, 167049, RUN, HXC_APPROVAL_WF_PKG.generate_app_period10) Wf_Engine_Util.Function_Call(HXC_APPROVAL_WF_PKG.create_appl_period_info, HXCEMP, 9229, 167049, RUN)

To implement the solution, please execute the following steps:

1. Go into the responsibility: Global OTL Application Developer.

2. Navigate to Preferences > Preferences.

3. Locate Preference Node for preference Time Store Approval Periods and set the value to the same period as used by preference Self Service Timecard Period for a Worker

4. Retest the issue.

5. Migrate the solution as appropriate to other environments.

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.

How to Prevent Users From Submitting Blank Timecard

The seeded functionality allows blank timecards to be successfully submitted where the attributes (Project, Task and Expenditure Type) and also the hours are NULL.

To prevent a blank timecard from being submitted by users, you can implement a time entry rule using seeded fast formula 'Period Hours vs Time Category ( Seeded formula)'.

Steps for creating the time entry rule:
- Create a time entry rule with formula 'Period Hours vs Time Category ( Seeded formula )'.  Formula Inputs:
   Period: <user's timecard period>
   Period Hours: 0
   Operator: Equal To
   Time Category: Project Processing Fields
- Create a time entry rule group which includes this time entry rule.  Choose your desired outcome.
- Assign this time entry rule group to employees via OTL preference 'Time Store Time Entry Rules'
- Retest by trying to submit a blank timecard.