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

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 »

AssureNET GL : Thats a good Product for “Account Reconciliation”

Posted on August 13th, 2010 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you heard about the product called "ASSURENET" , this is one of good product for reconcilation activity getting attention now a days by Accountants , Auditors ,controllers because the good capability of managing Finance accounts reconciliation and Audits trials feature. No matter its Balance sheet account or bank account, this product have great functionality which will add lot of value to business.

What is AssureNET

AssureNET GL is a web-based process management system for the general ledger account reconciliation & certification function. It is designed to strengthen the account reconciliation internal control while making the process much more efficient and SOX compliance.

This Product normally comes with three major functional modules like:

  1. Complete Assigned Tasks & Activities Module
  2. Prepare or Monitor Quality Assurance Reviews Module
  3. Manage or Monitor Task & Activities Module

Using this software you can get the advantage of following benefits:

  • This will Simplified the account reconciliation process , as most of the ERP does not have enough capability keeping the auditors in mind.
  • This will reduced the amount of time necessary for Internal Audit's testing of account reconciliations.
  • This enhanced the visibility into the performance of the control across the entire enterprise which may include detailed analysis by department, location, products or region.
  • Automated email notifications will help to inform participants of impending reconciliation and review dates or missed deadlines
  • Automated summaries of exception statistics and extensive management reporting
  • Last but not the least complete segregation of duties between the reconciliation, review, approve and certification functions

Application Technology

Typically this application is developed using

  • .NET Framework
  • IIS WSE
  • ASP.NET , AJAX Extensions
  • And SQL Server as database.

This comes with hosted solutions via vendors On-Demand business unit as well as you manage and own this this product at your site.

References
Check out this product at vendor site, if your department is ready to spend few thousand of dollar.

Posted in Oracle General Ledger, Oracle Product | 1 Comment »

Understanding Global Accounting Engine – Dual posting, Tables, Reports

Posted on November 10th, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Continuing my last post for AX , here is some more information for Global accounting Engine's Dual posting and Reporting need. Lets start with Dual posting.

1

Global Accounting Engine (AX) Dual Posting

The Global Accounting Engine's dual posting functionality allow simultaneous posting into two sets of books (a main and a secondary sets of books).The AX Dual posting (or multiple posting) functionality lets you meet reporting and accounting requirements when you have multiple sets of books with different charts of accounts, calendars, and rules sets.

  • Control Accounts
    The Global Accounting Engine automatically creates detailed balances for control accounts. The balances are calculated for each account with the control account status by period and third party when you run a subledger report. Control accounts are printed on summary and detail balance reports provided by the Global Accounting Engine.
  • Documents Sequencing
    A document sequence uniquely numbers documents generated by an Oracle Applications product. Using Oracle Applications, you initiate a transaction by entering data through a form and generating a document, for example, an invoice. Document sequences can provide proof of completeness. For example, document sequences can be used to account for every transaction, even transactions that fail.

Document sequences can also provide an audit trail. For example, a document sequence can provide an audit trail from the general ledger into the subsidiary ledger, and to the document that originally affected the account balance.

2Table Details

These are the additional tables which keeps the events data.

  • gloabal accounting processAX_SETUP_GLOBAL
  • AX_SETUP_POSTING_BOOKS
  • AX_TRANS_PROGRAMS
  • AX_EVENTS
  • AX_DOCUMENT_STATUSES
  • AX_SLE_HEADERS
  • AX_SLE_LINES
  • AX_BALANCES
  • GL_INTERFACE
  • GL_JE_LINES

 

3AX Reporting

Below is a list of the most important AX Reports:

  • The Daily Journal Book - Line Descriptions report displays fiscal year totals for specified sequences. For both manual and imported journals in General Ledger, the report shows the General Ledger accounting sequence number assigned at the time of posting, instead of the General Ledger document sequence number.
  • The Daily Journal Book - Header Descriptions report is sorted by sequence name, General Ledger date, and accounting sequence number within the range of requested balancing segments. The report provides totals for the range of balancing segments requested, but not subtotals for each balancing segment.
  • The Final Daily Journal Book - Header Descriptions report allow the review of all accounting entries for your set of books by sequence name and period.
  • The Supplier/Customer Balance by Account/Accounting Flexfield report allows reviewing information about balances and period activities by account and supplier/customer for one or more accounting periods. This report lets you justify your balances in General Ledger, Payables, and Receivables.

4 Limitations of AX

  • It has been designed based on primary transactions in Local GAAP.
  • Its needs same calendar in primary and secondary set of books
  • The other limitation is that no user access to account transformation rules that mean very limited functionality.
  • Intensive setup and maintenance, that makes a technical difficulty.
  • Separate release and patch sets. This support issue is yet another limitation.
  • Non-Standard as it is replaced by GL posting process,separate additional tables.
  • Not Complete as only limited to few like AP, AR and in some case France can use INVENTORY as sub-ledger modules

