Bi Publisher / XML Publisher: RTf Template Unable to Sum with NULL data

Sum results in NaN

RTF Template: If your column contains Null value the XML publishers SUM function results in NaN.

<?sum(current-group()/ELEMENT_NAME[.!=''])?> 

<?xdoxslt:sum(Amount))?>

Get XML Publisher report Output file

Get the Request Output File for a XML/BI Publisher based concurrent report:
The output is $APPLCSF/$APPLOUT/{REPORTNAME}_{REQUEST_ID}_{COUNT}.PDF|RTF|EXCEL|HTML



REPORTNAME is the concurrent program short name,
REQUEST_ID is the concurrent request ID
COUNT is a counter based on the number of times a request has been re-published.
One of PDF, RTF, EXCEL, HTML is the file extension/type dependent on the output formats chosen.

Custom HRMS Menu not displaying data form Session Controlled Tables

Custom HRMS Menu not displaying data form Session Controlled Tables like PER_PEOPLE used in value set or anywhere else.

No Data Found in LOV if accessed from Custom HRMS Responsibility, where custom menu is attached.

Solution:

Add following function to Custom HRMS Menu (do not Add any Prompt).

Navigator: Disable Multiform

Display HRMS View data in Toad

Display data form HRMS Views form Toad.



INSERT INTO FND_SESSIONS VALUES (USERENV ('SESSIONID'), SYSDATE);

Generate DDL Script (A Faster way)


SELECT dbms_metadata.get_ddl(Object_type,object_name,OWNER)
FROM all_objects
WHERE object_name LIKE 'XX%'
AND Object_type IN ( 'TABLE' ,'PACKAGE' , 'PROCEDURE' ,'FUNCTION' ,'SEQUENCE' ,'DIRECTORY' ,'TRIGGER' )
Order by Object_type

Restart Inactive Concurrent Manager (Concurrent Program Phase is "Inactive" and Status is "No Manager")

To re-start concurrent manager if Concurrent Program Phase is "Inactive" and Status is "No Manager"

Set the APPS Environment

Check the Status:

$adcmctl.sh status apps/<apps password>

To Stop:

adcmctl.sh stop apps/<apps password>

To start:

adcmctl.sh start apps/<apps password>