Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Introducing Oracle’s intelligent Bots

Posted on October 2nd, 2017 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Do you know ,Chatbots are the latest and hottest topic and the newest way to engage your customers , employee or partner through messaging apps.

This is one of the most interesting sessions that I attended on the first day of Oracle OpenWorld 2017 and there this post will help to share more insights on Chat bot and thus Oracle’s intelligent Bots.

As per Wikipedia ,A chatbot (also chatterbot, chatterbox) is a computer program which attempts to maintain a conversation with a person
A Chatbot or Bot is a computer program designed to simulate a conversation with human users, especially over the Internet. End users can easily discover and connect to Chatbots through many of the popular messaging apps, without the need to individually download and install them from an App store.

This gives Bots a distinct advantage over device-resident Mobile Apps in many circumstances. With a Bot, your service can be instantly available through a messaging app the user already has installed on their mobile device.

An Intelligent Bot, powered by Artificial Intelligence (AI) dramatically improves the conversational experience, allowing a far more natural conversation between the Bot and the end user. However it is expressed and respond accordingly. Intelligent Bots will ensure your users keep engaging and coming back to your service.

Oracle Intelligent Bots: Key Components

With Oracle Intelligent Bots, an integrated feature of Oracle Mobile Cloud, Enterprise, you can develop Intelligent Bots that can create a more natural conversational user interface, through text or speech, to your enterprise systems.

  • Pre-Integrated Delivery Across Channels - This is for APIs for integration with Instant Apps and channels, dialog builder, human-handoff framework
  • Enterprise Ready - Pre-built back end integration framework, connectors, security, scale, continuous bot analytics
  • Embedded AI for Conversational Dialog - Unified contextual state engine and AI platform, Speech & image recognition, intent detection, multilingual NLP

By using Artificial Intelligence (AI) and Natural Language Processing (NLP) powered by Neural Networks and Machine Learning, Oracle Intelligent Bots can more easily detect what the user is trying to achieve (their intent) and respond appropriately with information or results of transactions from API connections to any of your back-end enterprise applications and information sources.

The platform makes it simple and easy to build and train Intelligent Bots without the need for specialist AI skills.

Your bots can then be exposed through many Chat and Voice channels, a custom mobile app or even your web site.

Oracle Intelligent Bots has the following 4 components

Oracle Intelligent Bots has everything that customers need to build a chatbot with channel integration, dialog flow, AI engine, integration and an easy to use Bot builder UI that brings this all together. Oracle Intelligent Bots provides you with a solution that is predictable in terms of cost, ease of use, level of effort and with a rapid time to market.

Looking at the architecture, the Oracle Intelligent Bot supports a clear separation between Interacting with the channels (Facebook, etc.), the actual Intelligence, dealing with providing an answers, and the Integration with backend systems.

Chatbot architecture layering

Fig 1: Chatbot architecture layering

But above all, it provides you with a solution that can enable you to deliver the next generation of customer engagement

  1. Channel configurator that abstracts the communication and UI/UX aspects of the end channel.
    • Here end users have a choice of messaging channels they prefer to use. Certain geographies have specific channels as their preferred messaging channel while other geographies
      prefer other messaging channels. There are different categories of channels as well.
      Broadly, these can be categorized as follows:

      • OTT Channels: Over the top (OTT) messaging channels such as Facebook Messenger, Facebook WhatsApp, WeChat, Line, Kik, Telegram, Talk, Skype, Slack,SMS.
      • VPA: Virtual Private Assistants such as Amazon (Dot, Echo, Show), Google Home,Apple HomePod.
      • Mobile & Web app extensions: Extending native or hybrid/responsive mobile apps or web applications with chat capabilities.
      • Voice Based Input : Custom devices or apps with interfaces that use Siri, Cortana, Google Voice or other speech input for interaction.
  2. Dialog flow execution – the heart of the Intelligent Bots is a state machine that executes context driven workflow with scoped variables. One of the differentiators with Oracle’s Intelligent Bots is that the AI components of NLP and Machine learning are part of this state flow engine as opposed to a separate black box which makes it very simple and easy for the Bot developer to model a conversation without having to worry about the state engine and the AI algorithms
  3. AI Engine – Here active machine learning that identifies the intent of the conversations from the end user and extract entities from unstructured data to create a structure ‘query’ to get data from the enterprise and respond back.
  4. Components. This is final building block of the Bot builder are the components. These are typically enterprise backend systems that own customer’s banking information, or employee information in a HCM system, or sales information in a Sales CRM system.
    • There are system components that handle things like message channel visualization and custom components that provide integration to mobile cloud service to reuse APIs that have been created for the mobile channel.

