Need to post add or adjust fixed asset data in Oracle Cloud via OFC Fixed Asset API. Based on Fixed Assrt document provided from Oracle, create a test JSON payload as below:
{ "OperationName": "processTransaction-addAsset", "ParameterList": “{P_BOOK_TYPE_CODE: PL CORP,P_ASSET_NUMBER: NEWADD0726,P_DESCRIPTION: Dell Inspiron,P_MANUFACTURER_NAME: Dell,P_MODEL_NUMBER: 1500,P_ASSET_TYPE: CAPITALIZED,P_CATEGORY_ID: 21,P_DATE_PLACED_IN_SERVICE: '2021-03-31', P_COST : 15000,P_TRX_ATTRIBUTE1:d, P_TRX_ATTRIBUTE2:d, P_D_TRX_ATTRIBUTE1:d,P_D_TRX_ATTRIBUTE2:d, P_DISTRIBUTION_ID_TBL:'1', P_ASSIGNED_TO_TBL:'1',P_UNITS_ASSIGNED_TBL:'1', P_TRANSACTION_UNITS_TBL:'1',P_EXPENSE_CCID_TBL:'300100071633798',P_LOCATION_CCID_TBL: '300100071633789'}”}
Got JSON response with code 201 but cntain following error section:
{ ……………….
"ParameterList": {\"X_RETURN_STATUS\":\"E\",\"X_MSG_DATA\":\"A row from the FA_BOOK_CONTROLS table for the PL CORP book couldn't be retrieved.\\nThe error ORA-01403: no data found occurred during processing.\\nThe function fa_cache_pkg.fazcbc failed. Contact your system administrator.\\nThe function fa_addition_pub.do_addition failed. Contact your system administrator.\",\"X_MSG_COUNT\":\"4\"}",
……………….}
This is to add asset to oracle cloud via this Rest API. Why did I get ORA-01403 error but wth HTTP code 201 (created). How can I resolve this issue ?