ECM · ODC · ODDC

create ODC folder View with folder framework at dev_ocs schema

create view ODC_FOLDER_VIEW as select “FFOLDERGUID”,”FPARENTGUID”,”FFOLDERNAME”,”FINHIBITPROPAGATION”,”FPROMPTFORMETADATA”,”FISCONTRIBUTION”,”FTARGETGUID”,”FAPPLICATION”,”FOWNER”,”FCREATOR”,”FLASTMODIFIER”,”FCREATEDATE”,”FLASTMODIFIEDDATE”,”FSECURITYGROUP”,”FDOCACCOUNT”,”FCLBRAUSERLIST”,”FCLBRAALIASLIST”,”FCLBRAROLELIST” from FOLDERFOLDERS where FPARENTGUID=’451979EEE81E7B427F69F8998787BE3F’   check with select * from ODC_FOLDER_VIEW  

DAM

What is the digital asset management?

What is the digital asset management? Oracle WebCenter Content’s digital asset management capability allows organizations to store, find, view, and use digital assets and rich media quickly and easily. Content, collateral, and individual asset items can be made available instantly in the appropriate formats for use on Web sites, in print materials, or in other… Continue reading What is the digital asset management?

ECM · UCM

How to Update Metadata of documents through DB at UCM(webcenter Content) ?

let’s imagine the following scenario you have different employee profile for different Document types of each employee such sanctions,vacations, services,certificate ,.. etc and every UCM profile has 2 metadata “civil number of employee” , and ” employee name” and title which have specific signature as follow “type of Documnet of ********** ” where the position… Continue reading How to Update Metadata of documents through DB at UCM(webcenter Content) ?

oracle

How to Fix ORA-12162 TNS:net service name is incorrectly specified Error in Oracle?

sometimes  the oracle profile is not prepared correctly and this give so many errors and you should go direct to directory of SqlPlus to start DB /u01/app/oracle/product/11.2.0/dbhome_1/bin ./sqlplus sys/password as sysdba; the following error will arises ORA-12162 TNS:net service name is incorrectly specified Cause This arises if you have not set ORACLE_HOME and ORACLE_SID. Solution… Continue reading How to Fix ORA-12162 TNS:net service name is incorrectly specified Error in Oracle?