Posted in Functional, Oracle General Ledger, Oracle Product | 4 Comments »

Understanding Global Accounting Engine ( Product AX)

Posted on November 9th, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

1

Why is the Global Accounting Engine needed?

The Global Accounting Engine is needed for European foreign subsidiaries as they are required to do reporting in foreign countries.

The Global Accounting Engine produces European reports not available in the standard accounting applications.

It is Legal compliance tool for some international accounting and audit requirements.

  • Accounting transformation for inventory/purchasing
  • Audit Trail:
    • adds required sub-transactions (cash reversals,adjustments, and others)
    • additional GL sequences across AR/AP
    • Control accounts for sub-ledger-GL reconciliation

2 What is functionality of the Global Accounting Engine ?

The Global Accounting Engine provides you with features to satisfy the following basic business needs. You can:

  1. Comply with accounting regulations of any country. Some accounting entries are legal in one country but not in another.
  2. The Global Accounting Engine lets you choose the right accounting schemes for your country.
  3. Define accounting rules per set of books.
  4. Post different accounting rules to different sets of books.
  5. Generate different accounting entries from the same business transaction into different sets of books.
  6. Perform synchronous multiple set-of-book accounting. The multiple set-of-book accounting is synchronous because it ensures that a Business transaction is either posted in all related set of books or is not posted in any set of books.
  7. Comply with legal and fiscal audit trail requirements.
  8. Store all accounting entries in the same structure and format for all applications. An accounting entry always consists of a header and two or more accounting entry lines. The Global Accounting Engine uses this information to provide accurate reconciliation reports in applications such as Payables and Receivables.
  9. Reconcile your subledger accounting system with General Ledger. The Global Accounting Engine provides additional reports such as daily journal reports. Reports are used when a company needs to match the amounts in the subledgers such as Payables, Receivables, and General Ledger.
  10. Define journals rather than using hard-coded categories. These journals are numbered sequentially to comply with legal requirements.
  11. Assign sequential numbers to the defined journals across applications.
  12. Each accounting entry has a unique identifier as well as other header information. This accounting number is the primary key for your accounting lines. You can use the same numbering in applications such as Payables and Receivables.
  13. Audit and control period and fiscal year closing procedures.
  14. The Global Accounting Engine provides a new mechanism for closing periods that ensures a complete and gapless numbering is generated as required in some countries.
  15. Create journal entries and detailed balances for control accounts.
  16. Control accounts are General Ledger accounts that you can access only from subledger applications such as Payables and Receivables. The balances are calculated for each account with the control account status and third party period and identification. A third party can be a supplier in Payables or a customer in Receivables. The Global Accounting Engine uses these structures to provide legal balance reports that are the same across all applications.
  17. Secure subledger accounting entries. You can either secure accounts individually or secure the procedure to create accounting entries. To secure subledger accounting entries, use control accounts to define accounts. A control account is only accessible from the subledgers. Securing your entries ensures a valid audit trail is on paper. The secured posting makes sure that you are only given access to a range of steps involved in the posting cycle.
  18. Print reports that correspond to country-specific accounting practices.
  19. Print legal subledger accounting reports .

3 Which are potentially implementation using global accounting Engine(AX)?

AX is mainly used to comply with the European legislations mainly.Any European Implementation which is operating in more countries will have options to use.

4 Is Global Accounting Engine mandatory for Italy, France, Greece or Portugal?

Oracle has suggested for 6 countries (France, Italy,Greece, Portugal, Spain, Austria)

  • AX has replaced localizations for France, Italy.
  • AX provides legal report formats for specified countries.

5 How Global Accounting Engine works:

Operationally, the Global Accounting Engine changes the way in which transactions are posted from the sub-ledger to the General Ledger. For transactions from AR, AP, the standard GL Interface is switched off and postings are done via the Accounting Engine translator. A sub-ledger accounting entry is created for each Event, which represents a change in state of a document, e.g. an Invoice. Accounting Rules are used to translate these events and to create entries in the AX tables. A report is run to create the sub-ledger balances in AX by Third Party and accounting period. After AX translation is run, the accounting entries are transferred to the General Ledger via the normal GL interface tables.

The big difference in using AX is that instead of posting transactions direct to the GL Interface table, they are transferred via the AX Engine where they are translated before being transferred to the General Ledger. This can be shown as:

gloabal accounting process

This ends of Global Accounting Engine(Product AX) discussion, will see some more information on dual posting and some important technical details in next post. Till than keep watching this space :)

Posted in Functional, Oracle General Ledger, Oracle Product | 7 Comments »

Page 1 of 11