Graphs are not appearing in XML/BI Publisher reports - How to debug it?

1. Make sure that graphs are appearing in XML Publisher Desktop
2. Deploy the report in Oracle Apps
3. Run the report. Graphs are not appearing.
4. Use http://oraclesanpra.blogspot.ae/2013/06/how-to-find-opp-log-file.html to generate OPP log and provide that to DBA. Check if OPP log has below error message

“Caused by: oracle.xdo.parser.v2.XPathException: Extension function error: Error invoking 'chart_svg':'java.lang.NoClassDefFoundError: Could not initialize class sun.awt.X11GraphicsEnvironment'”

How to find OPP log File?

To investigate on XML issues or other publishing problems, often the OPP logfile is needed.
OPP stands for Output Post Processor. Below are the steps to find log file

1. Login to the application as SYSADMIN

2. Responsibility: System Administrator

3. Function: Concurrent --> Manager --> Administration

4. Select the Output Post Processor

5. Click on the Processes button

6. Select the Concurrent Process which was active during the time that the request ran

7. Click on the Manager Log button to open the Output Post Processor log file


Cheersss...

How to Identify Layout ldt file name in Oracle Time and Labor(OTL)

Check Page 13 of hxcconfiguiwp.pdf document

Clear Cache Shortcut in Functional Administrator

Function Name - Cache Component Global Configuration Page

Updating Layout in Oracle Time and Labor (OTL)

Steps:
1. Download the correct ldt file from $HXC_TOP/patch/115/import/US
2. Update the LDT file to removed the unnecessary part. Remove the whole "Begin End" part.
3. Go to dir: $HXC_TOP/patch/115/import/US and Upload the updated file to the directory
4. Issue the following Cmd:
FNDLOAD username/password@dbname 0 Y UPLOAD $HXC_ TOP/patch/115/import/hxclaytlayoutsld.lct hxczzhxclayt0030.ldt
5. Check the log file
6. Bounce apache
7. Login and check.


Done!!!
 

How to group numbers into ranges?

Requirement:

I have table with a numerical ID field. The values in this column may or may not be consecutive. For example

Data is

1, 2,3,4,5,8,9,10,15,16,17,18

Group should happen like –

Range1-5 count 5

 Range 6-7 count 0 because it’s missing

8-10 count 3

 11-14  0

 15-18 4

 

Test Table Design:

create table xxtest

(number1 number)

 

All numbers inserted in table:

Query:

SELECT   lb || '-' || ub RANGE, COUNT
    FROM (SELECT number1 + 1 AS lb,
                 LEAD (number1) OVER (ORDER BY number1) - 1 AS ub, 0 COUNT
            FROM xxtest)
   WHERE lb <= ub
UNION
SELECT   MIN (number1) || '-' || MAX (number1) number_range,
         MAX (number1) - MIN (number1) + 1 COUNT
    FROM (SELECT number1, number1 - ROW_NUMBER () OVER (ORDER BY number1) rn
            FROM xxtest)
GROUP BY rn
ORDER BY 1;

RANGE COUNT
1-5       5
11-14   0
15-18   4
6-7       0
8-10     3

 

 

Inserting a sequence number/counter into a table’s rows in SQL Loader program

Eg: Create Table T1
(seqCol number(4),
col1 varchar2(15),
col2 varchar2(12))
Create SQL Loader

LOAD DATA INFILE 'data_file_path_name/datafile.dat' APPEND
INTO TABLE T1
FIELDS TERMINATED BY ';' TRAILING NULLCOLS
( seqCol SEQUENCE(1,1) ,
col1 CHAR "LTRIM(RTRIM(:col1))",
col2 CHAR "LTRIM(RTRIM(:col2))" )

The sequence can be as you wish to be started, such as;
SEQUENCE(n,i) – Sequence starts with n(integer) value and increment by i.
SEQUENCE(COUNT,i) – Sequence starts with the number of rows already in the table and increment by i.
SEQUENCE(MAX,i) – Sequence starts with the current maximum value for the column and increment by i.