8/3/13

Document Display

How To Setup And Troubleshoot Invoicing Rules and Accounting Rules (Doc ID 1116934.1)
Modified: Jun 11, 2013 Type: TROUBLESHOOTING Status: PUBLISHED Priority: 3

In this Document Purpose Troubleshooting Steps 1. Overview of Invoicing Rules and Accounting Rules a. Invoicing Rules b. Accounting Rules 2. Setting up Invoicing and Accounting Rules 3. Using Invoicing and Accounting Rules a. Transactions form b. AutoInvoice 4. Underlying table information for Invoicing and Accounting Rules 5. Troubleshooting Invoicing and Accounting Rules a. Rule Defaulting issues i. Invoicing and Accounting Rule from setup for an Inventory Item ii. Invoicing Rule in transactions form b. Unexpected behavior when using the seeded Accounting Rule = Immediate when interfacing Sales Orders from Order Management (OM) c. Explanation of changes to Transaction and GL date in transaction form when using Bill in Arrears d. Updating Invoicing and Accounting Rules e. When choosing an Accounting rule get error f. Using Daily Revenue Rate type of periods raises error g. Unexpected Percentages when using an Accounting rule spread over multiple periods h. Issues with dates: Transaction or GL date i) Variable Accounting rule with over 50 periods ii) Other GL date issues i. Unable to update fields associated to Daily Revenue Rate in Interface Lines form j. Please supply both an invoicing rule and an accounting rule for this invoice. k. The valid values for credit method for accounting rule are: PRORATE, LIFO and UNIT 6. Code Bugs 7. Still Have Questions? References

APPLIES TO:
Oracle Receivables - Version 11.5.10.0 to 12.1.3 [Release 11.5.10 to 12.1] Information in this document applies to any platform. Executable:RAXMTR - AutoInvoice Master Program Executable:RAXTRX - AutoInvoice Import Program Form:ARXTWMAI.FMB - Transactions Form:RAXSURUL.FMB - Define Invoicing and Accounting Rules

PURPOSE
Oracle Receivables (AR): AutoInvoice Information Center > Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12 > Note 1116934.1 Oracle Receivables (AR): Transactions Workbench Information Center > Note 1116934.1 Invoicing Rules and Accounting Rules are used by Receivables to determine how you want to recognize your Receivable and Revenue. The information you setup for Accounting Rules determines the behavior of Revenue Recognition, and defines how the GL distributions are created for your invoices. This note is intended provide an overview of Invoicing and Accounting Rules in Receivables. It will discuss the difference and relationship between Invoicing Rules and Accounting Rules and provide details on how to set it up as well as troubleshoot issues.
https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_adf.ctrl-state=1cf43vt22c_29

Since Invoicing and Accounting Rules are tightly integrated with Revenue Recognition, please also review Note 1121944.1, Understanding and 1/12

8/3/13

Document Display Since Invoicing and Accounting Rules are tightly integrated with Revenue Recognition, please also review Note 1121944.1, Understanding and Troubleshooting Revenue Recognition

If you are encountering other issues involving AutoInvoice, please review Note 1075757.1, Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12

TROUBLESHOOTING STEPS
1. Overview of Invoicing Rules and Accounting Rules a. Invoicing Rules
Invoicing Rules allow you to determine when you should account/recognize the Receivable amount for invoices. You can assign invoicing rules to invoices that you manually enter or import into Receivables through AutoInvoice. Oracle Receivables seeded 2 Invoicing Rules, you cannot create more: Bill in Advance: This rule allows you to recognize the Receivable amount at the start of the revenue recognition schedule. Bill in Arrears: This rule allows you to recognize the Receivable amount at the end of the revenue recognition schedule. Invoicing Rules are associated to an Invoice at the Header level, and is enabled only when Class = Invoice. In conjunction with associating an Invoicing Rule to a transaction, you also need to associate an Accounting Rule (discussed next).

b. Accounting Rules
Accounting Rules allow you to define when you should account/recognize the Revenue for your invoices. Accounting rules determine the number of periods and percentage of total revenue to record in each accounting period. You can define various accounting rules which can recognize Revenue in one or more accounting periods. Transactions entered either manually or through AutoInvoice can use Accounting Rules for as long as they are associated to an Invoicing Rule. Oracle Receivables seeded 1 Accounting Rule, you can create more as required by your business needs: Immediate: This accounting rule recognizes the entire revenue for a transaction in one accounting period. Accounting Rules are associated to an Invoice at the Line level. Once an invoice is associated to an Invoicing Rule, each of its lines need to be associated to an Accounting Rule. The following table summarizes details regarding Invoicing and Accounting Rules: Rule Invoicing Rule Controls accounting for Receivable Seeded by Oracle Can users create more rules? No Invoice Level Header

In Advance In Arrears

Accounting Rule

Revenue

Immediate

Yes

Lines