Oracle Intelligent Bots Key Components

Fig 1 :Oracle Intelligent Bots : Key Components

Therefore Oracle’s intelligent Bots sounds to be integrated & One multichannel Integrated solutions.

Next post , will be more on Oracle Chatbot Platform

Posted in Technical | No Comments »

GCC :VAT IN THE MIDDLE EAST

Posted on September 2nd, 2017 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

GCC Apart from India GST new in recent past , In another milestone towards the implementation of VAT across the Gulf Cooperation Council, the Unified Agreement for VAT was published in the official gazette of one of the member states, Saudi Arabia.

The Unified Agreement provides the framework for the operation of VAT across the GCC.

Each GCC member state will implement the framework through legislation and other instruments. This milestone is another reason for companies operating in the Middle East to put in place or further their VAT implementation plans.. Companies in these region already started for Implemnating GCC .

Let's have a quick look :

The Gulf Cooperation Council (GCC) was formed in 1981 to create unity and economic stability amongst the member nations.

The International Monetary Fund recommended the introduction of an indirect tax system to increase revenue for the member countries.

All member states signed the VAT Framework Agreement, which establishes the main principles for the application of the VAT regime in the member countries.

Here are Key Highlights for KEY Unified VAT Framework

GCC KEY HIGHLIGHTS

Currently , GCC Member Nations

  • Bahrain
  • Kuwait
  • Oman
  • Qatar
  • Saudi Arabia
  • United Arab Emirates (UAE)

Each member will issue VAT legislation.

Majority of Tax system provide Tax Engine and Integration:

  • Logic to natively support Goods and multiple Services type transactions in the Kingdom of Saudi Arabia and the United Arab Emirates
  • Domestic, Intra-GCC, and International (Import and Export) transactions are all supported

Why GCC is getting some much attention

Reason , a deadline is given for these countries

  • United Arab Emirates and Saudi Arabia in Q4 2017
  • Qatar, Oman, Bahrain, Kuwait in 2018 (dependent on legislation)

Though , It’s official: 2018 will see the start of implementation of a value-added tax (VAT) across the Gulf states

Business Functional Area where get impacted [TRANSITION-RELATED CHALLENGES]

Businesses will face the impact of VAT in two ways: by the additional investments needed for compliance,as well as the higher input cost of the new VAT, itself .

However, companies may refrain from passing on the entire input VAT to consumers owing to the fear of losing business.

Some key Challenges can be best understood as :

In Procurement : Major Trabsition Releated challenges might be

  • Formulate new procurement strategies
  • Vendor management
  • Revisit contracts and arrangements

Accounting & IT System

  • Update financial and point of sale systems
  • VAT coding for payables and receivables
  • Electronic documentation/process automation [ if any]

Sales & Pricing

  • Assess impact of VAT on demand/current contracts
  • Pricing strategy and terms of payment
  • Customer management

Knowing Where to Start

So, where do you start to determine which approach is best for you? Deploy a new ERP in the cloud? Keep your core ERP and connect cloud VAT services? Should go with Tax vendor ?

