BC user properties: DrilldownObject<N:0,1,2..>=<AppletDrilldown> , <AppletDrilldown>:ProfileAttributeName<M:1,2,3> =<ProfileAttr.>, <AppletDrilldown>:ProfileAttributeValue<M:1,2,3>=<BCField>
Last updated on FEBRUARY 28, 2018
Applies to:Siebel CRM - Version 8.1.1  and later
Information in this document applies to any platform.
*** Checked for currency on APR-18-2016 ***
USE CASE (Display Balance Details in Siebel CRM UI using AIA PIP Order-to-Cash for Communicatons):
As a part of AIA ACR 474, field "Service Account Id" is defined in the Business Component "CMU Com Invoice Profile"
This field is defined as on the BC and has calculated field with the expression: GetProfileAttr("Service Account Id").
The "CMU Request Billing Profile IO" Integration Object is used to query the BC data and put this into a SOAP Request of the AIA Web Service to ask Billing system (Oracle BRM) to provide Balance Details for the given (by the "Service Account Id") Service Account .
In Siebel Client, the user first navigates to the Account Summary View to show Billing Profiles in the list applet: "CMU Billing Profile List Applet" based on the BC: "Com Invoice Profile"). And then the user should make drill a down on the Billing profile Name to get to Balance Details View (where response from the AIA Web Service is to be shown as VBC data from the Billing System).
However the instead of Balance Details View, the Web Service FAULT is shown from the AIA Web Service. It shows the error: XPathExecutionError: XPath expression failed to execute. Error while processing xpath expression, the expression is "ora:processXSLT('Xform_InvoiceListABMReqMsg_to_CommsInvoiceEBMReqMsg.xsl',bpws:getVariableData('QueryInvoiceListReqMsg','QueryInvoiceList'))", the reason is file:/... /Xform_InvoiceListABMReqMsg_to_CommsInvoiceEBMReqMsg.xsl: XML-22044: (Error) Extension function error: Error invoking 'lookupXRef':'oracle.tip.xref.exception.ValidationException: Reference value is empty for Reference Column Name "SEBL_01" and for Table Name "CUSTOMERPARTY_ACCOUNTID" Please ensure Reference value is not-empty ' . Please verify the xpath query. (SBL-BPR-00131)
The cause is that SOAP Request received from Siebel CRM by AIA Middleware (the Siebel ABCS Requester service) is that the value of the "Service Account Id" field, obtained from the BC: "CMU Com Invoice Profile"" was empty .
However non-empty value is required at AIA to identify Account Id in the Billing System.
The standard applet "CMU Billing Profile List Applet" was customized by customer so the name of the standard Drill-Down Object "Profile Name" (that invokes navigation to the Balance Details View) has been changed to "Name".
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