NOTE: If you can recognize Revenue for all of your invoice lines immediately, then there is no need to use Invoicing and Accounting Rules. If however, you have an invoice line for which you need to spread out the recognition of Revenue across several periods, then you need to use Invoicing and Accounting Rules. For example, Invoice #123 has 3 invoice lines. Line 1 and Line 2, Revenue can be recognized immediately. Line 3, Revenue has to be spread over 3 periods. You would have to associate an Invoicing Rule at the header level. Doing this, enables you to enter a value in the Accounting Rule for each line. For Line 1 and 2, you will use the seeded Accounting Rule = Immediate. For Line 3, you will use an Accounting Rule that you have previously defined, that allocates revenue across 3 periods.

2. Setting up Invoicing and Accounting Rules

There is no additional setup required for Invoicing Rules. Receivables seeds the 2 values you can use:
https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_adf.ctrl-state=1cf43vt22c_29 2/12

8/3/13

Document Display There is no additional setup required for Invoicing Rules. Receivables seeds the 2 values you can use: In Advance and In Arrears.

For Accounting Rules, you can setup as many rules as required to cover your various business scenarios involving how you want to recognize revenue. Responsibility: Receivables Manager Navigation: Setup > Transactions > Accounting Rules The following screenshots illustrate various Accounting Rule types: 1. Seeded Accounting Rule, Immediate: This Accounting Rule is provided by Oracle. The only field you can modify here is the Period type, and you should ensure that the value here matches the Period type used by your Ledger. Important: If your ledger has an accounting period type that is not Month and you use AutoInvoice with Oracle Order Management, you should update the Period field to match the same period as your accounting period type.

2. Example for Type = Fixed Schedule, with Revenue spread out evenly over 3 periods. 3. Example for Type = Variable Schedule, with first period's revenue percentage specified. 4. Example for Type = Daily Revenue Rate, All Periods

Note: There is no need to fill in the Schedule Section for Accounting Rules of this type. The schedule for such rules is provided during data entry when you specify Rule Start Date and Rule End date or Duration. The same is true for type = Daily Revenue Rate, Partial Periods

5. Example for Type = Specific Date, for this type of rule the dates in which to recognize revenue are hard-coded into the schedule. 6. Example for Deferred Revenue checked.

Note: You can check the Deferred Revenue checkbox for any type of Accounting Rule. The impact of checking the Deferred Revenue checkbox is discussed below.

Following describes each of the fields in the form: Name: Enter a unique and descriptive name for your Accounting Rule Description: Enter text that describes this Accounting Rule Type: You have 4 options for Rule type Fixed Schedule (formerly Fixed Duration), this type prorates 100% evenly across the Number of Periods you specify. Variable Schedule (formerly Variable Duration), this type allows you to later specify, during invoice data entry, the number of periods over which you want to recognize revenue. The next 2 types were introduced in 11.5.10 Family Pack G via the Patch 5684129 : Partial Period Revenue Recognition Backport Project on FP.G. Following are some term definitions: Daily Revenue Rate = Total Revenue / Total Number of Days across all periods Partial Period is when the invoice exists for only part of the period as opposed to all days within the period (see example below). Daily Revenue Rate, All Periods, this type will use a daily revenue rate to calculate the precise amount of revenue for all periods whether it is full or partial. Use accounting rules of this type to meet strict revenue accounting standards which require accurate revenue recognition on a per-day basis. Daily Revenue Rate, Partial Periods, this type is a hybrid between Fixed Schedule and Daily Revenue Rate, All Periods. It will use a daily revenue rate to calculate the precise amount of revenue for the partial periods in the schedule, then prorate the revenue evenly across the full periods. Period: This corresponds to the Period types you defined in Oracle General Ledger (see Oracle General Ledger Implementation Guide, Defining Period Types). Keep in mind that during data entry of the invoice lines, you can only use Accounting Rules that have the same Period as your Ledger. In addition to period types you've defined you can also pick Specific Date, which enables you to enter a specific date in the Date field in the Schedule section discussed below.
https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_adf.ctrl-state=1cf43vt22c_29 3/12

8/3/13

Document Display

Number of Periods: Enter the number of periods you want this accounting rule to recognize revenue across. Deferred Revenue: If you want to delay recognizing revenue, check this check box. When checked, invoices using this rule will have its revenue deferred to an unearned revenue account, and you must later use the Revenue Accounting Management (RAM) wizard to recognize the revenue. Note: Invoices that use a Deferred Rule, will not appear in the Revenue Recognition Report, until Revenue is Scheduled via the Revenue Accounting process. Responsibility: Receivables Manager Navigation: Control > Accounting > Revenue Accounting