There are a number of factors to consider:

  • What is the age of your existing ERP system? Are you running the latest version of the software, or are you on an old vesrion?
  • In how many countries do you do business?
    • The more geographies, currencies,and languages you operate in, the more rules, regulations, and compliance issues you will need to consider.
    • It might be worth a full-scale migration to cloud in order to keep on top of all the permutations.
  • How many transactions does your ERP process in a day?
    • The higher the transaction volume, the more important it is that your core system be scalable enough to meet demand.
  • Are you looking at a full ERP replacement in the near future?
    • If so, it might make sense to take a phased, “outside-in” approach—starting with tax applications in the cloud to meet the immediate VAT deadline, and then moving core ERP to the cloud at a later date.

No matter which approach you decide on, VAT is coming. Every GCC business will need to comply. I recommend that you form a project team as soon as possible to understand how VAT will impact your business and operating model.

Assess the capability of your existing systems to comply with the new regulations.And then, choose an implementation partner and a software vendor with the real experience and capabilities to meet your needs.

More Reading

You can get more reading

Closing Thoughts

As per The UAE Ministry of Finance

The system for VAT registration and payment is being developed to meet the very best global standards using leading-edge technology. All services will be online and accessible 24/7, responding to the requirements of business. This reflects the UAE’s aim to be a leader in innovation and technology across all aspects.

Posted in Finance, Functional, Fusion Application, Oracle Cloud * | No Comments »

Go Mobile with E-Business Suite [Smartphone Apps]

Posted on October 17th, 2014 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle has recently released 14 mobile applications for Oracle E-Business Suite. In order to support real-time business decisions and collaboration , today's increasingly mobile workforce requires instant access to targeted enterprise data and functions-wherever and whenever they want.

These mobile applications, including horizontal apps targeted for all employees as well as role-based line of business applications .

These new applications provide simple on-the-go access to horizontal functions such as:

S.N App Name Key HighLights Available as part of Licensed Product Remark
HORIZONTAL APPS FOR ALL EMPLOYEES
1 Mobile Approvals
  • Quickly filter approval requests by sender or subject
  • Review at a glance header and line details, action history, and comments
  • Approve or reject with or without comments, or request more information
  • Supports most used approval types in initial release, including expenses, requisitions, purchase orders, recruitment. More approval types to be added

Any Oracle E-Business Suite product

that uses workflow approvals

  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
2 Fusion Mobile Expenses for E-Business Suite
  • Enter expenses via quick entry, direct entry, receipt images, and calendar entries
  • Charge to projects and cost centers
  • Flag policy violations and receipt requirements
  • Download corporate card transactions and edit details
  • Enter mileage expenses
  • Submit expense reports
  • Enter expenses in connected and offline mode
Oracle Internet Expenses
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
3 Mobile Timecards
  • Enter time day-wise for easy time booking
  • Enter time in quick time or regular time modes
  • Support payroll and project based time entry
  • Aggregate day-wise entries into timecard periods
  • Submit timecards
  • View timecard history
Oracle Time and Labor
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
4 Mobile iProcurement
  • Track my requisitions for approval and delivery status
  • View requisition, approvers, lines, and shipments
  • Monitor alerts for rejections, delays, and returns
  • Collaborate in context using device features
Oracle iProcurement
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.

ROLE-BASED LINE OF BUSINESS APPS These role-based line of business applications drive faster business execution and decision making through improved visibility and access to enterprise data and functions

5 Mobile Sales Orders
  • View orders for my customer list
  • Search orders by key attributes
  • View order and line details and status (customer, product, pricing, holds, shipping)
  • Monitor shipment alerts (on hold, backorder)
  • Collaborate in context with device features
Oracle Order Management
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
6 Mobile Inventory
  • Search and barcode scan items and LPNs
  • View on-hand materials and LPNs across facilities
  • Identify loose vs. packed material
  • View existing material reservations
  • Identify material moves in a facility
  • View in-transit and received material
Oracle Inventory Management
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
7 Mobile Product Information
  • Search or scan items
  • Easily access favorite and recently viewed items
  • View product operational and user-defined attributes
  • View product images
  • View suppliers and on-hand quantities in list or map
  • View key transaction metrics, related to SOs, POs, WOs
  • Personalize what information is displayed
  • Collaborate in context using device features

