Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Asset tables behind Oracle Asset APIs

User_1J19LJun 6 2023 — edited Jun 16 2023

Need to use Oracle Asset REST APIs to adjust, update, retire and reclassify Asset data in Oracle Cloud. Likely will use Asset APIs below:

Update Descriptive Details of a Fixed Asset - processTransaction-updateAssetDescriptiveDetails

Reclassify a Fixed Asset - processTransaction-reclassAsset

Retire A Fixed Asset - processTransaction-retireAsset

Testing these APIs by sending payload and got response with data issue. For instance, sent this POST payload:

{ "OperationName": "processTransaction-updateAssetDescriptiveDetails",

"ParameterList": "{P_ASSET_ID: 154290, P_ASSET_NUMBER: P4108909109, P_TRX_ATTRIBUTE1:e, P_TRX_ATTRIBUTE2:e}"}

Got below:

{ "OperationName": "processTransaction-updateAssetDescriptiveDetails",

"DocumentId": null,

……..

"ParameterList": "{\\"X\_RETURN\_STATUS\\":\\"E\\",\\"X\_MSG\_DATA\\":\\"The error ORA-01403: no data found occurred during processing.\\\\nThe function fa\_asset\_desc\_pub.update\_desc failed. Contact your system administrator.\\",\\"X\_MSG\_COUNT\\":\\"2\\"}",

……}

Don'tunderstand what this error means. think to check table behind but not know what table to check. Read Oracle Asset User Guide but not able to find solution.

Oracle Asset or cloud API Guru, please help to guide what to do with such response error and how to find asset table behind?

Comments
Post Details
Added on Jun 6 2023
0 comments
515 views