BI Publisher - RTF Document file Size increase with EMF, PNG, GIF, or JPEG graphics in Microsoft Word

Issue : Recently we had file size issue while modifying the RTF document in BI publisher.

Resolution : Microsoft Support provide the solution for the same on following URL :

https://support.microsoft.com/en-us/help/224663/document-file-size-increases-with-emf--png--gif--or-jpeg-graphics-in-w

his article is a consolidation of the following previously available article 262464: WD97: Document File Size Increases with EMF, PNG, GIF, or JPEG Graphics

Important This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

Symptoms

When you save a Microsoft Word document that contains an EMF, PNG, GIF, or JPEG graphic as a different file format (for example, Word 6.0/95 (*.doc) or Rich Text Format (*.rtf)), the file size of the document may dramatically increase.

For example, a Microsoft Word 2000 document that contains a JPEG graphic that is saved as a Word 2000 document may have a file size of 45,568 bytes (44.5KB). However, when you save this file as Word 6.0/95 (*.doc) or as Rich Text Format (*.rtf), the file size may grow to 1,289,728 bytes (1.22MB).

Cause

This functionality is by design in Microsoft Word. If an EMF, a PNG, a GIF, or a JPEG graphic is inserted into a Word document, when the document is saved, two copies of the graphic are saved in the document. Graphics are saved in the applicable EMF, PNG, GIF, or JPEG format and are also converted to WMF (Windows Metafile) format.

Resolution

Warning If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

To prevent Word from saving two copies of the graphic in the document, and to reduce the file size of the document, add the ExportPictureWithMetafile=0 string value to the Microsoft Windows registry. 

To have us fix this problem for you, go to the "Fix it for me" section. If you prefer to fix this problem yourself, go to the "Let me fix it myself" section.

Fix it for me

To fix this problem automatically, click the Fix it button or link. Then click Run in the File Download dialog box, and follow the steps in the Fix it wizard.

Notes

• This wizard may be in English only. However, the automatic fix also works for other language versions of Windows.
• If you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.

Then, go to the "Did this fix the problem?" section.

Let me fix it myself

To do this, follow these steps:

1. Quit Word.
2. Click Start, click Run, type regedit in the Open box, and then click OK.
3. Locate and then click to select one of the following registry keys, depending on your version of Word:
   • For Microsoft Office Word 2007, locate and then click HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Word\Options
   • For Microsoft Office Word 2003, locate and then click HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word\Options.
   • For Microsoft Word 2002, locate and then click HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Word\Options.
   • For Word 2000, locate and then click HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Word\Options.
   • For Word 97, locate and then click HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Word\Options
4. After you select the key that is specified in step 3, point to New on the Edit menu, and then click String.
5. Type ExportPictureWithMetafile, and then press ENTER.
6. Right-click ExportPictureWithMetafile, and then click Modify.
7. In the Value data box, type 0, and then click OK.
8. On the File menu, click Exit to quit Registry Editor.

Now, when you save a Word document that contains an EMF, a PNG, a GIF, or a JPEG graphic in a different format (for example, Word 6.0/95 (*.doc) or Rich Text Format (*.rtf)), Word does not retain two copies of the graphic and does not dramatically increase the file size of the document as compared to the Word version of the file.

How to view CLOB data in Oracle SQL developer

 

Use dbms_lob.substr package to view CLOB field data in sql developer.

Eg :

SELECT dbms_lob.substr( DESCRLONG, dbms_lob.getlength(DESCRLONG), 1) FROM PSMSGCATDEFN

This voucher cannot be changed because it is currently in use by Budget Checking process. (7030,986)

Error :

This voucher cannot be changed because it is currently in use by Budget Checking process. (7030,986)
Resolution :

Update the fields IN_PROCESS_FLG = 'N' and  PROCESS_INSTANCE = 0 in PS_VOUCHER table.
UPDATE PS_VOUCHER SET PROCESS_INSTANCE=0 , IN_PROCESS_FLG = 'N' WHERE BUSINESS_UNIT ='ABCD' AND VOUCHER_ID='V001'

Update the field KK_PROCESS_STATUS ='V' in PS_KK_SHDR_APVCHR

UPDATE PS_KK_SHDR_APVCHR SET KK_PROCESS_STATUS='V' WHERE BUSINESS_UNIT ='ABCD' AND VOUCHER_ID='V001'

Run the budget check process again.

