APP-OFA-47294: Please finish assigning all units to assign to accounts and locations before saving.

APP-OFA-47294: Please finish assigning all units to assign to accounts and locations before saving. I was working on Oracle Fixed Assets (OFA), it is better if I say I was working on  OFA  first time and I was unable to assign asset due to error 'APP-OFA-47294: Please finish assigning all units to assign to accounts and locations before saving.'. Later I figured out this error so I thought to share it with world in case if any beginner...

Read More

Oracle Asset Transfer

Oracle Asset Transfer Asset transfer is a complex process and should not be entered into lightly, if your customer business is bit complex in nature. The complexity varies from companies to companies along with industry type.This post will briefly tells about Asset Transfer functionality of Oracle. You may have three main business scenario's within Asset Transfer. Location Transfer without ownership change Location Transfer with ownership...

Read More

Oracle Exceptions

Oracle/PLSQL: Exception Handling Oracle has a standard set of exceptions already named as follows: Oracle Exception Name Oracle Error Explanation DUP_VAL_ON_INDEX ORA-00001 You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index. TIMEOUT_ON_RESOURCE ORA-00051 You were waiting for a resource and you timed out. TRANSACTION_BACKED_OUT ORA-00061 The remote portion of a transaction has rolled back. INVALID_CURSOR ORA-01001 You...

Read More