Monday, January 10, 2022

How To Find the XML Publisher Temporary Directory Via SQL in Oracle APPS?

Navigate: XML Publisher -> Administrator Properties -> General -> Temporary Directory

SELECT value
FROM   XDO_CONFIG_VALUES
WHERE  property_code = 'SYSTEM_TEMP_DIR';

1 comment:

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...