Rapid Implementation Error : You cannot assign the legal entity XX Company because it was already assigned to an existing accounting configuration.

Isuue : Upload Enterprise Structure > Create Financials Common Entities

You cannot assign the legal entity XXX Equipment Finance Trust 2014-1 because it was already assigned to an existing accounting configuration.

You cannot assign the legal entity XXX Corporation United States because it was already assigned to an existing accounting configuration

Solution:
Verify the  BU Name , LE Name , Legal Entity Identifier and Registration Number   it must be unique always as you configure in manually



================================================================================
Fusion Financials Rapid Implementation for General Ledger
================================================================================
Processing started .. validating ..
Process File Id=727003
ESS Request Id=1416791
Zip file: /tmp/RapidImpl/1416791/RapidZipFile1681060598899828245.zip
--------------------------------------------------------------------------------
Upload Enterprise Structure > Create Financials Common Entities
--------------------------------------------------------------------------------
Processing Accounting Calendar
--------------------------------------------------------------------------------
Calendar imported successfully.
First period=Jan-17
--------------------------------------------------------------------------------
Processing Legal Entities
--------------------------------------------------------------------------------
Legal locations imported successfully.
Legal entities imported successfully.
--------------------------------------------------------------------------------
Processing Ledger
--------------------------------------------------------------------------------
Ledger import failed. Program will now exit. Review the exception details. oracle.as.scheduler.ExecutionErrorException: Ledger import failed. Error Details:

JBO-27023: Failed to validate all rows in a transaction.
LedgerConfiguration: JBO-25026: Row oracle.jbo.Key[300000174369961 ] with XML tag LedgerConfigurationVORow cannot be loaded.JBO-25027: Attribute LedgerConfigurationDetail at index 27 with XML tag LedgerConfigurationDetail cannot be loaded.JBO-25025: Rowset with XML tag LedgerConfigurationDetail cannot be loaded.JBO-25026: Row oracle.jbo.Key[300000174369961 LEGAL_ENTITY 300000172810338 NONE ] with XML tag LedgerConfigurationDetailVORow cannot be loaded.JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity Dell Equipment Finance Trust 2014-1 because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-25026: Row oracle.jbo.Key[300000174369961 LEGAL_ENTITY 300000172810339 NONE ] with XML tag LedgerConfigurationDetailVORow cannot be loaded.JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity EMC South Street Investments LLC United States because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-25026: Row oracle.jbo.Key[300000174369961 LEGAL_ENTITY 300000172810340 NONE ] with XML tag LedgerConfigurationDetailVORow cannot be loaded.JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity EMC Corporation United States because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-25026: Row oracle.jbo.Key[300000174369961 LEGAL_ENTITY 300000172810341 NONE ] with XML tag LedgerConfigurationDetailVORow cannot be loaded.JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity EMC IT Solutions India Private Limited India  because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-25026: Row oracle.jbo.Key[300000174369961 LEGAL_ENTITY 300000172810342 NONE ] with XML tag LedgerConfigurationDetailVORow cannot be loaded.JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity EMC Software and Services India Private Limited India because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-25026: Row oracle.jbo.Key[300000174369961 LEGAL_ENTITY 300000172810343 NONE ] with XML tag LedgerConfigurationDetailVORow cannot be loaded.JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity Dell DFS Corporation because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000174369961 ] in LedgerConfigurationEOJBO-27024: Failed to validate a row with key oracle.jbo.Key[300000174369961 ] in LedgerConfigurationEOJBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity Dell Equipment Finance Trust 2014-1 because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity EMC South Street Investments LLC United States because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity EMC Corporation United States because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity EMC IT Solutions India Private Limited India  because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity EMC Software and Services India Private Limited India because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity Dell DFS Corporation because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>
LedgerConfiguration: JBO-25026: Row oracle.jbo.Key[300000174369962 ] with XML tag LedgerConfigurationVORow cannot be loaded.JBO-25027: Attribute LedgerConfigurationDetail at index 27 with XML tag LedgerConfigurationDetail cannot be loaded.JBO-25025: Rowset with XML tag LedgerConfigurationDetail cannot be loaded.JBO-25026: Row oracle.jbo.Key[300000174369962 LEGAL_ENTITY 300000172810344 NONE ] with XML tag LedgerConfigurationDetailVORow cannot be loaded.JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity Dell Canada Inc. because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000174369962 ] in LedgerConfigurationEOJBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity Dell Canada Inc. because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>

Exception Message: Ledger import failed. Error Details:

JBO-27023: Failed to validate all rows in a transaction.
LedgerConfiguration: JBO-25026: Row oracle.jbo.Key[300000174369961 ] with XML tag LedgerConfigurationVORow cannot be loaded.JBO-25027: Attribute LedgerConfigurationDetail at index 27 with XML tag LedgerConfigurationDetail cannot be loaded.JBO-25025: Rowset with XML tag LedgerConfigurationDetail cannot be loaded.JBO-25026: Row oracle.jbo.Key[300000174369961 LEGAL_ENTITY 300000172810338 NONE ] with XML tag LedgerConfigurationDetailVORow cannot be loaded.JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity Dell Equipment Finance Trust 2014-1 because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-25026: Row oracle.jbo.Key[300000174369961 LEGAL_ENTITY 300000172810339 NONE ] with XML tag LedgerConfigurationDetailVORow cannot be loaded.JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity EMC South Street Investments LLC United States because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-25026: Row oracle.jbo.Key[300000174369961 LEGAL_ENTITY 300000172810340 NONE ] with XML tag LedgerConfigurationDetailVORow cannot be loaded.JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity EMC Corporation United States because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-25026: Row oracle.jbo.Key[300000174369961 LEGAL_ENTITY 300000172810341 NONE ] with XML tag LedgerConfigurationDetailVORow cannot be loaded.JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity EMC IT Solutions India Private Limited India  because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-25026: Row oracle.jbo.Key[300000174369961 LEGAL_ENTITY 300000172810342 NONE ] with XML tag LedgerConfigurationDetailVORow cannot be loaded.JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity EMC Software and Services India Private Limited India because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-25026: Row oracle.jbo.Key[300000174369961 LEGAL_ENTITY 300000172810343 NONE ] with XML tag LedgerConfigurationDetailVORow cannot be loaded.JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity Dell DFS Corporation because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000174369961 ] in LedgerConfigurationEOJBO-27024: Failed to validate a row with key oracle.jbo.Key[300000174369961 ] in LedgerConfigurationEOJBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity Dell Equipment Finance Trust 2014-1 because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity EMC South Street Investments LLC United States because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity EMC Corporation United States because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity EMC IT Solutions India Private Limited India  because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity EMC Software and Services India Private Limited India because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity Dell DFS Corporation because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>
LedgerConfiguration: JBO-25026: Row oracle.jbo.Key[300000174369962 ] with XML tag LedgerConfigurationVORow cannot be loaded.JBO-25027: Attribute LedgerConfigurationDetail at index 27 with XML tag LedgerConfigurationDetail cannot be loaded.JBO-25025: Rowset with XML tag LedgerConfigurationDetail cannot be loaded.JBO-25026: Row oracle.jbo.Key[300000174369962 LEGAL_ENTITY 300000172810344 NONE ] with XML tag LedgerConfigurationDetailVORow cannot be loaded.JBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity Dell Canada Inc. because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000174369962 ] in LedgerConfigurationEOJBO-${adfBundle['oracle.apps.fnd.applcore.messages.FndMessagesResourceBundle']['GL:::GL_ASM_CANT_ASSIGN_LE']}: <MESSAGE><NUMBER>GL-781317</NUMBER><TEXT>You cannot assign the legal entity Dell Canada Inc. because it was already assigned to an existing accounting configuration.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>

--------------------------------------------------------------------------------
Status: Process completed in error.
Action: Please resolve reported error manually and proceed to re-submit.
Zip file: /tmp/RapidImpl/1416791.zip
Note: If the above reported errors could not be resolved manually, please contact support providing the zip file and ESS request logs.
======================================================================================

Updating the interface table - start time : 23-10-2018 13:10:55

 Updating the interface table - end time: 23-10-2018 13:10:55

Creating new account combinations - start time: 23-10-2018 13:10:56

Creating new account combinations - end time: 23-10-2018 13:10:58

Updating the interface table - start time : 23-10-2018 13:11:20

 Updating the interface table - end time: 23-10-2018 13:11:20

Creating new account combinations - start time: 23-10-2018 13:11:22

Creating new account combinations - end time: 23-10-2018 13:11:22

Oracle Fusion Applications: Rapid Implementation

Go through : https://learn.oracle.com/pls/web_prod-plq-dad/learn?p=MO:39618:40002:40005:0

Rapid implementation spreadsheet template is used to implement Oracle Fusion Enterprise structures set up for the following objects:

· Chart of Accounts which includes set values, value sets and structures

