Oracle Fusion and EBS Knowledge Sharing

Oracle Purchasing 1.  Enter Purchase Order:      No accounting generates.   2.   Enter a Receipt:     For Inventory, Asset and Expense Items:         Dr: Inventory Receiving A/c         Cr: Accrual A/c   3. Receiving Transaction:     Based on type of item here accounting entry differs      Inventory Item:         Dr: Inventory Valuation A/c         Cr: Inventory Receiving A/c     Expense Item:         Dr: Expense A/c         Cr: Inventory Receiving A/c     Asset Item:         Dr: Asset Clearing A/c         Cr: Inventory Receiving A/c   Oracle Payable : 4 . Enter Invoice:     ...

    Enterprises An enterprise is a collection of legal entities sharing common control and management.  Division A business-oriented subdivision within an enterprise. Each division is organized to deliver products and services or address different markets. Legal entity An entity identified and given rights and responsibilities by commercial law through the registration with country's appropriate authority. Business unit (Operating Unit in R12) A unit of an enterprise that performs one or many business functions that can be rolled up in a management hierarchy.   Department (Inventory Organization in R12) A division of a business enterprise dealing with a particular area of activity.   Tables The Business Unit ID(BU ID) is stored in HR_ALL_ORGANIZATION_UNITS_ F and HR_ORGANIZATION_UNITS_F_TL table. -HR_ALL_ORGANIZATION_UNITS_F : the primary table which holds all the organization IDs -HR_ORGANIZATION_UNITS_F_TL: organization Translation Table...

  Publish to OIC Introduction Publish/subscribe or the pub/sub messaging is an a synchronous communication architecture   In a pub/sub model, any message published to a topic is immediately received by all of the subscribers to the topic.    Publisher publish a message and all the subscribers subscribes to a publisher. Oracle Integration provides a simple and managed solution for pub/sub communication. OIC provides “ICS Messaging Service Adapter” with quick configuration to achieve the objective.   And integrations that enable subscribers to subscribe to messages from Oracle Integration.   I will explain here with simple steps to build integrations that enable us to publish messages to Oracle Integration and as well subscribe to OIC   We will create 3 integrations         Publish to OIC in this article       First  Subscribe to OIC for FTP File cre...

Subscribe to OIC Introduction In the first blog we created a Push to OIC integration, in this blog we are going to create 2 more Subscribed to OIC integrations In this blog  we will create Subscribe to OIC integration to  consume payload and create a csv file on FTP location Push to OIC - Publish and Subscribe to Oracle Integration - Part-1 Integration to FTP in this integration, we will subscribe to the Push integration and consume it by creating a simple file on FTP location. To do that we need a FTP connection and a Sub Integrations 1.   Create a FTP Connection   Create a FTP connection  From the connections under the Integration home page, click create   Connections Search FTP Selecting Adapter Set the FTP connection properties Connections Details  Connection Details Credentials  Details as below screen shot Credential Details 2.    Create an Integration. From the Integrations, under the Integration  home page, click c...

Subscribe to OIC Introduction In the last blog we created a first Subscribe to OIC integration, in this blog we are going to create 2nd Subscribed to OIC integrations that will  consume payload and insert a row into on-premise database connecting through OCI Agent Subscribe to OIC - FTP file Creation - Publish and Subscribe to Oracle Integration - Part-2 Integration to On-Premise EBS Database In this integration, we will subscribe to the Push integration and consume it by inserting a row in on-premise database connecting through OCI Agent 1.   Create OIC Agent group, download and install on-premise machine There are 2 options you can follow. 1. I have used OIC agent connectivity and connecting with on-premise database, to continue with you can follow the simple steps described in my blog   OIC Agent (Oracle Integration Cloud Connectivity Agent for on-premise system Otherwise, you can use any available database i.e Apex on cloud or any REST database using R...