Contact Us

 

 @ 9347325817


                               : venkat9278@gmail.com 



 : http://orafusionaivrd.blogspot.com/ 








                                 https://www.youtube.com/@VenkatOracleERP






Comments

Post a Comment

Popular posts from this blog

Importance of Incremental Data in Oracle Fusion

 What is incremental data? Incremental Data Loads ----------------------- If you are sending employee data to a third-party payroll provider on every Friday, we don’t want to send all employees instead we only want the ones who changed current week. In this scenario, "LAST_UPDATE_DATE" column in the table plays vital role. LAST_UPDATE_DATE tells us when the record was physically saved. */ --Examples: ------------------------------- select count(1) from ( Select  papf.person_number, ppnf.FULL_NAME from  per_all_people_f papf, per_person_names_f ppnf WHERE 1=1 and papf.person_id=ppnf.person_id  and papf.LAST_UPDATE_DATE >=sysdate-7 --(Incremental) and ppnf.NAME_TYPE='GLOBAL' and sysdate between papf.EFFECTIVE_START_DATE and papf.EFFECTIVE_END_DATE and sysdate between ppnf.EFFECTIVE_START_DATE and ppnf.EFFECTIVE_END_DATE ) Result:  55 Records(Only Changed Records in current week) --------------------------------- select count(1) from ( Select  papf.person_n...
Read more

'Generate CSV File' Not Working in Oracle Fusion FBDI template

 Problem: On FBDI Customer Import Excel XLSM template, The Button 'Generate CSV File' Not Working. Solution1: On same Excel XSLM template: From Ribbon>View>Macros>View Macros>GenCSV>Run button.  Solution2: On Excel XLSM template, Go to the Developers Tab>Click on Macros>Choose GenCSV>Click on Run button. After the CSV file is generated, right click on the file>Choose Compress To>Zip Folder. Solution3: On Excel XLSM template> Right click > Properties Under General tab, below there will be an option- 'Unblock'. Enable this.
Read more

Mastering Parameters in Oracle Fusion BI Publisher

Mastering Parameters in Oracle Fusion BI Publisher: Mandatory, Optional, and "All" Logic When building Data Models in Oracle Fusion, how you handle parameters determines the user experience and report performance. Here is the definitive syntax guide: 1. Mandatory Parameters Use this when a value must be provided for the report to run. Syntax: AND column =:parameter Example: AND Person_Number = :p_Person_Number 2. Optional Parameters (The "All" Logic) Use this to allow users to leave a field blank or select "All" to see all records. Syntax (Recommended):  AND (:parameter IS NULL OR column = :parameter) Example: AND (:p_Person_Number IS NULL OR Person_Number = :p_Person_Number) Note: Using NVL is common but can be slower on large datasets as it may bypass indexes. 3. Multi-Select Parameters Use this when the user can select multiple values from a list. Syntax: AND (column IN (:parameter) OR 'All' IN (:parameter)) Example: AND (Person_Number IN (:p_Pe...
Read more