Schedule Section: Period: Specify the sequence of the Period starting with 1. Percent: Indicate the percent of the revenue you want to recognize in this period. Total Percent across all periods must equal 100% for Fixed Schedule types. For Variable Schedule types, you are allowed to define the percentage for the first period, which is typically less than 100%. Date: Enter a specific date, e.g. 10-JUN-2010, this field is only enabled if the Period you specified in the header section is Specific Date Notes: If you pick Type = Fixed Schedule, the Schedule section is automatically populated for you with as many rows as you specified in Number of Periods, and the percentage will be evenly spread across all periods to sum up to 100%. If you pick Type = Variable Schedule, you do not need to enter any details in the Schedule Section. However, if you want to recognize a specific percentage of revenue in the first period, you can enter Percent details for Period 1. The remaining percentage will be spread across the remaining periods you specify during transaction data entry.

The following example from the Oracle Receivables User Guide, illustrates the differences in Revenue calculation based upon your Accounting Rules setup: Suppose you bill a contract for $900, which starts January 14 and ends April 13 (90 days), and the accounting period is Monthly. In this contract period, January and April are partial periods, and February and March are full periods. This table illustrates the various revenue recognition schedules that Receivables calculates Daily Revenue Rate is calculated as $900 / 90 days = $10 per day. GL Date Jan 14 Feb 14 Mar 14 Apr 13 Period January February March April Days in Period 18 28 31 13 Daily Revenue Rate, All Periods 180 280 310 130 Daily Revenue Rate, Partial Periods 180 295 295 130 Fixed Schedule 225 225 225 225 Variable Schedule 180 240 240 240

Notes: 1. Daily Revenue Rate is calculated as $900 / 90 days = $10 per day. 2. For Daily Revenue Rate, All Periods: Revenue is a function of the number of days in the period multiplied by the Daily Revenue Rate 3. For Daily Revenue Rate, Partial Periods: the Daily Revenue Rate is used for the partial periods January and April. The remaining revenue is evenly split across the full periods February and March. 4. For the Fixed Schedule, each period gets 25% of the revenue. 5. For Variable Schedule, the setup was defined to recognize 20% during the first period, during data entry 4 periods are specified. 20% will be recognized in January, then the remaining 80% will be split evenly across February to April. For more information, please review the section on Accounting Rules in the Oracle Receivables Implementation Guide

3. Using Invoicing and Accounting Rules

Invoicing and Accounting rules are used for Invoices only . When crediting an invoice with rules, a credit memo inherits the Invoicing and Accounting rules from the Invoice. You specify these values via the Transactions form, when you do manual data entry of invoices, or you pass in the data associated to these rules via AutoInvoice in the RA_INTERFACE_LINES_ALL table.

https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_adf.ctrl-state=1cf43vt22c_29

4/12

8/3/13

Document Display

a. Transactions form
Responsibility: Receivables Manager Navigation: Transactions > Transactions When you create an Invoice, for which you want to specify the timing of the recognition of Receivable and Revenue, you should associate an Invoicing Rule at the Header Level. Enter the data for the invoice, and then make sure you navigate to the Invoicing Rule field, the data entered here is limited to 3 choices: In Advance: Recognizes the Receivable for this invoice on the GL date associated to the first period of your revenue schedule (see below) In Arrears: Recognizes the Receivable for this invoice on the GL date associated to the last period of your revenue schedule (see below) null: No Invoicing Rule, recognizes revenue on the GL date of the invoice.

Notes: You must pick an Invoicing Rule if you want to associate an Accounting Rule in the Lines window. Make sure you enter data in the Invoicing Rule field before you navigate away from the Header page, you will not be allowed to make changes to Invoicing Rule once you move into the Lines page. After entering the header information, navigate to the Lines form by clicking on the Lines button. You need to provide an Accounting Rule for all lines of this invoice in the Rules tab. Enter an Accounting rule, a Duration, and the First Date to start recognizing revenue for this invoice line. Notes: If the period type you specified does not match the period assigned to this ledger, or If your accounting rule spans multiple GL periods and not all the periods have already been defined, you will get an error: A P P A R 1 1 2 2 8 :P l e a s ed e f i n ea l lp e r i o d si nw h i c hr e v e n u ei st ob er e c o g n i z e do r c r e d i t e d .N o t et h a tr e v e n u ec a n n o tb er e c o g n i z e do rc r e d i t e di nc l o s e da n dc l o s e p e n d i n gp e r i o d s . For additional details on this error, please review Note 455691.1, Error: Please Define All Periods In Which Revenue Is To Be Recognized Or Credited (AutoInvoice and Transaction Workbench) Once an Invoice is associated to an Invoicing Rule at the header level, all lines of the invoice need to be associated to an Accounting Rule. If you do not need to specify a schedule for Revenue recognition for a particular invoice line, you can use the seeded Immediate accounting rule to recognize revenue immediately in one period. If you enter an accounting rule whose type is Daily Revenue Rate, All Periods or Daily Revenue Rate, Partial Periods, enter a rule start and end date. Do not enter a duration. If you enter a accounting rule whose type is Variable Schedule, enter the number of periods over which you want to distribute revenue for this invoice line in the Duration field. If you enter an accounting rule whose type is Fixed Schedule, Receivables displays the default duration for this rule.

