Fusion SCM INV : Unexpected Error While Calling The CycleCountTransactions REST API
(Doc ID 3054181.1)
Last updated on NOVEMBER 04, 2024
Applies to:
Oracle Fusion Inventory Management Cloud Service - Version 11.13.24.07.0 and laterInformation in this document applies to any platform.
Symptoms
While calling the cycleCountTransactions REST API below error occurs for some items
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "FUSION.CST_GET_COST_PKG", line 675
ORA-06512: at "FUSION.INV_CCEOI_PROCESS_PVT", line 61
Below is the payload used
REST URL : https://xxx-xxx.fa.us6.oraclecloud.com/fscmRestApi/resources/11.13.18.05/cycleCountTransactions
Method : POST
Request Payload: {
"countLines": [
{
"OrganizationCode": "123456",
"CountName": "3635",
"Item": "26653",
"CountQuantity": 2,
"CountUOM": "BT",
"CountDate": "2024-09-30",
"CountedByEmployeeName": "SCM TEST",
"Subinventory": "TEST 1",
"LocatorName": "X.X"
}
]
}
Response: {
"ReturnStatus": "ERROR",
"ErrorCode": "FND:FND_AS_UNEXPECTED_ERROR:PKG_NAME:INV_CCEOI_PROCESS_PVT:PROCEDURE_NAME:Calculate_Adjustment:ERROR_TEXT:ORA-06502: PL/SQL: numeric or value error:",
"ErrorExplanation": "An unexpected error has occurred.",
"ErrorUniqueTransactionId": "300006997969930"
}
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |