Wednesday, December 6, 2017

Which two delivered roles can access the full functionality of Functional Setup Manager

Question No: 7
Which two delivered roles can access the full functionality of Functional Setup Manager,
A. Functional Setup Manager Superuser
B. Application Implementation Consultant
C. Any functional user
D. IT Security Manager
E. Application Implementation Manager
Answer : B,E

Reference:



Your customer is using budgetary control and encumbrance

Question No: 6
Your customer is using budgetary control and encumbrance. You have an open purchase order for $500 USD, which you decide to match to an invoice for $300 USD. What will be the fund status of the purchase order and invoice?
A.         The purchase order is liquidated and the invoice is Partially Reserved.
B.         Both are Partially Reserved.
C.         The purchase order is Open and the invoice is validated.
D.         The purchase order is Partially Liquidated and the invoice is Partially Reserved.
E.         The purchase order is Partially Liquidated and the invoice will be reserved.
F.          Both are reserved.
Answer : E

Reference:

https://docs.oracle.com/cloud/latest/financialscs_gs/FAPPP/FAPPP1011878.htm#FAPPP1011858

https://docs.oracle.com/en/cloud/saas/financials/r13-update17d/fappp/

Monday, December 4, 2017

Identify three differences between Oracle Transactional Business Intelligence (OTBI) and Oracle Business Intelligence Applications (OBIA)

Question No: 5
Identify three differences between Oracle Transactional Business Intelligence (OTBI) and Oracle Business Intelligence Applications (OBIA).
A. Cloud customers can use both OTBI and OBIA.
B. OTBI allows you to create custom reports from real-time transactional data against the database directly
C. OBIA works for multiple sources including E-Business Suite, PeopleSoft, JD
Edwards, SAP, and Fusion Applications.
D. OBIA is based on the universal data warehouse design with different prebuilt
adapters that can connect to various source application
E. Both OBIA and OTBI provide a set of predefined reports and dashboards and a
library of metrics that help to measure business performance
Answer : B,C,D

Reference:
https://blogs.oracle.com/dylanwan/otbi-vs-obia

https://blogs.oracle.com/prajkumar/otbi-vs-obia-v2

Your user forgot the password

Question No: 4
Your user forgot the password. How do you resolve this?
A. Create a new user ID and password for the user.
B. Use Oracle Identity Management (OIM) to reset the user's password.
C. Log in to the user's machine as an Administrator and change the password from the login pa
D. Use Access Policy Manager (APM) to reset the user's password.
E. Use the Manage Users page to update the user's information and change the
password.
Answer : B

Reference:
https://docs.oracle.com/cd/E21764_01/doc.1111/e15477/pwd.htm#IMINT236

Your customer has enabled budgetary and encumbrance controls at the requisition level

Question No: 3
Your customer has enabled budgetary and encumbrance controls at the requisition level. You have a purchase order for $1,000 USD, which is fully reserved and has one invoice for $600 USD. When the purchase order is matched through the final match process, the purchase order is closed for further invoicing. What happens to the remaining $400 USD?
A. $400 USD will be added back to available funds
B. $400USD will be expired and not available for use.
C. Invoice type will have less funds available by $400 USD.
D. Manual encumbrance journal needs to be entered In General Ledger to release the budget amount of $400 USD.
E. Only obligation type will have $400 USD funds available.
Answer : A

Reference:


What happens to the available funds when I perform a final match on a purchase order that requires budgetary control?

The purchase order is finally closed, which releases funds for the quantities that aren't received or invoiced.
For example, if a purchase order for 1,000 USD has only one invoice for 600 USD, the final closing of the purchase order releases the 400 USD from the purchase order and adds it to the available funds.

https://docs.oracle.com/en/cloud/saas/financials/r13-update17d/fappp/invoices.html#FAPPP1326380

Thursday, November 30, 2017

You need to build a complex account rule

Question No: 2
You need to build a complex account rule. Which four value types can you use in your definition?
A. Value Set
B. Constant
C. Existing Account Rule
D. Account Combination
E. Mapping Set
F. Source

Answer : B, C, E, F

Reference:

