Showing posts with label rules. Show all posts
Showing posts with label rules. Show all posts

Manage Role Provisioning Rules in Oracle Fusion Applications

If you have numerous job roles and want to assign them automatically to users, you can use Job-Role Mappings to automate this process.

This is basically an If-Then Condition to assign roles automatically to users.



You can run a background program to automate this process.

For more full-detailed Tutorials and Tips, check out #TheOracleProdigy at https://lifeofanoracleprodigy.blogspot.com/
Follow The Oracle Prodigy on Facebook (https://www.facebook.com/theOracleProdigy/) and Twitter (https://twitter.com/D_OracleProdigy)

Configuring Revenue for Receivables in Oracle Fusion Applications

What is Revenue Management? 

Oracle Revenue Management complies with accounting standards that tell the organization to recognize the revenue later after the invoice has been sent. A sample of this would be a multi-period Mobile contract for Voice and Data Subscription, or Streaming Subscription, or a Software Support Contract. 

The concept of Revenue Management is that your organization sells a service or product to your customer, but have not fully delivered that service, we cannot fully recognize the whole revenue for that invoice at once because we have to follow an accounting standard. What Revenue Management does is we prorate our revenue from the start and end of the contract. For Example, the contract was for a 12-month period, that's the bill will be pro-rated for 12 months.

An example we can use for this whole article would be a support service provided by Oracle Corporation for a period of 12 months for $100,000.00. The Support fees would be pro-rated in a 12-month accounting period, instead of having it only at one accounting period. 

Depending on your Requirements, you may need to configure or update the following setups related to revenue:
  1. Setup Revenue Recognition
  2. Revenue Scheduling Rules
  3. Define Revenue Policies
  4. Define Revenue Contingencies
Each of these setups will be discussed in detail below.

Setup Revenue Recognition It's a collection of defaults, options, functionality features that is broken down into two areas, billing-related and cash-processing system options and customer payment system options. Below are the setups for Revenue Recognition:
  1. Salesperson System Options - Allows an organization to require a Salesperson when you enter an invoice. The idea here is to assign sales credit to that person that sold the product or service so that they can receive commissions based on their sales.
It also has an implication in terms of revenue recognition, because if you make an adjustment to their revenue, the sales credit of that salesperson will be impacted. If the salesperson gets paid based on revenue, an adjustment will also be made to his or her commission. 
In some cases, you compensate salespeople on revenue and non-revenue, so it doesn't have to equal 100%. You can strictly compensate a salesperson based on revenue. To do this, you can enter a value in the Sales Credit Percent Limit field.
  1. Revenue Adjustment Reason Lookup Type – If you create an invoice with revenue recognition rule that has the deferral option turned on, then you need to make sure that you track the reasons for revenue recognition. This Lookup just means you can add reasons to the seeded reasons list so that users can pick the value they need when they are about to recognize revenue manually.
  1. AutoAccounting based on a Standard Line - If AutoAccounting is based on standard line, the transaction line must either be an inventory item or a memo line, and not a user-entered line.
When you are entering lines for an invoice in receivables, those lines can be adhoc. If you enter an adhoc line, it's going to be difficult for receivables to generate the required revenue accounting information. It doesn't know how to generate the accounting distributions for that line.
However, if it's an inventory item that you are using in an invoice line, AutoAccounting can generate the accounting distribution. It can also can be a standard line, which means that you are defining products and services outside of the inventory module.

Revenue Scheduling RulesYou can create an invoice with revenue recognition rules. A scheduling rule is a rule that tells receivables how to allocate our revenue into the future. It can be that a revenue scheduling rule that tells receivables not to recognize revenue now, we are going to recognize the revenue manually in the future by processing a revenue adjustment. For more information about Managing Revenue Scheduling Rules, check out a separate article: Manage Revenue Scheduling Rules in Oracle Fusion Applications.

Revenue Policies - Revenue Policies allow your organization to make automatic revenue recognition decisions for manually entered and imported transactions. This works in connection with revenue contingencies.

To create Revenue Policies, go to the Functional Setup Manager, pick the Financials offering, select the Revenue Recognition functional area and choose the Task “Manage Revenue Policies”.

Revenue policies can be based on different criteria such as:
  1. Credit classification- When you create a customer, you can assign that customer a credit classification in the customer profile class setup. It can be excellent, average or poor credit. For example, the customer has excellent credit classification, then you might decide to recognize their revenue right away because they are good payers. Or on the other hand, you may want to recognize the revenue later on if the customers have poor credit, as you don’t want to recognize the revenue now and reverse it later on if the customer fails to pay.
  1. Refund Policy Threshold- You can use the refund policy threshold column to enter the standard refund period represented in days that you offer to your customers. When you enter or import the transaction, if a line is associated with a contract, receivables analyzes the contract and look at the refund period. And if the contract offers a refund period that exceeds their refund policy, then our contingency is going to be assigned to the line. This is commonly used when your organization might have a certain refund policy where you may allow an unhappy customer a refund within 30 or 45 days. If that's the case, you might want to wait after the refund period has passed to recognize your revenue.
  1. Payment Terms Threshold– Based on the Business Unit, payment terms and the transactions, receivables will identify that these are non-standard payment terms and therefore we are going to defer their revenue. This will dictate that we are only going to recognize the revenue after the removal event has happened, such as a customer payment, or after 60 days has passed, etc. For example, if there's an invoice created with these a non-standard NET 45 payment terms, it will be subject to a contingency and revenue will not be recognized unless the customer has already paid.
Revenue Contingencies - provides certain restrictions that you apply on revenue recognition that are going to be removed by an event. For example, the event can be payment, or the event can be that 30 days have passed, and now I feel comfortable that I can recognize the revenue.

How Does Revenue Contingencies Work?


You enter and complete the receivable transactions, either manually or automatically. Receivables will analyze the invoice and look at the contingencies and assignment rules that you have defined. If the customer specified in that invoice and the Business Unit matches the contingencies and assignment rules, it will proceed to determine if are there any restrictions for this invoice. 

If there are no restrictions, then it can go on and recognize the revenue. If it does find contingencies, it will defer the revenue and wait until a removal event takes place. The removal event in this example is a payment. The system will not recognize revenue until the customer pays. Once the customer pays, it will automatically recognize the revenue for that particular invoice. 

Removal Event – Removes the restriction based on an event such as a Payment, number of days passed, etc. For example, if a customer was billed with a non-standard payment term (NET 45), they will be assigned a revenue contingency, in which a payment will be the removal event. Once the customer pays, the restriction will be removed on the revenue, and we will recognize the revenue and report it because there's no risk anymore.

Revenue Contingency Assignment Rules - Defines a rule on how to apply that contingency. You can apply the rule to a given customer or a set of customers.

For more full-detailed Tutorials and Tips, check out #TheOracleProdigy at https://lifeofanoracleprodigy.blogspot.com/
Follow The Oracle Prodigy on Facebook (https://www.facebook.com/theOracleProdigy/) and Twitter (https://twitter.com/D_OracleProdigy)

Create a Bank Statement Transaction Creation Rule in Oracle Fusion Applications

This article will show you how to create a Bank Statement Transaction Creation in Oracle Fusion Applications. Go to the following navigation:

Screen
Offering
Financials
Functional Area
Cash Management and Banking
Task
Bank Statement Transaction Creation Rules



In the "Manage Bank Statement Transaction Creation Rules" page, you can either create a new Transaction Creation Rule or view an existing Transaction Creation Rule:



One example are Bank fees. Bank Fees are external transactions that are not going to be recorded in your ERP applications, but that you need to record once you receive the bank statement.




Transaction Creation Rule is connected to a legal entity and a business unit you need to specify the criteria to identify the bank statement line such as transaction codes and transaction types, which is 698 and Fee in the sample above. Once the program finds that transaction, then it will create an external transaction with the provided accounting information because you need to create accounting distributions and ultimately a journal that you send to GL.

Below is a step-by-step demonstration of Creating a Bank Statement Transaction Creation Rule in Oracle Fusion Applications:



For more full-detailed Tutorials and Tips, check out #TheOracleProdigy at https://lifeofanoracleprodigy.blogspot.com/
Follow The Oracle Prodigy on Facebook (https://www.facebook.com/theOracleProdigy/) and Twitter (https://twitter.com/D_OracleProdigy)

Configurations for Automatic Reconciliation Process for Cash Management in Oracle Fusion Applications

This article gives an overview of the configurations for Automatic Reconciliation Process for Cash Management in Oracle Fusion Applications. Below is a quick diagram:


Besides setting up the Bank, Bank Branch and Bank Accounts, below are some Configurations for Automatic Reconciliation Process for Cash Management in Oracle Fusion Applications:

Bank Statement Lines
Transaction Code
Transaction Type
Receipt 10,000 USD
222
Check
Disbursement 5,000 USD
475
Check
Bank Charges 100 USD
698
Fees

Bank Transaction Codes
  • Bank statement transaction codes are internal codes that are used on a bank statement line to identify the type of transaction being reported.
  • For example, there might be a code of "100" in the bank statement, and that code indicates that the line is a deposit.
  • These codes are normally numeric and these codes identify what the bank statement transaction line is about.
  • There are already predefined bank transaction codes, and custom codes can also be created.
  • In the example table above, it shows that transaction codes 222 and 475 are both Check transactions, but they are different because one is a Receipt from a Customer Payment (Inbound), and the other is a Payment Disbursement to a Vendor (Outbound). This is where Transaction type Mapping comes in.
  • Below is a video demonstration of Creating Bank Transaction Codes in Oracle Fusion Applications:

Transaction type Mapping
  • You want to make sure that those transaction codes mentioned above match to what your bank uses.
  • There are different transaction types for different modules, so Transaction type mapping identifies the transaction types for payables, receivables, and provide a description for them.
  • Some samples of transaction types are fees, lockbox, miscellaneous transactions, a reversal, a check, a bank adjustment. These are the transaction types that you will be mapping and specifying the module that they belong to.
Matching Rules
  • Allows the automatic reconciliation process to automatically match lines from a Statement to the transactions.
  • Usually, its one bank statement line to one system transaction (i.e. customer receipts in receivables, supplier payments in payables, etc) or one to many.
  • However, It does not have to be one to one. It can be one to many. One statement line that you are matching to a batch of customer receipts in AR. So a group of customer receipts, many to one, as you can see here. Many bank statement lines for one system transaction, or many to many, which makes the rules are a little more complex.
  • Below is a video demonstration of Creating Matching Rule in Oracle Fusion Applications:


Tolerance Rules
  • Tolerances specifies how much can you deviate in terms of amount, date or percentages.
  • For example, your specified tolerance is set to two to three days, it's going to allow the bank Statement to match if the date is a bit off by two to three days.
  • Another example would be If the amount is off by a few pennies, it might be due to the exchange rates that you see the difference, if you're dealing with multi-currency, and so on.
  • You can express variances or tolerances in an amount versus a percentage. If you use both, the system AutoReconciliation will consider the smallest of the two.
  • Below is a video demonstration of Creating Bank Statement Reconciliation Tolerance Rules in Oracle Fusion Applications:


Reconciliation Rule set
  • A group of rules that allow AutoReconciliation to match and assess tolerances and determine what is acceptable and what is not.
  • Groups together the matching rules, the tolerance rules, and attaches them to the bank account.
  • Below is a video demonstration of Creating Reconciliation Rule Sets in Oracle Fusion Applications:

  • Below is a video on how Reconciliation Rule Sets attaches to a bank account


Payment Code Map Groups
  • Payment Code Map Groups are codes that identify code groups in a bank statement such as opening and closing balances in a statement, and other codes that identify actual transactions lines on a bank statement. They simply identify if the line is an opening/closing balance or an actual transaction.
Payment Code Map Group Name
Field Value
Bank Transaction Code
Transaction Type Mapping
Bank of America BAI2
CE_TRX_CODE
174
WIRE IN
Citibank BAI2
CE_TRX_CODE
174
DEPOSIT

In the above example, Bank of America uses the code 174 to identify wires, but the same code, 174, might be used by Citibank to identify deposits. Of course, both of these are incoming money, but it is important to know the difference between a wire and a regular deposit.

For more full-detailed Tutorials and Tips, check out #TheOracleProdigy at https://lifeofanoracleprodigy.blogspot.com/
Follow The Oracle Prodigy on Facebook (https://www.facebook.com/theOracleProdigy/) and Twitter (https://twitter.com/D_OracleProdigy)

Recent Posts

SQL Fundamentals

Introduction to SQL and Syntax What is SQL? SQL stands for Structured Query Language. is a standard programming language for accessing datab...

Top Posts