Any Oracle E-Business Suite product that defines or uses Items.

Items are defined in an item master organization to represent products and services you buy, sell, or otherwise transact.

  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
8 Mobile Procurement
  • Track purchase orders requiring attention
  • Search purchase orders based on key attributes
  • View purchase order, approvers, lines, and shipments
  • Monitor alerts for shipment delays
  • Collaborate in context using device features
Oracle Purchasing
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
9 Mobile Project Manager
  • Monitor overall project status in dashboard
  • Contact team members and customer contacts
  • View open payables summary and invoices
  • View open receivables summary and invoices
  • View open issues and change orders
  • Collaborate in context using device features
Oracle Project Costing
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
10 Mobile Discrete Production Supervisor
  • Search or barcode scan work orders to view progress
  • View work order and operations detail
  • Perform quick actions like expedite and add notes
  • View component issue and resources charges
  • Manage exceptions like component shortage
  • Collaborate in context using device features
Oracle Discrete Manufacturing
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
11 Mobile Process Production Supervisor
  • Search batches and steps or barcode scan to view WIP
  • View batch, steps, material, and resource detail
  • Perform quick actions like release and reschedule
  • Manage exceptions like unallocated ingredients
Oracle Process Manufacturing
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
12 Mobile Project Manufacturing
  • Search project inventory by item, project, and task
  • View project on-hand quantities by locator
  • View outstanding project borrow and payback transactions
  • Identify project materials for transfer and borrow/payback
  • Collaborate in context with device features
Oracle Discrete Manufacturing
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
13 Mobile Maintenance
  • View and complete assigned operations
  • Issue materials and charge time to operations
  • View and search work orders and assets
  • View asset summary, work history, and meter readings
  • Record asset meter readings
  • View work request details
  • Create simple work orders and work requests
Oracle Enterprise Asset Management
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
14 Mobile Field Service
  • View customer, product, service request, and task info
  • View and update tasks
  • Capture materials, time, and expense details
  • Check inventory levels
  • Return, transfer, and request parts
  • Work online or disconnected
  • Synchronize when online
Oracle Mobile Field Service
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.

For app availability search ‘Oracle EBS America’ on app store

Oracle E-Business Suite mobile applications are extremely easy to use, resulting from a user-centered design process and user experience (UX) design principles based on simplicity, action ability, consistency, and device integration.

Oracle E-Business Suite mobile applications are built using Oracle Mobile Application Framework .

Oracle MAF framework accelerates and simplifies mobile development with the ability to build once and deploy to multiple platforms, providing tight integration with camera and other device services, device-native user experience, and enables end-to-end encryption and security

This framework accelerates and simplifies mobile development with the ability to build once and deploy to multiple platforms, providing tight integration with camera and other device services, device-native user experience, and enables end-to-end encryption and security

  • EBS Mobile Apps Documentation: Note 1641772.1
  • EBS Mobile Apps Administrator's Guide: Note 1642431.1

Posted in Oracle Application, Oracle Order Management, Oracle Payable, Oracle Pricing, Oracle Product, Oracle Purchasing, Technical | No Comments »

Introduction to Oracle MAF (Mobile Application Framework)

Posted on July 27th, 2014 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

In June 2014, Oracle unveiled Oracle Mobile Application Framework.

Oracle Mobile Application Framework is a hybrid mobile framework that enables developers to rapidly develop single-source applications and deploy to both Apple's iOS and Google's Android platforms.

Features include support for multiple integrated development environments, including Oracle JDeveloper and Eclipse (through Oracle Enterprise Pack for Eclipse); support for multiple development languages, support for Apache Cordova plug-ins; and support for applications developed under Oracle ADF Mobile.

