Oracle Fusion HCM Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

FAW: Oracle Analytics Publisher Connector (BIP Connector) Troubleshooting

565
Views
3
Comments
RanaAshutosh-Oracle
RanaAshutosh-Oracle Rank 6 - Analytics Lead
edited November 2023 in Oracle Fusion HCM Analytics

As a service administrator, you can use the Fusion Analytics Warehouse extract service to acquire data from the BI Publisher reports and use it to create data augmentations for various use cases.  Please review below points while using BIP Connector :  

----------------------------------------------------------------------------------------------------------------------    

  • BIP Connector support BIP in Fusion only – it does not support BIP in OAC as of now.Host name in Source Connection should be a valid FA host name. BIP reports in OAC host is not supported. OAC Host will throw below error :

"Status: ERROR.Error: oracle.apps.bi.extractservice.exception.DataExtractException: java.lang.NullPointerException

at oracle.apps.bi.extractservice.extract.impl.BIPExtractorImpl.invokeWithRetry(BIPExtractorImpl.java:316)"

Note : Host name should not be an URL but the Fusion BIP hostname.

----------------------------------------------------------------------------------------------------------------------   

  • Reports with spaces in Report name or Report path is not supported until 23.R4 hence rename the BIP reports without spaces. Reports with spaces in Report name or path will throw below error :

"Test connection failed. Substatus: InternalServerError. Error: oracle.apps.bi.extractservice.exception.DataExtractException: InvalidSecurity : error in processing the WS-Security security header"

----------------------------------------------------------------------------------------------------------------------   

  • If the Connection - "List of Reports" Value not in correct format, it will fail with error :

"Data Extract Exception: Following Report Paths Do Not Exist In BIP"

Only the PATH to the report should be included in the connection value for "List of Report"; do not specify hostname is report path.

As an illustration: ReportDirectory/ReportName.xdo (Note: Enter comma separated reports in List of Reports.)

----------------------------------------------------------------------------------------------------------------------   

  • Reports with parameters need to define the parameter values in Report Configuration connection property. The parameter name and value need to be provided in a JSON format or you may get error :

 'Reports Parameters, Along With Its Respective Values, Is Missing For The Report In BIP Connection properties. Please Provide These Details In The “Report Config Parameters” Field Connection Properties And Retry'

Please check below the json syntax expected:

[

{

"reportPath": "/~it_security_manager/User_Report.xdo",

"runInChunkMode": true,

"params": [

{

"name": "lastUpdateDate",

"value": "__lastUpdateDate__"

}

]

},

{

"reportPath": "/~it_security_manager/Department_Report.xdo",

"runInChunkMode": false,

"params": [

{

"name": "location",

"value": "S1- Chicago"

}

]

}

]

           Note: If no parameters are provided and the report has a param name defined as lastUpdateDate, value will be set as lastUpdateDate

----------------------------------------------------------------------------------------------------------------------   

  • "InvalidSecurity : error in processing the WS-Security security header - BIP SOAP API is not accessible" will need a FA ticket to bounce the FA servers. 

----------------------------------------------------------------------------------------------------------------------   

  • "XMLPGEN-03111: User requested cancel operation" error occurs when BIP is trying to cancel the report generation as the data generated is huge. For reports bigger than 10MB, customer has to enable chunking for the report by providing runInChunkMode as true in Report Configuration.

[ { "reportPath": "<Report path>", "runInChunkMode": true }]

----------------------------------------------------------------------------------------------------------------------   

  • Date format of report

CSV_DATE_FORMAT

Expected date format from report - ex "yyyy-MM-dd"

  • Timestamp format of the report

CSV_DATETIME_FORMAT

Expected timestamp format from report - ex "yyyy-MM-dd'T'hh:mm:ss.SSSX"

----------------------------------------------------------------------------------------------------------------------   

  • After successfully Testing connection, Go To Manage Connections page -> select the Actions menu for the BI Publisher reports connection -> select Refresh Metadata.Note: It's not possible to create augmentations for the BI Publisher reports unless a metadata extract is performed first.

Comments

  • RanaAshutosh-Oracle
    RanaAshutosh-Oracle Rank 6 - Analytics Lead

    Noticed that when we have single parameter, its working fine but when passing two parameters, getting following error :

    "" There are parameters defined for this report "XXXXXReport" which have no value "department". ""

    In Connection, "Report Configuration" parameter Json format input value :

    [

      {

        "reportPath": "Custom/FAW/Report/XXXXReport.xdo",

        "runInChunkMode": false,

        "params": [

          {

            "name": "manager_name",

            "value": "ABC"

          }

        ]

      },

    {

        "reportPath": "Custom/FAW/Report/XXXXReport.xdo",

        "runInChunkMode": false,

        "params": [

          {

            "name": "department",

            "value": "Logistics"

          }

        ]

      }

    To resolve this, please provide parameter value in single entry as below:

    [

    {

    "reportPath": "Custom/FAW/Report/XXXXReport.xdo",

    "runInChunkMode": false,

    "params": [


    { "name": "manager_name", "value": "ABC" }


    {color:#ff0000},\{ "name": "department", "value": "Logistics" }{color}]

    }

  • RanaAshutosh-Oracle
    RanaAshutosh-Oracle Rank 6 - Analytics Lead

    You can also refer : FAW: Oracle Analytics Publisher Connector (BIP Connector) Troubleshooting (Doc ID 2986408.1)