APP-OFA-48289 Unknown Error When Trying To Retire An Asset (文档 ID 1065437.1)

转：https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=327093403109966&id=1065437.1&displayIndex=8&_afrWindowMode=0&_adf.ctrl-state=zm396viw3_716#SYMPTOM

APP-OFA-48289 Unknown Error When Trying To Retire An Asset (文档 ID 1065437.1)

转到底部

---

In this Document Symptoms   Cause   Solution   References APPLIES TO: Oracle Assets - Version 11.5.10.0 to 11.5.10.2 [Release 11.5] Information in this document applies to any platform. SYMPTOMS When retiring an asset in the Asset Workbench, the following error occurs: APP-OFA-48289: Unknown Error. Please contact your system administrator CAUSE The cause of the issue is invalid / incorrect data in the fa_retirements table.  The value stored in the status field should be in uppercase. The following SQL can identify the invalid / incorrect data:     select status from FA_RETIREMENTS  where asset_id=&asset_id  and book_type_code='&book_type_code';   SOLUTION 1.  Run the following scripts in a TEST environment first: select status from FA_RETIREMENTS  where asset_id=&asset_id  and book_type_code='&book_type_code'; UPDATE FA_RETIREMENTS SET status=upper(status) where asset_id=&asset_id  and book_type_code='&book_type_code'; commit; 2.  Once the scripts complete, confirm that the data is corrected by running: select status from FA_RETIREMENTS  where asset_id=&asset_id  and book_type_code='&book_type_code';   REFERENCES NOTE:413738.1 - APP-OFA-48289: Unknown Error When Trying To Retire An Asset