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
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how these…
We have a Talent Community Pool configured with Organization and Job Family criteria. Some candidates were added to the pool, but we are unable to determine which specific criterion they matched. Is there a report, analysis subject area, audit history, or backend table that shows the attribute values that resulted in a…
Hi, We are looking for PVOs for below tables in BICC Can you guide us on the approach to extract data for these? PON_AGREEMENT_LINES_ALL PON_AGREEMENTS_ALL PON_APPROVAL_HISTORY PON_CONTRACT_PARTIES PON_PRICING_TERMS PON_TERMS_AND_CLAUSES Thanks, Nitin
Hi All, We are using Oracle Fusion Cloud Procurement and would like to secure the Purchase Order (PO) PDF that is generated from Oracle Fusion. Our requirement is to have the generated PO PDF password-protected, so that the recipient must enter a password before the PDF can be opened. Can someone please advise? We are…
Does Fusion release supports propagating an HTTP XML Feed authentication exception into the BIP-based ESS job’s completion text.
