API Error Csd_repairs_pub.create_repair_order ORA-06512 GET_RO_DEFAULT_CURR_PL (Doc ID 2213009.1)

Last updated on APRIL 28, 2017

Applies to:

Oracle Depot Repair - Version 12.2.4 and later
Information 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 : 10961526

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
   ORA-00972: ident JS01330917 15-NOV-16
Process Data - Invalid : Error while creating Service order =>
    API Programming Error (Create_Repair_Order): Required parameter P_REPLN_REC.CURRENCY_CODE was not passed.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms