Customer is requesting to have attribute "SourceAssetNumber" in OTBI subject areas for asset("Sales - CRM Asset","Sales - CRM Asset Resource","Sales - CRM Asset Contact")

Hello Sheethal, You can perform the following: Login to BI as Admin user > Click on Catalog> Change the view from UserView to Admin View on left-side top With this you will be able to see all Users My folders under User Folders. Now locate the user who has the agent created under /Myfolders and Set permissions of the…

Hello Team, Please check the following setup Navigator > Setup & Maintenance > Manage Administrator Profile Options > ZCA_COMMON_CALENDAR > Please share the screenshots Navigator > Setup & Maintenance > Manage Accounting Calendars > Edit the calendar and check for the year > If the Year is not equal to current year> Add…

Hello @KDR, Please find the below documents: https://community.oracle.com/products/oracleanalytics/discussion/14748/bip-rtf-template-modification-how-to-repeat-header-table-when-page-changes https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/insert-components-template.html#GUID-810DE89F-26FF-405E-9CF4-C9B3A90814ED…

Hello Ankur Jain--Oracle, From the document : Oracle Fusion BI: Starting 19D, You Can Configure New BI Reporting Duty Roles to Hide the Factory Catalog Folders (Doc ID 2596730.1), below are the reporting duty roles for corresponding Folders, can you re-validate and confirm if you have removed all of them, which you do want…

Hello Jason, Kindly refer the below screenshot, I just removed the first the column Header for Product Name before Revenue Type, is this what is your requirement? Kindly confirm? Thanks, Dimple N

Hello saurabh.dixit , You can try using Deep linking to SUI pages : Please refer the following : URL Pattern of Deep Link: https://<pod-name>/fndSetup/faces/deeplink?objType=<objID>&objKey=<name1=value1;name2=value2>&action=<action>&returnApp=<returnappURL>&returnAppParams=<returnAppParameter> To direct users to a…

Hello @Kundan Kumar17, Please follow below steps: 1. Create a variable dashboard prompt using presentation variable. 2. Name of presentation variable should be same as parameter name in BIP report. 3. You can Select "User Input" as List box and select "SQL Results" in "List of values" if required. 4. You can also select…

Hi @User_0ONK7, Please check if you want to use eText Templates: Introduction : An eText template is an RTF-based template that is used to generate text output for Electronic Funds Transfer (EFT) and Electronic Data Interchange (EDI). At runtime, BI Publisher applies this template to an input XML data file to create an…

Hi @User_0ONK7, Here is the documentation for Creating eText Templates: Introduction : An eText template is an RTF-based template that is used to generate text output for Electronic Funds Transfer (EFT) and Electronic Data Interchange (EDI). At runtime, BI Publisher applies this template to an input XML data file to create…

Hello @MichelleG, Are you saying the date column is also printing DATE & Time, if yes, you can edit the column properties in the data model to show Date Only. Kindly test the same and let me know if that helps. Thanks, Dimple N

Hello @Surendra Majeti, You need to have the below access : BIACM_ADMIN, kindly follow the steps from the below document: https://docs.oracle.com/en/cloud/saas/applications-common/24d/biacc/provision-a-user-with-access-to-bicc.html You can also refer to the Master Note on BICC : Fusion Applications Technology: Master Note…

Hi Mandeep, Did you try editing the existing CSA and adding the column from Application composer ? What type of columns did you try adding ? and can you share the steps taken to publish? Was the column not available after the CSA published with Ok Status? Does the republish the CSA fails ? or what is the exact issue faced?…

Hey Mandeep, Sure, please review this step-by-step guide with screenshots on How to create Custom Subject Area with worked examples on below : 1. Creating and Viewing a Report for the Custom Subject Area 2. Creating Custom Fields for a Standard Object: Explained 3. Adding Custom Fields Using CRM Application Composer 4.…

Correct Mandeep, You can also review on how to create Custom Subject Area to report on Custom Object and its attributes, here is the document on BEST Practices : Oracle Engagement Cloud (Sales and Service): Best Practices for BI Extensibility and Using Custom Subject Areas (Doc ID 2348001.1) Also here is doc shows what…

Hello @Hello123, Are you talking about custom fields created in UI, in that case you can find them under Object Dimension.Extension Folders. For eg: Custom Fields from Account, are available under Account → Account Extension Folders. But if you want to edit the existing report and add new columns, then locate the reporth…

Hi alby_b, Can you try the following: Edit the analysis in OTBI → Click on Criteria Tab → Select Column Properties → Data Format → Override Default Data Format → Select custom and from the drop down select the required date format → click Ok → Save the report → Test the export and let me know the results. Thanks, Dimple N

Hello @NIKHIL M Y, Did you try any of the above suggestions and it helped? Thanks, Dimple N

Hey @Vinoth Mounagurusamy, Did you try this, edit the data set in BIP datamodel to locate the DATE column and edit column properties to select display DATE Only and then test the flow Thanks, Dimple N

Dear Kavitha, I wanted to check if the issue has been resolved now. Thanks, Dimple N