MOAC setup from SQL Plus/TOAD

Multi Organization Access Control(MOAC) is maintained using Virtual Private Database (VPD). VPD applies security policies to the tables, views and synonyms. VPD replaced views for operating unit access in R12. In R12, org-specific views are replaced with synonyms Setting operating unit context in R11i exec fnd_client_info.set_org_context(&org_id); Setting Operating Unit context in R12: Single Organization/Operating Unit … Read more

Categories EBS

Account Receivables eInvoicing

I presented AR eInvoicing Solution at the OATUG COLLABORATE19 event on 04/11/2019. Presentation Abstract: Automatically sending AR Invoice PDF document to customers via email and copy of the same document to AR Invoice Dept. Customers are setup as EDI Trading partner to receive AR invoice document via email. The program runs for all the newly … Read more

Categories EBS

Public Cloud vs Private Cloud vs Hybrid Cloud

The main cloud deployment models are public cloud, private cloud, hybrid cloud and multi cloud.  Public cloud: Public clouds are the most common way of deploying cloud computing. The cloud resources (like servers and storage) are owned and operated by a third-party cloud service provider and delivered over the Internet. Oracle Cloud Infrastucture (OCI)/ AWS/Microsoft … Read more

Oracle EBS Strategy Updates from Oracle

I attended Oracle EBS Strategy Updates sessions by Cliff Godwin & Jeanne Lowell at OATUG Forum Online in April’2020. Here are my takeaways from the sessions. Oracle EBS R12.1 premier support ends Dec 2021. Support beyond 2021 available thru Oracle Advanced Customer Services(ACS) contract. EBS 12.2 provides substancial value now and into future: The latest … Read more

Categories EBS

Oracle Business Network or Oracle Supplier Network

Oracle Business Network (OBN) is a cloud-based supplier registration and messaging service provided to Oracle customers and their trading partners. For example, organizations can use OBN to automate electronic transmission of important business documents such as Purchase Orders and Invoices with their trading partners. The OBN service is hosted at https://businessnetwork.oracle.com. You will need to … Read more

Overview of Artificial Intelligence

What is Artificial Intelligence? Artificial Intelligence is a computer-aided process for solving complex problems that are normally reserved for humans. Examples are machine vision, pattern recognition, speech recognition, and knowledge-based decision making in a wider sense. Distinctions are made here, on the one hand, between classic algorithms which follow paths that are permanently fixed by … Read more

Overview of Robotics Process Automation (RPA)

What is RPA? Robotics Process Automation, or RPA for short, is the utilization of robotic software to perform repetitive digital tasks that humans perform day-today operations, similarly to how physical robots and machine already help our current way of life. It can perform perform repetitive and structured transactions processes. Prerequisite: The process is lean, documented … Read more

How does the user get access to User Management responsibility menu

User Management responsibility is assigned to the user, But the user can’t access User Management responsibility menu. This is true even when the user management responsibility is assigned by SYSADMIN user. The user has to be defined as “User Management Admin” in the system using Role Based Access Control(RBAC). The Functional Administrator need to grant … Read more

Oracle EBS Key Announcements and Highlights from Oracle OpenWorld 2019

Cliff Godwin, Oracle’s Senior Vice President, Applications Development summarized the key announcements and highlights from Oracle OpenWorld 2019 about Oracle E-Business Suite product on 10/29/2019 Oracle University’s webinar. He covered what to expect further from Oracle about EBS for the coming years. Here are the links for the presentation PDF document and recorded session. Presentation … Read more

Categories EBS