Wednesday 6 January 2016

Resolve Error: REP-1272: Column ‘CF_1’ may not be used as break Column.

While Oracle developer Develop the RDF Report and use some Formula column in this report and compile the RDF after that generate the XML then report showing the below error. 

Error: REP-1272: Column ‘CF_1’ may not be used as break Column.

We resolve this issue use the below steps:

Step 1: Changed the Break Order to None from Ascending.

Right Button click on Formula column and then click ==>Property Inspector

Changed the Break Order to None from Ascending

Step 1: Test it's working or not.

 Now it's worked.

During Oracle Apps Login, Responsibilities Assigned to Users is not appearing in the Navigator Page

While User Login on Oracle Application then some time Responsibility not showing to user then use the below steps to resolve this issue. 

User data in the FND_USER, FND_RESPONSIBILITY, WF_LOCAL_USER_ROLES, and WF_USER_ROLE_ASSIGNMENTS tables is not valid. To synchronize data follow the steps below.


1. Navigate to the define user form (FNDSCAUS).
2. Query up the user (that is having the issue) and insure the responsibility is NOT end dated. 
3. END DATE the USER (not the responsibility) and save the record. 
4. UNEND DATE the USER and save the record. 
5. Run the request 'Sync responsibility role data into the WF table'.
6. Run the request "Synchronize WF LOCAL tables". 
7. Run the request "Workflow Directory Services User/Role Validation" (with parameters 10000, yes, yes, yes). 
8. Have the user log off and back on and verify that the responsibility appears.

After that clear the apache cache.

How to clear Apache Cache from Application without bouncing listener.

1. Navigate to "Functional Administrator" responsibility.
2. Once logged in click on the "Core Services" tab.
3. Click on "Caching Framework" link in the blue menu bar.
4. Click on "Global Configuration" link in the left vertical menu.
5. In the "Cache Policy" region click on the "Clear All Cache" button.
6. Click the "Yes" button to confirm the action.
7. Click the "Apply" button to apply the changes.

The above steps will clear the apache cache without the need of bouncing by the DBA's