· Account hierarchies (trees and tree versions)

· Accounting calendars

· Legal entities and Jurisdictions

· Primary Ledgers

· Business Units

The aforementioned items are Functional Set up manager tasks which need to be performed to rapidly implement Oracle Fusion GL. Set up Chart of Accounts, Ledger, Legal Entities and BU’s in a Spreadsheet can be downloaded for the rapid implementation Excel spreadsheet template.

Uploading of COA — Create an enterprise structure process from the scheduled process using Upload Data file as a parameter.

Deployment of COA — To perform this activity, open the manage chart of accounts instance page. There is an option to select an accounting flex field and press deploy button to deploy the accounting flex field.

Uploading of the Ledger — We can create an enterprise structure process from a scheduled page with the upload data file as parameter.

Below are some of the best practices and recommendations:

Chart of Accounts needs to be designed carefully, need to include the number and sequence of segments. It is advisable to identify the aspects of business that you want to track and analyze. i.e., Entity, Division, Cost Center etc.

Fast and Robust Account Inquiry

Foresee future growth and changes needed in reporting requirements. Based on that, ensure to define future segments. Always have default values for future segments for better data entry. Set up account hierarchies to reflect managerial, legal and geographical relationships between the value set values. Financial balances are pre-aggregated at each parent level. It would allow fast and robust account inquiry.

Preparing and Loading Rapid implementation templates

Collect Data:

First, collect the required data for implementation.

1. Finalize chart of accounts segments

2. Compilation of segment values

3. Identification of LE’s and BU’s

4. Determining Retained earnings account

How to prepare Data Sheet Templates

Complete the data sheets for each enterprise structure. There would be character and word limitations so consider to apply Hyperion Essbase and to other Oracle GL configurations. Follow the steps below:

1. Finish Chart of Accounts, Calendar, Currency and Ledger

2. Finish BU data entry

3. Finish Companies and LE’s

4. Finish Natural Accounts sheet

5. Finish Financial sequences

6. Validate the workbook data

How to Load Templates

· Once you click on Step 2, it generates an XML data file called ChartOfAccounts.xml

· Save this file in our local folder

· Now click on Step 3, it generates an XML data file called FinancialsCommonEntities.xml

· We can save the file in our local folder

· Go to setup and maintenance page in FSM, search and select the Upload Chart of Accounts task

· Upload file — select ChartOfAccounts.xml file

· Click on the Submit button, you will be directed to Scheduled Process Page

· Check for any errors or warnings to ensure the process is completed without any interruptions

· Click on Done button

· Select deploy chart of accounts from the set up and maintenance form

Oracle Fusion R13: Chart of Accounts Structure Instance Error

Oracle Fusion R13: Chart of Accounts Structure Instance Error: Flexfield metadata warnings were found. Validating flexfield GL# of Application 101 ... 1. WARNING: No active tree version found for hierarchy with tree code Account JLR and tree structure code GL_ACCT_FLEX which is used by flex segment Account belonging to structure instance JLR Validating Flexfield Metadata : No errors found.

Solution: Fix the Specific issue by correcting Chart of Account Structure Setup and Run again Deployment .

Note:  In Oracle Fusion Flex field Compilation there at Chart of Account Instance Level on Accounting flex field  i.e  While Deployment ,
Oracle Fusion will now allow you  to compile   Chart of Account  structure if one of the Chart of Account doesn't have valid setup.

Payables Invoice Validation Status

In Oracle payables, for paying supplier payment we have created the invoices into this modules.

Whenever the invoices is created, how to find out the status of the invoice whether it is validated never validated or approved.

1.       A user is created the invoice manually, the data will be inserted into  different tables

AP_INVOICES_ALL

AP_INVOICE_LINES_ALL

AP_INVOICE_DISTRIBUTIONS_ALL

AP_PAYMENT_SCHEDULES_ALL

To find out the status of the invoices, we need to check the match_status_flag column of ap_invoice_distributions_all table.

1.Match_status_flag = Null

Invoice is Never Validated status

2.Match_status_flag=’A’

 Invoice is Validated Status

3.Match_status_flag=’N’

Invoice is Need Revalidation status

           Api is also available to find the status of the invoices which is given below

             AP_INVOICES_UTILITY_PKG.Get_approval_status(  l_invoice_id IN NUMBER,                              l_invoice_amount           IN NUMBER,  l_payment_status_flag      IN VARCHAR2,                 l_invoice_type_lookup_code IN VARCHAR2)

         How you know who has validated the invoice and who has made the payment for that particular invoices.

