SQL is used to extract the security rules that are defined in the system. The parameter is Accounting Flex Structure SELECT ffvr.flex_value_rule_name, ffvr.description, ffvr.error_message, DECODE( ffvrl.include_exclude_indicator, ‘I’, ‘Include’, ‘E’, ‘Exclude’,…
Read MoreThe prepayment matching program is the child program of the Autoinvoice import program and it is expected to trigger immediately after the Autoinvoice import is completed as per the intended…
Read MoreThe sample query can be used to extract the Training history report for an employee in Oracle OLM(Learning Management) Query : Oracle Learning Management – Training History report SELECT full_name,…
Read MoreThe below sample query can be used to extract the objectives , competencies for an employee in Oracle EBS PMS Query: KRA Report (Objectives & Competencies) for an person id,…
Read MoreThe below sample query can be used to extract the employee absence history in Oracle EBS. Query: Absence history for an person id, if person id is not given on…
Read MoreXML Publisher report data definitions and data template definitions codes names are unique in nature, if you want to delete the defined templates and definitions you can use the below…
Read MoreThe sample script is used to create an assignment set using an API. You can create an assignment from the assignment set creation window in Oracle but you will not…
Read MoreThere are scenarios where we are need to delete the element entries created. Here is sample script which can be used to delete(i.e purge, Date track delete mode as ‘ZAP’)…
Read More