Kevin M-Oracle

You are welcome. Kevin

in Scheduled report jobs current & previous month formula for a specific date each month Comment by Kevin M-Oracle May 16, 2024 8:05PM

You can create three schedules to cover months with 30 and 31 days, and February. The use {$SYSDATE()-30$}, or {$SYSDATE()-31$} or February. Kevin

in Scheduled report jobs current & previous month formula for a specific date each month Comment by Kevin M-Oracle May 16, 2024 2:23PM

See Increment Date Parameters https://docs.oracle.com/middleware/bi12214/bip/BIPUG/GUID-22F94743-8AB7-43E8-AEE8-3D022AB306B2.htm#GUID-ADEE63B7-0FF7-45F8-B4B6-DE8915B3242A Rgds, Kevin

in Scheduled report jobs current & previous month formula for a specific date each month Comment by Kevin M-Oracle May 15, 2024 6:56PM

in Scheduled report jobs current & previous month formula for a specific date each month Comment by Kevin M-Oracle May 15, 2024 6:54PM

Try adding this field as well: <?if: PaymentAmount/Value < 25000?> <?xdoxslt:set_variable($_XDOCTX, 'logopath', '')?> <?end if? Rgds, Kevin

in How to display a 2nd signature based on Check Amount Comment by Kevin M-Oracle May 9, 2024 1:21PM

Hi Craig, You can try moving the page break to the top to right after the for-each@section. I d not see a conditional statement around your images. Rgds, Kevin

in How to display a 2nd signature based on Check Amount Comment by Kevin M-Oracle May 8, 2024 6:23PM

The layout starts with an issue: <?for-each:OutboundPayment@section?> It should be: <?for-each@section:OutboundPayment?> Rgds, Kevin

in How to display a 2nd signature based on Check Amount Comment by Kevin M-Oracle May 8, 2024 2:35PM

These are the reports I pointed out at the start: https://www.oracle.com/middleware/technologies/analytics-publisher/downloads.html Download Sample Reports (for Oracle Analytics Cloud) Rgds, Kevin

in Security audit logs for the system Comment by Kevin M-Oracle May 7, 2024 10:48AM

The audit reports have samples that you can use to start. Rgds, Kevin.

in Security audit logs for the system Comment by Kevin M-Oracle May 6, 2024 1:27PM

See: Tips for Multi-value Parameters https://docs.oracle.com/middleware/bi12214/bip/BIPDM/GUID-478A2B1D-BC89-421E-9702-5749BA49EFD2.htm#GUID-95A9BA71-6703-40F2-9181-C693E1307F7F Rgds, Kevin

in invalid relational operator error Comment by Kevin M-Oracle May 2, 2024 5:18PM

What are you asking? Rgds, Kevin

in Security audit logs for the system Comment by Kevin M-Oracle May 2, 2024 12:40PM

See Tips for Multi-value Parameters: https://docs.oracle.com/middleware/bi12214/bip/BIPDM/GUID-478A2B1D-BC89-421E-9702-5749BA49EFD2.htm#GUID-95A9BA71-6703-40F2-9181-C693E1307F7F Rgds, Kevin

in invalid relational operator error Comment by Kevin M-Oracle May 1, 2024 3:34PM

Have you checked the sample audit reports here: https://www.oracle.com/middleware/technologies/analytics-publisher/downloads.html Download Sample Reports (for Oracle Analytics Cloud) Rgds, Kevin

in Security audit logs for the system Comment by Kevin M-Oracle May 1, 2024 3:31PM

The XDO_METADATA sheet cannot be removed, it can only be hidden in the output Excel file. Rgds, Kevin

in Hidden worksheet XDO_METADATA appearing in the final output Comment by Kevin M-Oracle Jun 23, 2023 2:53PM

Use this attribute: <v2:attributeLocale>?</v2:attributeLocale> Example: <v2:attributeLocale>en-US</v2:attributeLocale> --> English (United States) Or: <v2:attributeLocale>es-ES</v2:attributeLocale> --> Spanish (Spain) Kevin

in How schedule report in specified language using ScheduleService Comment by Kevin M-Oracle Oct 10, 2017 7:00AM

Have a good day! Kevin

in How to display amounts in Excel Accounting format? Comment by Kevin M-Oracle Sep 16, 2021 11:48AM

NP. This is Analytics, we still have BIP (OAS) under https://community.oracle.com/mosc/categories/bi_publisher Kevin

in How to display amounts in Excel Accounting format? Comment by Kevin M-Oracle Sep 15, 2021 6:35PM

Nope, I just do not normally monitor this forum. This is not a feature they can use in EBS 12.1.3. In 12.2 they could use an Excel layout. But they are not supported in 12.1.3. Rgds, Kevin

in How to display amounts in Excel Accounting format? Comment by Kevin M-Oracle Sep 15, 2021 6:19PM

Welcome to the Oracle Analytics and AI Community

Kevin M-Oracle Rank 6 - Analytics & AI Lead

Comments