OPEN Tech Talks: AI worth Talking| Artificial Intelligence |Tools & Tips

In this session guest speaker Lothar Flatz will give a tech talk on DISPLAY_CURSOR Table Function of DBMS_XPLAN.

Our guest speaker Lothar Flatz, from Switzerland, comes from a family of Austrian engineers and inventors. This inherited talent he used since 1989 to improve applications in the Oracle environment being faster and better. He is an Oracle ACE and in 2010 Oracle appointed him a member of the Real World Performance Group. He is also a member of OakTable.net and he blogs on his own blog Oracle RiddleBlog.wordpress.com. A decade of experience working with customers to solve Oracle Problems.

Thank you so much Lothar for your experience sharing with the Oracle community.

IN THIS SESSION, WE WILL LEARN

The DBMS_XPLAN package gives us a very easy method to display the output of the EXPLAIN PLAN command in predefined formats. DBMS_XPLAN the package can also be used to display the plan of a statement stored in the Automatic Workload Repository (AWR) or stored in a SQL tuning set. It further provides a way to display the SQL execution plan and SQL execution runtime statistics for cached SQL cursors based on the information stored in the V$SQL_PLAN and V$SQL_PLAN_STATISTICS_ALL fixed views.

https://www.otechtalks.tv/tech-talk-on-display_cursor-table-function-of-dbms_xplan/

In this session, we will review the basic concept of Oracle Financials part of Oracle E-Business Suite Release 12. Oracle E-Business Suite is a complete set of business applications with different components to cover different business aspects/operations that enables companies to cater detailed business transaction data, which will enable decision making.

IN THIS SESSION, WE WILL LEARN

A few of the key concepts for beginners before start working on Oracle Financials are must

1. The basic concept of Oracle Financials
2. What is the concept behind Legal Organization?
3. How we will represent Your Organization in the Application financials
4. Business Group and Department
5. Government Reporting Legal Entity
6. Definition of Legal Entity
7. Concept of Establishment in Oracle Fin
8. What is the concept of Ledger?
9. Ledgers and Sub ledgers
10. Operating Units
11. Inventory Organizations
12. Chart of Accounts
13. Cost Center
14. Balancing Segment
15. Natural Account
16. Multiple Ledgers
17. Sub ledger
18. Ledgers and Sub ledgers
19. Subledger Accounting and Operating Units

https://www.otechtalks.tv/basic-concepts-of-oracle-financials/

In this session, we will cover an introduction about myself, session formalities, and what to expect in this podcast. It is quite late, should have been done earlier as a first session but was just focusing on content and creating podcast sessions so now we have already covered 8 sessions so thought this is the time to put forward a session on podcast formalities and what was the idea behind this.

LINKS MENTIONED IN THIS SESSION

• Oracle ACE Program
• OracleERP Social Community: #1 Free Online Oracle Study Resource portal are: OraERP.com – The Knowledge Center for Oracle ERP Professionals – Looking Beyond the Possibilities
• Oracle User Groups

https://www.otechtalks.tv/introduction-and-podcast-formalities/