Unable to send date field and throwing exception while sending SMC to RMCS integration Algorithm
Summary:
We are using Product Start Date field in Subscription Product Line in SMC and mapping with INITIAL_PERF_EVENT_DATE date field in RMCS Document Lines. But after running job Send Subscription Revenue Information to Oracle Revenue Management Cloud, its log file contains below exception error and RMCS contract is not getting created:
"SubscriptionId:300000090838229Exception encountered while inserting doc line with id 641210 faced Exception java.sql.SQLException: ORA-17041: Missing IN or OUT parameter at index: 60"
Tested Eg in Dev 6, Subscription Number: 401031 (Subscription Id: 300000090838229)
Attached log file of errored processed files of Send Subscription Revenue Information to Oracle Revenue Management Cloud and Manage Algorithm Code