Invoice Event
Invoice Adjustment Event
Invoice Cancellation Event
Prepayment Application Event.
Prepayment Unapplication Event.
The Accounting events for the payment document class are
Payment Event.
Payment Matruity Event.
Payment Adjustment Event.
Payment Cancellation Event.
Payment Clearing/Unclearing Event.
Invoice Event.
AP_ACCOUNTING_EVENTS_ALL
Accounting_Event_id Event Type Code Acounting Date Event Status Code Source Table
49999 INVOICE XXXXXXXX ACCOUNTED AP_INVOICES
AP_AE_HEADERS_ALL
AE_Header_id Accounting_event_id Accounting_Date Ae_Category
54544 49999 xxxxxxxxx PurchaseInvoice
AP_AE_LINES_ALL
Ae_line_id Ae_header_id Ae_Line_number Ae_line_type_code entered_dr entered_cr source_table
89898 54544 1 Charge 100 ap_inv_distribution
89899 54544 2 Liability 100 ap_invoices
Invoice Adjustment Event
In AP_ACCOUNTING_EVENTS_ALL
Event_Type Code is “Invoice Adjustment” and Source_Table is “AP_INVOICES”
Invoice Cancellation Event
In AP_ACCOUNTING_EVENTS_ALL
Event_Type_Code is “Invoice Cancellation” and Source_Table is “AP_INVOICES”
Prepayment Application/Unapplication Event
In AP_ACCOUNTS_EVENTS_ALL Event_Type_Code is “PREPAYMENT APPLICATION” for prepayment Unapplicaiton EventType_Code “PREPAYMENT UNAPPLICAITON”. Source_Table is “AP_INVOICES”.
Payment /Payment Cancellation Event
In AP_ACCOUNTING_EVENTS_ALL event_type_code “PAYMENT” for Payment and .For Payment Cancellation event type code “PAYMENT CANCELLATION” . Source_Table is “AP_CHECKS”.
PAYMENT MATURITY and PAYMENT CLEARING
In AP_ACCOUNTING_EVENTS_ALL event_type_code for Payment Maturity is “PAYMENT MATURITY” and for Payment Clearing is “PAYMENT CLEARING”.
Source_Table is “AP_CHECKS”.
Oracle Payable Accounting Events
Tax Reporting Entities
In the United States we must report to the Internal Revenue Service certain type of payments we make to 1099 reportable suppliers. During the supplier setup We can make supplier as federally reportable. When we enter invoices for that supplier, we classify invoice distributions by 1099 misc type using the Income Tax type field. At the year end, we can then report, in standard formats of accumulated 1099 payment information to the Internal Revenue Service, other tax agencies and to our suppliers.
For each reporting entity, we assign one or more balancing segment values, when we submit 1099 reports for a tax entity, Payable sums up the paid invoice distributions that have these balancing segment values in their accounts (Eg- Company, Fund balancing segments)to create and report on 1099 supplier payments.
If we want to use combined federal and state 1099 filing, and want to produce K-Records and B-Records, we have to enable the combined filing program in payables option.
If we use combined federal and state filing, then we have define tax regions.
Define tax reporting entities.
Resolve 1099 exceptions if any:
Submit for each reporting entity the 1099 Invoice exception report to identify the following exceptions :
A )1099 Invoice distribution with no income tax type.
B) 1099 Invoice distributions with invalid or missing income tax region.
Submit the 1099 supplier exception report to identify and resolve the exceptions:
A) Suppliers with Null or Invalid State abbreviations.
B) Suppliers that will be flagged as foreign in the 1099.
Resolve any exceptions in the Suppliers window.
A)Optionally withhold tax from suppliers if they have a missing or invalid Tax Identification Number (TIN) and if you have not met the legal requirements of requesting a valid TIN from them.
Generate 1099 Reports.
A)1099 Forms. Submit to the Internal Revenue Service for each 1099 supplier, and send a copy to the supplier.
B)1096 Form. Submit to the Internal Revenue Service for each 1099 MISC type paid during the calendar year.
C)1099 Electronic Media. If you submit 250 or more 1099 forms, the Internal Revenue Service requires you to file your 1099 payment information on magnetic media or electronically .
D)Form 941. Send this form to the Internal Revenue Service to report total supplier withholding for a quarter. Your Accounts Payable department should create a manual payment for the total amount withheld, and you should remit this amount and the 1096 Form to the Internal Revenue Service.
E)1099 Payments Report. Run this report for your reference to review 1099 payments by supplier or MISC type
For each reporting entity, we assign one or more balancing segment values, when we submit 1099 reports for a tax entity, Payable sums up the paid invoice distributions that have these balancing segment values in their accounts (Eg- Company, Fund balancing segments)to create and report on 1099 supplier payments.
If we want to use combined federal and state 1099 filing, and want to produce K-Records and B-Records, we have to enable the combined filing program in payables option.
If we use combined federal and state filing, then we have define tax regions.
Define tax reporting entities.
Resolve 1099 exceptions if any:
Submit for each reporting entity the 1099 Invoice exception report to identify the following exceptions :
A )1099 Invoice distribution with no income tax type.
B) 1099 Invoice distributions with invalid or missing income tax region.
Submit the 1099 supplier exception report to identify and resolve the exceptions:
A) Suppliers with Null or Invalid State abbreviations.
B) Suppliers that will be flagged as foreign in the 1099.
Resolve any exceptions in the Suppliers window.
A)Optionally withhold tax from suppliers if they have a missing or invalid Tax Identification Number (TIN) and if you have not met the legal requirements of requesting a valid TIN from them.
Generate 1099 Reports.
A)1099 Forms. Submit to the Internal Revenue Service for each 1099 supplier, and send a copy to the supplier.
B)1096 Form. Submit to the Internal Revenue Service for each 1099 MISC type paid during the calendar year.
C)1099 Electronic Media. If you submit 250 or more 1099 forms, the Internal Revenue Service requires you to file your 1099 payment information on magnetic media or electronically .
D)Form 941. Send this form to the Internal Revenue Service to report total supplier withholding for a quarter. Your Accounts Payable department should create a manual payment for the total amount withheld, and you should remit this amount and the 1096 Form to the Internal Revenue Service.
E)1099 Payments Report. Run this report for your reference to review 1099 payments by supplier or MISC type
Oracle R12 Business Essentials FAQs PART-2
Q) ZZZ Corp has acquired MMM Corp. ZZZ Operates with multi or access control. Consequently ZZZ Corp needs to add additional operating units. Identify the statement that describes the sequence for adding additional operating units.
Ans) Create Operating Unit, run the Replicate Seed Data Concurrent Request , assign the Operating Unit to a security hierarchy, run Security List Maintenance concurrent program, create a new responsibilities as necessary, and set up the MO : Security Profile Option.
Q) A new Receivables Inquiry responsibility is created for the Denmark Operating Unit and is assigned to the end users. You receive a call from the end user, who states that the Sweden receivables data is displayed on the Denmark Receivables Inquiry Screen. What is the cause of the wrong data being displayed?
Ans) Incorrect Operating Unit Profile Option set for the responsibility.
Q) Application Security Consists of User, Responsibility and Self Service Application Security. Select three authorizations to which a responsibility allows access?
Ans) Ledger, A specific application or applications, A restricted list of windows, functions and reports.
Q) You have logged into the Oracle E Business Suite Release 12 Instance and accessed your worklist. You see four FYI notifications in your default worklist view. You opened the first notification and clicked the OK Button after reviewing the content. Identify three things that can happen after you return to your worklist (Choose three).
Ans) You see three notifications in your worklist.
Status of the first notification has been updated to closed.
You can view the first notification by choosing the FYI Notifications view from your worklist.
Q) Identify two features related to parameters in a Daily Business Intelligence report. (Choose two).
Ans) Each page in a report contains common parameters.
The primary dimension parameter is different for each page in a Daily business intelligence report.
Q) Company ZZZ added a new responsibility to an existing Oracle E Business Suite Release12 application. The system administrator sets the MO:Operating Unit Profile Option at the Application Level. The application level will override the ____level?
Ans) Site
Q) Identify three correct statements about the Operating Unit in a Multi Org model of Oracle E Business Suite Release 12. (Choose three)
Ans) It is an organization type that secures transaction data.
An operating Unit can be associated with a single legal entity.
Multiple Operating Units can be assigned to a single responsibility.
Q) An activity in a workflow process can be a
Ans) PL/SQL function, a notification, a subprocess, or a business event.
Q)Identify two features of the notification system in Oracle Workflow?(choose two)
Ans)Enables any user with access to the Internet to be included in a workflow process.
Provides access to the worklist from Oracle E Business Suite Release 12 through the worklist web pages.
Q) Which five options are available when scheduling a periodic concurrent request in Oracle E Business Suite Release 12? Choose Five
Days, Hours,Week, Month, Minutes
Q) ZZZ Corp, has a number of service calls that require a resource to be designated. Using the CRM application foundation module. Identify the component that helps ZZZ Corp. Designate the resources that will own and work on the task?
Ans) Assignment Manager.
Q) Select three features that Multi Org Provides to satisfy business needs.(Choose three)
Ans) Secure user access to data, Procures from one Legal Entity and receives in another, Supports any number of business units within a single installation.
Q) Identify three true statements regarding Multiple Organization Reporting >? Choose Three?
Ans) Cross Organization reports can be submitted for a Reporting Level of Ledger.
Multiple Organization reports produce outputs for different Operating Units one at a time from a single responsibility.
Cross Organization reports produce outputs across different operating units in a single report from a single responsibility.
Q) A ledger is a financial reporting entity. What is new in Oracle E Business Suite Release 12 that facilitates generation of accounting entries ?
Ans) Accounting Convention.
Q) Which two statements are true regarding partitioning of data by an application (choose two)?
Ans) General Ledger is partitioned by ledgers.
Accounts Receivable is partitioned by Operating Unit.
Q) You have received a workflow notification from the Oracle E Business Suite Release 12 instance , which requires an electronic signature in your response. Identify the true statement regarding your notification response?
Ans)You can submit your response from any of your worklists after logging into the Oracle E Business Suite Release 12 instance
Q) Identify three features of Multi Org (Choose three)
Ans) The data can be logically partitioned.
Users can be assigned to specific organizations
It defines organizations and the relationships between them.
Q) Identify two business benefits of using Multi Org Access Control (Choose Two)?
Ans) Inquiry only access to data across different operating units.
Transaction entry across Operating Units using one responsibility.
Q) What are the three characteristics of an application and Oracle ID When defining a Data Group>
Ans) An application can be listed only once in a data group.
An oracle id can be paired with more than one application.
Custom applications registered with Oracle Application can be included in a data group.
Q) Identify two features of a table validated value set(Choose two)?
Ans) Table validated value sets obtain their lists of approved values from existing application tables.
A table validated value set enables you to use your own application tables as value sets for flexfield segments.
Q) During the cutover phase of a project to implement Oracle E-Business Suite Release 12, you are responsible for converting historical account balances into Oracle General Ledger from a legacy system. There is no Account Code Combination setup in the Production Instance. Identify the setup in the Accounting Key Flexfield structure that is required to perform this conversion.
Ans) Select the Allow Dynamic Inserts Check box in the Accounting Key Flexfield structure.
Q) You are the Human Resources lead for the ERP implementation of ZZZ Corporation. You have defined the employees in Oracle Human Resources. Select three activities that utilize the employee record. (Choose three.)
Ans) Approvals, Asset Assignment, Auto Create Purchase Orders.
Q) Which two statements are correct regarding a table validated value set? Choose Two.
Ans) You use a table validated value set when you have a set of values that is already maintained in application table.
You can use SQL query to retrieve all the approved values from the table when defining the table validated value set.
Q) Identify four components of the Fusion Business Intelligence Embedded Dashboard. (Choose Four)
Ans)Multiple Currencies, Flexible Time periods, Multiple Dta widgets, Key Performance indicators.
Q) You are the project manager with access to the Oracle Project Management application in Oracle E Business Suite Release 12. You have granted User X access to your worklist. User X now logs into Oracle E Business Suite Release 12 and accesses his or her worklist by clicking the Workflow Notification link. Identify three actions User X can perform. (Choose Three)
Ans) Approve the projects on your behalf.
View the username of the worklist owner in the worklist.
Access your worklist by clicking the Switch User button and then selecting your name.
Q) Which three statements are true about Oracle Workflow and Oracle Alters?
Ans) Workflow can support complex conditional logic.
Workflows can wait for a user response during an activity.
Alerts can perform multiple actions in a sequence that you specify.
Q) Company ZZZ has requested you to define a custom application to support custom forms and reports. The DBAs have created a new CUSTOM_TOP directory. Which are the three mandatory fields required to define a new custom application? Choose three.
Ans) Base Path, Application, Shortname.
Q) View the Exhibit. While entering a journal in the Journals form, you enter a code combination of 29.402.45.19.2103,240 in the Five segment accounting flexfield. However, you are unable to proceed after entering this account combination. What could be the problem in the structure definition of the Accounting Flexfield?
Ans) The Allow Dynamic Inserts Check Box is deselected.
Q) Oracle Daily Business Intelligence functions are secured using standard oracle applications function security. Choose three dashboards that are secured by the inventory Oraganization (Choose Three).
Ans)Inventory Management, Warehouse Management , Customer Fulfillment Management .
Q) Identify three Fusion Business Intelligence products for Oracle E Business Suite Release 12 (Choose three).
Ans) Oracle Sales Analytics, Oracle Financial Analytics, Oracle Supply Chain Analytics.
Q) Embedded Dashboards are a feature of Oracle Fusion Business Intelligence Release12. Select three additional features that Embedded Dashboards provide (choose three)?
Ans) Multiple Currencies, Flexible time periods, Ability to export to Excel or PDF.
Q) If the user has set Multi Org preferences, the system administrator has to assign ?
Ans) The user preferences function to the responsibility.
Q) Which two statements are true regarding ownership of shared entities ?
Ans) Suppliers is owned by Oracle Purchasing, whereas Units of Measure is owned by Oracle Inventory.
Ledger is owned by Oracle General Ledger, whereas locations I owned by Oracle Human Resources.
Q) It is your first day at a client site to implement Oracle E Business Suite Release 12. The client wants you to log a Service Request using Metalink, regarding a problem with the invoice workbench from in Oracle Payables. Identify the key information that is required to initiate a service request for this client?
Ans) Customer Support Identifier.
Q) You are involved in a project to upgrade to Oracle E Business Suite, Release12. You need more information about the upgrade processes and paths. Where would you find upgrade guide for Oracle E Business Sute?
Ans) Metalink Knowledge Base.
Q) As a system administrator for Oracle E Business Suite Release12, which two actions can be perform on user passwords (choose two)
Ans) See the initial password, Change an existing password.
Q) Identify two correct statements related to key performance indicators and the KPI region in Daily Business Intelligence (Choose two)
Ans) Can be configured for each dashboard, Is a strategic business factor that is used for reporting.
Q) Identify two types of regions in Daily Business Intelligence.
Ans) Table, Graph.
Ans) Create Operating Unit, run the Replicate Seed Data Concurrent Request , assign the Operating Unit to a security hierarchy, run Security List Maintenance concurrent program, create a new responsibilities as necessary, and set up the MO : Security Profile Option.
Q) A new Receivables Inquiry responsibility is created for the Denmark Operating Unit and is assigned to the end users. You receive a call from the end user, who states that the Sweden receivables data is displayed on the Denmark Receivables Inquiry Screen. What is the cause of the wrong data being displayed?
Ans) Incorrect Operating Unit Profile Option set for the responsibility.
Q) Application Security Consists of User, Responsibility and Self Service Application Security. Select three authorizations to which a responsibility allows access?
Ans) Ledger, A specific application or applications, A restricted list of windows, functions and reports.
Q) You have logged into the Oracle E Business Suite Release 12 Instance and accessed your worklist. You see four FYI notifications in your default worklist view. You opened the first notification and clicked the OK Button after reviewing the content. Identify three things that can happen after you return to your worklist (Choose three).
Ans) You see three notifications in your worklist.
Status of the first notification has been updated to closed.
You can view the first notification by choosing the FYI Notifications view from your worklist.
Q) Identify two features related to parameters in a Daily Business Intelligence report. (Choose two).
Ans) Each page in a report contains common parameters.
The primary dimension parameter is different for each page in a Daily business intelligence report.
Q) Company ZZZ added a new responsibility to an existing Oracle E Business Suite Release12 application. The system administrator sets the MO:Operating Unit Profile Option at the Application Level. The application level will override the ____level?
Ans) Site
Q) Identify three correct statements about the Operating Unit in a Multi Org model of Oracle E Business Suite Release 12. (Choose three)
Ans) It is an organization type that secures transaction data.
An operating Unit can be associated with a single legal entity.
Multiple Operating Units can be assigned to a single responsibility.
Q) An activity in a workflow process can be a
Ans) PL/SQL function, a notification, a subprocess, or a business event.
Q)Identify two features of the notification system in Oracle Workflow?(choose two)
Ans)Enables any user with access to the Internet to be included in a workflow process.
Provides access to the worklist from Oracle E Business Suite Release 12 through the worklist web pages.
Q) Which five options are available when scheduling a periodic concurrent request in Oracle E Business Suite Release 12? Choose Five
Days, Hours,Week, Month, Minutes
Q) ZZZ Corp, has a number of service calls that require a resource to be designated. Using the CRM application foundation module. Identify the component that helps ZZZ Corp. Designate the resources that will own and work on the task?
Ans) Assignment Manager.
Q) Select three features that Multi Org Provides to satisfy business needs.(Choose three)
Ans) Secure user access to data, Procures from one Legal Entity and receives in another, Supports any number of business units within a single installation.
Q) Identify three true statements regarding Multiple Organization Reporting >? Choose Three?
Ans) Cross Organization reports can be submitted for a Reporting Level of Ledger.
Multiple Organization reports produce outputs for different Operating Units one at a time from a single responsibility.
Cross Organization reports produce outputs across different operating units in a single report from a single responsibility.
Q) A ledger is a financial reporting entity. What is new in Oracle E Business Suite Release 12 that facilitates generation of accounting entries ?
Ans) Accounting Convention.
Q) Which two statements are true regarding partitioning of data by an application (choose two)?
Ans) General Ledger is partitioned by ledgers.
Accounts Receivable is partitioned by Operating Unit.
Q) You have received a workflow notification from the Oracle E Business Suite Release 12 instance , which requires an electronic signature in your response. Identify the true statement regarding your notification response?
Ans)You can submit your response from any of your worklists after logging into the Oracle E Business Suite Release 12 instance
Q) Identify three features of Multi Org (Choose three)
Ans) The data can be logically partitioned.
Users can be assigned to specific organizations
It defines organizations and the relationships between them.
Q) Identify two business benefits of using Multi Org Access Control (Choose Two)?
Ans) Inquiry only access to data across different operating units.
Transaction entry across Operating Units using one responsibility.
Q) What are the three characteristics of an application and Oracle ID When defining a Data Group>
Ans) An application can be listed only once in a data group.
An oracle id can be paired with more than one application.
Custom applications registered with Oracle Application can be included in a data group.
Q) Identify two features of a table validated value set(Choose two)?
Ans) Table validated value sets obtain their lists of approved values from existing application tables.
A table validated value set enables you to use your own application tables as value sets for flexfield segments.
Q) During the cutover phase of a project to implement Oracle E-Business Suite Release 12, you are responsible for converting historical account balances into Oracle General Ledger from a legacy system. There is no Account Code Combination setup in the Production Instance. Identify the setup in the Accounting Key Flexfield structure that is required to perform this conversion.
Ans) Select the Allow Dynamic Inserts Check box in the Accounting Key Flexfield structure.
Q) You are the Human Resources lead for the ERP implementation of ZZZ Corporation. You have defined the employees in Oracle Human Resources. Select three activities that utilize the employee record. (Choose three.)
Ans) Approvals, Asset Assignment, Auto Create Purchase Orders.
Q) Which two statements are correct regarding a table validated value set? Choose Two.
Ans) You use a table validated value set when you have a set of values that is already maintained in application table.
You can use SQL query to retrieve all the approved values from the table when defining the table validated value set.
Q) Identify four components of the Fusion Business Intelligence Embedded Dashboard. (Choose Four)
Ans)Multiple Currencies, Flexible Time periods, Multiple Dta widgets, Key Performance indicators.
Q) You are the project manager with access to the Oracle Project Management application in Oracle E Business Suite Release 12. You have granted User X access to your worklist. User X now logs into Oracle E Business Suite Release 12 and accesses his or her worklist by clicking the Workflow Notification link. Identify three actions User X can perform. (Choose Three)
Ans) Approve the projects on your behalf.
View the username of the worklist owner in the worklist.
Access your worklist by clicking the Switch User button and then selecting your name.
Q) Which three statements are true about Oracle Workflow and Oracle Alters?
Ans) Workflow can support complex conditional logic.
Workflows can wait for a user response during an activity.
Alerts can perform multiple actions in a sequence that you specify.
Q) Company ZZZ has requested you to define a custom application to support custom forms and reports. The DBAs have created a new CUSTOM_TOP directory. Which are the three mandatory fields required to define a new custom application? Choose three.
Ans) Base Path, Application, Shortname.
Q) View the Exhibit. While entering a journal in the Journals form, you enter a code combination of 29.402.45.19.2103,240 in the Five segment accounting flexfield. However, you are unable to proceed after entering this account combination. What could be the problem in the structure definition of the Accounting Flexfield?
Ans) The Allow Dynamic Inserts Check Box is deselected.
Q) Oracle Daily Business Intelligence functions are secured using standard oracle applications function security. Choose three dashboards that are secured by the inventory Oraganization (Choose Three).
Ans)Inventory Management, Warehouse Management , Customer Fulfillment Management .
Q) Identify three Fusion Business Intelligence products for Oracle E Business Suite Release 12 (Choose three).
Ans) Oracle Sales Analytics, Oracle Financial Analytics, Oracle Supply Chain Analytics.
Q) Embedded Dashboards are a feature of Oracle Fusion Business Intelligence Release12. Select three additional features that Embedded Dashboards provide (choose three)?
Ans) Multiple Currencies, Flexible time periods, Ability to export to Excel or PDF.
Q) If the user has set Multi Org preferences, the system administrator has to assign ?
Ans) The user preferences function to the responsibility.
Q) Which two statements are true regarding ownership of shared entities ?
Ans) Suppliers is owned by Oracle Purchasing, whereas Units of Measure is owned by Oracle Inventory.
Ledger is owned by Oracle General Ledger, whereas locations I owned by Oracle Human Resources.
Q) It is your first day at a client site to implement Oracle E Business Suite Release 12. The client wants you to log a Service Request using Metalink, regarding a problem with the invoice workbench from in Oracle Payables. Identify the key information that is required to initiate a service request for this client?
Ans) Customer Support Identifier.
Q) You are involved in a project to upgrade to Oracle E Business Suite, Release12. You need more information about the upgrade processes and paths. Where would you find upgrade guide for Oracle E Business Sute?
Ans) Metalink Knowledge Base.
Q) As a system administrator for Oracle E Business Suite Release12, which two actions can be perform on user passwords (choose two)
Ans) See the initial password, Change an existing password.
Q) Identify two correct statements related to key performance indicators and the KPI region in Daily Business Intelligence (Choose two)
Ans) Can be configured for each dashboard, Is a strategic business factor that is used for reporting.
Q) Identify two types of regions in Daily Business Intelligence.
Ans) Table, Graph.
Oracle R12 Business Essentials FAQs PART-1
Q) Which business is used for activities starting from product purchase to creating and closing service requests?
Ans) Request to Resolution
Q) ZZZ Corporation will be implementing Oracle E Business Suite Release 12. Purchasing , Payables, Receivables, General Ledger, Assets, Projects, Order Management and Cash Management will be implemented. Select three business flows that would involve these products?
Answers) Order to Cash , Procure to Pay, Project to Profit.
Q) Identify two descriptive flexfield components whose values are used to determine contexts. (choose two)
Ans) The Context Field , The Reference field
Q) Daily Business Intelligence reporting is available across all major product areas identify the Daily Businesss Intelligence tool that would provide manufacturing costs for an item over time by various cost elements?
Ans) Product Intelligence.
Q) What is the base release for Oracle E Business Suite Release 12?
Ans)12.0.0
Q) Identify the sequence of steps to determine the Descriptive Flexfield name on a form in Oracle E Business Suite Release 12 with Diagnostics enabled.
Ans) Step 1- Select Help > Diagnostics>Examine
Step 2- Select the $descriptive_flexfields$value for the block name.
Step 3- Select the DFF name from the list of values in the Field field. Step 4- The username of the DFF appears in the Value field.
Q) A Global Single Instance (GSI) provides the global enterprise with a single complete data model identify three features in Oracle E business suite Release 12 that support a GSI.( Choose Three)
Ans) Automation of standardized documents and audit process.
Consolidation of data centers and lowering administrative overhead.
Capture of Statutory and Customary local requirements in the same database.
Q) Identify the component in Subledger Accounting that enables you to meet the requirements of multiple accounting representations for an event.?
Ans) Application Accounting Defination.
Q) Oracle Fusion Intelligence Release 12 is a set of new Application products and one of the first of the Fusion Applications. Select four features that Oracle Fusion Intelligence Release 12 provides (Choose 4)?
Ans) Guided drilldown.
Integrated Security.
Guided navigation and action links.
Extends and configures key performance indicators.
Q) Which two parameters facilitate cross organization reports in aMulti-Org Environment (Choose two)?
Ans) Reporting Level, Reporting Context.
Q) ZZZ Corp, has implemented Oracle Manfacturing application from Oracle E Business Suite Release 12. How is the data in the manufacturing application partitioned?
Ans) By Inventory Organization
Q) You receive a request to create a new responsibility for US Payables Manager. The request states that new responsibility should have access to all menu items except invoice payments identify two options that you would use to restrict the invoice payments option on the new US Payables Manager responsibility. (Choose two).
Ans) Create a Menu Exclusion for Invoice Payments on the US Payables Manager responsibility.
Create a new manu excluding the invoice payments option and attach the new manu to the responsibility.
Q) What are the three elements involved in submitting a concurrent request ? (Choose three)
Ans) Providing Completion Option.
Defining a submission schedule.
Selecting the request or request set to be submitted.
Ans) Request to Resolution
Q) ZZZ Corporation will be implementing Oracle E Business Suite Release 12. Purchasing , Payables, Receivables, General Ledger, Assets, Projects, Order Management and Cash Management will be implemented. Select three business flows that would involve these products?
Answers) Order to Cash , Procure to Pay, Project to Profit.
Q) Identify two descriptive flexfield components whose values are used to determine contexts. (choose two)
Ans) The Context Field , The Reference field
Q) Daily Business Intelligence reporting is available across all major product areas identify the Daily Businesss Intelligence tool that would provide manufacturing costs for an item over time by various cost elements?
Ans) Product Intelligence.
Q) What is the base release for Oracle E Business Suite Release 12?
Ans)12.0.0
Q) Identify the sequence of steps to determine the Descriptive Flexfield name on a form in Oracle E Business Suite Release 12 with Diagnostics enabled.
Ans) Step 1- Select Help > Diagnostics>Examine
Step 2- Select the $descriptive_flexfields$value for the block name.
Step 3- Select the DFF name from the list of values in the Field field. Step 4- The username of the DFF appears in the Value field.
Q) A Global Single Instance (GSI) provides the global enterprise with a single complete data model identify three features in Oracle E business suite Release 12 that support a GSI.( Choose Three)
Ans) Automation of standardized documents and audit process.
Consolidation of data centers and lowering administrative overhead.
Capture of Statutory and Customary local requirements in the same database.
Q) Identify the component in Subledger Accounting that enables you to meet the requirements of multiple accounting representations for an event.?
Ans) Application Accounting Defination.
Q) Oracle Fusion Intelligence Release 12 is a set of new Application products and one of the first of the Fusion Applications. Select four features that Oracle Fusion Intelligence Release 12 provides (Choose 4)?
Ans) Guided drilldown.
Integrated Security.
Guided navigation and action links.
Extends and configures key performance indicators.
Q) Which two parameters facilitate cross organization reports in aMulti-Org Environment (Choose two)?
Ans) Reporting Level, Reporting Context.
Q) ZZZ Corp, has implemented Oracle Manfacturing application from Oracle E Business Suite Release 12. How is the data in the manufacturing application partitioned?
Ans) By Inventory Organization
Q) You receive a request to create a new responsibility for US Payables Manager. The request states that new responsibility should have access to all menu items except invoice payments identify two options that you would use to restrict the invoice payments option on the new US Payables Manager responsibility. (Choose two).
Ans) Create a Menu Exclusion for Invoice Payments on the US Payables Manager responsibility.
Create a new manu excluding the invoice payments option and attach the new manu to the responsibility.
Q) What are the three elements involved in submitting a concurrent request ? (Choose three)
Ans) Providing Completion Option.
Defining a submission schedule.
Selecting the request or request set to be submitted.
R12 Subledger Accounting Part 1
Why SLA?
Oracle Sub ledger Accounting is accounting hub in Oracle Application Release R12. It is used to derive all attributes required to account a transaction in Oracle General Ledger. In R12, SLA is used to derive the very basic accounting attributes like entered amount, accounted amount, date, currency code etc and the complex attributes like ledger, Code Combination ID, Period etc.
SLA is a powerful accounting engine or program with centralized data model and repository, which generates accounting entries for the transactions entered in the sub ledger modules.
SLA is a service and not a separate module or application.
SLA forms and programs can be accessed through standard Oracle Application Responsibilities.
SLA allows multiple accounting respsentations for a single transaction thereby enabling compliance with multiple geographic, regulatory or business requirements.
SLA also facilitates multi period accounting. standardized accounting across the sub ledgers.Streamlines Reconciliation resulting faster period end process.Supports shared service centers.
An existing accounting definition in SLA can be copied and modified as per the requirement.Expensive customizations can be avoided with the flexbility in accounting system.Single step posting to all ledgers at a time. Real time/online accounting.Audit Trail.
The sub ledger accounting method builder can be setup in the following order:
Define Journal Line Type
Define Journal Entry Description.
Define Accounting Derivation Rules.
Define Journal Line Definitions.
Define Application Accounting Definition
Define Sub ledger Accounting Method.
Define Ledger.
Modules Covered Under Sub ledger Accounting
Payables Receivables, Cash Management, Payroll, Purchasing, Assets, Loans, Lease Management, Property Manager, Public Sector Federal, Cost Management, Manufacturing etc.
Types of Sub ledger Accounting Method
Five Sub ledger Accounting methods are seeded in the Application. However as per the accounting requirement , new method of accounting can be created.
The five methods are as follows:
Accrual With Encumbrance Accounting.
Cash With Encumbrance Accounting.
Standard Accrual.
Standard Cash.US Federal Accounting.
Security Controls in SLA.
The following Security Controls are build in SLA.
sub ledger accounting rules and definitions of one module can be accessed from any other module. Seeded sub ledger accounting methods can be modified. Any change made a sub ledger accounting setup must be validated in order to make sure that the changes are logical.
Oracle Sub ledger Accounting is accounting hub in Oracle Application Release R12. It is used to derive all attributes required to account a transaction in Oracle General Ledger. In R12, SLA is used to derive the very basic accounting attributes like entered amount, accounted amount, date, currency code etc and the complex attributes like ledger, Code Combination ID, Period etc.
SLA is a powerful accounting engine or program with centralized data model and repository, which generates accounting entries for the transactions entered in the sub ledger modules.
SLA is a service and not a separate module or application.
SLA forms and programs can be accessed through standard Oracle Application Responsibilities.
SLA allows multiple accounting respsentations for a single transaction thereby enabling compliance with multiple geographic, regulatory or business requirements.
SLA also facilitates multi period accounting. standardized accounting across the sub ledgers.Streamlines Reconciliation resulting faster period end process.Supports shared service centers.
An existing accounting definition in SLA can be copied and modified as per the requirement.Expensive customizations can be avoided with the flexbility in accounting system.Single step posting to all ledgers at a time. Real time/online accounting.Audit Trail.
The sub ledger accounting method builder can be setup in the following order:
Define Journal Line Type
Define Journal Entry Description.
Define Accounting Derivation Rules.
Define Journal Line Definitions.
Define Application Accounting Definition
Define Sub ledger Accounting Method.
Define Ledger.
Modules Covered Under Sub ledger Accounting
Payables Receivables, Cash Management, Payroll, Purchasing, Assets, Loans, Lease Management, Property Manager, Public Sector Federal, Cost Management, Manufacturing etc.
Types of Sub ledger Accounting Method
Five Sub ledger Accounting methods are seeded in the Application. However as per the accounting requirement , new method of accounting can be created.
The five methods are as follows:
Accrual With Encumbrance Accounting.
Cash With Encumbrance Accounting.
Standard Accrual.
Standard Cash.US Federal Accounting.
Security Controls in SLA.
The following Security Controls are build in SLA.
sub ledger accounting rules and definitions of one module can be accessed from any other module. Seeded sub ledger accounting methods can be modified. Any change made a sub ledger accounting setup must be validated in order to make sure that the changes are logical.
R12 Subledger Accounting
What is Subledger Accounting ?
Oracle Subledger Accounting a rule based engine for generating accounting entries based on subledger transactions from all Oracle Applications.
Subledger Accounting is a data store in the same way as General Ledger but Subledger Accounting provides the detailed data whereas General Ledger provides a summarized version. Subledger Accounting is therefore a true subledger.
Oracle Subledger Accounting a rule based engine for generating accounting entries based on subledger transactions from all Oracle Applications.
Subledger Accounting is a data store in the same way as General Ledger but Subledger Accounting provides the detailed data whereas General Ledger provides a summarized version. Subledger Accounting is therefore a true subledger.
Subscribe to:
Posts (Atom)
Posts