For additional information, please review the Oracle Receivables User's Guide, To enter an invoice with rules.

b. AutoInvoice
When interfacing data via AutoInvoice, the feeder system will handle populating the fields required to pass on the Invoicing and Accounting Rules. If however, you are populating data into the interface table manually, Receivables will look at certain fields to get Invoicing and Accounting rules information. Depending upon your transaction source setup, Note 1068008.1, Creating Transaction Sources Used For AutoInvoice, in the Accounting Information tab, you indicate whether you will be passing Id or Value. Depending on what value you specify, the following fields in RA_INTERFACE_LINES_ALL need to be populated. Field Name INVOICING_RULE_ID Possible values Value in RA_RULES for seeded data: -2 (In Advance) -3 (In Arrears)
https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_adf.ctrl-state=1cf43vt22c_29 5/12

8/3/13

Document Display

INVOICING_RULE_NAME

Value in RA_RULES for seeded data: Advance Invoice Arrears Invoice

ACCOUNTING_RULE_ID ACCOUNTING_RULE_NAME ACCOUNTING_RULE_DURATION

value from RA_RULES.RULE_ID value from RA_RULES.NAME

For a Variable Schedule Accounting Rule, you need to populate this with the number of periods For Daily Revenue Rate rule, enter a value here if you do not provide a RULE_END_DATE

RULE_START_DATE RULE_END_DATE

Required for Daily Revenue Rate rules for Daily Revenue Rate rules, provide an end date if you did not provide a value for or duration

4. Underlying table information for Invoicing and Accounting Rules

The information presented in this section is not intended to provide a comprehensive list of data model and configuration, but rather just highlights information pertaining to Invoicing and Accounting rules. The data shown is for the invoice created in step 3.a. above. The following shows what fields in the table RA_CUSTOMER_TRX_LINES_ALL, keep track of Invoicing and Accounting Rule information: Field Name INVOICING_RULE_ID ACCOUNTING_RULE_ID ACCOUNTING_RULE_DURATION Description Contains the Invoicing rule id, value = -2 or -3 Contains Accounting rule id Contains the number of periods

AUTORULE_DURATION_PROCESSED Upon creation of an invoice with rules, this field is null. When the Revenue Recognition process is run, this field will get incremented to reflect the number of periods for which revenue has already been recognized. AUTORULE_COMPLETE_FLAG RULE_START_DATE RULE_END_DATE Upon creation of an invoice with rules, this field is N. When the Revenue Recognition process is run and completes processing all periods for this line, this field will get updated to null. Contains the start date Contains the end date (if provided)

Following shows RA_CUSTOMER_TRX_LINES_ALL data using the following select, column aliases were used to compress the data displayed:
s e l e c tc u s t o m e r _ t r x _ i dt r x _ i d ,c u s t o m e r _ t r x _ l i n e _ i dl i n e _ i d ,a c c o u n t i n g _ r u l e _ i dr u l e _ i d , a c c o u n t i n g _ r u l e _ d u r a t i o nd u r a t i o n ,a u t o r u l e _ d u r a t i o n _ p r o c e s s e dp r o c e s s e d ,a u t o r u l e _ c o m p l e t e _ f l a gc o m p l e t e , r u l e _ s t a r t _ d a t es t a r t _ d t ,r u l e _ e n d _ d a t ee n d _ d t f r o mR A _ C U S T O M E R _ T R X _ L I N E S _ A L L w h e r ec u s t o m e r _ t r x _ i d=5 2 6 6 4 6 ;

The values in AUTORULE_DURATION_PROCESSED (null) and AUTORULE_COMPLETE_FLAG (N) indicate that Revenue Recognition has not yet run for this invoice. After completing the invoice, clicking on the Distributions button will show you the current state of the distributions for the invoice. The following screenshot shows the distributions for the invoice in 3.a. above. The presence of Unearned Revenue distributions indicates this invoice uses the Invoicing rule = Advanced Invoice. From the back-end, the data in RA_CUST_TRX_LINE_GL_DIST is as follows. The distributions where GL_DATE is null are known as "model" rows. These distributions will be used as templates by the Revenue Recognition program and will be expanded to reflect the actual distributions containing GL_DATE, AMOUNT and PERCENT values across the multiple periods after the Revenue Recognition process is run.
https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_adf.ctrl-state=1cf43vt22c_29 6/12

8/3/13

Document Display

Note: After creating and completing an invoice in the transactions form, you will only see model rows to be used as templates to create the complete set of distributions. You will not see the complete set of distributions associated to the Accounting Rule until Revenue Recognition is run against the Invoice.

