Please suggest the special characters that are not to be used so that data will not be synced to view data in OTBI.
Hi Sunil, What do you mean synched? Please provide an example. Are you talking here about viewing data in either 1) a report in OTBI (yellow) from a data model with data source from one of the 3 application database FSCM/HCM/SCM or 2) an prompt/analysis in OTBI (blue) or a report in OTBI (yellow) from a data model with data source from subject area/analysis.
H I am referring to the blue one OTBI for Finance
@Sunil Nukala2 Please explain what you mean by synced, with an example.
Regards, Gaurav
@Sunil Nukala2,
Certain special characters can cause issues when syncing data in OTBI (Oracle Transactional Business Intelligence), leading to missing or improperly displayed values. Here are some characters that may disrupt data visibility:
Backslash () → Often ignored or misinterpreted in queries.
Ampersand (&) → Can interfere with parameter passing.
Single Quote (') → May cause SQL errors if not properly escaped.
Double Quote (") → Can affect text parsing in reports.
Percent (%) → Used as a wildcard in SQL, leading to unintended filtering.
Underscore (_) → Functions as a single-character wildcard in some queries.
Carriage Return / Line Breaks → Can cause formatting issues in reports.
Special Unicode Characters → Some non-standard characters may not render correctly.
Use REPLACE functions in OTBI to strip unwanted characters. Ensure proper escaping when using special characters in queries. Validate data formatting before syncing to OTBI.
If my response has answered your question or assisted you with your concern, please click"yes" below to accept the answer or comment with any additional queries.
Thanks, Riyaz Ali
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