Account Combination Rules
Set up account combination rules based upon the following value types:
  1. Source Value Type: Derive the account combination by specifying a "source".
    Sources that have been set up as accounts can be assigned to an account combination rule. Subledger Accounting then obtains the account combination identifier from the source.
  2. "Constant "Value Type: Establish the account as a constant value.
    For example, the constant could be a completed account combination from the "chart of accounts" specified. An example is the account combination, 01.000.2210.0000.000. This is the simplest way to derive an account.
  3. "Mapping Set" Value Type: Derive the account combination by referencing a mapping set.
    Set up a mapping set to determine the complete account combination from the chart of accounts specified.
  4. Account Rule Value Type: Derive the account by referencing another account rule.
    The chart of accounts is optional when defining this type of rule. If the account rule has a chart of accounts assigned, then all the related account rules must use the same or no chart of accounts.

https://fusionhelp.oracle.com/helpPortal/topic/TopicId_P_9BDEAA89D1E9982CE040D30A688136A1

After loading your budget data into Fusion General Ledger, you can view budget balances using these feature.

Question No: 1
After loading your budget data into Fusion General Ledger, you can view budget balances using these feature. Which feature does not belong on the list?
A. Account Inspector
B. Account Monitor
C. Smart View
D. Application Development Framework Desktop Integration(ADFdi)

Answer : D



Reference:
https://fusionhelp.oracle.com/helpPortal/topic/TopicId_P_C64F14F282FA6D2FE040D30A68811770

Friday, September 22, 2017

ADF Integration is Installed with an Incompatible Installer

When installing the ADF Desktop Integration add-in an error similar to the following occurs:
"ADFDI-04000: ADF Desktop Integration is installed on this computer with an incompatible installer. Please uninstall the currently installed version and retry the installation with the new installer."
The message may vary:
  • "Oracle ADF 11g Desktop Integration Add-In for Excel has previously been installed on this computer with an incompatible installer. Please uninstall it and retry the installation."
  • "ADFDI-04000: Oracle ADF 11g Desktop Integration Add-In for Excel is installed on this computer with an incompatible installer. Please uninstall the currently installed version and retry the installation with the new installer."
Reproduces starting in ADFdi 11.1.1.7.3 (4.0.0) - available in FA Release 9

Cause:

The ADF Desktop Integration add-in was previously installed with a legacy installer that is not compatible with the standard installer (adfdi-excel-addin-installer.exe).

Solution:
A. Remove the previous ADF Desktop Integration add-in installation with "Add/Remove Programs":
  1. Open "Add/Remove Programs" in the Windows control panel
  2. Search for "ADF Desktop Integration" and remove any installed versions of the client
  3. Retry the installation with the standard installer (adfdi-excel-addin-installer.exe)
B. If the ADF Desktop Integration client is not present in the installed programs listed in "Add/Remove Programs":
  1. Open Excel and navigate to Excel options
  2. Click the "Add-Ins" category
  3. In the "Manage" dropdown menu select "COM Add-Ins" and click "Go"
  4. "Oracle ADF Desktop Integration Runtime Add-In for Excel" or ""Oracle ADF Desktop Integration Add-In for Excel" should be present in the list of add-ins. Select it with the checkbox and click "Remove".
  5. Retry the installation with the standard installer (adfdi-excel-addin-installer.exe)
Source:
ADFDI-04000: ADF Desktop Integration is installed on this computer with an incompatible installer. (Doc ID 2017956.1)

Wednesday, September 20, 2017

Workaround for Maintain Transaction Class Deposit in Fusion Receivables

As we know there are no transaction class deposit in Fusion Receivables.

According to this Doc ID:


  1. Is There An AR Transaction Class = Deposit And AR Transaction Type = Commitment In Fusion Receivables ? (Doc ID 2052222.1)
  2. What are the Workarounds for Customer Deposits and Bank Guarantees in Fusion? (Doc ID 1675045.1)
  3. Oracle Fusion Receivables: Transactions Workbench Issue: Cannot create Deposits/Guarantees (Doc ID 1313616.1)
Detail below:

Doc ID 2052222.1

APPLIES TO:

Oracle Fusion Receivables Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

GOAL

Is there an AR transaction class = Deposit and AR transaction type = Commitment in Fusion Receivables ?
 

SOLUTION

No, there is nothing like that in Fusion. For deposit use receipts
 

REFERENCES


Doc ID 1675045.1

What are the workarounds for deposits and guarantee transactions in Fusion Applications?
 

SOLUTION

Possible workaround - For Customer Deposits:
===================================

For Customer Deposits when you receive an amount from your customer which needs to be tracked against the subsequent invoices or kept open . The amount held under this document is considered in calculating the customers outstanding balance.