DATETIMESTAMP Issue After Upgrade 8.4 to 9.1 application and FS_BP Issue in 9.1

Issue : All the DATETIMESTAMP fields show only Date in MM-DD-YYYY format.




Solution : DATABASE_OPTIONS field set to 34



SELECT DATABASE_OPTIONS  FROM PSSTATUS


Question: How to get numeric value from Alpha Number data


Eg :  VOUCHER ID = 1234ABCD


Out put : 1234


Solution : SELECT REGEXP_REPLACE(VOUCHER_ID,'[[:alpha:]]') FROM PS_VOUCHER WHERE WHERE VOUCHER_ID='1234ABCD'


Output : VOUCHER_ID=1234


Question : Voucher Budget Check Error : FS_BP process Request 1 attempted to process documents that are locked by another request.


"Warning: Request 1 attempted to process documents that are locked by another request. (18021,96)" While Budget Checking AP Vouchers"


Solution :


For version 9.1 and later update PS_KK_SHDR_APVCHR.KK_PROCESS_STATUS ='V'


UPDATE sysadm.PS_KK_SHDR_APVCHR SET KK_PROCESS_STATUS= 'V' WHERE KK_PROC_INSTANCE = AND KK_PROCESS_STATUS = 'I';

For versions prior to 9.1 update PS_KK_SOURCE_HDR.KK_PROCESS_STATUS = 'N'


UPDATE sysadm.PS_KK_SOURCE_HDR SET KK_PROCESS_STATUS= 'N' WHERE KK_PROC_INSTANCE = AND KK_PROCESS_STATUS = 'I';


PS_KK_SOURCE_LN
PS_KK_ACTIVITY_LOG
PS_KK_LIQUIDATION - Check for PO Voucher
PS_KK_REFERENCE - Check for PO Voucher

Crystal & Nvision Reports are in queued status in Process Scheduler 9.1

Error : Signon Process Timed Out. Please Retry (0,0)


Resolved : Check to see if there is any crystal running at the o/s level (Task Manager).
Check for the process pscrrun.exe and Kill the process
Bring down the process scheduler and clean the IPC resource and the process scheduler cache.


Error : nVision Reports are running for a long hours


Resolved  :  Logon to Process Scheduler NT Server Machine
Check to see if there is any nvision running at the o/s level (Task Manager) for long hours
Check for the process psnvs.exe and Kill the process
Bring down the process scheduler and clean the IPC resource and the process scheduler cache.

Dynamically change the Tab Name in component

You can pass the tab name dynamically to component item label name.

1) Create the HTML object ZAM_COMP_LABLE and write the following piece of java code.

  


2)  Create the work record ZAM_COMP_LABEL_WRK along with field HTMLAREA

3) Drage the HTML Area from menu Insert

4) Assing the work record name and field to HTML area

5) Write the code either on Component - Post Build or Page activate

ZAM_COMP_LABEL_WRK.HTMLAREA.value = GetHTMLText(HTML.ZAM_COMP_LABLE,  NAME.NAME1);

6) In above example i am passing %bind(:1) value NAME.NAME1 name to the component tab
   %bind(:1) = NAME.NAME1

PeopleSoft Security Queries

Query to find the list of users having access to component, action along with Navigation details

 

SELECT DISTINCT roleclass.rolename,
authitem.menuname,
authitem.menulabel, 
authitem.baritemname,
authitem.itemlabel,
DECODE(authitem.DISPLAYONLY, 0, 'N', 1, 'Y') AS "Display_Only",
CASE authitem.AUTHORIZEDACTIONS
    WHEN 1 THEN 'Add'
    WHEN 2 THEN 'Update/Display'
    WHEN 3 THEN 'Add, Update/Display'
    WHEN 4 THEN 'Update/Display All'
    WHEN 5 THEN 'Add, Update/Display All'
    WHEN 6 THEN 'Update/Display, Update/Display All'
    WHEN 7 THEN 'Add, Update/Display, Update/Display All'
    WHEN 8 THEN 'Correction'
    WHEN 9 THEN 'Add, Correction'
    WHEN 10 THEN 'Update/Display, Correction'
    WHEN 11 THEN 'Add, Update/Display, Correction'
    WHEN 12 THEN 'Update/Display All, Correction'
    WHEN 13 THEN 'Add, Update/Display All, Correction'
    WHEN 14 THEN 'Update/Display, Update/Display All, Correction'
    WHEN 15 THEN 'Add, Update/Display, Update/Display All, Correction'
    ELSE 'SPECIAL' END AS "Authorized_Actions",