We can identified the user who has validated the invoices using ap_invoice_distributions_all table

In ap_invoice_distributions_all table  if the match_status_flag=’A’ then pickup the value of last_updated_by column and find out name in per_people_f table using person_id.

  Select * from per_people_f where person_id=last_updated_by;

  If we using the fnd_user table then the command is

 Select * from fnd_user where employee_id = last_updated_by

For payments we need to check ap_payment_schedules_all tables.

In ap_payment_schedules_all table if the payment_status_flag=’Y’ then pickup the value of last_updated_by column.

  Select * from per_people_f where person_id=last_updated_by;

  If we using the fnd_user table then the command is

 Select * from fnd_user where employee_id = last_updated_by

Oracle Fusion Roles and Data Access

Oracle Fusion Roles and Data Access

Add Application Logo in Oracle Fusion Cloud R12 and R13

Add Application Logo in Oracle Fusion Cloud R13

Oracle Fusion Implementation User Roles

Oracle Fusion Financial Implementation User Roles

Roles	Role Code	Assinable	Auto Provisioned
Application Implementation Consultant	ORA_ASM_APPLICATION_IMPLEMENTATION_CONSULTANT_JOB	Yes	No
Employee	PER_EMPLOYEE_ABSTRACT	No	No
IT Security Manager	FND_IT_SECURITY_MANAGER_JOB	Yes	No

Oracle Apps GL Period to Date(PTD) and Year to Date(YTD) query

Oracle Apps GL Period to Date(PTD) and Year to Date(YTD) query

Below query will give YTD and PTD balances for specific Account posted in a specific Period.

SELECT   gb.LEDGER_ID,
         glcc.SEGMENT1,
         glcc.segment2,
         glcc.SEGMENT3,
         glcc.segment4,
         glcc.segment5,
         glcc.segment6
         FFV.DESCRIPTION,
         gb.PERIOD_NAME,
         NVL (gb.PERIOD_NET_DR, 0) - NVL (gb.PERIOD_NET_CR, 0) PTD,
         (NVL (gb.BEGIN_BALANCE_DR, 0) - NVL (gb.BEGIN_BALANCE_CR, 0))
         + (NVL (gb.PERIOD_NET_DR, 0) - NVL (gb.PERIOD_NET_CR, 0)) YTD
    FROM  gl_balances gb,
          gl_ledgers gl,
          gl_code_combinations_kfv glcc,
          APPS.FND_FLEX_VALUES_VL FFV,
          gl_ledgers gl
   WHERE  gb.code_combination_id = glcc.code_combination_id
      AND gb.LEDGER_ID = gl.ledger_id
      AND GLCC.SEGMENT3 = FFV.FLEX_VALUE
      AND gl.name = :ledger_name
      AND gb.period_name = :PERIOD_NAME
ORDER BY  gb.LEDGER_ID,
          glcc.SEGMENT1,
          glcc.segment2,
          glcc.SEGMENT3,
          glcc.segment4,
          glcc.segment5,
          glcc.segment6

EBS Financials vs ERP Cloud: Key Functional Differences”,

EBS Financials vs ERP Cloud: Key Functional Differences”, 

which focused on the functional differences between the two ERP suites. Today we bring you a quick transcript of the questions we took live from the audience.

What is your assessment of other modules such as Supply Chain, Procurement and Manufacturing?
Procurement is phenomenal. Supply Chain is pretty good, what I’ve seen in manufacturing seems very good, but I’d be hesitant to be in the first release – if you’re going to do that, you need to be sure you have the right business case. A year from now we will see a lot of customers adopting the Manufacturing piece.

What is the biggest benefit for customers adopting the Cloud?
The first one is functionality, there’s also the part of skipping the hardware investment and hardware maintenance resources, and there’s also the part of being in the cutting edge of technology, always receiving the latest functionality and enhancements. We speak to many customers who have not updated their Oracle since 2003, and think of how different your business was at that point – this is one of the best advantages of the Cloud.

Looking at the roadmap, what item should we most be looking forward to?
Look out for the Cloud equivalent of iReceivables – the functionality it will carry is by far the most exciting one.

Are Financials easier to implement in the Cloud or in EBS?
Oracle has gone out of its way to make implementation easier in the Cloud - think rapid implementation sheets. Last week we were at a customer kicking off a Cloud project, and we got 70% of the modules implemented in 2 days, just working through the spreadsheet uploaders. It’s very easy to go and do that, and in the latest release Oracle has even simplified what they had simplified before