Oracle recommends that new mobile application development be done with the new Oracle Mobile Application Framework. Some Key Highlights Includes:

  • Build Once, Run on Multiple-Platforms
  • Simpler UI development
  • Java, JavaScript, and HTML5-based application development
  • Choice of development tools
  • Offline-capable: SQLite with Encryption
  • Full Access to Native Device Features
  • Modular, Reusable Components

Oracle MAF – Business Benefits

  • Increase mobile development speed
  • Eliminate mobile skills shortage – use existing skill sets
  • Complete solu)on out of the box
  • Extensible

Here is Oracle Mobile Application Framework Architecture [ Adopted from www.Oracle.com ]

Oracle Mobile ApplicationFrameworkArchitecture

Here is YouTube lesson, for More insights.

Additionl Note

Posted in Centrestage, Emerging Technologies, Technical | No Comments »

Oracle Environmental Accounting and Reporting [ EAR] -Solution for capturing and reporting environmental and emissions data

Posted on February 19th, 2014 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

In Release 12.1.3 of the eBusiness Suite, Oracle included an Environmental Accounting and Reporting application.

Environmental Accounting and Reporting (EAR) enables to record and account for activities that have an impact on the environment. It provides the ability to store date effective energy consumption and emissions by location that are later used for environmental reporting.

EAR provides several flexible means to record environmental data through the use of standard transactions , such as invoice processing, inventory issues, batch entry, and manual
data entry.

Supported by a built-in emissions calculation engine that takes the emission factors, the emission sources and the transactional data, it computes the CO2 equivalent and the inventory usage, and stores the data where all the reporting is then done, the Environmental Data Ledger.

It allows the classification of green house gas (GHG) emissions data by Scope 1, 2, or 3 [ see more details at the end] , and also by standard industry codes

The application was originally built by an Australian company NDEVR and subsequently acquired by Oracle . [ Source Oracle Website]

Oracle Environmental Accounting and Reporting is an add-on module to Oracle E-Business Suite and provides multiple modes to capture environmental data, a GHG emissions accounting engine, and pre-built dashboards and reports to:

  • Record, account, track, and report activities that impact the environment.
  • Participate in voluntary GHG monitoring and disclosure programs such as Carbon Disclosure Project.
  • Identify opportunities to improve energy efficiencies and reduce GHG emissions.
  • Recognize and undertake early voluntary actions for reducing greenhouse gas emissions.
  • Fulfill mandatory GHG reporting requirements enforced by global and local legislations.
  • Enhance shareholders confidence as an environmentally conscious organization.

Some of the key features of Oracle EAR that allow you to achieve the above are:

  • Store date effective energy and emission factors for location specific GHG accounting.
  • Maintain an emissions audit data trail in the Environmental Ledger for a time based analysis, reporting, and statutory auditing requirements.
  • Classify GHG emissions data as Scope 1, 2, or 3 and by standard industry codes. Refer to the Setting Up chapter for more information on Scopes.
  • Configure organization hierarchy to meet specific analysis and reporting needs of the enterprise.
  • Record environmental data through several flexible means – through ERP transactions, manual batches or import using WebADI templates.
  • Report emissions data using Oracle Business Intelligence dashboards.
  • Define KPIs for tracking an enterprise’s sustainability performance.

Technology Overview

Oracle Environmental Accounting and Reporting uses the following Oracle technologies:

  • Oracle Business Intelligence Enterprise Edition (OBIEE).
  • Oracle E-Business Suite (EBS) Technology Stack.
    • Following applications of Oracle E-Business Suite to be able to run the EAR application:
      • Oracle System Administration
      • Oracle Inventory
      • Oracle General Ledger
      • Oracle Human Resource Management System
      • Oracle Payables
      • Oracle Assets
      • Oracle Projects
  • Oracle Data Integrator (ODI).

Oracle Environmental Accounting and Reporting