authitem.PNLGRPNAME,
CASE InStr(nav.PATH_TO_COMPONENT, 'Root>', 1)
  WHEN 0 THEN nav.PATH_TO_COMPONENT
  ELSE SubStr(nav.PATH_TO_COMPONENT, InStr(nav.PATH_TO_COMPONENT, 'Root>', 1) + 5, length(nav.PATH_TO_COMPONENT) - InStr(nav.PATH_TO_COMPONENT, 'Root>', 1) + 5)
  END AS navigation
from
(SELECT
DISTINCT a.CLASSID, a.MENUNAME, b.MENULABEL , a.BARITEMNAME,c.itemlabel ,
a.DISPLAYONLY,                                                                               
a.AUTHORIZEDACTIONS,
c.PNLGRPNAME
FROM PSAUTHITEM a, PSMENUDEFN b, PS_ACLCOMPONENT_V2 c
where a.MENUNAME = b.MENUNAME
AND a.menuname =  c.menuname
AND a.barname = c.barname
AND a.baritemname = c.baritemname) authitem ,
psroleclass roleclass,
(SELECT a.PORTAL_URI_SEG2 as component
, E.PORTAL_LABEL || '>' || D.PORTAL_LABEL || '>' ||C.PORTAL_LABEL ||
'>' || B.PORTAL_LABEL || '>' || A.PORTAL_LABEL as PATH_TO_COMPONENT
, A.PORTAL_URLTEXT
, A.PORTAL_ISPUBLIC as Active
, A.LASTUPDOPRID
, A.LASTUPDDTTM
, A.PORTAL_URI_SEG2
FROM PSPRSMDEFN A, PSPRSMDEFN B, PSPRSMDEFN C, PSPRSMDEFN D, PSPRSMDEFN
E
WHERE 1=1
AND A.PORTAL_PRNTOBJNAME = B.PORTAL_OBJNAME(+)
AND B.PORTAL_PRNTOBJNAME = C.PORTAL_OBJNAME(+)
AND C.PORTAL_PRNTOBJNAME = D.PORTAL_OBJNAME(+)
AND D.PORTAL_PRNTOBJNAME = E.PORTAL_OBJNAME(+)
AND (E.PORTAL_NAME IS NULL OR E.PORTAL_NAME = 'EMPLOYEE')
AND (A.PORTAL_NAME = 'EMPLOYEE' OR A.PORTAL_NAME IS NULL )
AND (B.PORTAL_NAME = 'EMPLOYEE' OR B.PORTAL_NAME IS NULL )
AND (C.PORTAL_NAME = 'EMPLOYEE' OR C.PORTAL_NAME IS NULL )
AND (D.PORTAL_NAME = 'EMPLOYEE' OR D.PORTAL_NAME IS NULL )
) nav
WHERE  roleclass.rolename =
AND authitem.classid = roleclass.classid
AND  authitem.PNLGRPNAME =  nav.PORTAL_URI_SEG2(+)
ORDER BY rolename, menuname, baritemname

 

***********************************************************************

Below are the SQLs to find the Peoplecode and SQL objects which are  created or modified by you but not included in any of your project.

 

 

--------------------------------------------------

-- Selects Peoplecode not inserted in a project

--------------------------------------------------

SELECT

CASE A.OBJECTID1

when 1 then 'Record Peoplecode'

when 3 then 'Menu Peoplecode'

when 9 then 'Page Peoplecode'

when 10 then 'Component level Peoplecode'

when 60 then 'Message Peoplecode'

when 74 then 'Component Interface Peoplecode'

when 87 then 'Subscription Peoplecode'

END AS  OBJect_Type

,

A.OBJECTVALUE1 || '.' || A.OBJECTVALUE2 || '.' || A.OBJECTVALUE3 || '.' || A.OBJECTVALUE4 || '.' || A.OBJECTVALUE5 || '.' || A.OBJECTVALUE6  || '.' || A.OBJECTVALUE7

AS EXTENDED_OBJ_NAME

FROM PSPCMPROG    A 

 , PSPCMTXT B -- join to pspcmtxt to filter out reverted changes (back to blank)

WHERE  LASTUPDOPRID =