Following shows changes in the data after running Revenue Recognition: Responsibility: Receivables Manager Navigation: Control > Accounting > Revenue Recognition data in RA_CUSTOMER_TRX_LINES_ALL, changes to: The values in AUTORULE_DURATION_PROCESSED (=ACCOUNTING_RULE_DURATION) and AUTORULE_COMPLETE_FLAG (null) indicate that Revenue Recognition has completed processing this invoice. data in RA_CUST_TRX_LINE_GL_DIST_ALL expands to: Rows 7-36 were created by the Revenue Recognition process. Row 33, shows the Receivable amount for the entire invoice was recognized in full on 04-JUN-10. This is the earliest date associated with the rules of the invoice lines. It uses the earliest date, because the Invoicing Rule is In Advance. If the Invoicing rule was In Arrears, it would use the latest date instead. Rows 35-36, show that Revenue is lodged in the Unearned Revenue GL account because the Accounting Rule spreads out the recognition of Revenue across multiple periods. Over each period, a fraction of the Revenue is taken out of Unearned Revenue and moved into Revenue. This is handled by the pairs of REV and UNEARN rows 7-32. For CUSTOMER_TRX_LINE_ID = 822552 (which had Accounting Rule, Monthly, 1 Year), 12 pairs of REV and UNEARN rows were created to recognize Revenue across 12 periods starting from 04-JUL-10. For CUSTOMER_TRX_LINE_ID = 822553 (which had Accounting Rule, Immediate), 1 pair of REV and UNEARN rows was created to recognize Revenue immediately in one period starting from 04-JUN-10. A discussion of Invoicing and Accounting Rules cannot be isolated from the Revenue Recognition process, because it is Revenue Recognition that requires the definition of these rules. However, the above is just to illustrate the concept of Invoicing and Accounting rules. For a more detailed discussion of Revenue Recognition, please review Note 1121944.1, Understanding and Troubleshooting Revenue Recognition.

5. Troubleshooting Invoicing and Accounting Rules

The following highlights issues that have been reported by customers in the past, regarding Invoicing and Accounting rules.

a. Rule Defaulting issues

i. Invoicing and Accounting Rule from setup for an Inventory Item Responsibility: Receivables Manager Navigation: Setup > Transactions > Items > Define items In the Invoicing Tab, you can setup an Accounting Rule and an Invoicing Rule. The values defined here are used to default the rules for invoice lines that are interfaced from Order Management (OM). In the transactions form, when manually creating an invoice, you first need to choose an Invoicing rule at the header level, so that when you navigate to the Lines form and use the same inventory item, the form will be able to default the Accounting rule you set up. If you do not manually choose an Invoicing Rule first, the form cannot default the Accounting rule. ii. Invoicing Rule in transactions form There is no feature to default the value of the Invoicing Rule when entering invoices manually using the Transactions form.

b. Unexpected behavior when using the seeded Accounting Rule = Immediate when interfacing Sales Orders from Order Management (OM)
In Release 11.5, majority of sales orders imported from OM had the seeded Immediate rule (ACCOUNTING_RULE_ID = 1) associated to it. This means that practically 100% of all invoices from OM would have to pass through Revenue Recognition, to process an Immediate rule which was similar to not having any rule at all. In order to avoid the extra overhead on the Revenue Recognition process, OM built in logic to null out the Invoicing and Accounting rule from a Sales order if it was associated to the seeded Immediate Rule. This removed the burden on Revenue
https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_adf.ctrl-state=1cf43vt22c_29 7/12

8/3/13

Document Display Accounting rule from a Sales order if it was associated to the seeded Immediate Rule. This removed the burden on Revenue Recognition. However, it caused Sales Orders meant to be grouped into one invoice to split into 2 or more invoices due to the Grouping Rules associated to Accounting and Invoicing Rules.

To get around this issue, if you want to really associate an Immediate rule to your Sales Order, you are advised to create a userdefined Accounting Rule, with attributes identical to the seeded rule, then use this new rule in OM. This would prevent the logic that wipes out the rules from kicking in, and your sales order will be interfaced with the Invoicing and Accounting Rules intact, and would be grouped into one invoice as expected. Notes: In Release 11.5.10, the code was modified to retain the ACCOUNTING_RULE_ID value of 1 instead of stripping its value to null. Behavior was changed in OEXPINVB.pls 115.221.11510.33, this version is available via the Patch 5853601: January 2007, Order Management (11.5.10) Cumulative Patch In Release 12, this is no longer an issue. OM has removed the logic that wipes out the Invoicing and Accounting Rule for Sales Orders that use seeded Immediate rule. This change in behavior impacts the volume of data reported in the Revenue Recognition Report. A larger set of transactions are picked up by this report because almost all Invoices from OM are now passed in with rules.

