API Error Csd_repairs_pub.create_repair_order ORA-06512 GET_RO_DEFAULT_CURR_PL
(Doc ID 2213009.1)
Last updated on JUNE 01, 2023
Applies to:
Oracle Depot Repair - Version 12.2.4 and laterInformation in this document applies to any platform.
Symptoms
Error In creating Service Order API csd_repairs_pub.create_repair_order.
ERROR
-----------------------
Invalid : Error while creating Service order => ORA-00972: identifier is too long
ORA-06512: at "APPS.JTF_PLSQL_API", line 65
ORA-06512: at "APPS.CSD_RULES_ENGINE_PVT", line 1167
ORA-00972: identifier is too long
ORA-06512: at "APPS.JTF_PLSQL_API", line 65
ORA-06512: at "APPS.CSD_RULES_E in Package CSD_PROCESS_UTIL Procedure GET_RO_DEFAULT_CURR_PL
- Invalid : Error while creating Service order => API Programming Error (Create_Repair_Order): Required parameter P_REPLN_REC.CURRENCY_CODE was not passed.
Request id : nnnnnnnn
STEPS
----------------------
When using Depot Repair defaulting rules for defaulting the Pricelist for different service types.
The rules have been setup with value type as PL/SQL API and the package assigned ss XXSVC_PRICING_ATTRIBUTE_PKG.DEF_PRICELIST(P_SR_ACCT_ID => $SRACCTID$)
The rule is working fine as expected in Depot Repair module.
From the error message, it seems it is validating the package name size
Process Data - Invalid : Error while creating Service order =>
ORA-00972: identifier is too long
ORA-06512: at "APPS.JTF_PLSQL_API", line 65 ORA-06512: at "APPS.CSD_RULES_ENGINE_PVT", line 1167
Process Data - Invalid : Error while creating Service order =>
API Programming Error (Create_Repair_Order): Required parameter P_REPLN_REC.CURRENCY_CODE was not passed.
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 |
References |