My Portfolio

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 ...

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...

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          ...

Oracle Fusion Roles and Data Access

Add Application Logo in Oracle Fusion Cloud R13

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 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) -...

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 ...

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. ü ...