Read and monitor Oracle related blogs and news sources, all in one place.
The exam content for the Inventory Fundamentals section is mostly the same for R12 and R11i exams. There are minor changes in the exam topic names - '11i Receipt to Issue Overview' and '11i Defining Inventory Organizations' for the R11i exam is 'Overview of Oracle Inventory' and 'Inventory Structure' respectively for the R12 exam. Some R12 topics are now independent topics like 'Unit of Measure' (R12) and '11i Inventory Controls' is split up in the R12 exam content as 'Lot and Serial Control' and 'Material Status Control'. R12 exam content also mentions the topic of 'Table Information' where one needs to identify the Oracle Inventory tables (for this eTRM is the reference of choice)
Please enjoy the Nano 9s on Oracle Inventory Fundamentals while sipping your hot cup of java and also enter for a chance to win the OCP Blog T-shirt to a lucky winner with all correct answers.
I’ve gushed before about how lucky I am and what a great team we have. As someone who puts a lot of herself into her work, a great team is a big part of my own personal engagement.
In the past few weeks I’ve been thinking about great teams I have worked with in the past. Specifically those people who I would rehire if ever an opportunity were to arise.
In most cases my interest in rehiring someone is not as much about the current job opening, it is usually more about them being the right people to have on the bus. So, what makes someone right for my particular bus?
Been thinking about that too and here is what I’ve decided
Anyway, this is the list for my bus. What about you? What traits have the best people you worked with had? What about them makes you wake up at night saying “I could totally solve that problem at work if only I had XXX back on my team“?
A quick post ... it's been a frenetic few months, so blog posts a bit thin lately but plenty of good stuff in the pipeline!
Generally when I'm designing a BI Publisher/XML Publisher report I'll create a concurrent program that generates XML, I'll follow the usual steps:
Is there an easier way to get the XML file from a concurrent request? Sure is - nice and easy through the front end.
But where does the XML file live?
Well, by default it is $APPLCSF/$APPLOUT/o{REQUEST_ID}.out.
But if that's the XML file, then where does the actual output file reside as the location of the XML file is where normal request output resides?
The output is $APPLCSF/$APPLOUT/{REPORTNAME}_{REQUEST_ID}_{COUNT}.PDF|RTF|EXCEL|HTML
Where
An example is: XXXX_FNDSCURS_2803880_1.EXCEL
Output file location courtesy of Tim's post here.
Cool, file locations identified!
How multi-modal capabilities empower ubiquitous computing.
Centered around the user, multi-modal computing is as much a hybrid approach to user input as multiple drive trains are to a Prius. we will attempt to answer the following questions:
Fig 1a: Tethered Modern Worker
We are all used to carrying multiple devices with us and the modern forklift warrior is also encumbered by having to use a number of devices and input devices to update a system with what he/she has done. Depending on the work situation, this would include any number of inputs and communications types.
For example if the user is working in a distribution center handling returns or maintenance/repair, a typical workflow would look like the following:
As you can surmise, the above operations in combination or singly can involve one or many modes of inputs in the form of scanner, sensor, speech, manual mobile input and some form of automation.
Multi-modal or Aria as branded by some industry exponents, is as much a device solution capability as well as software that enables the orchestration of these machine events and inputs into a synchronized business flow.
Keep a lookout for key capabilities, TCO impact and ROI measures.....
As some of you may have noticed, my server has been experiencing a lot of problems this past month.. :’(
Going down, coming back up, emails breaking, not recieving, not sending its a complete nightmare..
So if you’ve emailed me in the past month I probably did not receive it unless it was fluke..
Everything seems to be back and stable so fingers crossed it was just the gremlins in my friends server room in Slovenia playing god…
Recently I came across a small problem with setting up Oracle UCM 10gR3 on a MSSQL2005 instance.
Using the net.sourceforge.jtds.jdbc.Driver class.
The DBAs had setup a clustered SQL environment and had given me MSSQLDB0001\ARCHIVETR.
ARCHIVETR being the SQL instance which I needed to install the UCM to.
For future reference all you need to do is append ‘;instance=ARCHIVETR’ to the connection string like the following:
jdbc:jtds:sqlserver://<SQLServer>:<PORT>/;instance=<SQLInstanceName>
Example:
jdbc:jtds:sqlserver://MSSQLDB0001:1433/UCM;instance=ARCHIVETR
A Brief History of nVision and Queries
Let's start this discussion by going back to the beginning of nVision, where it was initially developed as part of the GL product and there was no such thing as PS/Query yet. It was built to perform reporting against the ledger and that was pretty much it. In PeopleTools 3, there was a bunch of new things that came in the reporting area: nVision was moved from being part of the GL development team to becoming a PeopleTool, Query and Crystal were introduced as additional reporting capabilities, and nVision received several new features out of the mix, allowing it to perform analysis against content other than Ledgers (as well as drilling into supporting transactional detail through queries).
On the nVision side, this was accomplished by extending the product to support Query as a data source in addition to ledgers as well as support of tabular layouts (in addition to Matrix layouts).
More about Query Support
Adding support for queries as a data source was a very elegant way of identifying data to be used while still leveraging much of the metadata in the PeopleSoft system. This allowed a business user to identify fields of interest, specify how to aggregate data to be analyzed, as well as leveraging effective dating logic.
nVision has special logic inside it to handle the additional criteria specified in a report layout, or to apply scope criteria to the report (it actually modifies the query on the fly to add the additional value or tree criteria and process it). However, a Query simply does not have the same level of metadata as a ledger does, which means that there are limitations. For example, there is no calendar mapping to queries as there is for ledger (which is the primary key to identify what a timespan means). Therefore, although the scope and criteria extensions of queries in nVision work seamlessly, much of the other extensions that are part of the report request are not applied (in the circumstance in question, the business unit specification in the report request is not used to filter the data, although it is used for setid indirection.
Tabular Layouts
One other thing that has intracies (or rather inconsistencies) with how it works is tabular layouts. For example, it would be nice to be able to take a query and apply worksheet criteria to it in a tabular layout. Unfortunately, worksheet criteria does not work and if you want to apply additional criteria to a tabular report without modifying the query, you will need to use a scope.
Recently one of my clients servers were attacked by the ASCII Encoded/Binary String Automated SQL Injection Attack. [Info Here]
They had an old ASP web application which allowed the injection through a HTTP GET..
They should of really used store procedures!
Unfortunatly the database wasn`t being backed up. 
But good news… here`s the query you can use to tidy up your database if your are ever injected 
Hope this helps. As for hope to prevent sql injection in future learn to use store procedures!! Or you can find another not so great solution here:[Info Here]
Read On for the sql query..
SET NOCOUNT ON
DECLARE @SCRIPT VARCHAR(1024)
DECLARE @T VARCHAR(255)
DECLARE @C VARCHAR(255)
DECLARE Table_Cursor CURSOR FOR
SELECT [A].[Name], [B].[Name]
FROM sysobjects AS [A], syscolumns AS [B]
WHERE [A].[ID] = [B].[ID] AND
[A].[XType] = ‘U’ /* Table (User-Defined) */ AND
([B].[XType] = 99 /* NTEXT */ OR
[B].[XType] = 35 /* TEXT */ OR
[B].[XType] = 231 /* SYSNAME */ OR
[B].[XType] = 167 /* VARCHAR */)
OPEN Table_Cursor
FETCH NEXT FROM Table_Cursor INTO @T,@C
WHILE (@@FETCH_STATUS = 0)
BEGIN
print ‘Updating [' + @T + '].[' + @C + ']…’
SET @SCRIPT = ‘<script src=http://www.asodbr.com/ngg.js></script>’
EXEC(‘UPDATE [' + @T + '] SET [' + @C + '] = REPLACE(cast([' + @C + '] as nvarchar(4000)), ”’ + @SCRIPT + ”’, ””)’)
SET @SCRIPT = ‘<script src=http://www.dbgbron.com/ngg.js></script>’
EXEC(‘UPDATE [' + @T + '] SET [' + @C + '] = REPLACE(cast([' + @C + '] as nvarchar(4000)), ”’ + @SCRIPT + ”’, ””)’)
SET @SCRIPT = ‘<script src=http://www.browsad.com/ngg.js></script>’
EXEC(‘UPDATE [' + @T + '] SET [' + @C + '] = REPLACE(cast([' + @C + '] as nvarchar(4000)), ”’ + @SCRIPT + ”’, ””)’)
SET @SCRIPT = ‘<script src=http://www.ucomddv.com/ngg.js></script>’
EXEC(‘UPDATE [' + @T + '] SET [' + @C + '] = REPLACE(cast([' + @C + '] as nvarchar(4000)), ”’ + @SCRIPT + ”’, ””)’)
Print ‘Done’
Print ”
FETCH NEXT FROM Table_Cursor INTO @T, @C
END
CLOSE Table_Cursor
DEALLOCATE Table_Cursor
Print ‘Clean-up Complete.’
Local JavaObject &loginMgr = CreateJavaObject("com.greysparling.asterisk.PSoftLoginManager", &host, &user, &pswd);
Local JavaObject &loginEvt = &loginMgr.challengeUser(&userID, &phone, &pinCode, &channel, &context, &exten);
If &loginEvt.isSuccess() Then
Warning ("Successfully validated user " | &userID);
Else
Warning ("Off with " | &userID | "'s head!");
End-If;[challenge-psft-user]
exten => 7189,1,Answer()
exten => 7189,2,Playback(vm-intro)
exten => 7189,3,NoOp(Authenticating user ${PSFTUSERID})
exten => 7189,4,Authenticate(${PIN},j)
exten => 7189,5,NoOp(Successful login ${PSFTUSERID})
exten => 7189,6,UserEvent(PSoftLogin|userId: ${PSFTUSERID}|result: SUCCESS)
exten => 7189,7,Hangup()
exten => 7189,105,NoOp(Unsuccessful login ${PSFTUSERID})
exten => 7189,106,UserEvent(PSoftLogin|userId: ${PSFTUSERID}|result: FAILURE)
exten => 7189,107,Hangup()
-- Executing [7189@challenge-psft-user:1] Answer("IAX2/123456789-2", "") in new stack
-- Executing [7189@challenge-psft-user:2] Playback("IAX2/123456789-2", "gs-demo-login") in new stack
-- Playing 'gs-demo-login' (language 'en')
-- Executing [7189@challenge-psft-user:3] NoOp("IAX2/123456789-2", "Authenticating user PTDMO") in new stack
-- Executing [7189@challenge-psft-user:4] Authenticate("IAX2/123456789-2", "4554|j") in new stack
-- Playing 'agent-pass' (language 'en')
-- Playing 'auth-thankyou' (language 'en')
-- Executing [7189@challenge-psft-user:5] NoOp("IAX2/123456789-2", "Successful login PTDMO") in new stack
-- Executing [7189@challenge-psft-user:6] UserEvent("IAX2/123456789-2", "PSoftLogin|userId: PTDMO|result: SUCCESS") in new stack
-- Executing [7189@challenge-psft-user:7] Hangup("IAX2/123456789-2", "") in new stack
== Spawn extension (challenge-psft-user, 7189, 7) exited non-zero on 'IAX2/123456789-2'
-- Hungup 'IAX2/123456789-2'package com.greysparling.asterisk;
import org.asteriskjava.manager.event.UserEvent;
public class PSoftLoginEvent extends UserEvent {
private String userId;
private String result;
public PSoftLoginEvent(Object source) {
super(source);
}
public String toString() {
return "PSoftLogin for " + getUserId() + " (" + result + "),"
+ super.toString();
}
public boolean isSuccess() {
return "SUCCESS".equals(result);
}
public void setResult(String result) {
this.result = result;
}
public String getUserId() {
return userId;
}
public void setUserId(String userId) {
this.userId = userId;
}
private static final long serialVersionUID = 1L;
}
package com.greysparling.asterisk;
import java.io.IOException;
import java.util.HashMap;
import org.asteriskjava.manager.AuthenticationFailedException;
import org.asteriskjava.manager.ManagerConnection;
import org.asteriskjava.manager.ManagerConnectionFactory;
import org.asteriskjava.manager.ManagerEventListener;
import org.asteriskjava.manager.TimeoutException;
import org.asteriskjava.manager.action.OriginateAction;
import org.asteriskjava.manager.event.ManagerEvent;
import org.asteriskjava.manager.response.ManagerResponse;
public class PSoftLoginManager implements ManagerEventListener {
private ManagerConnection connection;
private boolean keep_running = true;
private String userId;
private PSoftLoginEvent event;
static final String USERID = "PSFTUSERID";
static final String PIN = "PIN";
public PSoftLoginManager(String host, String user, String pswd) throws
AuthenticationFailedException, TimeoutException, IOException {
ManagerConnectionFactory factory =
new ManagerConnectionFactory(host, user, pswd);
connection = factory.createManagerConnection();
connection.addEventListener(this);
connection.registerUserEventClass(PSoftLoginEvent.class);
connection.login();
}
public PSoftLoginEvent challengeUser(String userId, String phone,
String pinCode, String channel, String context, String exten)
throws InterruptedException, TimeoutException, IOException {
this.userId = userId;
this.event = null;
HashMap vars = new HashMap();
vars.put(USERID, userId);
vars.put(PIN, pinCode);
OriginateAction action = new OriginateAction();
action.setChannel(channel + "/" + phone);
action.setContext(context);
action.setVariables(vars);
action.setExten(exten);
action.setPriority(new Integer(1));
ManagerResponse response = connection.sendAction(action, 30000);
System.out.println(response.getResponse());
while (keep_running)
Thread.sleep(100);
return this.event; // caller can check isSuccess()
}
public void onManagerEvent(ManagerEvent event) {
if (event instanceof PSoftLoginEvent) {
PSoftLoginEvent login_event = (PSoftLoginEvent)event;
System.out.println("Login event: " + login_event);
if (userId.equals(login_event.getUserId())) {
System.out.println("Matched user");
this.event = login_event;
this.stop();
}
else {
System.out.println("User was " + login_event.getUserId());
}
}
else {
System.out.println("Event: " + event);
}
}
public void stop() {
keep_running = false;
}
}
Rounding out our ever-growing set of 11gR1 Database certifications, I'm pleased to let you know that our Applications Platform Group has certified E-Business Suite Release 11i (11.5.10.2) with the 11gR1 Database version 11.1.0.6 on Microsoft Windows Server 2003 x64 (AMD64 / EM64T).
Note: This is a database tier only certification (also known as a 'split configuration'). The application tier must be on a fully certified E-Business Suite 11i platform.
References
Related Articles
The fix can be obtained via Patch 6841295 "DB SESSIONS FROM JVMS ARE VERY VERY HIGH AFTER ATG RUP6 + JDK 1.6 UPGRADE"
This patch is password protected - please contact Oracle Support
We executed the SQL:
SQL> select s.sql_hash_value, t.sql_text, s.last_call_et
from v$session s , v$sqltext t
where s.username = 'APPLSYSPUB'
and s.sql_hash_value= t.hash_value
and t.sql_text like '%fnd_security_pkg.fnd_encrypted_pwd%'; 2 3 4 5
SQL_HASH_VALUE SQL_TEXT
-------------- ----------------------------------------------------------------
LAST_CALL_ET
------------
2656254451 BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1,:2,:3,:4,:5); END;
6712
2656254451 BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1,:2,:3,:4,:5); END;
472085
2656254451 BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1,:2,:3,:4,:5); END;
363139
SQL_HASH_VALUE SQL_TEXT
-------------- ----------------------------------------------------------------
LAST_CALL_ET
------------
2656254451 BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1,:2,:3,:4,:5); END;
472085
2656254451 BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1,:2,:3,:4,:5); END;
1140226
2656254451 BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1,:2,:3,:4,:5); END;
472095
SQL_HASH_VALUE SQL_TEXT
-------------- ----------------------------------------------------------------
LAST_CALL_ET
------------
2656254451 BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1,:2,:3,:4,:5); END;
471800
2656254451 BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1,:2,:3,:4,:5); END;
1140221
2656254451 BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1,:2,:3,:4,:5); END;
1140219
SQL_HASH_VALUE SQL_TEXT
-------------- ----------------------------------------------------------------
LAST_CALL_ET
------------
2656254451 BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1,:2,:3,:4,:5); END;
1133010
2656254451 BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1,:2,:3,:4,:5); END;
472089
2656254451 BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1,:2,:3,:4,:5); END;
472094
SQL_HASH_VALUE SQL_TEXT
-------------- ----------------------------------------------------------------
LAST_CALL_ET
------------
2656254451 BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1,:2,:3,:4,:5); END;
1140216
2656254451 BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1,:2,:3,:4,:5); END;
472090
2656254451 BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1,:2,:3,:4,:5); END;
472090
SQL_HASH_VALUE SQL_TEXT
-------------- ----------------------------------------------------------------
LAST_CALL_ET
------------
2656254451 BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1,:2,:3,:4,:5); END;
472082
16 rows selected.
That matches roughly with:
$ top -b 5000 -s size | grep applmgr
25809 applmgr 73 59 0 1140M 356M sleep 39:01 0.00% java
15528 applmgr 65 59 0 361M 187M sleep 28:49 0.00% java
15548 applmgr 62 59 0 1051M 275M sleep 22:02 0.00% java
15770 applmgr 62 59 0 1051M 269M sleep 21:59 0.00% java
15538 applmgr 62 59 0 1051M 283M sleep 21:23 0.00% java
19372 applmgr 62 59 0 1136M 345M sleep 12:28 0.00% java
19435 applmgr 62 59 0 1140M 338M sleep 11:53 0.00% java
19409 applmgr 62 59 0 1112M 306M sleep 9:39 0.00% java
19395 applmgr 62 59 0 1111M 315M sleep 9:31 0.00% java
19399 applmgr 62 59 0 1111M 313M sleep 9:29 0.00% java
19414 applmgr 62 59 0 1111M 304M sleep 9:11 0.00% java
19421 applmgr 60 59 0 1144M 343M sleep 8:59 0.00% java
19452 applmgr 61 59 0 1114M 307M sleep 8:55 0.00% java
19384 applmgr 59 59 0 1114M 307M sleep 8:40 0.00% java
Strangely this instance was not on RUP6 but on RUP4. Maybe this issue occurs on RUP4 too. Since this patch is password protected, I have logged an SR with Oracle to get the password. We'll be applying this in one of the affected instances and check if it solves the issue. Will update this post once it is done.
Don’t hesitate to add into your email signature some informations like your Linkedin profile or Facebook ID, and for all Oracle lovers add your Mix Profile link like that :
Oracle E-Business Suite Release 12 (12.0) is now certified with Oracle Database Server 10gR2 version 10.2.0.3 on IBM Linux on System z (zLinux).
Note: This is a database tier only certification (previously known as a ’split configuration’ in 11i). The application tier must be on a fully certified E-Business Suite R12 platform.
Linux on mainframe (Red Hat and SUSE) is just like any other Linux deployment from Oracle’s perspective. The novelty of a mainframe deployment is that Linux server instances are completely virtualized through z/VM — their virtualization software (this is how they compete effectively with very large Linux/Unix server farms). In Japan we have the largest pure Oracle customer on System z deployment running 3 RAC clustered mainframes with 300 processors (huge). There are dozens more in production. The customer may only be thinking server consolidation to realize management, power and other environmental savings.
Where can I find more information?
Certify’s E-Business Suite -> EBS Release 12 -> Database Tier Only page for details
Latest Activity on OracleCommunity.net
RSS
Email