c. Explanation of changes to Transaction and GL date in transaction form when using Bill in Arrears
When entering an invoice using Invoicing Rule In Arrears, and a revenue schedule spread over several periods, expect the GL Date you entered at the Header section of the Invoice to be replaced upon saving the Invoice. In Arrears means that the Receivable account will be hit on the last period in which you recognize revenue. As such, the form will wait for you to enter the number of periods, and then it will move the GL Date to the last period to reflect that is when the Receivable will be posted to the General Ledger. For Example: 1. create an Invoice, set Date and GL Date = 07-JUN-2010 2. associate Invoicing Rule = In Arrears 3. go into the Lines section and pick an Accounting rule spread over 3 months, Rule Start Date = 07-JUN-2010. This means revenue will be recognized on 7-JUN, 7-JUL and 7-AUG. 4. Upon saving the invoice, you will get 2 pop-up windows: A P P A R 1 1 4 2 6 :T r a n s a c t i o nD a t eh a sb e e ns e tt o0 7 A U G 2 0 1 0 . A P P A R 1 1 4 2 5 :G LD a t eh a sb e e ns e tt o0 6 A U G 2 0 1 0 . This indicates that form logic has altered the Transaction and GL date to use the last period's date, to conform to the behavior of Billing In Arrears. The pop-up windows are purely information, the form just wants to call your attention that it has changed values that you entered manually. If you do not agree with the new Transaction and GL date, you are free to change it back to the original value, or some other value based upon your business requirements. Note: The latest version of the code no longer changes the Transaction Date based on the Rule date, it now leaves the Transaction Date as is, and only alters the GL Date. This new behavior is available via the following patches: 11i.AR.N: Patch 5952309 11i.AR.O: Patch 6280258 R12.AR.A and R12.AR.B: Patch 6350680

d. Updating Invoicing and Accounting Rules

During data entry of an invoice, please note that Invoicing rules cannot be updated once you have navigated away from the Header section of an invoice. Even prior to saving the invoice, once you move away from the Header form, the field is protected from any updates. Accounting rules can be updated even after an invoice is saved and completed, for as long as the Revenue Recognition program has not yet processed the invoice. Once an invoice is picked up for Revenue Recognition processing, the rule field becomes protected against updates.

e. When choosing an Accounting rule get error

You are attempting to associate an Accounting rule to one of your invoice lines and are hitting the error:
https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_adf.ctrl-state=1cf43vt22c_29

A P P A R 1 1 2 2 8 :P l e a s ed e f i n ea l lp e r i o d si nw h i c hr e v e n u ei st ob er e c o g n i z e do rc r e d i t e d .

8/12

8/3/13

Document Display A P P A R 1 1 2 2 8 :P l e a s ed e f i n ea l lp e r i o d si nw h i c hr e v e n u ei st ob er e c o g n i z e do rc r e d i t e d .

This error is raised when: The Period type associated to your accounting rule does not match the period type of your Ledger. 1. Check the period type associated to your Ledger. Do the following to check: In release 11.5: Responsibility: General Ledger, Super User Navigation: Setup > Financials > Books > Define

In release 12.0: Responsibility: General Ledger, Super User Navigation: Setup > Financials > Accounting Setup Manager > Accounting Setups Search on the Ledger Name Click on the icon Update Accounting Options towards bottom of screen, look for Setup step with the description: Define and update the journal processing options for your ledger, and click on the pencil icon to update. In the Accounting Calendar section, check the value in Accounting Calendar and Period Type

2. Check the definition of the Accounting Rule Responsibility: Receivables Manager Navigation: Setup > Transactions > Accounting Rules Query the Accounting rule used, and check that the value in Period Type for the Ledger, matches the value of the Period in your Accounting Rules definition.

The periods in which your accounting rule is attempting to schedule revenue in do not yet exist in the Calendar. Check that you have defined the periods the Revenue Schedule is attempting to use. Responsibility: General Ledger User Navigation: Setup > Financials > Calendars > Accounting

For additional details on this error, please review Note 455691.1, Error: Please Define All Periods In Which Revenue Is To Be Recognized Or Credited (AutoInvoice and Transaction Workbench)

f. Using Daily Revenue Rate type of periods raises error

You have defined a new Accounting Rule with the type Daily Revenue Rate, All Periods or Daily Revenue Rate, Partial Periods. In the transactions form, you pick this accounting rule and hit the error: F R M 4 0 2 0 7 :M u s tb ei nr a n g e1t o. . . This issue is due to mismatched Period types between the Accounting rule and the Ledger. Please use the steps detailed in 5.e. to troubleshoot the problem.

g. Unexpected Percentages when using an Accounting rule spread over multiple periods
Differences between the actual percentages used in an invoice's distribution versus the percentage defined in the Accounting rule are attributed to Rounding issues. The logic does the following: For example: 1. Calculate the Revenue amount to recognize for the period as line amount * percentage 2. This amount will then be rounded to the minimum accountable unit, e.g. 2 decimal places 3. The percentage associated to this amount will then be re-calculated to account for the changes due to rounding. 4. The distribution will then be created using the amount in step1 and the percentage in step 3. For example: Accounting Rule is defined as follows: Period 1 = 4.1669 Period 2 -12 = 8.3333 Period 13 = 4.1668 An Invoice has line amount = 23.95
https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_adf.ctrl-state=1cf43vt22c_29 9/12

