Best Of
Re: How to remove 0s from BI Publisher Word RTF Stacked Bar Chart
For the stacked graph, I ended up not showing the count on the graph, relying on a table underneath instead.
Counts are only being used on non-stacked graphs, this is the code for that in case it is useful:
<Graph seriesEffect="SE_NONE"><LegendArea visible="true" automaticPlacement="AP_NEVER" position="LAP_BOTTOM" /><O1Title text="Questions" visible="true"><GraphFont bold="false" italic="false" underline="false" fontColor="#000000" /></O1Title><Y1Title text="Number of Responses" visible="true"><GraphFont bold="false" italic="false" underline="false" fontColor="#000000" /></Y1Title><Y1TickLabel><GraphFont bold="false" italic="false" underline="false" fontColor="#000000" /></Y1TickLabel><O1TickLabel><GraphFont bold="false" italic="false" underline="false" fontColor="#000000" /></O1TickLabel><LocalGridData colCount="{count(xdoxslt:group(current-group(), 'G.LM_QUESTION_TEXT'))}" rowCount="{count(xdoxslt:group(current-group(), 'G.LM_RESPONSE_TXTLBL'))}"><RowLabels><xsl:for-each-group select="current-group()" group-by="G.LM_RESPONSE_TXTLBL" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><Label><xsl:value-of select="current-group()/G.LM_RESPONSE_TXTLBL" /></Label></xsl:for-each-group></RowLabels><ColLabels><xsl:for-each-group select="current-group()" group-by="G.LM_QUESTION_TEXT" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><Label><xsl:value-of select="current-group()/G.LM_QUESTION_TEXT" /></Label></xsl:for-each-group></ColLabels><DataValues><xsl:variable name="G2" select="current-group()" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" /><xsl:for-each-group select="current-group()" group-by="./G.LM_RESPONSE_TXTLBL" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><xsl:variable name="G1" select="current-group()" /><RowData><xsl:for-each-group select="$G2" group-by="./G.LM_QUESTION_TEXT"><Cell><xsl:value-of select="sum($G1[(./G.LM_QUESTION_TEXT=current()/G.LM_QUESTION_TEXT)]/G.LM_ENRLMT_ID[.!=''])" /></Cell></xsl:for-each-group></RowData></xsl:for-each-group></DataValues></LocalGridData><MarkerText visible="true" markerTextPlace="MTP_OUTSIDE_MAX"><Y1ViewFormat><ViewFormat decimalDigit="0" decimalDigitUsed="true" /></Y1ViewFormat><GraphFont bold="false" italic="false" underline="false" fontColor="#000000" /></MarkerText></Graph>
Re: Where is Windows Patch for oracle 19.28?
No - conflict details are not contained in patch README files.
Re: Is there a master list of all delivered roles from Oracle?
Hi @User_0YH30,
Unfortunately, we do not have such details.
You can get the Role name and its description to understand the significance of the Role from the description.
You can check the related Permission lists to understand its (role's) significance.
Regards,
Pavani
Re: Does anyone have a backup plan (disaster recovery) for DDP001 in the event the bank cannot accept
I'll echo what Bill said and share some of my own thoughts.
Scenario 1 - Disaster where YOU cannot process payroll or get a file to the bank
As Bill said, it's really important to define what the scenario is, and what a "disaster" is.
If you can get your systems up in 24 hours, and it's the day you process payroll, that might not be an emergency. But if it'll be more than 24 hours, maybe that's an emergency.
In this disaster, is there an outage to your single sign on? Can you access shared drives?
The ideal solution for this (sort of) is to have an offsite recovery environment that constantly refreshes from Production and that you can bring up within a few hours, and which can interface with your critical vendors, like your bank.
Let's say you don't have that sort of service.
In that case, it's good to see what options your bank already offers.
Our bank offers a replay service FOR ACH ONLY so that in the event of an emergency, we can re-send the previous pay period's ACH. That isn't perfect, because there are changes in pay, new employees, terminated employees, but it covers 98% of what we need (depending on the pay period).
However, replay is only for ACH. For physical checks, we need to create a separate file (different format from our check file) and have it stored in a secure location that can be accessed outside of our single sign on.
In this case, you need to ensure:
a) access to the "other" drives for those who need it
b) access to procedures
c) a review every six months or year to make sure everything is still working, that the people who are the bank's emergency sign-off are still the right people, etc. At a previous workplace, we'd actually have a senior leader surprise us and say that it was disaster recovery day, and we would need to simulate everything to make sure all of our procedures were up-to-date, etc.
Scenario 2 - Disaster where the bank has a problem
In our case, our bank has their own disaster recovery process so I don't have a lot of concerns that they would not be able to accept a file.
In the case you describe, I would look at the file you create. If it's a file your other bank can accept, then maybe just modifying it for the correct bank account (etc) in the header would be enough.
Otherwise, I'd create a program to produce a disaster recovery DDP file that can be easily produced in this case.
Re: Can someone explain me the steps of following note (Doc ID 1922770.1)
Check this note. It has queries and also a presentation that will show you the table joins and data flow. These days you don't need to run them as we have analyzers doing this for assistance.
Brown bag: R12 Inventory Sales Order Flow and Troubleshooting (Doc ID 1100764.1)
FAQ: Troubleshooting Stuck Pick Release And Shipping Transactions (Doc ID 863761.1)
Re: What are the check points when Sales order line closed but not interfaced to AR
Check if the delivery is shipped and interfaced to inventory and closed. Check if the interfaced trip stop (ITS) ran? Do you see the 'Sales Order Issue' transaction in Inventory?
Re: Shared directory rights problem
Ok thanks
After verification i have ;
root@xxxxxxxx:~# share -F nfs
exploit /exploit sec=sys,rw
exploitora /exploitora sec=sys,rw
Re: Full Package increase the Tablespace
Hello,
Otherwise perhaps the R98825D report can help you and see where it was deployed.
Please see
Sincere regards
Johan
Re: Full Package increase the Tablespace
Hello @2011
I would perhaps check any of this Forms mentioned in the Manual
if that can give you any clue, I presume you have many fat clients.
Secondly, I believe this question is not related to Tablespaces that you initially asked, is that correct? because tablespace is on Database level.
Sincere regards
Johan


