Thursday, January 9, 2014

Oracle XML Publisher Reports Important Tables

XML Publisher Reports Important Tables


Below are Important database tables which stores data related to data definitions
and templates of XML Publisher-

XDO_LOBS
XDO_DS_DEFINITIONS_B
XDO_TEMPLATES_B
XDO_TEMPLATE_FIELDS

Translation tables- This tables stores traslated values of template fields

XDO_TRANS_UNIT_PROPS
XDO_TRANS_UNITS  --UNDERSTAND POSITION OF FIELDS AND THEIR UNIT ID
XDO_TRANS_UNIT_VALUES  -- THEIR UNIT ID AND TRANSALTED VALUES

 
Use the below code to delete Data definition.

BEGIN
XDO_DS_DEFINITIONS_PKG.DELETE_ROW(<APPL_SHORT_NAME>,<DATA DEFINITION CODE>);
END;

Use the below code to delete template definition.  

BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW(<APPL_SHORT_NAME>,<DATA DEFINITION CODE>);
END;

Use the below code to remove the uploaded template and translation files 

DELETE FROM XDO_LOBS
WHERE LOB_CODE = 'XXMI_VAT_INVOICE_UKRAINE';

For deleting the translations, we have to delete data from all below tables after deleting temaplate-

Delete from XDO_TRANS_UNIT_PROPS
Where TEMPLATE_CODE = 'XXMI_LIBRO_DIARIO_CHILE';

Delete from XDO_TRANS_UNITS 
Where TEMPLATE_CODE = 'XXMI_LIBRO_DIARIO_CHILE';

Delete from XDO_TRANS_UNIT_VALUES 
Where TEMPLATE_CODE = 'XXMI_LIBRO_DIARIO_CHILE';


While uploading XLFF file use encoding ‘UTF-8’ method.
Transfer the rdf and rtf file in ‘binary’ mode.
Remaining in ‘ASCII’ mode.
  To control format output in excel -
Use below code while designing rtf-

<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"><?CF_JL_DEBIT_3X_FORMAT?></fo:bidi-override>


To Fix Java Memory Error-

Data Template Code: XXCWB_CNTRY_MVMNT_RPT
Data Template Application Short Name: XXCWB
Debug Flag: N
{P_SHIPTO=, P_TNDR=Y, P_TRMNL=, P_GRN_CLASS=, P_PROD_AUTH=Y, P_GEN=Y, P_GRN=01, P_TRN_RN=, P_DEST=, P_ADVCARS=Y, P_STN=, P_WK_TO=200920, P_CO=, P_WK_FROM=200916, P_ZONE=}
Calling XDO Data Engine...
JVMDG217: Dump Handler is Processing OutOfMemory - Please Wait.
JVMDG315: JVM Requesting Heap dump file
...JVMDG318: Heap dump file written to /appsoft_pebs/pebs/oracle/pebsdb/pebscomn/admin/log/PEBS_wpgapp01/heapdump1237120.1267482644.phd
JVMDG303: JVM Requesting Java core file
JVMDG304: Java core file written to /appsoft_pebs/pebs/oracle/pebsdb/pebscomn/admin/log/PEBS_wpgapp01/javacore1237120.1267482651.txt
JVMDG274: Dump Handler has Processed OutOfMemory.
JVMST109: Insufficient space in Javaheap to satisfy allocation request
****Warning!!! Due to high volume of data, got out of memory exception...***
****Please retry with scalable option or modify the Data template to run in scalable mode...***
********************************************************************************
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE


Solution:
--Increment 1024 *2,4,6

"UPDATE fnd_cp_services
SET developer_parameters =
'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m'
WHERE service_id = (SELECT manager_type
FROM fnd_concurrent_queues
WHERE concurrent_queue_name = 'FNDCPOPP');

OR
Use options
 Concurrent program definitions-










Also from find request window , choose concurrent program -> Diagnostics -> view XML
Check the xml file in the end for error.


Please check the details in the DD and template creation e.g.lang, territory,default output,default file.

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete