How to Prepare Effective Slides

Communication

Neural entrainment is the process by which brain responses become locked to and aligned with the sounds of speech. When speaker and listener really understood each other, their brain responses became coupled and were very similar. This is the idea related to communication and is discussed in great detail in the following article: https://ideas.ted.com/this-is-your-brain-on-communication/

Presentation is a complementing tool to share your ideas with others. A good presentation keeps the audience engaged and understand the idea one is trying to convey.

There are several layers of presentation:

Language proficiency : Language proficiency is a must. This helps in building one’s confidence and on-stage presence. Proper selection of words does wonders.
Meaningful content: The content should be such that most of the audience can relate to. A good research is a must while preparing content for presentation.
Body language : People tend to drift away too soon if even if the most interesting of the ideas are delivered in dull manner.
Effective Slides :This post is mainly related to the creation of slides to deliver the contents in a manner that is easy to grasp and help the audience be with you.

A very important thing to remember is the fact that slides are your aid. You are the presentation. This is discussed in the content above. Here I will be discussing about the slides.

One should not jump into slides creation from the very onset. The first objective is to do a thorough research and gather meaningful contents. Next, one should spend time on organization the content for presentation. Creating slides is the last activity.

Making Effective Slides

In this section, I will be discussing some useful tips for creating better slides.

Fonts

The fonts should be so chosen that the text that represents the main ideas grabs the most attention

Number of pages

The number of pages should be effectively T/2 ,plus or minus 1. Here T is the time that in minutes that one has got to present the slides, considering on spends an average of 2 minutes per slide. There can be fewer slides as well but that mostly works for people who have mastery over presenting things. Slides significantly more than T/2 are a big no.

Images

A picture is worth thousands swords. One can decide to insert an image instead of making the slide verbose and then use it to discuss the ideas. Images also help in grabbing more attention.

Other Titbits

Perform spell-checks, include branding logos or text, avoid vibrant colors ,etc.

Oracle bursting program doesn’t send attachment in email

We may encounter issues with XDOBURSTREP program in which the sends the email notification without any attachment (if it is intended to) and goes into error.

The log for the same looks like:

java.io.FileNotFoundException: /archive/ebz/outbound/010521_121821572/XXXX.xls (No such file or directory)
	at java.io.FileInputStream.open(Native Method)
	at java.io.FileInputStream.<init>(FileInputStream.java:146)
	at java.io.FileInputStream.<init>(FileInputStream.java:101)
	at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.zipOutputFiles(JCP4XDOBurstingEngine.java:532)
	at oracle.apps.xdo.oa.cp.JCP4XDOBurstingEngine.runProgram(JCP4XDOBurstingEngine.java:299)
	at oracle.apps.fnd.cp.request.Run.main(Run.java:156)

 You may also see something like:
 INFO: JOC is shutdown. 
 But this is not a cause of concern as far as this particular issue is concerned.

To resolve such issue make sure we have the following in bursting control file:

Choose the correct template type. If it is rtf template, choose rtf instead of xsl-fo
Use the correct location:
TEMPLATECODE is the actual template code that is registered in XML Publisher.

Query to get location:

select 'xdo://'||
xtb.application_short_name||'.'||
xtb.template_code ||'.'||
xtb.default_language ||'.'||
xtb.default_territory
from apps.xdo_templates_b xtb
where xtb.template_code ='TEMPLATECODE'

e.g:
<xapi:template type="rtf" location="xdo://CIE.TEMPLATECODE.en.US/?getSource=true">

Independent Value Set R12.2

Fields disabled for entering values:

Solution:

Query the user that you want to grant access to all value sets > and grant the following role :

Role = Flexfield Value Set Security: All privileges
Code = UMX|FND_FLEX_VSET_ALL_PRIVS_ROLE

Oracle Report Errors: REP-0110, 1070

REP-0110: Unable to open file 'XX_TEST.rdf'.
REP-1070: Error while opening or saving a document.
REP-0110: Unable to open file '/somepath/reports/US/XX_TEST.rdf'.

Fix:
Check the file permission
Transfer the rdf file to server in binary mode instead of text mode.

Sending Report Output as email attachment (excel) using XML Bursting

Bursting Control File Content:

<?xml version=”1.0″ encoding=”UTF-8″?>
<xapi:requestset xmlns:xapi=”http://xmlns.oracle.com/oxp/xapi” type=”bursting”>
<xapi:request select=”/XX_TEST/LIST_G_1″>
<xapi:delivery>
<xapi:email id=”123″ server=”xxmail.xx.com” port=”25″ from=”abc@xyz.com” reply-to=”abc@xyz.com” >
<xapi:message id=”123″ to=”abc@xyz.com” cc=”abc@xyz.com”
attachment=”true” subject=”Subject Text”>
EMAIL Body goes here
</xapi:message>
</xapi:email>
</xapi:delivery>
<xapi:document output=”file name of attachment” output-type=”excel” delivery=”123″>
<xapi:template type=”rtf” location=”xdo://XX.XX_TEST.en.00/?getSource=true”>
</xapi:template>
</xapi:document>
</xapi:request>
</xapi:requestset>

Location can be found using below query:

SELECT ‘xdo://’
|| xtb.application_short_name
|| ‘.’
|| xtb.template_code
|| ‘.’
|| xtb.default_language
|| ‘.’
|| xtb.default_territory
FROM apps.xdo_templates_b xtb
WHERE xtb.template_code = ‘XX_TEST’;

Oracle Report Builder Doesn’t Launch

Solution:

Under Dev Suite Home directory, search for cauprefs.ora file.

Search for Reports.root_max

Change it’s value to yes (Reports.root_max = Yes). Save and Close it.

Relaunch Report Builder.

REST API Response Codes

200 Ok

400 Bad Request (Often from syntax error)

401 Unauthorised

404 Not Found

405 Method Not Allowed

408 Request TimeOut

Org Access to Users based on MO: Security Profile

SELECT DISTINCT fu.user_name,
C.RESPONSIBILITY_NAME,
d.SECURITY_PROFILE_NAME,
d1.name ou_name
FROM FND_PROFILE_OPTIONS_VL A,
fnd_profile_option_values b,
fnd_responsibility_vl c,
per_security_profiles_v d,
per_organization_structures a1,
PER_ORG_STRUCTURE_VERSIONS b1,
per_org_structure_elements_v c1,
hr_operating_units d1,
fnd_user_resp_groups_direct furg,
fnd_user fu
WHERE 1 = 1
AND furg.user_id = fu.user_id
AND furg.responsibility_id = c.responsibility_id
AND A.user_PROFILE_OPTION_NAME LIKE ‘MO%Security%’
AND d.ORGANIZATION_STRUCTURE_ID = a1.ORGANIZATION_STRUCTURE_ID
AND a.PROFILE_OPTION_ID = b.PROFILE_OPTION_ID
AND TO_NUMBER (b.LEVEL_VALUE) = c.RESPONSIBILITY_ID
AND d.SECURITY_PROFILE_ID = b.PROFILE_OPTION_VALUE
AND a1.ORGANIZATION_STRUCTURE_ID = b1.ORGANIZATION_STRUCTURE_ID
AND b1.ORG_STRUCTURE_VERSION_ID = c1.ORG_STRUCTURE_VERSION_ID
AND ( d1.organization_id = c1.ORGANIZATION_ID_CHILD
OR d1.organization_id = c1.ORGANIZATION_ID_parent)
and fu.user_name not in (‘AUTOINSTALL’,’APPADMIN’,’SYSADMIN’,’AMW’,’MAINT_ADMIN’,’103336′)
UNION ALL
SELECT DISTINCT fu.user_name,
C.RESPONSIBILITY_NAME,
d.SECURITY_PROFILE_NAME,
d1.name ou_name
FROM FND_PROFILE_OPTIONS_VL A,
fnd_profile_option_values b,
fnd_responsibility_vl c,
per_security_profiles_v d,
PER_SECURITY_ORGANIZATIONS_V c1,
hr_operating_units d1,
fnd_user_resp_groups_direct furg,
fnd_user fu
WHERE 1 = 1
AND furg.user_id = fu.user_id
AND furg.responsibility_id = c.responsibility_id
AND A.user_PROFILE_OPTION_NAME LIKE ‘MO%Security%’
AND a.PROFILE_OPTION_ID = b.PROFILE_OPTION_ID
AND TO_NUMBER (b.LEVEL_VALUE) = c.RESPONSIBILITY_ID
AND d.SECURITY_PROFILE_ID = b.PROFILE_OPTION_VALUE
AND c1.SECURITY_PROFILE_ID = d.SECURITY_PROFILE_ID
AND c1.ORGANIZATION_ID = d1.ORGANIZATION_ID
and fu.user_name not in (‘AUTOINSTALL’,’APPADMIN’,’SYSADMIN’,’AMW’,’MAINT_ADMIN’,’103336′)
order by 1,2