.

The Financial Reports Center reports shown in the presentation are out of the box or customized?
Oracle provides about 180 standard financial reports – all subledger type reports. The Financial Reports Center reports need to be built as part of the project as every customer has its own Chart of Accounts structure. Typically you work with your implementation partner to build those, it is a custom piece of the implementation.

Is AP Invoice scanning included or an additional product? Is Advanced Collections a separate module?
Those are both separate modules. Advanced Collections is separately licensed, about $150 per month, with a 5 user minimum. AP Invoice imaging list price is $3,000 per 1,000 invoices. Very cheap versus the on premise investment.

Is iSupplier still in Cloud ERP or is it part of Payables?
There is, it’s called the Supplier Portal now, it’s easier to use and better looking. We will cover it soon when we do our webinar on Procurement.

Is the Excel option in a browser or workstation? Do we need a MS Office license?
Yes, you need a license for Microsoft Office. Bear in mind that SmartView does not run in Macs, you will need a virtualized Windows machine.

Does Oracle iExpense Cloud only work with American Express?
No, you can build the integration for other credit cards – Diners, Visa, whatever you need.

Is there a web API for AR invoices?
Yes, for AR and AP both.

What is lacking in the multi-period accounting functionality when comparing EBS and ERP Cloud?
Let’s say you have an expense that comes across for $1,200 and you want to recognize that in a 12-period (in the first $100, $1100 deferred) you can set that up automatically in EBS. This capability is not there yet in ERP Cloud. You can still do it with a workaround; it’s just not such a straight forward process.

How easy would it be to keep a hybrid model?
Well, you can have HCM or Sales on the Cloud, but splitting your ERP between Cloud and EBS modules adds a lot of complexity, so the ROI would not really make sense. It’s a hard sell when looking at the costs of implementing and supporting such a model.

What are the differences between the Purchasing and iProcurement modules?
The functionalities are very similar; we will cover them soon when we do our webinar on Procurement.

How do clients typically manage migrating customizations to the Cloud?
Because there are no customizations to the Cloud, you have to make decisions – the ultimate one being: “Is this customization important enough to us to be developed outside?” If you need to keep a customization you will need to use the Platform as a Service and create an external app that integrates it. What we’ve seen is that from 20 customizations, 16 are covered by standard functionality. There’s usually only one that customers need to really decide on, and then it’s a matter of ROI. In financials, what can you really be doing that is different at the end of the day? Pay, bill, revenue, reports... is it really driving the business value? It’s all about the analysis.

Is Mobile expenses app available in EBS from what version? 
It’s Oracle R12.1.3 and afterwards. You can start using them now, the fusion apps modules are free.

Can you tell me more about invoice imaging in Payables? 
If it’s a PDF someone sends you, you see about 90% accuracy; for a physically scanned invoice it’s somewhat around 80 to 85% accuracy. You set it up and you can configure how it is routed. Your user comes in, sees the invoice, clicks on it, it pops up and they validate. If it’s a PO, you can even run the matching program against it. Then it automatically attaches that to the invoice, so from a cost and ROI perspective, it’s the best ROI from all the financial modules.

How long would a full migration from EBS to ERP Cloud take? 
It really depends. For quick books we’re doing an 8 week project. Others range from 12 to 16 weeks. The timeline is so much shorter (especially if you do not have a lot of countries) because you are not dealing with customizations. The implementation itself takes barely 8 weeks, but the integration and data conversion add the extra weeks.

In your experience, are customers going for the full Cloud migration or coexistence model? 
Most customers go all the way in.

Can you tell me more about Fusion Revenue Management addressing IFRS revenue recognition? 
Fusion Revenue Management is a module that supports multiple element arrangements, VSOE, etc. Oracle has been tweaking it for the past two years, and it’s waiting for the rules to be finalized and make sure it works properly, but it allows your sales team to sell bundle products and apply the true revenue recognition behind there. They are targeting December 2017 but it has not been finalized yet.

Are you able to modify the logic for workflow approvals? 
Yes, there’s a UI to modify the existing workflows and create those you want. I have not seen that being an issue for any customers, but you can do that.

For the data migration, how the initial master data move is done? Does Oracle have integration points out of the box? 
Yes, there’s the Oracle Enterprise Repository, which lists all of the integrations, a combination of file uploads, web services, all of the pieces.

How successful are integrations with asset management systems? Does it have a similar cost accounting model for long term capital projects as in Oracle EBS? 
Yes, in PA there are a lot of similarities for handling capital projects and being able to capitalize from there.