AND  A.OBJECTID1 || A.OBJECTVALUE1 || A.OBJECTID2 ||A.OBJECTVALUE2 || A.OBJECTID3 || A.OBJECTVALUE3 || A.OBJECTID4 || A.OBJECTVALUE4

NOT IN

(

SELECT OBJECTID1 || OBJECTVALUE1 || OBJECTID2 || OBJECTVALUE2 || OBJECTID3 || OBJECTVALUE3 || OBJECTID4 || OBJECTVALUE4

FROM PSPROJECTITEM I, PSPROJECTDEFN   d

WHERE I.PROJECTNAME = D.PROJECTNAME

AND D.LASTUPDOPRID =

and i.objecttype in (8,9,39,40,42,43,44,46,47,48)

)

AND a.objectid1                               = b.objectid1

AND a.objectvalue1                        = b.objectvalue1

AND a.objectid2                               = b.objectid2

AND a.objectvalue2                        = b.objectvalue2            

AND a.objectid3                               = b.objectid3

AND a.objectvalue3                        = b.objectvalue3

AND a.objectid4                               = b.objectid4

AND a.objectvalue4                        = b.objectvalue4

AND a.objectid5                               = b.objectid5

AND a.objectvalue5                        = b.objectvalue5

AND a.objectid6                               = b.objectid6

AND a.objectvalue6                        = b.objectvalue6

AND a.objectid7                               = b.objectid7

AND a.objectvalue7                        = b.objectvalue7

AND  A.OBJECTID1 NOT IN   (66,104)

;    

  

 

 

--------------------------------------------------

-- Selects App Engine Peoplecode not inserted in a project

--------------------------------------------------

SELECT

DISTINCT

'Application Engine Peoplecode',

A.OBJECTVALUE1 || '.' || A.OBJECTVALUE2 || '.' || A.OBJECTVALUE3 || '.' || A.OBJECTVALUE4 || '.' || A.OBJECTVALUE5 || '.' || A.OBJECTVALUE6  || '.' || A.OBJECTVALUE7

FROM PSPCMPROG    A 

WHERE  LASTUPDOPRID =

AND   A.OBJECTID1|| A.OBJECTVALUE1|| A.OBJECTID2||A.OBJECTVALUE2||A.OBJECTVALUE3||A.OBJECTVALUE4||A.OBJECTVALUE5  

 NOT IN

(

SELECT I.OBJECTID1 ||I.OBJECTVALUE1 || I.OBJECTID2 ||REPLACE(I.OBJECTVALUE2,' ','')

 FROM PSPROJECTITEM I, PSPROJECTDEFN   d

WHERE I.PROJECTNAME = D.PROJECTNAME

AND D.LASTUPDOPRID =

and objecttype =43

)

and A.OBJECTID1 = 66

;    

 

--------------------------------------------------

-- Selects App Package Peoplecode not inserted in a project

--------------------------------------------------

SELECT

'Application Package Peoplecode'

, A.OBJECTVALUE1 || '.' || A.OBJECTVALUE2

 FROM PSPCMPROG    A 

WHERE  LASTUPDOPRID =

AND   A.OBJECTID1|| A.OBJECTVALUE1|| A.OBJECTID2||A.OBJECTVALUE2

NOT IN

(

SELECT I.OBJECTID1 ||I.OBJECTVALUE1 || I.OBJECTID2 || I.OBJECTVALUE2

 FROM PSPROJECTITEM I, PSPROJECTDEFN   d

WHERE I.PROJECTNAME = D.PROJECTNAME

AND D.LASTUPDOPRID =

and objecttype =58

)

and A.OBJECTID1 = 104

;    

 

 

 

--------------------------------------------------

-- Selects SQL Objects not inserted in a project

--------------------------------------------------

SELECT 

CASE WHEN SQLTYPE = 0 THEN 'SQL Object '

WHEN SQLTYPE = 1 THEN 'App Engine Step '

WHEN SQLTYPE = 2 THEN 'Record View'

WHEN SQLTYPE = 6 THEN 'Application Engine XSLT'

END AS OBJECTTYPE      ,

SQLID

FROM PSSQLDEFN

WHERE   LASTUPDOPRID =

AND  SQLID

NOT IN

(

SELECT OBJECTVALUE1

FROM PSPROJECTITEM I, PSPROJECTDEFN   d

WHERE I.PROJECTNAME = D.PROJECTNAME

AND D.LASTUPDOPRID =

AND OBJECTTYPE in (30)

);