The centre of the diagram [ Fig 1] shows the environmental ledger [ CHG Ledger] – the central storage for EAR, which is supported by a number of configuration screens.
The top section of the diagram shows how environment source data may be collected from:

  • Oracle Payables (e.g. from electricity invoices which show usage statistics)
    • EAR integrates with Oracle Payables to capture data while processing Invoices with or without Purchase Order match, related to the supply and use of products and services that have environmental impact.
  • Oracle Inventory (e.g. if you have an onsite petrol bowser)
    • EAR integrates with Oracle Inventory to record data related to the issue of Items to Assets that result in environmental emissions
  • The Environmental Transaction Batches window (manual data entry specifically related to environmental sources)
  • Or upload data from spread-sheets using Oracle WebADI Templates (e.g. from data extracted fromother systems)
  • EAR leverages Oracle Data Integrator (ODI) to transfer the data from the Environmental Ledger to the Environmental Data Warehouse. The Oracle Business Intelligence application uses the data for environmental reporting through the pre-built dashboards and reports.
  • EAR enables you to record environmental transactions involving the issue of items, to assets defined in the Oracle Assets application.
  • EAR allows you to map Environmental Organizations to projects and tasks defined in Oracle Projects. While processing Invoices that have references to projects and tasks, EAR uses this information to identify organizations to calculate and store environmental data based on the projects and tasks mapped to the organization.

Environmental Reporting Overview

Oracle Environmental Accounting and Reporting provides the following pre-built dashboards to report the source usage, emissions data, carbon disclosure, and KPI measures for organizations:

  • Emissions
  • Energy
  • Metrics
  • Reporting
  • Summaries
  • Test
  • Transaction
  • Usage

Categorization of Emission Types

  1. Scope 1 : Direct GHG Emission from sources owned or controlled by the organization (i.e. gasoline that is put into a fleet of vehicles owned by the organization)
  2. Scope 2 : Energy Indirect GHG Emission from the generation of imported electricity, heat or steam consumed by the organization (i.e. electricity or gas bought by the organization)
  3. Scope 3 : GHG emission that arises from GHG sources that are owned or controlled by other org anizations (i.e. business travel)

Additional Reference

  • Oracle Environmental Accounting and Reporting User's Guide 12.1 (# E23439-02)
  • MOS 1327248.1 - Oracle Environmental Accounting and Reporting Release Notes 12.1.3

Posted in Functional, General Interest, Oracle Application | No Comments »

Identity Management for Oracle R12 E-Business Suite

Posted on May 20th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle Identity Management (OIM) is an integrated system of business processes, policies and technologies that enable organizations to facilitate and control their users' access to critical online applications and resources -- while protecting confidential personal and business information from unauthorized users. It supports user authentication, authorization and provisioning.OIM suite of products now has been extended to support the Oracle R12 E-Business Suite of ERP applications

In summary, Oracle Identity Management includes the following products and applications:

  • Oracle Internet Directory (OID): Oracle Internet Directory is an LDAP server for authentication between Oracle R12 EBS and third party LDAP servers such as Microsoft Active Directory.
  • Oracle Access Manager (OAM): OAM provides additional security authentication for identity management which basically replacing previous Oracle Single Sign On (OSSO) as future solution for single sign on authentication product.
  • Oracle Adaptive Access Manager (OAAM) :Oracle Adaptive Access Manager (OAAM) is the complementary identity management solution which is part of the Oracle Identity Management (OIM) suite of Oracle Fusion Middleware products.
  • Oracle Virtual Directory (OVD) :Oracle Virtual Directory provides LDAP virtualization directory services with Oracle Identity Management products to authenticate LDAP resources between Oracle database and Oracle EBS applications. As such OVD functions to
    integrate Oracle applications in a secure environment.

Posted in Technical | No Comments »

EBS Maximum Attachment Size

Posted on May 16th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

When you are trying to upload any attachment in EBS via iProc or iexpense or isupplier or istore, Take a note there is no limit to the file size of an attachment; however, the 2-4 GB limitation of a LOB could be considered the limitation of an attachment file.

You can also limit the file size by setting the Profile Option on site level:

'Upload File Size Limit'