8/3/13

Document Display An Invoice has line amount = 23.95 Calculation for Period 1: 23.95 * 4.1669 = 0.9980, this is rounded up to 1.00 Then the percentage associated to 1.00 is recalculated: 1.00 * 100 / 23.95 = 4.1754

Calculation for Period 2-12: 23.95 * 8.3333 = 1.9958, this is rounded up to 2.00 Then the percentage associated to 2.00 is recalculated: 2.00* 100 / 23.95 = 8.3507 In the last period, the sum of all amounts must match the invoice line amount, and the total of all percentages must be 100.00 Calculate Revenue schedule so far: 1.00 (for Period 1) + 22.00 (for Period 2-12) = 23.00 Remaining Amount: 23.95 - 23.00 = 0.95 Calculate the Percentage schedule so far: 4.1754 (for Period 1) + 91.8577 (for Period 2-12) = 96.0331 Remaining Percentage = 100.00 - 96.0331 = 3.9669 The distributions for this invoice line are then: Period 1 : amount = 1.00, percentage = 4.1754 Period 2-12 : amount = 2.00, percentage = 8.3507 Period 13 : amount = 0.95, percentage = 3.9669 The logic puts a precedence on the amount calculated, and then determines the percentage associated to that amount. Also, Rounding amounts plays a factor in explaining the difference.

h. Issues with dates: Transaction or GL date

i) Variable Accounting rule with over 50 periods If you have a variable accounting rule that span over 50 periods, and a review of revenue distributions created by Revenue Recognition shows that the first 49 periods used correct GL dates, but the rest of the distributions after the 49th period all use the GL date for the 50th period, then you may be hitting an issue wherein the seeded data associated to Invoicing Rule is incomplete. To address this issue, the script populating RA_RULE_SCHEDULES, in $AR_TOP/patch/115/sql/arsdrls.sql needs to be run manually in SQL*Plus. If the following select returns a count of 4000, then the script ran successfully:
s e l e c tc o u n t ( * )f r o mr a _ r u l e _ s c h e d u l e sw h e r er u l e _ i d=1 ;

ii) Other GL date issues If you encounter issues with the GL dates associated to distributions of an Invoice with rules, please take a review Note 201241.1, Troubleshooting AutoInvoice Date Derivation: GL Date, Invoice Date, Due Date, Ship Date, Billing Date, Rule Date.

i. Unable to update fields associated to Daily Revenue Rate in Interface Lines form
When attempting to make modifications or corrections to the Interface Lines form you note that you do not have access to RULE_END_DATE, or in the Accounting Rules field, you do not see rules associated with the types: Daily Revenue Rate, All Periods or Daily Revenue Rate, Partial periods. Ensure you have the latest ARXAIEXP.fmb (see details in section 6 below).

j. Please supply both an invoicing rule and an accounting rule for this invoice.
This error is encountered in the Autoinvoice Execution Report, if either the Invoicing Rule or the Accounting Rule for an invoice that uses rules is not specified. This is due to interface data wherein you did not provide values for both the Invoicing and the Accounting Rule, and an error is raised because both values are required. Check your transaction source setup to determine whether you indicated that you would provide either value or Id, then check the data in RA_INTERFACE_LINES_ALL to ensure that you populated the right fields with proper data. For more information on Transaction Sources, please review Note1088132.1, Troubleshooting Transaction Batch Sources For AutoInvoice

k. The valid values for credit method for accounting rule are: PRORATE, LIFO and UNIT
When passing interface data for a Credit Memo against an Invoice with Rules, you need to provide a value in RA_INTERFACE_LINES.CREDIT_METHOD_FOR_ACCT_RULE, to indicate how you want the credit to impact the revenue schedule of the invoice. Valid values are: PRORATE, will split up the credit amount equally across all revenue periods. LIFO, will apply the credit amounts starting from the last period. UNIT, the credit amount will be based on quantity associated to each line.
https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_adf.ctrl-state=1cf43vt22c_29 10/12

8/3/13

Document Display UNIT, the credit amount will be based on quantity associated to each line.

If this field was populated incorrectly, you can use the Interface Lines form to clear out the value in this field. Responsibility: Receivables Manager Navigation: Control > AutoInvoice > Interface Lines Alternatively, you can run an update statement like the following to correct the data, you may also change the where condition to use the INTERFACE_LINE_ATTRIBUTE* fields to identify the specific row you want to fix:
U p d a t eR A _ I N T E R F A C E _ L I N E S _ A L L S e tC R E D I T _ M E T H O D _ F O R _ A C C T _ R U L E = ' & e n t e r _ p r o p e r _ v a l u e ' W h e r en v l ( I N T E R F A C E _ S T A T U S ,' ~ ' )! =' P ' a n dS A L E S _ O R D E R=& s a l e s _ o r d e r _ w i t h _ e r r o r;

