ERROR

APP-OFA-48723 You cannot delete setup data from a secured responsibility. The data may already be in use by assets or books that you do not have access to. To delete setup data please use a non-secured responsibility.

SOLUTION

This Error is normally Produced when you try to delete an Unused/Wrong Asset Category from any Secured Responsibility

Step 1. Connect to System Administrator responsibility

Step 2. Navigate to Profile > System

Step 3. Query for Profile FA:Security with any FA responsibility.

Step 4. You could temporary remove the profile value in order to delete the wrong Asset category and then reset the profile back.

June 25, 2017 Oracle Account Receivables (AR) Late charge report ended with “no data found”

Accounts ReceivablesErrors/Workarounds-AROracle Functional

ERROR

Oracle Account Receivables (AR) Late charge report ended with “no data found”

(more…)

June 25, 2017 ERROR ORA-00020 maximum number of processes (%s) exceeded

APPS DBAErrors/Workarounds-ApplicationsErrors/Workarounds10gErrors/Workarounds11gErrors/Workarounds12cOracle APPS DBAOracle Database Material

ERROR

ERROR ORA-00020 maximum number of processes (%s) exceeded

(more…)

June 25, 2017 Tkprof – Convert Trace .trc to Readable

APPS DBAInstallations/Configurations-ApplicationsOracle APPS DBA

Tkprof – Convert Trace .trc to Readable

tkprof <file.trc> <file.tkprof> explain=<apps_user>/<pswd>

Where,

tkprof: is command
<file.trc>: is file name of trace file with location (if currently not in same directory)
<file.tkprof>: is output file name
explain= <apps_user>/<pswd>: provide apps user name and password.

Example:

tkprof /tmp/oracle.trc /tmp/output.tkprof explain=apps/****