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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.