Company logo at EBS, doubt

[Porva]

Save, Save, Happy 2010

Next, I need to make a logo association with their respective companies in EBS for when the company is X (association by org_id) in the report Show your respective X, When y, yours, and so on.

Does anyone know if there is any table / registration core where I can do this, or via lookup or something?

or will I have to create a registration screen with the BLOB field for the image and associate it with?


Thanks

[alexrsilva]

Porva,
I believe that via lookup you can solve this.
Core, that I know does not exist.
You will really need to use FND_PROFILE.VALUE('ORG_ID') for this.

Att,

[Porva]

beleza Alex, I'll see if I can do using using lookup

[madmax]

Hi Rafael.

I worked in a company that we used soon in Reports and we looked at this query.

Select all

 
SELECT LOGO 
FROM HR_ORGANIZATION_UNITS     HOU 
    , REC_FISCAL_ENTITIES_ALL  RFEA     
WHERE RFEA.LOCATION_ID = HOU.LOCATION_ID 
AND  RFEA.ENTITY_TYPE_LOOKUP_CODE = 'LOCATION' 
AND  HOU.ORGANIZATION_ID = :P_ORGANIZATION_ID 

I can not remember if the field was created or already core.

No Report We created a Query and the Layout of the Report we placed an Image to bring Query's logo.

I hope I have helped.

ABS.

[Porva]

Madmax

Do you have any idea where I record the figure in this table REC_FISCAL_ENTITIES_ALL ???

or if they made "in hand", directly on the table?

[alexrsilva]

Porva,
looking at the structure of the table, mine is already from R12, but only changes the name, the field soon exists in the table and is the blob type.
To record the logo on the table I created a Java class just to get this file and write to the table.
As I am doing in testing environment, I did directly on the desktop, I did not generate a JSP for that.
The structure of my test table is

Select all

 
CREATE TABLE testblob ( 
  id    NUMBER NOT NULL, 
  photo BLOB   NULL 
); 
 

follows the code

Select all

 
package teste; 
 
import java.io.File; 
import java.io.FileInputStream; 
import java.io.IOException; 
import java.sql.Connection; 
import java.sql.PreparedStatement; 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.sql.Statement; 
 
import oracle.jdbc.pool.OracleDataSource; 
 
public class BlobTest { 
 
	/** 
	 * @param args 
	 */ 
	public static void main(String[] args)  throws SQLException, IOException { 
		// TODO Auto-generated method stub 
		String user = "user"; 
		String password = "password"; 
		String database = "database"; 
		 
		System.out.print("Connecting to the database..."); 
		System.out.flush(); 
		System.out.println("Connecting..."); 
		// Open an OracleDataSource and get a connection 
		OracleDataSource ods = new OracleDataSource(); 
		ods.setURL("jdbc:oracle:oci:@" + database); 
		ods.setUser(user); 
		ods.setPassword(password); 
		Connection conn = ods.getConnection(); 
		System.out.println("connected."); 
		conn.setAutoCommit(false); 
		PreparedStatement pstmt = conn.prepareStatement ("INSERT INTO testblob VALUES (?,?)"); 
		pstmt.setInt (1, 1); 
		File fBlob = new File ( "dir_logo" ); 
		FileInputStream is = new FileInputStream ( fBlob ); 
		pstmt.setBinaryStream (2, is, (int) fBlob.length() ); 
		pstmt.execute (); 
		conn.commit(); 
		 
		// Create a statement 
		Statement stmt = conn.createStatement(); 
		// Do the SQL "Hello World" thing 
		ResultSet rset = stmt.executeQuery("select 'Hello World' from dual"); 
		while (rset.next()) 
			System.out.println(rset.getString(1)); 
		// close the result set, the statement and the connection 
		rset.close(); 
		stmt.close(); 
		conn.close(); 
		System.out.println("Your JDBC installation is correct."); 
	} 
	 
} 
 

if you need, warn that I do her JSP to meet who needs .
Inforce again that this Java and this table were created for testing.

attentivally,

[madmax]

Hello Porva.

Dude, if I'm not mistaken, a BLOB field was created in this table with the name soon so.

In this way it is easy and only insert the JPG from the logo and use the SELECT that I passed using location and organization_id.

Select all

 
SELECT LOGO  
FROM HR_ORGANIZATION_UNITS     HOU  
    , REC_FISCAL_ENTITIES_ALL  RFEA     
WHERE RFEA.LOCATION_ID = HOU.LOCATION_ID  
AND  RFEA.ENTITY_TYPE_LOOKUP_CODE = 'LOCATION'  
AND  HOU.ORGANIZATION_ID = :P_ORGANIZATION_ID  

ABS.