6. Code Bugs
When dealing with issues related to Invoicing or Accounting Rules, it is always beneficial to ensure that you are in the latest code to avoid hitting issues that have already been addressed by code fixes. Make sure you are on the latest file version available for the following files. Note: Patch numbers provided may be for an issue not related to Invoicing or Accounting rules, however the patch contains the latest version of the file that impacts rules. Patches listed are the latest available as of Last Update date of this note. Some patches in Release 12 will not be available for download in My Oracle Support, please contact support for assistance.

Filename

Description

Release 11.5 Mini-pack version number patch number

Release 12 Point release version number patch number 12.0: 120.42.12000000.2 baseline 12.1: 120.53.12010000.19 baseline

OEXPINVB.pls

When interfacing from 11.5.10: Order Management, this 115.221.11510.33 file handles what value is 5853601 passed in for ACCOUNTING_RULE_ID and INVOICING_RULE_ID. The version listed here is when logic was changed to stop nulling out the value in these fields when the seeded accounting rule = Immediate is used.

ARXLAEVB.pls

handles creation of accounting events Forms library handling logic for Transaction lines

n/a

12.0: 120.48.12000000.20 7229913:R12.AR.A

ARXTWLIN.pld

AR.O: 12.0: 115.103.15104.27 120.56.12000000.14 9249157 8310721:R12.AR.A AR.O: 115.19.15104.3 8545749 AR.O: 115.45.15104.6 9578708 12.0: 120.6 baseline 12.0: 120.22.12000000.13 8557277:R12.AR.A 12.1: 120.25.12010000.3 6678700

RAXSURUL.fmb Accounting Rules form

ARXAIEXP.fmb

Interface Exceptions form

https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_adf.ctrl-state=1cf43vt22c_29

11/12

8/3/13

Document Display

7. Still Have Questions?

To discuss this information further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the My Oracle Support Receivables Community. To provide feedback on this note, click on the Rate this document link.

If you feel that a Service Request is needed, please be sure to provide the information listed below. If you are encountering the issue in AutoInvoice: Are you able to replicate the issue with a manual invoice created via the Transactions Workbench? Include the AutoInvoice Exception Report (if any). Include the AutoInvoice Concurrent Process log file (see Note 1079666.1). Enable and include the FND debug log file generated by AutoInvoice (see Note 1079666.1). Oracle Diagnostics - Oracle Receivables AutoInvoice Interface Data Collection Test - this will show what your interface data looks like Include output from the following Oracle Diagnostics: Oracle Receivables Transaction Data Setup Test - this will show what the created transaction looks like. For information on Oracle Diagnostics, please review the Diagnostic catalogs for your release as noted below: Release 11.5: see Note 179661.1, E-Business Suite Diagnostics 11i Test Catalog Release 12.x: see Note 421245.1, E-Business Suite Diagnostics References for R12 Once you have identified your release, locate the note for the specific diagnostic you would like to run. For example, in 12.0.6, Note 732203.1, R12.0.6+ : Oracle Receivables AutoInvoice Interface Data Collection Test.

REFERENCES
NOTE:1067402.1 - AutoInvoice Setup for Release 12: A Case Study Using a Simple Script NOTE:1068008.1 - Creating Transaction Sources Used For AutoInvoice and the Transactions Workbench [Video] NOTE:1075757.1 - Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12 NOTE:1079666.1 - How to Capture a Debug Log or Trace File and Diagnostics for AutoInvoice in 11i and R12 NOTE:1088132.1 - Troubleshooting Transaction Batch Sources For AutoInvoice and Transactions Workbench NOTE:1116934.1 - How To Setup And Troubleshoot Invoicing Rules and Accounting Rules NOTE:1121944.1 - Understanding and Troubleshooting Revenue Recognition in Oracle Receivables NOTE:1320546.1 - Information Center: Overview of the Transactions Workbench in Oracle Receivables (AR) 11.5 and later NOTE:179661.1 - E-Business Suite Diagnostics 11i Test Catalog NOTE:201241.1 - Troubleshooting AutoInvoice Date Derivation: GL Date, Invoice Date, Due Date, Ship Date, Billing Date, Rule Date NOTE:421245.1 - E-Business Suite Diagnostics References for R12 NOTE:455691.1 - AutoInvoice & Transaction Workbench Error: Please Define All Periods In Which Revenue Is To Be Recognized Or Credited NOTE:732203.1 - R12.0.6+ : Oracle Receivables Transaction Data Setup Test

https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_adf.ctrl-state=1cf43vt22c_29

12/12