Dec 6, 2023 · Summary: Hi Team, I am looking for an SQL query to extract customer data in 'CustomerImportTemplate' FBDI format, if anyone has it, could you please share it?

Apr 4, 2023 · Learn how to format phone numbers in SQL using Oracle methods, including handling specific country codes and removing unnecessary characters for consistency.

I'm working on a report where I have a field which correspond to the time of arrival of a truck at a shipment stop. I would like the time displayed (which is currently set as local time) to be in french …

Feb 15, 2019 · I have reviewed the links that talk about the canonical date format, but as this is entirely within SQL and I am not starting with a date parameter and I am using to_date and a date format …

Jul 21, 2022 · In the query I am not doing any kind of formatting, just fetching the date field from the table. and in RTF Template on the date field making the field type as Date and format as "dd-MMM-yy".

Aug 28, 2025 · Need SQL query to extract Customer Contacts from R12 in Fusion FBDI customer upload format (4 sheet) If not the entire query, can someone please help me with the tables and joins.

Jul 30, 2025 · For downstream processing and integration, we need to encode (or encrypt, if possible) the BLOB data into Base64 format within the SQL query or as part of the BIP data model.

Jan 23, 2024 · How to format below query, so that I can read it more easily? Output looks like blocky and ugly and hard to read, see below Thanks

May 28, 2024 · Learn how to add a date parameter in MON-YY format to the dashboard in Oracle Fusion.

Jul 27, 2010 · Hello AP Community, How to find the SQL Program (or Package) existing inside of this "Format Payment Instructions with Text Output" automatically run concurrent program, which creates …