General Ledger Accounting flexfield Assets Asset Key flexfield Location flexfield Category flexfield Service Service Item flexfield Receivables Territory flexfield Sales Tax Location flexfield Inventory Item Categories System Items Sales Orders Item Catalogs
So as to discover copy provider, SUPPLIER AUDIT REPORT is runned
Configure applications to help your very own bookkeeping, item and different codes. Enable the development of wise keys. Configure application to catch extra information. Use the application to approve esteems and esteem mixes entered by the client. Support different flexfield structures relying upon information setting.
Key flexfield Descriptive flexfield
A qualifier is a mark connected to a specific key flexfield section so it tends to be situated by the application requiring its data. It can be of two types: Flexfield qualifiers recognize a fragment in a flexfield. Segment qualifiers recognize an esteem set in a fragment.
Common Account Each Accounting Flexfield structure must contain just a single characteristic record portion. When setting up the qualities, you will demonstrate the sort of record as Asset, Liability, Owner’s Equity, Revenue, or Expense. Adjusting Account Each Structure must contain just a single adjusting section. Oracle GL guarantees that all diaries balance for each adjusting fragment. Cost Center This fragment is required for Oracle Assets. The Cost focus fragment is utilized in numerous Oracle Assets reports and by Oracle Workflow to produce account numbers. Furthermore, Oracle applications preparing Bangalore Projects and Oracle Purchasing likewise use the cost focus section. Intercompany GL naturally utilizes the intercompany portion in the record code mix to follow intercompany exchanges inside a solitary arrangement of books. This portion has a similar esteem set and indistinguishable qualities from the adjusting fragment. Fragment Qualifiers Record TYPE: Asset, Liability, Owner’s Equity, Revenue, Expense, Budgetary Dr, and Budgetary Cr. Spending passage allowed (Yes/No) Posting allowed (Yes/No) Control Account Reconciliation Flag Available for explicit nations
Dynamic Insertion is a component which controls whether the client can enter new record code blends from any shape/window. On the off chance that this element is incapacitated, the client can’t include new record code blends from any window/frame. Oracle applications utilize a specific frame (called a Combination shape) for straightforwardly entering the new code blends. Clients can enter new record code mixes just through this frame if Dynamic Insertion is crippled.
For key flexfields with various portions, we can characterize standards to cross check esteem blends entered with in the key flexfield fragments. This choice is alluded as Cross Validation rules. Esteem Set List Types Rundown of values (10 to 200) Extensive rundown of values (> 200) Poplist (> 10) Esteem Set Security Type No Security: All security is handicapped for this esteem set. Hierarchical Security: With Hierarchical security, the highlights of the esteem security and esteem chains of importance are consolidated. With this element any security that applies to a parent esteem additionally applies to its tyke esteems. Non-Hierarchical Security: Security is empowered, however the guidelines of the various leveled security don’t make a difference. That is, a security decide that applies to a parent esteem does not “course down” to its youngster esteems.
Special: This specific esteem set gives another flexfield as an esteem set for a solitary fragment. Dependent: A needy esteem set is related with an autonomous esteem set. Subordinate esteem sets guarantee that all needy esteem are related with an incentive in the related free esteem set. None: An esteem set of the sort None has no rundown of endorsed esteems related with it. A None esteem set performs just insignificant checking of, for instance, information type and length. Independent: Independent sort esteem sets perform fundamental checking yet in addition check an esteem entered against the rundown of affirmed esteems you characterize. Table: Table esteem sets acquire their arrangements of affirmed esteems from existing applications tables. When characterizing your table esteem set, you determine a SQL inquiry to recover all the affirmed esteems from the table. Pair: This particular esteem set gives a range flexfield as an esteem set for a couple of portions. Translated Independent: This works like Independent sort. Nonetheless, a Translated Independent esteem set can contain show esteems that are converted into various dialects. Translated Dependent: This works like Dependent sort. In any case, a Translated Dependent esteem set can contain show esteems that are converted into various dialects.
Oracle GL Key flexfield can have 15 sections each speaking to a portion. Be that as it may, the fragments type can be: Cost Center portion Balancing portion Account portion Intercompany portion
It’s a component of Key flexfield, pertinent on Value Sets.
It’s a component of Key flexfield, material on Value Sets. Shorthand nom de plume. An Alias is a mark for a specific blend of key flexfield fragment esteem. This enables clients to enter information quicker and all the more effectively in light of the fact that the client needs to simply enter the shorthand moniker, and the flexfield consequently populates the qualities for the fragment.
A Period relates to a period range inside which exchanges are entered preceding finishing, generally called as close of the period.
Predefined period types in Oracle GL are: Month Quarter Year If necessary, period kinds of our own can be characterized notwithstanding the standard time frames. Distinctive statuses of a bookkeeping period. Never Opened – Cannot enter or post diaries. Future Enterable – Enter diary, however can’t post. The quantity of future enterable periods is a settled number characterized in the arrangement of books window. The quantity of future enterable period can be changed whenever. Open – Enter and port diaries to any open period. A boundless number of periods can be open, yet doing as such may moderate the posting procedure and can confound clients entering diaries. Closed – Cannot post diaries in a shut period. Must revive shut periods previously posting diaries. Should physically close periods subsequent to completing month/quarter/year-end preparing. Permanently Closed – Permanently shut periods can’t be revived. This status is required to Archive and Purge information.
Ordinarily, the most recent day of the financial year is utilized to perform modifying and shutting diaries passages. This period is alluded to as Adjusting Period. Picking whether to incorporate an altering period or not in a timetable is an essential choice. There can be boundless number of altering periods. When the bookkeeping logbook is utilized, changes to its structure to evacuate or include a modifying period is impossible.
There are 5 essential kinds of change rate types predefined in Oracle GL: Detect: A swapping scale dependent on the rate for a particular date. It applies to the prompt conveyance of a money. Corporate: A swapping scale that institutionalize rates for your organization. This rate is commonly a standard market rate controlled by senior money related administration for use all through the association. Client: A conversion scale that you enter amid outside cash diary section. Emu Fixed: A conversion scale that is utilized by nations joining the EU amid the progress time frame to the Euro cash. Client Defined: A rate type characterized by your organization to address explicit issues.
Spot (Not certain).
Diagram of Accounts Your diagram of records is the record structure you characterize to fit the particular needs of your association. You can pick the quantity of record fragments just as the length, name, and request of each seg15 ment. Bookkeeping Calendar A bookkeeping date-book characterizes a bookkeeping year and the periods it contains. You can characterize various timetables and relegate an alternate schedule to each arrangement of books. Monetary standards You select the useful cash for your arrangement of books just as different monetary standards that you use to execute business and report in. GL changes over money related sums entered in an outside cash to utilitarian cash reciprocals utilizing provided rates.
The esteem referenced in the Future Period field speaks to the quantity of future enterable periods that clients can use to include diary sections (gave those future periods are opened). Notwithstanding, thought must be given to limit the quantity of future enterable periods to keep clients from unintentionally entering diary passages in an erroneous period.
There are 5 selected areas in the arrangement of books definition shape. Closing Journaling Average Balances Budgetary Control Multiple Reporting Currencies
GL posts the net equalization of all pay and costs accounts from the earlier year to this record when you open the main time of a financial year.
On the off chance that you interpret your useful money adjusts into another cash for revealing, or in the event that you revalue outside cash overwhelmed balances, you should indicate an interpretation modification account. Parent Do no empower Budget Yes Posting Yes Record Type Ownership/Stock
GL utilizes this record to catch the net movement of all income and cost accounts while figuring the normal equalization for held profit.
Exchange logbook is characterized to enable normal equalization preparing. Exchange logbook is made alternatively with legitimate business days referenced. So as to permit unbalances diary posting what activity is required at set of book definition level/23. what is a tension record and its motivation? On the off chance that you permit posting of out-of-balance/uneven diary sections, GL naturally presents the distinction on Suspense Account. In any case, the Suspense Account check box ought to be checked and an Account # to be accommodated this component to work amid the formation of set of books. On the off chance that you have different organizations or adjusting elements inside a lot of books, GL consequently makes an anticipation represent each adjusting substance.
An esteem set characterizes the limits for the ascribes that you dole out to a key or illustrative flexfield fragment. Esteem sets control what sorts of qualities can be utilized as Accounting Flexfield section esteems. Esteem sets decide the properties of your sections, for example, length, zero-fill, and right legitimize, alphanumeric, and esteem security. Esteem sets additionally control how approval is performed. Inorder to permit intercompany diaries what activity is required at set of book definition level? One of the bookkeeping key flexfield sections ought to be of the sort Intercompany. This portion would have a similar esteem set and indistinguishable qualities from the adjusting section. Additionally, empower Balance Intercompany Journals highlight. This enables clients to post out-of-balance intercompany diary passages and consequently balance those diary sections against a predetermined intercompany account
Record pecking order director is a component given by Oracle Application which permits to: Graphically make, keep up, and audit account structure orders. Define new parent and kid fragment esteems, just as change parent/kid conditions. Create new move up gatherings from the record chain of importance director and have your progressions reflected naturally in both key portion esteems and rollup bunches window. Likewise gives an alternative to control elements, for example, Read-as it were Read/compose security Segment Value Security: An oracle applications include that gives you a chance to bar a portion esteem or scopes of fragment esteems for a particular client duty. Fragment Value Security is reached out to the Account Hierarchy Manager. Chart of Accounts Security
Not Sure. May be ACTUAL.
As a matter of course, there are 3 catches on the manual diary passage shape: More Details Change Currency More Actions
When we tap on the “More Actions” catch, another window shows up with 4 catches: Reverse Journal Post Change Period CANCEL
Unposted Posting statuses Unposted Pending Processing Selected for posting Posted Error
GL_JE_BATCHES GL_JE_HEADERS GL_JE_LINES
Reverse the Journal.
You can connect factual sums with financial sums by utilizing factual units of measure. This empowers you to enter both fiscal and measurable sums in a solitary diary section line.
A solitary diary passage recipe that apportions incomes and costs over a gathering of cost focuses, offices, or divisions.
A*B/C. An is the Cost Pool that will be distributed. It tends to be sum or record balance. B is the numerator of the factor (a number or measurable record) that duplicates the cost pool for the designation. C is the denominator of the factor (a number or measurable record) that isolates the cost pool for the distribution. Note: Parent esteems can be utilized in at least one portions.
Circling Summing Consistent
Characterize new monetary forms Empower seeded monetary forms Characterize rate types Enter day by day rates
Day by day rates Authentic rates Revaluation rate is the reverse of period end rate.
Period-End Period-Average Notable GL Account Type Period-End Period-Average Notable
Cumulative Translation Adjustment (CTA) record ought to be determined in the SOB widows to guarantee that your books stay in parity.
To utilize MRC, the essential and the detailing SOBs should all have a similar logbook and diagram of record structures.
When diaries are posted in the essential SOBs.
Fiscal report Generator (FSG): Use FSG to solidify money related data for organizations utilizing a solitary SOBs or organizations utilizing diverse SOBs that share a similar schedule and diagram of records. Worldwide Consolidation System (GSC): Use GCS to unite monetary data for various SOBs, assorted budgetary frameworks, and geographic areas, including both Oracle and non-Oracle applications.
If we utilize Global Consolidation System, there is no such prerequisite. Be that as it may, it might be that the Period to be same.
A workbench to see the combination status of your auxiliaries. Complex combination mapping standards to delineate and indicate exchange rules from the auxiliary to the parent. A shading coded combination screen that guides you through the union advances. A solidification order watcher to graphically show your combination structure. The Interface Data Transfer makes bringing in information from outside feeder framework less demanding. Programmed age of taking out sections. Staggered drilldown capacities to auxiliary adjusts and sub-records. Incredible report distributing capacities utilizing FSG and ADI. Incorporated multi-dimensional examination utilizing Oracle Financial Analyzer. Can be utilized if the organization chooses to change the Accounting Calendar. Taxi be utilized if the organization chooses to change the Chart of Accounts.
The IDT is an easy to use instrument that makes bringing in of information from outer feeder frameworks into Oracle GL or Oracle GCS a lot less demanding and less tedious. Advantages of IDT are: Programmed information transformation that changes over dissimilar information positions into an Oracle organize. Reapplication of similar standards each time you exchange. Programmed information approval on imported information give more noteworthy adaptability. Conditions enable you to control when Transformation tenets to be applies.
Combination workbench The combination workbench gives an essential issue of control for solidifying a boundless number of backups to your parent. This window gives criticism on the condition of the union procedure, keeping you educated about every backup’s solidification status. The workbench additionally screens backup account adjusts for any progressions that happen after the auxiliary information has been exchanged to your parent SOBs. Solidification Sets: You can even make combination sets which dispatch various unions in a solitary advance for by and large streamlining of the union procedure. Solidification Hierarchies: You can make combination orders, or staggered chains of importance, and view your unions orders utilizing a graphical Consolidation Hierarchy Viewer. State Controller: From the union workbench, you can get to the State Controller, which is a shading coded route instrument to direct through the solidification procedure.
A union mapping is a lot of guidelines for mapping records or whole record portions from an auxiliary SOBs to the parent SOBs. We can characterize section rules, account rules or a mix of both. Record rules supersede section rules.
Mapping sets are made to exchange information for numerous auxiliaries at the same time. After the mapping set is made the outcome can be seen in the Consolidation Hierarchy Viewer.
By default, there are 3 catches on the manual diary passage shape: More Details Change Currency More Actions
Unposted Pending Preparing Chosen for posting Posted Mistake
When we tap on the “More Actions” catch, another window shows up with 4 catches: Turn around Journal Post Change Period Drop
Oracle Financial Applications are a subset of the Oracle E-Business Suite. It’s also the products family developed to analyze and capture your financial information across the globe.
The Oracle E-Business Suite is an entire business application set that allows organizations to track the complete business transaction data efficiently. With the help of a system built on unique information architecture, it turns into decision making information.
The Oracle Apps Financial has been used to manage the business towards the target that is announced to investors in a better way.
Financial Control, Cost Containment, Compliance, Regulatory Reporting, and Risk Management.
Think universally to make the correct decisions Work universally to act competitively. Manage universally to increase performance and lower cost.
Reduced Number of Instances Database Integration Common Data Model Integrated Applications
Yes, there are subfamilies and they are arranged by standard business flow to support the financial process of your firm. Some of them include Corporate Performance Management, Credit-to-cash, Asset, Lease Management, and Real Estate, Travel & Expense Management, Reporting & Financial Control, Corporate Governance, Procure-to-pay, and Treasury & Cash Management.
GRLE (Government Reporting Legal Entity) Ledgers Inventory Organization Business Group and Departments Legal Entity Operating Unit Human Resources Organization.
It’s one of the basic concepts of Oracle Financial Applications. Ledger indicates a representation of accounts for a corporation that is accountable in a self-contained way. The ledger owner can be a legal entity, a substantial operation within a legal entity but incorporated with the attributed of a legal entity, a group of organizations in a common legal environment, or a foreign branch.
Oracle Apps Financial offers a collection of reporting ability as presented in sections like Shared reports, Filling with the Authorities, Reconciliation, and control, Cross-reference and Drill-down, Product-specific reports and generating reports.
XML Publisher, Desktop Integrators, and RXI Report Administration Tools.
Oracle XML Publisher is one of the important reporting tools of Release 12. It enables the user to make formatting templated in Microsoft Word, Microsoft Excel, and other desktop products so that non-information technology and non-technical people can do it. Apart from this, it also helps to pair the templates automatically with the extracts to make use of the ideal report.
Oracle XML Publisher is used to save reports to many various file types which include PDF, Excel, XML, RTF, etc. Its also used to publish the report by sending in an email, printing, or posting to portals or websites.
Natural Account, Balancing Segment, and Cost Center.
Oracle Subledger is an accounting service that is in accordance with rules of accounting which you produce in line with the requirements of your compliances. It also offers a standard means of posting a sub-ledger to a general ledger. It’s a flexible and open service that defines and generates transaction accounts captured by the transaction processing system present in the Oracle E-Business Suite.
Flexible Journal Entry Setup, Multiple Accounting Representations using two important methods namely Same Ledger, and Primary & Secondary Ledger, Common Subledger Operations, and Inquires reporting and, drill-down.
Automated Processing, Sub-consolidations, Simulations, Drill-downs and Audit entries for every consolidation stage, and partial ownership.
Holistic, good, compliance, and governance require that the management have better visibility of the enterprise, operate efficiently and also have effective internal controls.
Process/Risk Management, Training Management, Content and Records Management, Security and Identity Management, Performance Management and Reporting, E-Business Suite.
CAD Viewing, UCCnet Trading Connector, Product Lifecycle Management, Product Information Management Hub, and Product Intelligence.
Asset Intensive: Improved fleet asset management, Enhanced forecasting and budget, Support for 21 CFR Part 11, and Common asset repository. Public Services: Improved Shared services, Configured and centralized accounting and budgetary control. Manufacturing: Title 21 Code of Federal Regulations Part 11 (21 CFR Part 11) and Regulatory compliance for clinical trials. Service: Oracle Financial Services Accounting Hub, and Oracle Retek Merchandising & Oracle Financial System.
Flex Field helps in capturing your corporation’s entire information.
DFF: It’s used for capturing extra information and this is stored in the attribute column. KFF: It’s a unique identifier and this is stored in a segment column.
GL Accounting FF, AR Sales Tax Location FF, Module KFF, AP No KFF, and Territory FlexField.
Cost center, product, company, account, and future use.
Square Bracket [ ].
AFF contains a minimum of two and a maximum of thirty segments.
Flex field Qualifiers are used for recognizing the segments in a clear way.
Cost center segment qualifier, Intercompany segment qualifier, balancing segment qualifier, and Natural account segment qualifier.
A profile is one of the options that can be changed; this affects the way of how your applications run. Two types of the profile include User-defined and System defined profiles.