Month: June 2017
ERROR
$ sqlplus / as sysdba
rlwrap: error: Cannot execute sqlplus: No such file or directory
SOLUTION
Add the following to the environment file:
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
Oracle EBS Application R12 Short Keys
Function |
Key |
Function |
Key |
| Actions LOV | Shift + Ctrl + F8 | Help | Ctrl + H |
| Block Menu | Ctrl + B | Insert Record | Ctrl + Down |
| Clear Block | F7 | List of Values | Ctrl + L |
| Clear Field | F5 | List Tab Pages | F2 |
| Clear Form | F8 | Next Block | Shift + Page Down |
| Clear Record | F6 | Next Field | Tab |
| Commit | Ctrl + S | Next Primary Key | Shift + F7 |
| Copy | Ctrl + C | Next Record | Down |
| Count Query | F12 | Next Set of Records | Shift + F8 |
| Cut | Ctrl + X | Paste | Ctrl + V |
| Delete Record | Ctrl + Up | Previous Block | Shift + Page Up |
| Display Error | Shift + Ctrl + E | Previous Field | Shift + Tab |
| Duplicate Field | Shift + F5 | Previous Record | Up |
| Duplicate Record | Shift + F6 | Ctrl + P | |
| Edit | Ctrl + E | Prompt Value LOV | Shift + Ctrl + F9 |
| Enter Query / Query Mode | F11 | Return | Return |
| Execute Query / Run Query | Ctrl + F11 | Scroll Down | Page Down |
| Exit/Cancel Query | F4 | Scroll Up | Page Up |
| Function 0 | Shift + Ctrl + F10 | Show Keys | Ctrl + K |
| Function 1 | Shift + Ctrl + F1 | Undo Typing | Ctrl + Z |
| Function 2 | Shift + Ctrl + F2 | Update Records | Ctrl + U |
| Function 3 | Shift + Ctrl + F3 | ||
| Function 4 | Shift + Ctrl + F4 | ||
| Function 5 | Shift + Ctrl + F5 | ||
| Function 6 | Shift + Ctrl + F6 | ||
| Function 7 | Shift + Ctrl + F7 | ||
| Help | Ctrl + H | ||
| Insert Record | Ctrl + Down | ||
| List of Values | Ctrl + L | ||
| List Tab Pages | F2 | ||
| Next Block | Shift + Page Down | ||
| Next Field | Tab | ||
| Next Primary Key | Shift + F7 | ||
| Next Record | Down | ||
| Next Set of Records | Shift + F8 | ||
| Paste | Ctrl + V | ||
| Previous Block | Shift + Page Up | ||
| Previous Field | Shift + Tab | ||
| Previous Record | Up | ||
| Ctrl + P | |||
| Prompt Value LOV | Shift + Ctrl + F9 | ||
| Return | Return | ||
| Scroll Down | Page Down | ||
| Scroll Up | Page Up | ||
| Show Keys | Ctrl + K | ||
| Undo Typing | Ctrl + Z | ||
| Update Records | Ctrl + U |
ERROR
Unable to validate invoice where the item line has a withholding tax group due to:
APP-SQLAP-10000: ORA-01403: no data found occurred in with parameters (Term id = Sequence num = 1) while performing the following operation: &DEBUG_INFO the following error occurs.
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.