My Oracle Support Banner

BC user properties: DrilldownObject<N:0,1,2..>=<AppletDrilldown> , <AppletDrilldown>:ProfileAttributeName<M:1,2,3> =<ProfileAttr.>, <AppletDrilldown>:ProfileAttributeValue<M:1,2,3>=<BCField> (Doc ID 1531111.1)

Last updated on JANUARY 30, 2022

Applies to:

Siebel CRM - Version 8.1.1 [21112] and later
Information in this document applies to any platform.


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".


To view full details, 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 a vibrant support community of peers and Oracle experts.