1) On receipt of a deposit from your customer - Create a Receipt ( may be
 use a separate receipt method to be able to track such receipts).

2) Apply the invoices raised to such receipt to have the effect of squaring off the deposit amount against the invoice . (In EBS you would have raised the invoices against the deposit)

There is no known workaround for bank guarantees.

An enhancement request has been logged.
 
Bug 13920845 FUSION RECEIVABLES NEED DOCUMENT TYPES FOR CUSTOMER DEPOSITS , BANK GUARANTEES

REFERENCES

NOTE:1313616.1 - Oracle Fusion Receivables: Transactions Workbench Issue: Cannot create Deposits/Guarantees

Wednesday, September 6, 2017

Functionality of Segment Value Inheritance ESS Process

The Segment Value Inheritance process simplifies the maintenance of the chart of accounts. When the characteristics of values in the value sets are updated then all previously created account code combinations that referenced such values are not automatically updated by these changes.

This process is run to automatically propagate the following attributes of a segment value to all account code combinations which contain that segment value.

- Enable/disable flag
- Effective dates
- Allow budgeting flag
- Allow posting flag

The Segment Value Inheritance process allows you to run a controlled process to update such existing account code combinations. This process maintains and corrects the current attribute settings for those account code combinations that contain the account values that were changed.

For account code combinations where the present settings need to be retained and not impacted by account attribute changes, activate the flag to preserve the account code combination's attribute. Activating the flag prevents those account code combination's attributes from being update when the Segment Value Inheritance process is run.

Note:


  • Use the Segment Value Inheritance Exception Report to view the account combinations that have been changed.
  • Individual segment value attributes override account combination attributes.
  • Conflicting settings for Enabled, Allow Posting, From Date, or To Date are resolved by using the most restrictive of the settings of the individual segment values.
  • Disabling a segment value disables the combinations containing that value, even if the Preserve Attributes check box is selected

Friday, July 14, 2017

Glossary Related to Intercompany Transaction in Fusion Applications ERP

Glossary

a)     Intercompany Organization

Intercompany organizations can be considered legal entities or management entities and they can transact with each other. An intercompany organization is associated with a legal entity and optionally a receivables and payables business unit.

b)     Legal Entity

Each intercompany organization must be associated with a legal entity. Multiple intercompany organizations can be associated with the same legal entity.

c)      Receivables Business Unit

The receivables business unit is used when an intercompany transaction requires a receivables invoice to be generated. The invoice is raised in the provider organization’s receivables business unit. If you do not need to create receivables invoices for your intercompany transactions you do not need to assign a receivables business unit to your intercompany organization.

d)     Payables Business Unit

The payables business unit is used to record the invoice for the receiver organization. The invoice is recorded in the receiver organization’s payables business unit. If you do not need to record payables invoices for your intercompany transactions you do not need to assign a payables business unit to your intercompany organization.

Created by: 
Bernardine Rogers
Bidisha Silveira

Friday, June 16, 2017

Cannot Unapply Receipt in Fusion Receivables Cloud Service

When do unapply receipt for the transaction that has adjustment, this error come out:

1. A document sequence does not exist for the current document, even though the ledger option Enforce Sequencing for Receivables is enabled. (AR-855682)

2. ORA-20001: (AR-855636)

3. An Unexpected error occurred while reversing the adjustment . Contact your help desk (AR-856802)


After submit Service Request like below:

PROPOSED SOLUTION 
================== 
SELECT * 
/* SR3-15016089661 */ 
FROM FND_DOC_SEQUENCE_CATEGORIES 
WHERE NAME = 'Adjustment Reversal' 

Result: 

CODE NAME TABLE_NAME DESCRIPTION 
Adjustment Reversal Adjustment Reversal AR_ADJUSTMENTS_ALL Adjustment Reversal 

However, the above category is not assigned to any document sequence: 

SELECT 
/* SR3-15016089661 */ 
FROM fusion.FND_DOC_SEQUENCE_ASSIGNMENTS 
WHERE CATEGORY_CODE = 'Adjustment Reversal' 

Result: No Data Available 

Hence, you need to go to task Manage Document Sequences and assigned the Document Sequence Category 'Adjustment Reversal' to the appropriate Document sequence (I assume AR_PJA_SEQ_ADJUSTMENT) and its Legal Entity 

This assignment it is required. 

CAUSE DETERMINATION 
================== 
document sequence category 'Adjustment Reversal' is missing the assignment to a document sequence