I suspect it is not working due to the installation on Windows.
I need some time to investigate.
Will you be available for a meeting next week?
I do not know the day yet as I need to prepare for the investigation.
Please apply it to get the latest features.
Please let me know if you want the excel output of Blitz Report to be saved on the application server?
This is possible in your current version 3.2.4.
Please create a directory on the apps server. E.g. /tmp/output
Populate ‘Add. Out. Dir. APPS Node’ runtime option with that directory before running the report
Find the output of this report in that directory.
Tokens are only for additional flexibility in naming directories and output files. They are not mandatory to use.
Please test and let me know if it works for you.
It looks like you are using an older version of Blitz.
You can either
upgrade to the latest version or use the current version without tokens and ‘Add. Out. Filename Pattern’ instead of the Additional Out FIle Name.
Please let me know what you think?
Yes Blitz Report is supported with EBS 12.2.12 on Linux.
We always test Bltiz Report with the latest EBS releases on Linux.
To prepare you can create a custom XXEN application as per our installation guide.
Apart from that the installation should be quick and straightforward.
Could you please send me the concurrent request log?
The LOV for the DB Node gets the data from the dba_directories.
So you can create a new directory in the database, so it is displayed in the LOV
as follows.Please perform following tests:
1) In addition to ‘Add. Out. Dir APPS Node’
Set ‘Add. Out. Filename Pattern’ to any value from the LOV, e.g. _’YYYYMMDD’
Run the report.
Check if the output was copied to the folder.
2) If the folder is still empty.
Set ‘Add. Out. Dir APPS Node’ to ‘Z:\invalid_directory’.
Run the report.
Send me the request log.
I want to understand if Blitz tries to copy the file at all.
If the disk/directory is invalid, it should produce an error in the log.
Thank you.
To enable it at the report level, please go to the Setup screen->Options and set the “Add. Out. Dir. DB Node” option.
The screen may differ a bit in your version.
This way the associated runtime option is going to inherit the report level value automatically.
This is not an error in the report. These 2 vendors each have 2 vendor sites defined as attached.
The supplier is derived from the sourcing rules for the specified Assignment Set defined in the EBS instance.
Hi,
This is due to the automated column translation feature, which would not just convert an UPPER_CASE_COLUMN to a more readable Upper Case Column. This feature also translates some of the most common column names to local language, in case a user is logged on with a different language than US.
You can disable this translation with the options checkbox.
Alternatively, if you do not require the underscore, you can do the following:
select
aps.vendor_name “VENDOR NAME”
from
ap_suppliers aps
Or, if you don’t mind having an extra space in the excel cell:
select
aps.vendor_name “VENDOR_NAME ”
from
ap_suppliers aps
Let me know if this works for your requirement.
Yes, Blitz Report 3.2.6 is supported on r12.2.11 and Linux.