oracle.prm file locations

[former_member202489]

We have changed our oracle.prm file date parameters to fix an issue similar to the error reported in message 1952314 ORA-01843 http://service.sap.com/sap/support/notes/1952314.  We made changes to two lines in the file under the <business object install>\dataaccess\connectionserver\oracle\extension\qt.  The changes we made were

        <Parameter Name="USER_INPUT_DATE_FORMAT">'MM-dd-yyyy HH:mm:ss'</Parameter>

        <Parameter Name="DATABASE_DATE_FORMAT">MM-DD-YYYY HH24:MI:SS</Parameter>

Question1.  What is the definition of the directory structure under oracle extensions e.g. qt?  There are multiple copies or oracle.prm containing different parameters.

Question2.  Where are these file stored for use by the WEBI rich client server install?  We need to have the user receive this custom content when they install the rich client from our server.

[Former Member]

Hi Roger,

The PRM files actually state the functions that are normally available in a database, including the standard format.

They are what drives the list of functions available when you build the SELECT definition or CONDITION definitions in Information designer... The fact that a function needs aggregation or/not is also determined in there.

For more info please refer the guide.

https://help.sap.com/businessobject/product_guides/boexir3/en/xi3_data_access_guide_en.pdf

Regards,

Siva

[former_member202489]

Thanks but my question is not about the content of the prm files.  My question is: What is the significance of having multiple .prm files in different locations.  Why have a file under \oracle and another under \oracle\extensions\qt?  Why is it necessary and what file would take precedence over the other if they contained the same parameter with different values?  Also question about how a customized version of this file can be included in the server based install of rich client.