Normally, any file upload within OA Framework observes this profile option value.

The 'Upload File Size Limit' profile option is being interpreted as bytes instead of kilobytes by the forms application.This profile option is being interpreted correctly by the framework interface but not interpreted correctly via the forms interface.

It specifies the maximum allowable file size in KB for uploaded attachments.For example, if the limit is 2MB, this value should be set to 2000.

Posted in Technical | No Comments »

Generation of GL code combinations by Sql

Posted on April 28th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Here is workaround for automatic/mass CCID generation or insertion of new CCID’s in GL_CODE_COMBINATIONS Table, when new values in Accounting Flexfield Segment are created, EXCEPT “Dynamic Insert” option activated .

you can use the api (function) -> fnd_flex_ext.get_ccid to create the ccid.

If the combination already exists, it returns the existing ccid else creates a new one and returns the id. Explicit commit command needs to be executed after calling this function.

Use below function which returns the CCID if it is exist and create the CCID if it doesn't exist in the application

 

  1.  
  2. <pre>fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
  3. key_flex_code =>'GL#',
  4. structure_number =>l_coa_id,
  5. validation_date =>to_char(SYSDATE,apps.fnd_flex_ext.date_format),
  6. concatenated_segments =>l_account);
  7.  

Read the rest of this entry »

Posted in Technical | No Comments »

Priority for Concurrent Program

Posted on September 29th, 2010 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

If you are working in big user environment, user always complain there request get stuck or takes time to start processing. Majority of time Support team cann't do anything, unless waiting or asking DBA to check the server performance.

There is couple of option you can try , if you know a demanding user and there request name( Concurrent Program) he/she always want in periority.

dgreybarrowOptions 1: If you know what particular program user required in priority.

In oracle EBS you need to set the priority of specific users so that when they run specific reports, those reports should be run on high priority. The steps are very simple:

  1. Go to Sysadmin Responsibility and go to menu Profile > System.
  2. Make sure Site and User boxes are checked.
  3. Select the user name for the user for whom you want to increase the priority
  4. Enter the following within the Profile box and click on Find: Concurrent:Request Priority
  5. Change the priority for the user as you see fit (1 is highest, 99 is lowest, 50 is the default) , Save and exit.

Concurrent Priority1

dgreybarrowOptions 2: You know the Program name, and want to make execution in priority

The steps are very simple:

  1. Login system administrator /Application developer and go to define concurrent screen
    Under Concurrent >> Program >> Define
  2. Find the Program name whose priority you wish to change for ex. "Payable Transfer to GL"
  3. On this screen you can set priority of this request by entering value in "Priority" field( as mark in red) (1 is highest, 99 is lowest, 50 is the default) , Save and exit.

Concurrent Priority

dgreybarrow Oracle definition for Priority

Priority is used to indicate the priority that the concurrent request will be assigned when it is submitted. If you do not assign a priority, the user's profile option Concurrent:Priority sets the request's priority at submission.

dgreybarrow Profile : Concurrent:Request Priority

This displays the default priority number for your concurrent requests. Only a system administrator can change your request priority.

Requests normally run according to start time, on a "first-submitted, first-run" basis. Priority overrides request start time. A higher priority request starts before an earlier request.

Priorities range from 1 (highest) to 99 (lowest). The standard default is 50.

Users can see this profile option, but they cannot update it. This profile option is visible and updatable at all four levels.

Posted in AOL, Technical | 2 Comments »

Contrasting Workflow and BPEL

Posted on May 19th, 2010 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Here is quick compare with two process modeling tool available in oracle.

 

Aspect Workflow BPEL
Repository DB Tables Message/DB
Comm. Method DB Queues XML Messages
Scope EBS All Fusion products
“Widget” Development PL/SQL /Java Web Services wrapper
Architecture Proprietary Standards Based
Versioning No Yes
Scalability Good Excellent

Suggested Read

Posted in Technical | No Comments »

Page 1 of 512345

« Previous Entries