Item Where-Used Analysis Report (Excel – PL/SQL)
Introduction: This blog has the SQL query that can be used for Item where used Report in Oracle Apps R12. Cause of the issue: Business wants a PLSQL excel based report…
Read MoreForms and Report 11gR2 Configuration: Report Component Failed
Description: During configuration of forms and report, component of report configuration failed with the below Error. Step Executing: opmnctl startproc ias-component=RptSvr_xxxxxx_asinst_1 failed Configuration Action ‘Executing: opmnctl startproc ias component=RptSvr_xxxxxx_asinst_1’ has…
Read MoreQuery to get Data Accesses of Users – Oracle Fusion
Introduction: This blog has the SQL query that can be used to pull the data access details of all the users irrespective of their status. Cause of the issue: Business…
Read MoreEmployee Recall Query – Oracle Fusion
Introduction: This blog has the SQL query that can be used to pull the data of employees who are recalled to join the organization. Cause of the issue: Business wants…
Read MoreReport Builder Components
Report Builder Components 1. Data Model 2. Layout Model 3. Object Navigator 4. Report Triggers 5. Parameter Form 6. Program Units 7. Attached Libraries Data Model The Report Editor’s Data…
Read More