How does Cloud support customizations like Personalization, 3rd party interfaces, etc.?
Personalization and branding are outstanding in the Cloud. Each user can personalize their user experience. For third party interfaces Oracle provides the Enterprise Repository with all of the various details for interfacing to and from the Cloud application.

Can we have Financials on Cloud an Manufacturing on-premise EBS?
You can leverage FAHRCS to provide this type of model by giving you Cloud reporting.

Are Request Sets available in ERP Cloud?
There is not direct request set functionality, but any user can schedule any batch process.

Oracle comes with various integration API out of the box. Can I develop my own API?
No, the data model cannot be changed, but if you have the need to have an API that is not available you can work with Oracle development. We worked with a customer who needed a Webservice for contract integration. Oracle got the Webservice into the next release for them.

Oracle History and ERP Versions their Release Dates

Oracle History and ERP Versions their Release Dates

Ellison co-founded Oracle Corporation in 1977 with Bob Miner and Ed Oates under the name Software Development Laboratories (SDL). In 1979 SDL changed its name to Relational Software, Inc. (RSI). In 1982, RSI renamed itself Oracle Systems Corporation to align itself more closely with its flagship product Oracle Database. At this stage Bob Miner served as the company's senior programmer. In 1995, Oracle Systems Corporation changed its name to Oracle Corporation. On March 12, 1986: Now  Oracle gone public with revenues of $33 billion USD.

ü  Oracle E-Business Suite started life as Oracle Financials in 1987. 

ü  August 1987: Oracle founds its Applications division, building business-management software closely integrated with its database software. Oracle Corporation acquires TCI for its project management software.

ü  October 1987: Oracle Applications Release 1

ü  Sometime in August 1988 they released their first ERP application called accounting system that has only general Ledger functionality enabled. This is one of the reason of having General ledger application_id is 101.

ü  November 1988: Release 3

ü  January 1989: Release 4

ü  May 1989: Release 5

ü  October 1989: Release 6

ü  May 1990: Release 7

ü  November 1990: Release 8

ü  June 1992: Release 9

ü  1995: Release 10

ü  Release 10 Sub versions are 10.7NCA, 10.7.16.1, 10.7

ü  April 1998: Release 11

ü  Release 11 sub versions are 11.0, 11.0.1, 11.0.2, 11.0.3, 11.0.28

ü  July 16, 1998: First combined production installation of Oracle Applications Release 10.7 NCA at Leeson Electric Corporation.

üMay 1999: Release 11.0.3

ü  11i Sub Versions are 11.5, 11.5.1, 11.5.2, 11.5.3, 11.5.4, 11.5.5, 11.5.6, 11.5.7, 11.5.8, 11.5.9, 11.5.10.0, 11.5.10.1, 11.5.10.2.

üMay 2000: Release 11.5.1

ü  Oct 2000: Release 11.5.2

ü  Jan 2001: Release 11.5.3

ü  Jun 2001: Release 11.5.4

ü  Sep 2001: Release 11.5.5

ü  Jan 2002: Release 11.5.6

ü  May 2002: Release 11.5.7

ü  Nov 2002: Release 11.5.8

ü  Jun 2003: Release 11.5.9

ü  Nov 2004: Release 11.5.10

ü  Feb 2006: Release 11.5.10.2

ü  R12 Sub Versions are 12.0.0, 12.0.1, 12.0.2, 12.0.3, 12.0.4, 12.0.5, 12.0.6, 12.0.7, 12.1, 12.1.1, 12.1.2, 12.1.3 and latest version is R12.2.4

ü  31 Jan 2007: Release R12.0.0

ü    26th Apr 2007: R12.0.1 Released

ü    18th Jul 2007: R12.0.2 Released

ü    16th Oct 2007: R12.0.3 Released

ü    15th Jan 2008: R12.0.4 Released

ü    7th Nov 2008: R12.0.6 Released

ü    4th May 2009: R12.1.1 Released

ü 17th Dec 2009: R12.1.2 Released 

ü    20th Aug 2010: R12.1.3 Released

ü    19th Sep 2013: R12.2 (R12.2.1) Released

ü    20th Sep 2013: R12.2.2 Released

ü    16th Dec 2013: R12.2.3 Released

ü    08th Aug 2014: R12.2.4 Released

ü    16th Oct 2015: R12.2.5 Released

ü    15th Sep 2016: R12.2.6 Released

ü    15th Sep 2017: R12.2.7 Released

ü    15th Sep 2018: R12.2.8 Released