Journal Entry------------- 1. How to delete a Journal Batch? The delete icon is grayed out. The Journal Batch does not have journals associated and it is unposted.
Answer ------ The journals/enter first popup form looks only for batches with journals.
a. Go to Journals > Enter. b. When the Find Journals window appears, click on the 'X' in the upper right corner to close the window. c. Click the Review Batch button on the Enter Journals form. This will bring up the Find Batches window to query the batch. d. Enter the batch Name and the Period. e. Click the Find button and the batch should be displayed on the Batch window now. f. Now it is possible to click on the delete icon to delete the unposted journal batch. Note 1036784.6
2. Why does an accounting period not appear in the accounting Periods list of values on the journal entry form?
Answer------ The accounting period list of values displays periods that have a closing status of Open (O) or Future Enterable (F). New journal entries can be defined in open and future enterable accounting periods. New journal entries can be posted only in open accounting periods.
3. Why can not a journal batch be deleted or modified?
Answer------ A journal batch can not be deleted or modified under the following circumstances: a. The source is frozen b. Funds have been reserved for the batch c. Funds are in the process of being reserved for the batch d. The batch is in the process of being posted e. The batch is posted f. The batch is approved g. The batch is in the process of being approved
A journal batch should not be updated if it comes from a sub-ledger. Changing accounting information in a journal that originated in a sub-module will unsynchronize the accounting information between the ledger and the sub-ledger. Instead of changing the sub-ledger journal, define a new journal to adjust the accounting information if necessary.
A journal batch that has funds reversed can not be updated because the funds would not be re-reserved appropriately.
4. Which report shows details of a posted journal batch?
Answer------ Journals - General (180 Char) and Journals - General (132 Char) reports display information relating to a particular journal batch.
5. Is there a report that displays information of one specific journal entry - unposted/posted?
Answer------ No. General Ledger reports display information of journal batches that are posted or unposted. Note 200787.1 give a workaround solution.
6. Can a posted journal batch be deleted?
Answer------ No, a posted journal batch can not be deleted. Reverse it to nullify the accounting effects of the posted journal batch. See Note 135532.1.
7. Is possible to restrict users from entering negative amounts in journal lines?
Answer------- Unfortunately, it is not possible to restrict users from entering negative amounts in journal entry lines.
8. How to set up journal approval in General Ledger?
Answer------ This is set up using Oracle Workflow Builder. The complete procedure is explained in Note 176459.1
9. How do you attach an Excel spreadsheet to a journal entry in Oracle General Ledger?
Answer------ Please refer to Note 1074918.6.
10. How do you easily copy a journal entry from one set of books to another?
Answer------ There is no standard feature to copy journal entries between sets of books. However, there are some alternatives. See Note 204082.1.
Reversing Journals------------------11. An entire batch was reversed and posted, while trying to reverse and post just one journal entry in the batch. How can this be corrected?
Answer------ When you reverse an entire batch, one reversal batch is created for each journal in that batch. To correct your problem, reverse the reversal batches that contained the journals you reversed by mistake, and then post them.
12. Why is there a reversed posted journal in the next accounting period of a non posted journal?
Answer------ This is the current functionality. Reversing journals can be posted before the original journal is posted. Note 176329.1
13. Why is the reversal period of a journal being cleared out after the period is changed?
Answer------ This is the expected functionality in Release 11i. When you change the period of a journal, the application can not determine what you want to do with the reversal period, so it is cleared.
14. A journal entry with a source set up for automatic reversal is not reversed.
Answer------ General Ledger automatically submits the Auto Reverse program when a period is opened if the profile option, GL: Launch Auto Reverse after Open Period, is set to Yes. If a journal is created after the period has already been opened, then the Auto Reverse program will need to be submitted manually.
15. Does the reversal program generate separate reversal batches-journals for each journal in a batch that is reversed?
Answer------ Yes. When a batch is reversed, General Ledger creates a reversing journal entry for each journal entry in the batch. Note that this also generates a separate reversal batch for each reversed journal. 16. How do you reverse a journal entry that was already reversed, but its reversed journal was deleted?
Answer------ General Ledger does not allow you to reverse a journal entry twice. Confirm that the first reversed journal entry does not exist in the system. Contact Oracle Support for the solution to Note 145043.1. 17. How do you restrict the ability to reverse unposted journals?
Answer------ Unposted journals can be posted, this is the intended functionality. Additional information can be found in Note 172016.1.
18. How do you automatically generate a reversal journal entry for a journal category in the previous accounting period?
Answer------ Automatic Journal Reversal is a feature that is included in Release 11i. Additional information can be found in Note 151920.1.
Wednesday, March 26, 2008
GL & AR FAQs
GL & AR FAQs
9. How many Flex fields are there in AR and what are they?
10. What is MRC and what is its use?
Ans: The Multi Reporting Currency Feature allows you to report and maintain records at the transaction level in more than one functional currency. You can do by defining one or more set of books in addition to primary set of books.
11. How many reporting currencies can be attached to Primary Set of Books?
12. What are the new features in Release 11I?
14. What is FSG and what is its use?
Ans: FSG is a powerful and flexible tool you can use to build your own custom reports without programming. FSG is only available with GL.
15. What are Different types of transactions in AR?
16. What are value sets?
17. What do you mean by HZ_ in customer tables?
1. What are different period types?
2. What are different types of Journal entries?
3. What are the setup steps for testing?
5. What is an Invoice? How many types of invoices are there in AP and AR?
6. What id recurring invoices?
7. What are AP setup steps?
10. If any conflict occurs in FSG who will override Column Set or Row Set?
13. What is Set of Books? What are the four conditions when you change your SOBs
17. What is the difference between cross-validation rules and security-rules?
18. In how many ways can you enter a journal in GL?
19. What are the setup steps for AP, AR, and GL?
21. What is the difference between discounts and adjustments?
22. What are different types of invoices and what is a recurring invoice?
23. What are cycles of GL, AP, and AR?
24. What are Summary Accounts and Rollup groups?
9. How many Flex fields are there in AR and what are they?
10. What is MRC and what is its use?
Ans: The Multi Reporting Currency Feature allows you to report and maintain records at the transaction level in more than one functional currency. You can do by defining one or more set of books in addition to primary set of books.
11. How many reporting currencies can be attached to Primary Set of Books?
12. What are the new features in Release 11I?
14. What is FSG and what is its use?
Ans: FSG is a powerful and flexible tool you can use to build your own custom reports without programming. FSG is only available with GL.
15. What are Different types of transactions in AR?
16. What are value sets?
17. What do you mean by HZ_ in customer tables?
1. What are different period types?
2. What are different types of Journal entries?
3. What are the setup steps for testing?
5. What is an Invoice? How many types of invoices are there in AP and AR?
6. What id recurring invoices?
7. What are AP setup steps?
10. If any conflict occurs in FSG who will override Column Set or Row Set?
13. What is Set of Books? What are the four conditions when you change your SOBs
17. What is the difference between cross-validation rules and security-rules?
18. In how many ways can you enter a journal in GL?
19. What are the setup steps for AP, AR, and GL?
21. What is the difference between discounts and adjustments?
22. What are different types of invoices and what is a recurring invoice?
23. What are cycles of GL, AP, and AR?
24. What are Summary Accounts and Rollup groups?
FSG FUNCTIONAL FAQs
FSG Functional FAQ
1. How do I find the latest FSG patch that is available?
For the General Ledger Patch List, on MetaLink, click on Top Tech Docs...General Ledger...Patchset Information (Note 159239.1).
2. Is there a way to suppress zero amounts on the FSG Report?
You cannot suppress individual zero amounts in FSG. However, when all the values in a row or column are zero, you can have FSG suppress them all. To do this, make sure the Display Zero option is unchecked on the appropriate Rows or Columns window.
3. How do you print credit amounts on the FSG Report as positive instead of negative numbers?
For a related row or column definition, check the Change Sign checkbox. Credit amounts for this row or column will now print as positive numbers. Negative credits will print as negative numbers. Note that this changes the sign for display purposes only.
4. Can I display account descriptions on the FSG Report in addition to the account segment values?
Yes. You simply have to define a Row Order, then, assign it to your report. In your Row Order, set the Account Display options of the account segments for which you want to print descriptions. Select Value and Description as your segment display method. Also, make sure that you set the printing width, so there is enough room to print both the segment value and the description.
5. Is there a limit on how large a FSG Report can be?
Yes. The column set width of an FSG report cannot exceed 255 characters. In release 11i, the column set width can exceed 255 characters. (However, while printing, there is still a limit of 255 characters.)
6. What is the profile option 'FSG: Expand parent value' used for?
This profile option controls the expansion of parent values when requesting summary balances. The following values are available to you:
Yes: FSG uses the rollup group to determine whether to expand a parent value into its child ranges. If the parent value belongs to a rollup group, FSG does not expand the parent value into its child ranges. If the parent value does not belong to a rollup group, FSG expands the parent value into its child ranges.
No: FSG uses the summary flag associated with the flex-field assignment to determine whether to expand a parent value into its child ranges. If the summary flag is set to Yes, FSG does not expand the parent value into its child ranges. If the summary flag is set to No, FSG expands the parent value into its child ranges.
The default value for this profile option is No.
Note 1012620.102 provides more information regarding this profile option.
7. I am trying to display budget amounts in my reports but they are not showing up. What is wrong?
Since Oracle GL allows you to define multiple budgets, you must indicate what budget you want displayed in the row or column. You do this by first assigning a Control Value in the Balance Control section of the Row or Column window. The control value is any numeric value. Next, you must tell FSG what budget relates to the Control Value. You do this in the Define Report form. When you define a control value for either your Row Set or Column Set in your report, the Control Value button will be activated.
By selecting the Control Value button you can assign budgets to your control values. Another reason you may not be seeing your amounts is if you are using the YTD-Budget (FY End) amount type, but have not budgeted to every period in the fiscal year. See Note 1036437.6.
8. How do you enable FSG security?
First, you define security rules for specific account segment values. Then, you assign your security rules to specific responsibilities. Lastly, you set the profile option 'FSG: Enforce Segment Value Security' to YES.
Flex-field value security has been enhanced in Release 11.5, with hierarchical security. Instead of having to create security rules for a range of segment values, you can assign security rules at the parent level and have the rules automatically apply to all of the child values within the parent hierarchy. To use this, choose the Security Type of Hierarchical for the value set, on the Value Sets form. See Note 138143.1 for more information.
9. How can you add/define/create your own new amount types in FSG reporting?
Oracle comes with seeded amount types, which can be specified in the Balance control region of a FSG row or column definition. You cannot create your own.
10. Where should the period offset and the amount type be specified?
The period offset and amount type must both be specified in the row set or both be specified in the column set. You cannot have a period offset in the row set and an amount type in the column set, or vice versa.
11. On a calculation column, can I enter an amount type?
You should not define rows or columns that contain both calculation information and an amount type. If you do, the amount type will override and this may cause errors.
12. Is there a quick and supported method of transferring FSGs between environments, so that users do not have to key them in twice?
Run the FSG Transfer program (under Report/Request/Standard) to copy report objects from one General Ledger database (or instance) to another. You can copy row sets, column sets, reports, report sets, content sets, row orders, display sets, and display groups.
Prerequisites
- You or your System Administrator must define database links.
- The chart of accounts in the set of books in your source database must be identical to the chart of accounts in the set of books in your target database.
- Any currencies and sets of books referred to by the row sets and column sets being copied must exist in the target database.
- Report details, such as budgets and encumbrance types, referred to by
copied reports must exist in the target database.
- You must be logged into General Ledger and connected to the target database.
- The target and source apps releases must be the same. See Note 1083689.6 for more information.
If any of the prerequisites are not met, you will not be able to use FSG Transfer to copy the report objects. You will have to enter them manually in the target set of books.
13. What FSG enhancements are introduced in Release 11i ?
Unlimited Width Reports
Oracle General Ledger now allows you to create FSG reports with an unlimited number of columns. FSG will pick the widest of the column set header or the total width of all the columns to determine the width of the report. However, while printing, there is still a limit of 255 characters.
Absolute Value Function in Reports
To ease reporting, you can now use the absolute value function in row set definitions to display amounts as positive numbers, regardless of their debit or credit balances. This function is helpful for defining income statements, balance sheets, and other financial reports in which amounts are generally displayed as positive numbers.
14. Can I remove the 'No specific Company requested' text from the FSG heading?
The text 'No specific Company requested' will appear as long as no content set is used for the report. A content set must be specified for this text not to appear. Depending on the content set parameters the actual segment value description or the text 'No specific Company requested' will appear. For example, when Display is set to 'PE' a separate report is generated for each value and the specific value's description is displayed, rather than 'No specific Company requested'. This text will also change if you enter a Segment Override for Company (segment) at runtime on the Run Financial Reports form. By doing this, you are running the FSG for only the Company value you specified.
15. Can I remove the segment header descriptions from the top of the FSG reports?
The accounting flexfield segment headings (CO, REG, etc.) can be removed with the use of a Row Order. See Note 1037253.6 for instructions on how to do this.
16. Can I customize or move the 3 heading lines that appear at the top of the FSG (set of books, report name, period)?
The first line of the FSG report heading contains the set of books name. This information can not be changed.
The second line of the FSG report heading contains the report name.
For Release 10, this is the Row Set name that is used in the FSG.
For Release 11 and 11i, this report name is defined in the Report definition (Navigation = Reports/Define/Report).
The third line contains the period that the FSG is being run for. This can not be changed.
The date and time in the upper right corner indicates when the report
was created. The page number appears here also. This can not be changed.
ADI can be used to publish the FSG report, using a theme that you customize to make some of these changes. See the Application Desktop Integrator User's Guide for more information.
17. How can I display USD and STAT amounts on the same FSG report?
On the Define Rowset form:
Make sure you have the following set up:
STAT Accounts
-- Set the 'Currency' field to STAT for accounts that are STAT only.
-- Set the 'Control Value' field to 1 for accounts that are STAT.
USD Accounts
-- Set the 'Currency' field to USD.
-- Leave the 'Control Value' field blank for USD accounts.
On the Define Column Set form:
Under Balance Control Option - Do not input any Currency or Control values
(i.e. leave fields blank). (If you enter a Currency on the Column also, FSG will report 0 in intersection of the row and column.)
18. How can I report on a multiple level account hierarchy in an FSG?
To report on Multiple Hierarchy levels (child, parent, grandparent, etc.) in FSGs you have to have as many sequences in the row set as the number of parents/grandparents/great-grandparents that you wish to report on. You can not report on all levels by defining a single row sequence.
See Note 1014255.102 for more information on how to do this.
19. How can I define an FSG percentage calculation Column such as percent of sales?
When defining a row, you can enter a value in the 'Percent of Row' field. The value entered in this field is the sequence number of the row, that will be used as the denominator in the calculation of the percentage column.
See Note 1014921.6 for detailed instructions.
20. Can an FSG output be created in PDF format?
No. That functionality is not available. Enhancement Request 1569021 has been logged for this.
21. What is the meaning of 'n/m' on my FSG?
The means 'no meaning'. FSG displays this when there is a calculation that is attempting a divide by zero. You cannot remove this, or change it to any other value (other than changing the calculation itself so it doesn't result in a divide by zero).
22. I used column set builder to set the width of the last column in my report. After saving and requerying the column set, the width has changed. Why?
The width of the last column can only be controlled through the format mask. Define the format mask of the last column to be as wide as the desired width of the column.
23. Can FSG reports and components be secured/protected so only certain people can modify or run them?
No. You can only restrict/protect the data that is reported on in the report. You cannot restrict access to the reports and components themselves.
24. How do segment overrides, content sets, account assignment ranges and display types work together?
For a detailed explanation, see Note 207779.1.
25. When hiding data using a Display Group/Set in FSG the underline under that data still appears.
The underline character is part of the format option and is not affected by the display set definition, which only hides the actual data. The work around is to remove the underline from the row definition prior to running the report.
26. I'm using a Content Set with a range of cost centers. There are some inactive cost centers within that range. How can I suppress the creation or printing of the reports for those inactive cost centers, or for disabled or inactive accounts?
There is no way to exclude particular values that are included in the range you defined in the content set, or in an account assignment range in a row or column set. You must define new ranges that do not include those inactive cost centers or accounts.
27. How can I define a column to be for a specific or constant period, such as January of the current year, or dynamically change the period?
This functionality is not available. FSG uses the period Offset, and the runtime period you enter, to determine which periods to report on. Use a negative number to report on periods prior to your runtime period, and a positive number to report on periods after your runtime period. For example, a column with an offset of 0 will contain amounts for the period you entered at runtime. A column with a -1 offset will contain amounts for the prior period, a -2 will contain amounts for a period 2 earlier than the runtime period. An offset of 1 will give you amounts for the period following the runtime period (providing that period has been opened before).
28. Why can some column sets be viewed/used with different sets of books and others cannot?
If account assignments have been defined in the column set, then that column set is only available to sets of books that use that same chart of accounts. If there are no account assignments in them, and the same chart of accounts (accounting flexfield structure) is used between sets of books, then they should be available to all of those sets of books.
29. How do I see the SQL code behind the FSG report?
The FSG reports are created from a program written in 'C' code, not from Oracle Reports, as is the case with standard reports. Many modules and tables are used to create reports based on the definition and component of a particular FSG. This would make looking at code for an FSG report (as you would a standard report) almost impossible. One approach is to turn the profile FSG: Message Detail to FULL and run the report. The logfile will contain some of the SQL. A session level trace will provide all of the SQL. See Note 141278.1 for information on how to get the trace.
30. How do I show the YTD amount for the end of the fiscal year on an FSG?
In Release 11i, there is a patch available (2650861) that will allow you to use an amount type called YTD-Actual (FY End). Used without a period offset, FSG will give you the YTD balance for the fiscal year the report is run for. This amount type only pertains to the very last period of the current fiscal year and the status of that period must be Open or Closed. Current fiscal year means the year the period you are running the FSG for falls into. If you use a period offset with the YTD-Actual (FY-End) amount type, and the resulting period falls into another fiscal year, it will get the year to date balance for that year.
In release 11.0 and 10.7, you must still use the YTD-Actual amount type and the offset for the last period of the year.
31. Can I create an FSG in html format?
Not from the standard application. In the applications you have a choice of 3 output options: 1) Text, 2) Tab-delimited - for importing into a spreadsheet, or 3) Spreadsheet - for downloading to ADI. You can create an FSG in html format in ADI (Applications Desktop Integrator).
32. How can I run an FSG from the Standard Request Submission form?
Add the program 'Program - Run Financial Statement Generator' to your Request Group. See Note 1060806.6 for detailed instructions.
33. When using a content set, sometimes the amounts are duplicated (doubled or tripled).
The values defined in a content set override the values defined in the row set account assignments. Depending on how your account assignments are structured, this may result in duplication of the account assignment ranges. See Note 147218.1 for an explanation and workaround.
-----------------------------------------------------------------------
Note:1012620.102PROBLEM DESCRIPTION:
You are not getting the results you expected in your Financial Statement Generator (FSG) reports when using parent values.
How is the profile option, 'FSG:Expand Parent Value' used?
PROBLEM EXPLANATION: The Oracle General Ledger documentation (User's Guide and Reference Manuals) describe this profile option, but the explanation is not clear.
Here is the profile option documentation from the manuals:
Control the expansion of parent values when requesting summary balances. The following values are available to you:
Yes: FSG uses the rollup group to determine whether to expand a parent value into its child ranges. If the parent value belongs to a rollup group, FSG does not expand the parent value into its child ranges. If the parent value does not belong to a rollup group, FSG expands the parent vaue into its child ranges.
No: FSG uses the summary flag associated with the flexfield assignment to determine whether to expand a parent value into its child ranges. If the summary flag is set to Yes, FSG does not expand the parent value into its child ranges. If the summary flag is set to No, FSG expands the parent value into its child ranges. The default value for this profile option is No.
SEARCH WORDS: summary account, balance, summary flag, rollup group, child range,detail account, financial statement generator, row set, accounting flexfield range, account range, FSG
REFERENCES: Oracle General Ledger Release 10SC, User's Guide, part number A21643-7, pages B-5 through B-6.
Oracle General Ledger Release 10.7 Volume 2, Reference Manual, part number A13113-5, page C-4.
SOLUTION DESCRIPTION: The FSG:Expand Parent Value profile option controls whether FSG expands a parent value into its child ranges or uses the parent value.
The summary flag contols whether FSG looks for summary accounts or detail accounts.
Yes: FSG uses the Rollup Group to determine whether to expand a parent value into its child ranges. If the parent value belongs to a rollup group, FSG does not expand the parent value into its child ranges. If the parent does not belong to a rollup group, FSG expands the parent value into its child ranges.
No: FSG uses the Summary Flag associated with the flexfield assignment to determine whether to expand a parent value into its child ranges. If the summary flag is set to Yes, FSG does not expand the parent value into its child ranges. If the summary flag is set to No, FSG expands the parent value into its child ranges.
The following are the possible scenarios:
Example 1: FSG:Expand Parent Value = Yes , Summary Flag = Yes
Parent Value belongs to a Rollup Group
Result: FSG looks for summary accounts that have this parent value for this segment. It does not expand the parent value into its child ranges.
Example 2: FSG:Expand Parent Value = Yes , Summary Flag = Yes
Parent Value does not belong to a Rollup Group
Result: FSG expands the parent value into its child ranges, then looks for summary accounts that have values for this segment that are within these child ranges. (The summary template associated with this summary account would have to have a 'D' for this segment.)
Example 3: FSG:Expand Parent Value = Yes , Summary Flag = No
Parent Value belongs to a Rollup Group
Result: FSG looks for detail accounts that have this parent value for this segment. It does not expand the parent value into its child ranges. It is never going to be successful.
Example 4: FSG:Expand Parent Value = Yes , Summary Flag = No
Parent Value does not belong to a Rollup Group
Result: FSG expands the parent value into its child ranges, then looks for detail accounts that have values for this segment that are within these child ranges.
Example 5: FSG:Expand Parent Value = No , Summary Flag = Yes
Result: FSG looks for summary accounts that have this parent value for this segment. It does not expand the parent value into its child ranges.
Example 6:FSG:Expand Parent Value = No , Summary Flag = No
Result: FSG expands the parent value into its child ranges, then looks for detail accounts that have values for this segment that are within these child ranges.
Note:1036437.6PROBLEM DESCRIPTION:
When you run your Financial Statement Generator (FSG) report for the month of July, the amount type YTD-budget (FY End) column prints zeroes.
You have budgets for January through June, but nothing specified for July.
SEARCH WORDS: FSG Financial Statement Generator
SOLUTION DESCRIPTION:
In order for the amount type YTD-BUDGET (FY END) to print, you MUST enter a budget for all periods including the adjusting period. This is documented on page 3-111 of the General Ledger Reference Manual for release 10.7. You can enter a number in the adjusting period and run the report again. This forces the report to print correctly.
Note: If you set up the budget for 12 periods without an adjusting period, you cannot add an adjusting period or change the last period of the budget once the budget setup process is completed.
Note:138143.1
QUESTIONS & ANSWERS:
1. I have defined a security rule and assigned it to my responsibilty, but is still does not work, why?
Answer: Make sure that you have enabled security at both the segemnt and value set levels, it must be enabled at both these levels to work. Also make sure you have switched out and back into the responsibility.
2. My security rules don't work for the Account Analysis and General Ledger reports in Release 11.0.3.
Answer: This functionality is available starting in Release 11i. In Releases 11 and lower, one cannot set security for standard reports. Security Rules will only limit users from a few functions (e.g. Account Inquiry, Budgets, Journal Entries, and FSGs). In addition,in Release 11i there is limited use of the security rule functionality for running standard reports. It appears that your goal is to restrict users from submitting reports for a particular company, this cannot be accomplished using security rules.
3. In Rel 11i with the intercompany segment being used, is it possible to have a security rule on the balancing segment (company) without it affecting the intercompany segment, since they share the same value set?
Answer: Yes it is possible. You would enable security on the value set, but then on the flexfield segment (intercompany) you would not enable security.
4. Is there a way to assign different security rules to a responsibily based on the User ID?
Answer: You cannot apply different security rules to the same responsibility for different users based on the user ID. You will have to create a new responsibility and define its own security rules. Then you can assign the new responsibility to one of the users.
5. Can security rules be used to control the posting of journal entries?
Answer: Security rules apply only with regards to creation/modification of lines within a journal. They do not apply when the journal is posted.
6. Security rules don't seem to work on all forms when performing a query.
Answer: Flexfield Value Security gives you the capability to restrict the set of values a user can use during data entry. With easy-to-define security rules and responsibility level control, you can quickly set up data entry security on your flexfield segments and report parameters. Flexfield Value Security lets you determine who can use flexfield segment values and report parameter values. Based on your responsibility and access rules that you define, Flexfield Value Security limits what values you can enter in flexfield pop-up windows and report parameters.
Security rules for the Accounting Flexfield also restrict query access to segment values in the Account Inquiry, Funds Available, and Summary Account Inquiry windows. In these windows, you cannot query up any combination that contains a secure value. However in all other forms, you will be able to query up a value even if it is restricted to the user.
Reference Oracle Applications Flexfield Guide Release 11, page 5-10.
7. Can Security Rules prevent users in one organization in the same set of books from adding Cross Validation Rules to another organization?
Answer There is not a way in the same set of books, to prevent users from one operating unit via security rules, from changing cross validation rules for another operating unit. The only way to do this would to be create a separate set of books for each operating unit. Since security rules prevent users from either viewing data or entering data in general, they do not pertain to set up issues such as creating cross validation rules.
Therefore, the only other way to prevent one user from one organization from creating cross-validation rules to the other organization, when in the same set of books, would be to completely remove that menu function from the user.
8. Every Country has a Global Manager or User Responsibility to access Global SOB but it is supposed to limit users to their own Legal Entities. However, an Argentian journal can be posted by the Chilian user. How is this possible?
Answer This is working as intended. Security rules will prohibit a responsibility from being able to ente certain values as well as prohibit the viewing of those values. However security rules will not prohibit the actions above because they are in the same set of books. The system does not determine if a journal has values in it that are blocked by security rules. If it did that, the journal would appear as unbalanced. There would have to be an incredible amount of logic involved, which would further reduce performance, for the posting program to scan the journal for security rules first before posting. Posting does not take into consideration the rules, this is done at the time of journal entry.
9. Forgot to check the security enabled flag for each segment and it is not updatable. How do I correct this?
Answer Check your Accounting Flexfield structure to see if it is frozen. Unfreeze the structure, then you should be able to enable Security for the Segment.
10. In General Ledger, a security rule of a parent with children was set up to include the parent and assigned to a responsibility. However it is not functioning properly.
Answer: The system allows the account the customer wanted but doesn't disallow the ones that are children of the parent values excluded. Review note OSS177300 Titled: Key Flexfield Rollup Hierarchical Security not Working Properly.
11. Is it feasible to delete an Exclude statement in order to resolve a Security Rule issue?
Answer The Security rule should not be modified by deleting an exclude or include as it may corrupt the rule. Instead, delete all rule lines (include and excludes), save and redefine the include and excludes. If the rule still doesn't work, create a new rule and assign it to the responsibilities in place of the original rule.
12. What standard reports have security enabled in Release 11i?
Answer Trial Balance, Account Analysis and General Ledger are the only standard reports in Release 11i for which security rules apply.
13. Is it recommended to use a universal Include when setting up rules?
Answer It is recommended to start each security rule with a universal Include statement and then eliminate each value using Exclude statements.
14. What functions do security rules apply to?
Answer Security rules apply to Account Inquiry, budgets, FSG's and journal entry functions. In Release 11i, this also applies to several standard reports (listed previously). Please note, they do not apply to the posting of journals or the review of journals. When reviewing a journal with security rules, the totals are still displayed, it is only the individual lines that are not visible. This is standard functionality.
15. What is Hierarchical Security?
Answer Please see Note:164769.1 for information regarding this new feature. For addition information go to Metalink:
1. Logon to Metalink.
2. Select Top Tech Docs -> Top Tech Docs button (it says 'Click for the original Top Tech Doc pages') -> ERP Applications -> Financials -> General Ledger
-> Documentation -> Release 11i General Ledger Product Documentation ->Doc Update Oracle General Ledger User's Guide, Hierarchical Security
Note:1083689.6Problem Description
-------------------
Running: RGRXFR - Program - FSG Transfer and receiveing an error.
Responsibility = General Ledger Super User
Navigation = Reports -> Request -> Standard
Report/Program Name = Program FSG - Transfer (RGRXFR)
Running this program completes in error and produces a log file with a error
message much like the following:
Encountered error while transferring report '&REPORT'
Cancelling transfer of this report
DECLARE * ERROR at line 1:
ORA-00904: invalid column name
ORA-06512: at line 147
Program exited with status 1
Cause: The program completed execution -in particular with status 1
Solution Description
--------------------
You are trying to transfer FSG Report Objects from a 10.7 Applications
instance to a Release 11 or 11.5 Apps instance.
You cannot transfer objects from one release to another. In Release 11/11.5, changes have been made to the tables, eg. the addition/removal of columns etc. Therefore when you try to transfer, the process RGRXFR cannot find the column name it is being referred to.
Search Words
------------
rgrxfr, status 1, ora-6512
Financial Statement Generator
Note:1037253.6Problem Description
-------------------
You are trying to run an FSG (Financial Statement Generator) report which
will NOT show segment descriptions on the top of the rows as follows:
Responsibility = General Ledger Super User GUI
GUI Navigation = Reports/Request/Financial
GUI Form Name = RGXGRRST (Run Financial Reports)
1. Navigate to Reports/Request/Financial.
2. Place your cursor in Report field and select the report to run by clicking on Query/Find or the Find icon (flashlight) on the toolbar.
3. After report is selected, place cursor in the Period field and enter or select from list of values (LOV) the desired report period.
4. Click on the [Submit] button to submit this report. When this report is generated, you do not want the header descriptions for particular account segments to be displayed. An example of the report header would be -
Currency: USD
No Specific Company requested
CO REG CC ACCT PRD SUB
--- ---- --- ----- ---- ----
Solution Description
--------------------
You will need to define a Row Order to be used with the FSG in order for the headings to NOT display. The row order must contain all segments of the flexfield. To suppress the header description for particular account segments, set the width to 0 for those segments. Attach the row order to the FSG report.
To do this, sign into Oracle applications as General Ledger Super User GUI and follow the steps listed below:
I. Define Row Order
----------------
GUI Navigation = Reports/Define/Order
GUI Form Name = RGXGDORD (Row Order)
1. Navigate to Reports/Define/Order.
2. Enter a Name and Description for your row order.
3. Place your cursor in the 'Seq' field of the Account Display region and enter a sequence number for the first segment in your account combination.
4. Tab to 'Segment' field and select the segment to display from your list of values (LOV).
5. Tab to 'Order By' field and select the order of segment to be displayed.
6. For all segments segments whose header description you wish to suppress, set the Width field to 0.
7. Repeat this for each segment in your accounting flexfield.
8. Save your work before exiting the form.
II. Define Report
-------------
GUI Navigation = Reports/Define/Report
GUI Form Name = RGXGDREP (Define Financial Report)
1. Navigate to Reports/Define/Report.
2. Place your cursor in the 'Row Order' field of the Optional Components region and query the row order you created in Step I (above).
3. Save your work before exiting the form.
III. Run Report
----------
Run the report as listed in the Problem Description.
Search Words
------------
Accounting Flexfield Segment, Heading, Header
Note:1014255.102Problem Description:
====================
Is reporting on multiple level segment hierarchies possible
using the Financial Statement Generator (FSG)?
Can this be done by defining a single Row Sequence?
Problem Explanation:
====================
You have tried to report on a grandparent segment value and the parents
assigned to that grandparent segment value in an FSG, with a single row
sequence in your row set. The generated report did not provide the
expected hierarchical level of detail. You were expecting to get the
accounts and amounts for the parents. Instead you got the accounts and
the amounts for the lowest level hierarchy - the non-parent children.
Search Words:
=============
parent value, grandparent value, row sequence, row set, FSG:Expand Parent Value , hierarchy , total , subtotal
Solution Description:
=====================
-- In order to report on Multiple Hierarchy levels in FSGs you have
to have as many sequences in the row set as the number of
parents/grandparents/great-grandparents that you wish to report on.
You can not report on all levels by defining a single
row sequence.
Solution Explanation:
=====================
-- To get a report with grandchildren detail, parent subtotals and a
grandparent total, do the following. The example below assumes the
grandparent has 3 children, who are each parents themselves. The 3rd
level contains only low level children.
GP
---------------------
P1 P2 P3
------- ------ -----------
C1 C2 C3 C4 C5 C6 C7
(The YTD amounts posted to the detail level accounts in the example are:
C1 = $1, C2 = $2, C3 = $3, C4 = $4, C5 = $5, C6 = $6, C7 = $7)
Set the Profile Option "FSG: Expand Parent Value" to Yes.
I. Set Up The Account Hierarchy
-------------------------------
1) Navigation = Setup=>Financials=>Flexfields=>Key=>Values
Enter Application = Oracle General Ledger
Title = Accounting Flexfield
Structure =
Segment =
2) Define the low level child accounts values C1 through C7.
3) Define the three parent accounts, P1 through P3. In the Blue
Drop Down box select Hierarchy,Qualifiers. Check the Parent Box
for each of these three values.
Define the child ranges for each parent by clicking the [Define Child Ranges] Button. None of the children are parents, so select Child Values Only in the Include column. Only child values within the range will be picked up.
Example: For P3 Parent
From To Include
----- ----- -------
C5 C7 Child Values Only
4) Define the grandparent account GP. Check the Parent box for this value as well. This time define the child ranges as the parent segment values that you had defined in step 2. Set Range Type ( Include ) to Parent. Only values that are defined as parents within the range will be picked up.
From To Include
----- ----- -------
P1 P3 Parent Values Only
5) Save your work.
The hierarchy assignments will launch a flexfield compilation process. Ensure that this process completes successfully by reviewing it from the Requests form (From the toolbar: Help..View My Requests).
II. Define the FSG
------------------
1) Navigation = Reports=>Define=>Row Set
Enter a Row Set Name.
Enter a Description and a Report Title.
Click on the [Define Rows] button.
Create one row sequence for each of the 3 parent values. Enter account assignments using 'B'oth as the display type, to show both the detail and total for the parent.
Line = 10 Line Item = The amounts for Parent P1
Low High Display
---- ----- --------
P1... P1... B.T.T...
Or use 'T'otal in the Display, if you just want a total for the parent.
Define Lines 20 and 30 doing the same for Parents P2 and P3.
2) Create one row sequence (line) for the grandparent GP. Enter
a calculation sequence that sums the row sequences created for
each parent.
Line = 40 Line Item = The calculated total for GP
Click on the Calculations Radio Button.
Seq Operator Constant Low High Row Name
---- -------- -------- --- ---- ---------
10 + 10 30
Alternatively,
Specify the grandparent value, with 'T'otal for the
display type by entering the following account assignment.
Sign Low High Display
---- ----- ------ --------
+ GP.XXX GP.XXX T.T.T...
Do not check the Summary Box in any of the account
assignments while defining the row set.
You will obtain the following report:
YTD-Actual
P1 The amounts for Parent P1
C1 1
C2 2
TOTAL 3
P2 The amounts for Parent P2
C3 3
C4 4
TOTAL 7
P3 The amounts for Parent P3
C5 5
C6 6
C7 7
TOTAL 18
GP The Calculated Total for GP 28
If you do not get desired results from the FSG run the Standard report
"Chart of Accounts - Rollup Detail Listing" to make sure that the
parent/child relationships and hierarchies are defined correctly.
Note:1014921.6· goal: How to define an FSG percentage calculation column such as percent of · sales· · fact: Oracle General Ledger· · fact: RGRARG - Financial Statement Generator· · fix: Problem Description------------------- How can a column (C3) that represents another column (C1)as a percentage of the column (C1) total in FSG's (Financial Statement Generator) be defined? Example-------C3 represents C1 as a percentage of the TOTAL in column C1. C1 C2 C3 -------------------------------- R1 30 15% -------------------------------- R2 70 35% -------------------------------- R3 80 40% -------------------------------- R4 20 10% -------------------------------- TOTAL 200 100% Solution Description-------------------- When defining a row, user can enter a value in the 'Percent of Row' field.The value entered in this field is the sequence number of the row, that willbe used as the denominator in the calculation of the percentage column. For the following example: C1 C2 C3 -------------------------------- R1 30 15% -------------------------------- R2 70 35% -------------------------------- R3 80 40% -------------------------------- R4 20 10% -------------------------------- TOTAL 200 100% 1. In the Define Row Set screen, define rows R1, R2, R3,R4 with sequence numbers 10, 20, 30,40 respectively, and define account assignments for each row. 2. Define the TOTAL row as a calculation (i.e., the sum of the rows R1 through R4 as follows: Click on the calculation button in the Define Row Set screen, then enter the data below on the Calculations screen Seq Operator Constant Low High Row Name 50 + 10 49 NOTE: This does not have to be a calculation. You can use account assignment ranges instead to obtain your total amount. 3. In the Row Definitions for R1, R2, R3 and R4 enter the sequence number 50 (i.e., the sequence number of the TOTAL row) in the 'Percent of Row' field. 4. In the Row Definition for the TOTAL row, select the checkbox option 'Override Column Calculations', so that it is checked. (This allows the TOTAL row calculation - the sum of R1 through R4 to be enforced across the entire total row, even if there is a conflicting column calculation, as is the case with the intersection of C3 and TOTAL.) If this row is not a calculation, do not check Override Column Calculations. 5. In the define column set screen, when defining column C3, -- Leave the Amount Type and Offset fields blank -- Select the Calculations button, and define the calculation for column C3 as follows : Seq Operator Constant Low High Column Name 1 % C1
Note:207779.1· goal: How do FSG Segment Overrides, Content Sets, Account Assignment Ranges · and Display Types work together?· · fact: Oracle General Ledger· · fact: RGRARG - Financial Statement Generator · · fact: RGXGDAXS - Define Axis Set· · fact: RGXGDCON - Define Content Set· · fact: RGXGDREP - Define Report· · fact: RGXGRRST - Request Report Set· · fix: Account assignments ranges: Account assignment ranges can be defined in both the row and the column set. If you enter accounts for both rows and columns, FSG only reports on intersecting accounts. You can enter a different set of books for each account assignment range, if the sets of books share the same chart of accounts and calendar as your current set of books. The set of books shown in the list of values are those with the same chart of accounts and calendar as the set of books assigned to your current responsibility. Content sets: Content sets override the account assignments in your row set. When a flexfield assignment is defined in a content set, the values defined there take precedence over the values defined in each row within the row set. This applies to the Display options as well. See <Note:147218.1> for more information. Display Types: Any kind of Expand with multiple account assignments in one row sequence is not supported. You must use a display type of T (Total) for each segment if you assign: - Accounts to a column. - Multiple account ranges to a row. The same rules apply to Content Sets. You can not use a display type that expands, such as RE, RB or PE, if you assign: - Accounts to a column. - Multiple account ranges to a row. If you need to expand, but have multiple account assignments ranges in one row sequence, you can: - Break out those account assignment ranges into separate row sequences. OR - Define a single row that encompasses the ranges needed. If the values are not in sequence, create a parent value that contains the values you want to expand on, the use that one parent value in the account assignment. Segment Override specified on Define Financial Report form: Enter values for the account segments you want to override. When you enter a segment override value, FSG produces a report for that specific value. For example, assume you have a report definition which produces a combined assets report for four companies. If you modify the report definition to add a segment override for company value 01, then FSG will create the report for company 01 only. Segment Override specified at runtime: Enter values for the account segments you want to override. When you enter an override segment value, FSG produces a report for the specific company, cost center, product or other value associated with that segment. If you don't provide a segment override, FSG uses the one specified in the report definition, if any. This will override the assignments even if assignments are made in both the row and column. This will also override segment overrides defined in the column set. NOTE: A segment value that has been disabled cannot be used as a segment override; at runtime or on the Define Financial Report form. However, you can use a segment value that has been end-dated. See <Note:1057153.6> for more information. Override Segment on Column Set: Use the override segment feature to produce reports that show information for each department or company, with one column for each. Define one of your segments as the Override Segment on the Column Set form. Define one column for each of your values in that segment that you want to report on (for example create one column for each department). On each column definition, specify the Override Value that you want to report on (for example, department 01 for Sales). If you define an Override Segment, but do not define an Override Value for a column, FSG will substitute an all encompassing range (e.g. all zeros to all Z's) for that segment in that column. An override segment defined on the column set will take precedence over all other overrides for that same segment (content set, report definition or a runtime override).
Note:141278.1· goal: How to Create a Trace File and Run Tkprof in Applications - Condensed · Version· · fact: SQL Trace· · fact: Oracle Application Object Library· · fix: WHAT TO SET UP BEFORE GENERATING THE TRACE These steps must be performed by the DBA on the database server. 1. Set TIMED_STATISTICS to TRUE. For performance issues, make sure TIMED_STATISTICS is turned on, before attempting to generate the trace. Set the following in the init.ora file: TIMED_STATISTICS=TRUE OR in SQL*Plus: ALTER SYSTEM SET TIMED_STATISTICS=TRUE; 2. Set the location of the trace output. Set the following in the init.ora file: USER_DUMP_DEST = 3. Create the PLAN_TABLE to hold the output of the explain plan. Run the SQL script called UTLXPLAN.SQL to create this in the apps schema. This script is usually in $ORACLE_HOME/rdbms/admin. 4. If the init.ora file has been updated, you must shut down and restart the database before the changes will take effect. TYPES OF TRACE - HOW TO TURN TRACE ON Regardless of the type of trace file you create, make sure you note the time that you create it. 1. Form Trace Toggle trace on/off on the form, to trace specific application functions. Make sure you go in fresh (sign off/on to the application), since some queries are cached and may not be executed on subsequent visits to the form. From the menu, select Help..Diagnostics..Trace (Release 11i) to turn trace on (when checked, it is on). Release 11 and 10.7 GUI/NCA --> Help..Tools..Trace Release 10.7 Character --> \Other Trace On Perform the action to be traced. From the menu, turn trace off, by selecting Help..Diagnostics..Trace (it should now be unchecked). Release 11 and 10.7 GUI/NCA --> Help..Tools..Trace Release 10.7 Character --> \Other Trace On 2. Concurrent Program Trace This will turn trace on for each execution of this program. In Release 11.0 and lli, check the Enable Trace checkbox for the concurrent program on the Concurrent Programs form. After running the program to be traced, make sure you uncheck the Enable Trace checkbox. Select the System Administrator responsibility. Navigation = Concurrent -> Programs -> Define. Query the concurrent program you want to trace. Check the Enable Trace checkbox and save. 3. Database Level Trace This will turn trace on for all processes that are running in the instance and should only have to be used in Release 10.7, for concurrent programs. (This has to be done by the DBA.) Set the following in the init.ora file: SQL_TRACE=TRUE Shut down and restart the database. After generating the trace file, shut down and restart the database with the original init.ora. 4. Report Trace If you are on 10.7 and need to trace an Oracle Report, you can modify the report to turn trace on for that session. a. Convert the report from rdf to rex: $ORACLE_HOME/bin/r25convm batch=yes userid= \ > stype=rdffile source=REPORT_NAME.rdf dtype=rexfile overwrite=yes b. Edit the rexfile and search for the beforerep trigger in the report. Locate the following code: IF (:p_trace_switch = 'Y') THEN SRW.DO_SQL('alter session set sql_trace TRUE'); END IF; Comment out the IF and END IF lines. c. Save the report. d. Convert the report from rex to rdf: $ORACLE_HOME/bin/r25convm batch=yes userid= \ > stype=rexfile source=REPORT_NAME.rex dtype=rdffile overwrite=yes WHAT TO DO AFTER GENERATING THE TRACE FILE These steps should be performed by the DBA, on the database server. 1. Find the trace directory. Get the location of user_dump_dest. Log into SQL*Plus as the apps user. select value from V$PARAMETER where name = 'user_dump_dest'; 2. Find the trace file for your process. Go to the directory you found in step 1 (in UNIX, use cd). Look for a file (..trc) that was created at the time you started your process (in UNIX, use ls -ltr). 3. Run tkprof with explain plan. Go to a directory in which you have write privilege (in UNIX, use cd). Run tkprof: tkprof
1. How do I find the latest FSG patch that is available?
For the General Ledger Patch List, on MetaLink, click on Top Tech Docs...General Ledger...Patchset Information (Note 159239.1).
2. Is there a way to suppress zero amounts on the FSG Report?
You cannot suppress individual zero amounts in FSG. However, when all the values in a row or column are zero, you can have FSG suppress them all. To do this, make sure the Display Zero option is unchecked on the appropriate Rows or Columns window.
3. How do you print credit amounts on the FSG Report as positive instead of negative numbers?
For a related row or column definition, check the Change Sign checkbox. Credit amounts for this row or column will now print as positive numbers. Negative credits will print as negative numbers. Note that this changes the sign for display purposes only.
4. Can I display account descriptions on the FSG Report in addition to the account segment values?
Yes. You simply have to define a Row Order, then, assign it to your report. In your Row Order, set the Account Display options of the account segments for which you want to print descriptions. Select Value and Description as your segment display method. Also, make sure that you set the printing width, so there is enough room to print both the segment value and the description.
5. Is there a limit on how large a FSG Report can be?
Yes. The column set width of an FSG report cannot exceed 255 characters. In release 11i, the column set width can exceed 255 characters. (However, while printing, there is still a limit of 255 characters.)
6. What is the profile option 'FSG: Expand parent value' used for?
This profile option controls the expansion of parent values when requesting summary balances. The following values are available to you:
Yes: FSG uses the rollup group to determine whether to expand a parent value into its child ranges. If the parent value belongs to a rollup group, FSG does not expand the parent value into its child ranges. If the parent value does not belong to a rollup group, FSG expands the parent value into its child ranges.
No: FSG uses the summary flag associated with the flex-field assignment to determine whether to expand a parent value into its child ranges. If the summary flag is set to Yes, FSG does not expand the parent value into its child ranges. If the summary flag is set to No, FSG expands the parent value into its child ranges.
The default value for this profile option is No.
Note 1012620.102 provides more information regarding this profile option.
7. I am trying to display budget amounts in my reports but they are not showing up. What is wrong?
Since Oracle GL allows you to define multiple budgets, you must indicate what budget you want displayed in the row or column. You do this by first assigning a Control Value in the Balance Control section of the Row or Column window. The control value is any numeric value. Next, you must tell FSG what budget relates to the Control Value. You do this in the Define Report form. When you define a control value for either your Row Set or Column Set in your report, the Control Value button will be activated.
By selecting the Control Value button you can assign budgets to your control values. Another reason you may not be seeing your amounts is if you are using the YTD-Budget (FY End) amount type, but have not budgeted to every period in the fiscal year. See Note 1036437.6.
8. How do you enable FSG security?
First, you define security rules for specific account segment values. Then, you assign your security rules to specific responsibilities. Lastly, you set the profile option 'FSG: Enforce Segment Value Security' to YES.
Flex-field value security has been enhanced in Release 11.5, with hierarchical security. Instead of having to create security rules for a range of segment values, you can assign security rules at the parent level and have the rules automatically apply to all of the child values within the parent hierarchy. To use this, choose the Security Type of Hierarchical for the value set, on the Value Sets form. See Note 138143.1 for more information.
9. How can you add/define/create your own new amount types in FSG reporting?
Oracle comes with seeded amount types, which can be specified in the Balance control region of a FSG row or column definition. You cannot create your own.
10. Where should the period offset and the amount type be specified?
The period offset and amount type must both be specified in the row set or both be specified in the column set. You cannot have a period offset in the row set and an amount type in the column set, or vice versa.
11. On a calculation column, can I enter an amount type?
You should not define rows or columns that contain both calculation information and an amount type. If you do, the amount type will override and this may cause errors.
12. Is there a quick and supported method of transferring FSGs between environments, so that users do not have to key them in twice?
Run the FSG Transfer program (under Report/Request/Standard) to copy report objects from one General Ledger database (or instance) to another. You can copy row sets, column sets, reports, report sets, content sets, row orders, display sets, and display groups.
Prerequisites
- You or your System Administrator must define database links.
- The chart of accounts in the set of books in your source database must be identical to the chart of accounts in the set of books in your target database.
- Any currencies and sets of books referred to by the row sets and column sets being copied must exist in the target database.
- Report details, such as budgets and encumbrance types, referred to by
copied reports must exist in the target database.
- You must be logged into General Ledger and connected to the target database.
- The target and source apps releases must be the same. See Note 1083689.6 for more information.
If any of the prerequisites are not met, you will not be able to use FSG Transfer to copy the report objects. You will have to enter them manually in the target set of books.
13. What FSG enhancements are introduced in Release 11i ?
Unlimited Width Reports
Oracle General Ledger now allows you to create FSG reports with an unlimited number of columns. FSG will pick the widest of the column set header or the total width of all the columns to determine the width of the report. However, while printing, there is still a limit of 255 characters.
Absolute Value Function in Reports
To ease reporting, you can now use the absolute value function in row set definitions to display amounts as positive numbers, regardless of their debit or credit balances. This function is helpful for defining income statements, balance sheets, and other financial reports in which amounts are generally displayed as positive numbers.
14. Can I remove the 'No specific Company requested' text from the FSG heading?
The text 'No specific Company requested' will appear as long as no content set is used for the report. A content set must be specified for this text not to appear. Depending on the content set parameters the actual segment value description or the text 'No specific Company requested' will appear. For example, when Display is set to 'PE' a separate report is generated for each value and the specific value's description is displayed, rather than 'No specific Company requested'. This text will also change if you enter a Segment Override for Company (segment) at runtime on the Run Financial Reports form. By doing this, you are running the FSG for only the Company value you specified.
15. Can I remove the segment header descriptions from the top of the FSG reports?
The accounting flexfield segment headings (CO, REG, etc.) can be removed with the use of a Row Order. See Note 1037253.6 for instructions on how to do this.
16. Can I customize or move the 3 heading lines that appear at the top of the FSG (set of books, report name, period)?
The first line of the FSG report heading contains the set of books name. This information can not be changed.
The second line of the FSG report heading contains the report name.
For Release 10, this is the Row Set name that is used in the FSG.
For Release 11 and 11i, this report name is defined in the Report definition (Navigation = Reports/Define/Report).
The third line contains the period that the FSG is being run for. This can not be changed.
The date and time in the upper right corner indicates when the report
was created. The page number appears here also. This can not be changed.
ADI can be used to publish the FSG report, using a theme that you customize to make some of these changes. See the Application Desktop Integrator User's Guide for more information.
17. How can I display USD and STAT amounts on the same FSG report?
On the Define Rowset form:
Make sure you have the following set up:
STAT Accounts
-- Set the 'Currency' field to STAT for accounts that are STAT only.
-- Set the 'Control Value' field to 1 for accounts that are STAT.
USD Accounts
-- Set the 'Currency' field to USD.
-- Leave the 'Control Value' field blank for USD accounts.
On the Define Column Set form:
Under Balance Control Option - Do not input any Currency or Control values
(i.e. leave fields blank). (If you enter a Currency on the Column also, FSG will report 0 in intersection of the row and column.)
18. How can I report on a multiple level account hierarchy in an FSG?
To report on Multiple Hierarchy levels (child, parent, grandparent, etc.) in FSGs you have to have as many sequences in the row set as the number of parents/grandparents/great-grandparents that you wish to report on. You can not report on all levels by defining a single row sequence.
See Note 1014255.102 for more information on how to do this.
19. How can I define an FSG percentage calculation Column such as percent of sales?
When defining a row, you can enter a value in the 'Percent of Row' field. The value entered in this field is the sequence number of the row, that will be used as the denominator in the calculation of the percentage column.
See Note 1014921.6 for detailed instructions.
20. Can an FSG output be created in PDF format?
No. That functionality is not available. Enhancement Request 1569021 has been logged for this.
21. What is the meaning of 'n/m' on my FSG?
The means 'no meaning'. FSG displays this when there is a calculation that is attempting a divide by zero. You cannot remove this, or change it to any other value (other than changing the calculation itself so it doesn't result in a divide by zero).
22. I used column set builder to set the width of the last column in my report. After saving and requerying the column set, the width has changed. Why?
The width of the last column can only be controlled through the format mask. Define the format mask of the last column to be as wide as the desired width of the column.
23. Can FSG reports and components be secured/protected so only certain people can modify or run them?
No. You can only restrict/protect the data that is reported on in the report. You cannot restrict access to the reports and components themselves.
24. How do segment overrides, content sets, account assignment ranges and display types work together?
For a detailed explanation, see Note 207779.1.
25. When hiding data using a Display Group/Set in FSG the underline under that data still appears.
The underline character is part of the format option and is not affected by the display set definition, which only hides the actual data. The work around is to remove the underline from the row definition prior to running the report.
26. I'm using a Content Set with a range of cost centers. There are some inactive cost centers within that range. How can I suppress the creation or printing of the reports for those inactive cost centers, or for disabled or inactive accounts?
There is no way to exclude particular values that are included in the range you defined in the content set, or in an account assignment range in a row or column set. You must define new ranges that do not include those inactive cost centers or accounts.
27. How can I define a column to be for a specific or constant period, such as January of the current year, or dynamically change the period?
This functionality is not available. FSG uses the period Offset, and the runtime period you enter, to determine which periods to report on. Use a negative number to report on periods prior to your runtime period, and a positive number to report on periods after your runtime period. For example, a column with an offset of 0 will contain amounts for the period you entered at runtime. A column with a -1 offset will contain amounts for the prior period, a -2 will contain amounts for a period 2 earlier than the runtime period. An offset of 1 will give you amounts for the period following the runtime period (providing that period has been opened before).
28. Why can some column sets be viewed/used with different sets of books and others cannot?
If account assignments have been defined in the column set, then that column set is only available to sets of books that use that same chart of accounts. If there are no account assignments in them, and the same chart of accounts (accounting flexfield structure) is used between sets of books, then they should be available to all of those sets of books.
29. How do I see the SQL code behind the FSG report?
The FSG reports are created from a program written in 'C' code, not from Oracle Reports, as is the case with standard reports. Many modules and tables are used to create reports based on the definition and component of a particular FSG. This would make looking at code for an FSG report (as you would a standard report) almost impossible. One approach is to turn the profile FSG: Message Detail to FULL and run the report. The logfile will contain some of the SQL. A session level trace will provide all of the SQL. See Note 141278.1 for information on how to get the trace.
30. How do I show the YTD amount for the end of the fiscal year on an FSG?
In Release 11i, there is a patch available (2650861) that will allow you to use an amount type called YTD-Actual (FY End). Used without a period offset, FSG will give you the YTD balance for the fiscal year the report is run for. This amount type only pertains to the very last period of the current fiscal year and the status of that period must be Open or Closed. Current fiscal year means the year the period you are running the FSG for falls into. If you use a period offset with the YTD-Actual (FY-End) amount type, and the resulting period falls into another fiscal year, it will get the year to date balance for that year.
In release 11.0 and 10.7, you must still use the YTD-Actual amount type and the offset for the last period of the year.
31. Can I create an FSG in html format?
Not from the standard application. In the applications you have a choice of 3 output options: 1) Text, 2) Tab-delimited - for importing into a spreadsheet, or 3) Spreadsheet - for downloading to ADI. You can create an FSG in html format in ADI (Applications Desktop Integrator).
32. How can I run an FSG from the Standard Request Submission form?
Add the program 'Program - Run Financial Statement Generator' to your Request Group. See Note 1060806.6 for detailed instructions.
33. When using a content set, sometimes the amounts are duplicated (doubled or tripled).
The values defined in a content set override the values defined in the row set account assignments. Depending on how your account assignments are structured, this may result in duplication of the account assignment ranges. See Note 147218.1 for an explanation and workaround.
-----------------------------------------------------------------------
Note:1012620.102PROBLEM DESCRIPTION:
You are not getting the results you expected in your Financial Statement Generator (FSG) reports when using parent values.
How is the profile option, 'FSG:Expand Parent Value' used?
PROBLEM EXPLANATION: The Oracle General Ledger documentation (User's Guide and Reference Manuals) describe this profile option, but the explanation is not clear.
Here is the profile option documentation from the manuals:
Control the expansion of parent values when requesting summary balances. The following values are available to you:
Yes: FSG uses the rollup group to determine whether to expand a parent value into its child ranges. If the parent value belongs to a rollup group, FSG does not expand the parent value into its child ranges. If the parent value does not belong to a rollup group, FSG expands the parent vaue into its child ranges.
No: FSG uses the summary flag associated with the flexfield assignment to determine whether to expand a parent value into its child ranges. If the summary flag is set to Yes, FSG does not expand the parent value into its child ranges. If the summary flag is set to No, FSG expands the parent value into its child ranges. The default value for this profile option is No.
SEARCH WORDS: summary account, balance, summary flag, rollup group, child range,detail account, financial statement generator, row set, accounting flexfield range, account range, FSG
REFERENCES: Oracle General Ledger Release 10SC, User's Guide, part number A21643-7, pages B-5 through B-6.
Oracle General Ledger Release 10.7 Volume 2, Reference Manual, part number A13113-5, page C-4.
SOLUTION DESCRIPTION: The FSG:Expand Parent Value profile option controls whether FSG expands a parent value into its child ranges or uses the parent value.
The summary flag contols whether FSG looks for summary accounts or detail accounts.
Yes: FSG uses the Rollup Group to determine whether to expand a parent value into its child ranges. If the parent value belongs to a rollup group, FSG does not expand the parent value into its child ranges. If the parent does not belong to a rollup group, FSG expands the parent value into its child ranges.
No: FSG uses the Summary Flag associated with the flexfield assignment to determine whether to expand a parent value into its child ranges. If the summary flag is set to Yes, FSG does not expand the parent value into its child ranges. If the summary flag is set to No, FSG expands the parent value into its child ranges.
The following are the possible scenarios:
Example 1: FSG:Expand Parent Value = Yes , Summary Flag = Yes
Parent Value belongs to a Rollup Group
Result: FSG looks for summary accounts that have this parent value for this segment. It does not expand the parent value into its child ranges.
Example 2: FSG:Expand Parent Value = Yes , Summary Flag = Yes
Parent Value does not belong to a Rollup Group
Result: FSG expands the parent value into its child ranges, then looks for summary accounts that have values for this segment that are within these child ranges. (The summary template associated with this summary account would have to have a 'D' for this segment.)
Example 3: FSG:Expand Parent Value = Yes , Summary Flag = No
Parent Value belongs to a Rollup Group
Result: FSG looks for detail accounts that have this parent value for this segment. It does not expand the parent value into its child ranges. It is never going to be successful.
Example 4: FSG:Expand Parent Value = Yes , Summary Flag = No
Parent Value does not belong to a Rollup Group
Result: FSG expands the parent value into its child ranges, then looks for detail accounts that have values for this segment that are within these child ranges.
Example 5: FSG:Expand Parent Value = No , Summary Flag = Yes
Result: FSG looks for summary accounts that have this parent value for this segment. It does not expand the parent value into its child ranges.
Example 6:FSG:Expand Parent Value = No , Summary Flag = No
Result: FSG expands the parent value into its child ranges, then looks for detail accounts that have values for this segment that are within these child ranges.
Note:1036437.6PROBLEM DESCRIPTION:
When you run your Financial Statement Generator (FSG) report for the month of July, the amount type YTD-budget (FY End) column prints zeroes.
You have budgets for January through June, but nothing specified for July.
SEARCH WORDS: FSG Financial Statement Generator
SOLUTION DESCRIPTION:
In order for the amount type YTD-BUDGET (FY END) to print, you MUST enter a budget for all periods including the adjusting period. This is documented on page 3-111 of the General Ledger Reference Manual for release 10.7. You can enter a number in the adjusting period and run the report again. This forces the report to print correctly.
Note: If you set up the budget for 12 periods without an adjusting period, you cannot add an adjusting period or change the last period of the budget once the budget setup process is completed.
Note:138143.1
QUESTIONS & ANSWERS:
1. I have defined a security rule and assigned it to my responsibilty, but is still does not work, why?
Answer: Make sure that you have enabled security at both the segemnt and value set levels, it must be enabled at both these levels to work. Also make sure you have switched out and back into the responsibility.
2. My security rules don't work for the Account Analysis and General Ledger reports in Release 11.0.3.
Answer: This functionality is available starting in Release 11i. In Releases 11 and lower, one cannot set security for standard reports. Security Rules will only limit users from a few functions (e.g. Account Inquiry, Budgets, Journal Entries, and FSGs). In addition,in Release 11i there is limited use of the security rule functionality for running standard reports. It appears that your goal is to restrict users from submitting reports for a particular company, this cannot be accomplished using security rules.
3. In Rel 11i with the intercompany segment being used, is it possible to have a security rule on the balancing segment (company) without it affecting the intercompany segment, since they share the same value set?
Answer: Yes it is possible. You would enable security on the value set, but then on the flexfield segment (intercompany) you would not enable security.
4. Is there a way to assign different security rules to a responsibily based on the User ID?
Answer: You cannot apply different security rules to the same responsibility for different users based on the user ID. You will have to create a new responsibility and define its own security rules. Then you can assign the new responsibility to one of the users.
5. Can security rules be used to control the posting of journal entries?
Answer: Security rules apply only with regards to creation/modification of lines within a journal. They do not apply when the journal is posted.
6. Security rules don't seem to work on all forms when performing a query.
Answer: Flexfield Value Security gives you the capability to restrict the set of values a user can use during data entry. With easy-to-define security rules and responsibility level control, you can quickly set up data entry security on your flexfield segments and report parameters. Flexfield Value Security lets you determine who can use flexfield segment values and report parameter values. Based on your responsibility and access rules that you define, Flexfield Value Security limits what values you can enter in flexfield pop-up windows and report parameters.
Security rules for the Accounting Flexfield also restrict query access to segment values in the Account Inquiry, Funds Available, and Summary Account Inquiry windows. In these windows, you cannot query up any combination that contains a secure value. However in all other forms, you will be able to query up a value even if it is restricted to the user.
Reference Oracle Applications Flexfield Guide Release 11, page 5-10.
7. Can Security Rules prevent users in one organization in the same set of books from adding Cross Validation Rules to another organization?
Answer There is not a way in the same set of books, to prevent users from one operating unit via security rules, from changing cross validation rules for another operating unit. The only way to do this would to be create a separate set of books for each operating unit. Since security rules prevent users from either viewing data or entering data in general, they do not pertain to set up issues such as creating cross validation rules.
Therefore, the only other way to prevent one user from one organization from creating cross-validation rules to the other organization, when in the same set of books, would be to completely remove that menu function from the user.
8. Every Country has a Global Manager or User Responsibility to access Global SOB but it is supposed to limit users to their own Legal Entities. However, an Argentian journal can be posted by the Chilian user. How is this possible?
Answer This is working as intended. Security rules will prohibit a responsibility from being able to ente certain values as well as prohibit the viewing of those values. However security rules will not prohibit the actions above because they are in the same set of books. The system does not determine if a journal has values in it that are blocked by security rules. If it did that, the journal would appear as unbalanced. There would have to be an incredible amount of logic involved, which would further reduce performance, for the posting program to scan the journal for security rules first before posting. Posting does not take into consideration the rules, this is done at the time of journal entry.
9. Forgot to check the security enabled flag for each segment and it is not updatable. How do I correct this?
Answer Check your Accounting Flexfield structure to see if it is frozen. Unfreeze the structure, then you should be able to enable Security for the Segment.
10. In General Ledger, a security rule of a parent with children was set up to include the parent and assigned to a responsibility. However it is not functioning properly.
Answer: The system allows the account the customer wanted but doesn't disallow the ones that are children of the parent values excluded. Review note OSS177300 Titled: Key Flexfield Rollup Hierarchical Security not Working Properly.
11. Is it feasible to delete an Exclude statement in order to resolve a Security Rule issue?
Answer The Security rule should not be modified by deleting an exclude or include as it may corrupt the rule. Instead, delete all rule lines (include and excludes), save and redefine the include and excludes. If the rule still doesn't work, create a new rule and assign it to the responsibilities in place of the original rule.
12. What standard reports have security enabled in Release 11i?
Answer Trial Balance, Account Analysis and General Ledger are the only standard reports in Release 11i for which security rules apply.
13. Is it recommended to use a universal Include when setting up rules?
Answer It is recommended to start each security rule with a universal Include statement and then eliminate each value using Exclude statements.
14. What functions do security rules apply to?
Answer Security rules apply to Account Inquiry, budgets, FSG's and journal entry functions. In Release 11i, this also applies to several standard reports (listed previously). Please note, they do not apply to the posting of journals or the review of journals. When reviewing a journal with security rules, the totals are still displayed, it is only the individual lines that are not visible. This is standard functionality.
15. What is Hierarchical Security?
Answer Please see Note:164769.1 for information regarding this new feature. For addition information go to Metalink:
1. Logon to Metalink.
2. Select Top Tech Docs -> Top Tech Docs button (it says 'Click for the original Top Tech Doc pages') -> ERP Applications -> Financials -> General Ledger
-> Documentation -> Release 11i General Ledger Product Documentation ->Doc Update Oracle General Ledger User's Guide, Hierarchical Security
Note:1083689.6Problem Description
-------------------
Running: RGRXFR - Program - FSG Transfer and receiveing an error.
Responsibility = General Ledger Super User
Navigation = Reports -> Request -> Standard
Report/Program Name = Program FSG - Transfer (RGRXFR)
Running this program completes in error and produces a log file with a error
message much like the following:
Encountered error while transferring report '&REPORT'
Cancelling transfer of this report
DECLARE * ERROR at line 1:
ORA-00904: invalid column name
ORA-06512: at line 147
Program exited with status 1
Cause: The program completed execution -in particular with status 1
Solution Description
--------------------
You are trying to transfer FSG Report Objects from a 10.7 Applications
instance to a Release 11 or 11.5 Apps instance.
You cannot transfer objects from one release to another. In Release 11/11.5, changes have been made to the tables, eg. the addition/removal of columns etc. Therefore when you try to transfer, the process RGRXFR cannot find the column name it is being referred to.
Search Words
------------
rgrxfr, status 1, ora-6512
Financial Statement Generator
Note:1037253.6Problem Description
-------------------
You are trying to run an FSG (Financial Statement Generator) report which
will NOT show segment descriptions on the top of the rows as follows:
Responsibility = General Ledger Super User GUI
GUI Navigation = Reports/Request/Financial
GUI Form Name = RGXGRRST (Run Financial Reports)
1. Navigate to Reports/Request/Financial.
2. Place your cursor in Report field and select the report to run by clicking on Query/Find or the Find icon (flashlight) on the toolbar.
3. After report is selected, place cursor in the Period field and enter or select from list of values (LOV) the desired report period.
4. Click on the [Submit] button to submit this report. When this report is generated, you do not want the header descriptions for particular account segments to be displayed. An example of the report header would be -
Currency: USD
No Specific Company requested
CO REG CC ACCT PRD SUB
--- ---- --- ----- ---- ----
Solution Description
--------------------
You will need to define a Row Order to be used with the FSG in order for the headings to NOT display. The row order must contain all segments of the flexfield. To suppress the header description for particular account segments, set the width to 0 for those segments. Attach the row order to the FSG report.
To do this, sign into Oracle applications as General Ledger Super User GUI and follow the steps listed below:
I. Define Row Order
----------------
GUI Navigation = Reports/Define/Order
GUI Form Name = RGXGDORD (Row Order)
1. Navigate to Reports/Define/Order.
2. Enter a Name and Description for your row order.
3. Place your cursor in the 'Seq' field of the Account Display region and enter a sequence number for the first segment in your account combination.
4. Tab to 'Segment' field and select the segment to display from your list of values (LOV).
5. Tab to 'Order By' field and select the order of segment to be displayed.
6. For all segments segments whose header description you wish to suppress, set the Width field to 0.
7. Repeat this for each segment in your accounting flexfield.
8. Save your work before exiting the form.
II. Define Report
-------------
GUI Navigation = Reports/Define/Report
GUI Form Name = RGXGDREP (Define Financial Report)
1. Navigate to Reports/Define/Report.
2. Place your cursor in the 'Row Order' field of the Optional Components region and query the row order you created in Step I (above).
3. Save your work before exiting the form.
III. Run Report
----------
Run the report as listed in the Problem Description.
Search Words
------------
Accounting Flexfield Segment, Heading, Header
Note:1014255.102Problem Description:
====================
Is reporting on multiple level segment hierarchies possible
using the Financial Statement Generator (FSG)?
Can this be done by defining a single Row Sequence?
Problem Explanation:
====================
You have tried to report on a grandparent segment value and the parents
assigned to that grandparent segment value in an FSG, with a single row
sequence in your row set. The generated report did not provide the
expected hierarchical level of detail. You were expecting to get the
accounts and amounts for the parents. Instead you got the accounts and
the amounts for the lowest level hierarchy - the non-parent children.
Search Words:
=============
parent value, grandparent value, row sequence, row set, FSG:Expand Parent Value , hierarchy , total , subtotal
Solution Description:
=====================
-- In order to report on Multiple Hierarchy levels in FSGs you have
to have as many sequences in the row set as the number of
parents/grandparents/great-grandparents that you wish to report on.
You can not report on all levels by defining a single
row sequence.
Solution Explanation:
=====================
-- To get a report with grandchildren detail, parent subtotals and a
grandparent total, do the following. The example below assumes the
grandparent has 3 children, who are each parents themselves. The 3rd
level contains only low level children.
GP
---------------------
P1 P2 P3
------- ------ -----------
C1 C2 C3 C4 C5 C6 C7
(The YTD amounts posted to the detail level accounts in the example are:
C1 = $1, C2 = $2, C3 = $3, C4 = $4, C5 = $5, C6 = $6, C7 = $7)
Set the Profile Option "FSG: Expand Parent Value" to Yes.
I. Set Up The Account Hierarchy
-------------------------------
1) Navigation = Setup=>Financials=>Flexfields=>Key=>Values
Enter Application = Oracle General Ledger
Title = Accounting Flexfield
Structure =
Segment =
2) Define the low level child accounts values C1 through C7.
3) Define the three parent accounts, P1 through P3. In the Blue
Drop Down box select Hierarchy,Qualifiers. Check the Parent Box
for each of these three values.
Define the child ranges for each parent by clicking the [Define Child Ranges] Button. None of the children are parents, so select Child Values Only in the Include column. Only child values within the range will be picked up.
Example: For P3 Parent
From To Include
----- ----- -------
C5 C7 Child Values Only
4) Define the grandparent account GP. Check the Parent box for this value as well. This time define the child ranges as the parent segment values that you had defined in step 2. Set Range Type ( Include ) to Parent. Only values that are defined as parents within the range will be picked up.
From To Include
----- ----- -------
P1 P3 Parent Values Only
5) Save your work.
The hierarchy assignments will launch a flexfield compilation process. Ensure that this process completes successfully by reviewing it from the Requests form (From the toolbar: Help..View My Requests).
II. Define the FSG
------------------
1) Navigation = Reports=>Define=>Row Set
Enter a Row Set Name.
Enter a Description and a Report Title.
Click on the [Define Rows] button.
Create one row sequence for each of the 3 parent values. Enter account assignments using 'B'oth as the display type, to show both the detail and total for the parent.
Line = 10 Line Item = The amounts for Parent P1
Low High Display
---- ----- --------
P1... P1... B.T.T...
Or use 'T'otal in the Display, if you just want a total for the parent.
Define Lines 20 and 30 doing the same for Parents P2 and P3.
2) Create one row sequence (line) for the grandparent GP. Enter
a calculation sequence that sums the row sequences created for
each parent.
Line = 40 Line Item = The calculated total for GP
Click on the Calculations Radio Button.
Seq Operator Constant Low High Row Name
---- -------- -------- --- ---- ---------
10 + 10 30
Alternatively,
Specify the grandparent value, with 'T'otal for the
display type by entering the following account assignment.
Sign Low High Display
---- ----- ------ --------
+ GP.XXX GP.XXX T.T.T...
Do not check the Summary Box in any of the account
assignments while defining the row set.
You will obtain the following report:
YTD-Actual
P1 The amounts for Parent P1
C1 1
C2 2
TOTAL 3
P2 The amounts for Parent P2
C3 3
C4 4
TOTAL 7
P3 The amounts for Parent P3
C5 5
C6 6
C7 7
TOTAL 18
GP The Calculated Total for GP 28
If you do not get desired results from the FSG run the Standard report
"Chart of Accounts - Rollup Detail Listing" to make sure that the
parent/child relationships and hierarchies are defined correctly.
Note:1014921.6· goal: How to define an FSG percentage calculation column such as percent of · sales· · fact: Oracle General Ledger· · fact: RGRARG - Financial Statement Generator· · fix: Problem Description------------------- How can a column (C3) that represents another column (C1)as a percentage of the column (C1) total in FSG's (Financial Statement Generator) be defined? Example-------C3 represents C1 as a percentage of the TOTAL in column C1. C1 C2 C3 -------------------------------- R1 30 15% -------------------------------- R2 70 35% -------------------------------- R3 80 40% -------------------------------- R4 20 10% -------------------------------- TOTAL 200 100% Solution Description-------------------- When defining a row, user can enter a value in the 'Percent of Row' field.The value entered in this field is the sequence number of the row, that willbe used as the denominator in the calculation of the percentage column. For the following example: C1 C2 C3 -------------------------------- R1 30 15% -------------------------------- R2 70 35% -------------------------------- R3 80 40% -------------------------------- R4 20 10% -------------------------------- TOTAL 200 100% 1. In the Define Row Set screen, define rows R1, R2, R3,R4 with sequence numbers 10, 20, 30,40 respectively, and define account assignments for each row. 2. Define the TOTAL row as a calculation (i.e., the sum of the rows R1 through R4 as follows: Click on the calculation button in the Define Row Set screen, then enter the data below on the Calculations screen Seq Operator Constant Low High Row Name 50 + 10 49 NOTE: This does not have to be a calculation. You can use account assignment ranges instead to obtain your total amount. 3. In the Row Definitions for R1, R2, R3 and R4 enter the sequence number 50 (i.e., the sequence number of the TOTAL row) in the 'Percent of Row' field. 4. In the Row Definition for the TOTAL row, select the checkbox option 'Override Column Calculations', so that it is checked. (This allows the TOTAL row calculation - the sum of R1 through R4 to be enforced across the entire total row, even if there is a conflicting column calculation, as is the case with the intersection of C3 and TOTAL.) If this row is not a calculation, do not check Override Column Calculations. 5. In the define column set screen, when defining column C3, -- Leave the Amount Type and Offset fields blank -- Select the Calculations button, and define the calculation for column C3 as follows : Seq Operator Constant Low High Column Name 1 % C1
Note:207779.1· goal: How do FSG Segment Overrides, Content Sets, Account Assignment Ranges · and Display Types work together?· · fact: Oracle General Ledger· · fact: RGRARG - Financial Statement Generator · · fact: RGXGDAXS - Define Axis Set· · fact: RGXGDCON - Define Content Set· · fact: RGXGDREP - Define Report· · fact: RGXGRRST - Request Report Set· · fix: Account assignments ranges: Account assignment ranges can be defined in both the row and the column set. If you enter accounts for both rows and columns, FSG only reports on intersecting accounts. You can enter a different set of books for each account assignment range, if the sets of books share the same chart of accounts and calendar as your current set of books. The set of books shown in the list of values are those with the same chart of accounts and calendar as the set of books assigned to your current responsibility. Content sets: Content sets override the account assignments in your row set. When a flexfield assignment is defined in a content set, the values defined there take precedence over the values defined in each row within the row set. This applies to the Display options as well. See <Note:147218.1> for more information. Display Types: Any kind of Expand with multiple account assignments in one row sequence is not supported. You must use a display type of T (Total) for each segment if you assign: - Accounts to a column. - Multiple account ranges to a row. The same rules apply to Content Sets. You can not use a display type that expands, such as RE, RB or PE, if you assign: - Accounts to a column. - Multiple account ranges to a row. If you need to expand, but have multiple account assignments ranges in one row sequence, you can: - Break out those account assignment ranges into separate row sequences. OR - Define a single row that encompasses the ranges needed. If the values are not in sequence, create a parent value that contains the values you want to expand on, the use that one parent value in the account assignment. Segment Override specified on Define Financial Report form: Enter values for the account segments you want to override. When you enter a segment override value, FSG produces a report for that specific value. For example, assume you have a report definition which produces a combined assets report for four companies. If you modify the report definition to add a segment override for company value 01, then FSG will create the report for company 01 only. Segment Override specified at runtime: Enter values for the account segments you want to override. When you enter an override segment value, FSG produces a report for the specific company, cost center, product or other value associated with that segment. If you don't provide a segment override, FSG uses the one specified in the report definition, if any. This will override the assignments even if assignments are made in both the row and column. This will also override segment overrides defined in the column set. NOTE: A segment value that has been disabled cannot be used as a segment override; at runtime or on the Define Financial Report form. However, you can use a segment value that has been end-dated. See <Note:1057153.6> for more information. Override Segment on Column Set: Use the override segment feature to produce reports that show information for each department or company, with one column for each. Define one of your segments as the Override Segment on the Column Set form. Define one column for each of your values in that segment that you want to report on (for example create one column for each department). On each column definition, specify the Override Value that you want to report on (for example, department 01 for Sales). If you define an Override Segment, but do not define an Override Value for a column, FSG will substitute an all encompassing range (e.g. all zeros to all Z's) for that segment in that column. An override segment defined on the column set will take precedence over all other overrides for that same segment (content set, report definition or a runtime override).
Note:141278.1· goal: How to Create a Trace File and Run Tkprof in Applications - Condensed · Version· · fact: SQL Trace· · fact: Oracle Application Object Library· · fix: WHAT TO SET UP BEFORE GENERATING THE TRACE These steps must be performed by the DBA on the database server. 1. Set TIMED_STATISTICS to TRUE. For performance issues, make sure TIMED_STATISTICS is turned on, before attempting to generate the trace. Set the following in the init.ora file: TIMED_STATISTICS=TRUE OR in SQL*Plus: ALTER SYSTEM SET TIMED_STATISTICS=TRUE; 2. Set the location of the trace output. Set the following in the init.ora file: USER_DUMP_DEST =
PO FAQs
FAQ: Requisition Import
Q1. What is the Basic Purchasing Setup for Requisition Import?A: If importing requisitions from Inventory, input a value for the profile option INV: Minmax Reorder Approval. If the value of INCOMPLETE is selected, the result will be imported Requisitions that require an approval. If the value is APPROVED, then the requisitions cannot be queried in the Requisition entry form; rather, the Requisition Summary form will have to be utilized to view information on the imported approved requisitions.
If importing requisitions from MRP, input a value for the profile option MRP: Purchasing By Revision. This profile option is important if you are using multiple revisions per item and using sourcing rules to create Purchase Orders or Releases. This profile option indicates whether or not to pass on the item revision to the purchase requisition.
Setup/Organizations/Purchasing - Default Alternate Region Requisition Import Group-By Field. The Requisition Import process will first look at the Group By parameter selected when the process is submitted; should this parameter be left blank, the system will then look to the Group-By field residing in the Purchasing Options form. If you expect releases to be created from the requisitions, which you import, make sure the profile option PO: Release During Req Import is populated with the correct value. The choices for this profile are Yes or No. If the profile is set to Yes and all sourcing rule information is properly set up, then blanket releases will be created via the Create Releases process. If the profile is set to No, the Create Releases process will not run at the completion of Requisition Import and all releases will have to be created manually via Auto Create.[top]
Q2. How does Requisition Import determine the grouping method for incoming pieces of data?A: This function groups requisitions. It first assigns values to REQUISITION_LINE_ID and REQ_DISTRIBUTION_ID; the function then groups Requisitions based on the REQ_NUMBER_SEGMENT1 column. All requisitions with the same NOT NULL REQ_NUMBER_SEGMENT1 are assigned the same REQUISITION_HEADER_ID. The function then groups Requisitions based on the GROUP_CODE column. All requisitions with the same value in the GROUP_CODE column are assigned the same REQUISITION_HEADER_ID. It then groups based on the GROUP_BY parameter, which takes on the value of DEFAULT_GROUP_BY if not provided. GROUP_BY could be one of the following: BUYER, CATEGORY, ITEM, VENDOR, LOCATION or ALL. [top]
Q3. How is the PO_INTERFACE_ERRORS table purged and does this data have any dependencies?A: Oracle Purchasing provides the Requisition Import Exceptions Report, which can be used to diagnose records in Error in the PO_REQUISITIONS_INTERFACE_ALL table. It also has an option to purge the Error records in PO_REQUISITIONS_INTERFACE_ALL and the corresponding Error message in the PO_INTERFACE_ERRORS table: - Responsibility: Purchasing Super User- Navigation: Reports/Run, then select Requisition Import Exceptions Report There is a parameter titled 'Delete Exceptions'. If you select 'Yes', then records in the PO_REQUISITIONS_INTERFACE_ALL table with a status of ‘ERROR' and the corresponding records in the PO_INTERFACE_ERRORS table will be deleted. You can also restrict the deleted records by selecting the Batch_id and the Interface Source code. The dependency is between PO_REQUISITIONS_INTERFACE_ALL (transaction_id) and PO_INTERFACE_ERRORS (interface_transaction_id) [top]
Q4. How is the list of values derived for the Import Source column within the Requisition Import report parameters window?A: The list of values for the Import Source parameter drives off of the records, which currently reside in the PO_REQUISITIONS_INTERFACE_ALL table. Within this table is the column, INTERFACE_SOURCE_CODE, which contains the source from where the data was created and in turn is the same value that shows in the list of values. Example: Say that there are currently 20 rows In PO_REQUISITIONS_INTERFACE_ALL.Ten of the rows have an INTERFACE_SOURCE_CODE of 'INV', and the other ten rows have an INTERFACE_SOURCE_CODE value of 'WIP'. When the user then goes to view the list of values, it will show 'INV' and 'WIP' in the list, as those are the only sources currently loaded and unprocessed in the interface table. [top]
Q5. What methods are available in the application to resolve errored records in the PO_INTERFACE_ERRORS table?A: Oracle Purchasing provides the Requisition Import Exceptions Report, which can be used to diagnose problems with the records, which have currently errored out in the PO_REQUISITIONS_INTERFACE_ALL table. - Responsibility: Purchasing Super User - Navigation: Reports/Run, then select Requisition Import Exceptions Report There is a parameter titled 'Delete Exceptions’. If this is populated with 'Yes', then all records in the PO_REQUISITIONS_INTERFACE_ALL table with a status of ‘ERROR’will be deleted when the report is executed. If the parameter is set to ‘No', then you will see the errors from the report and be able to manually fix the data in the table, if so desired; then, upon completion of the data correction, run Requisition Import again to process the modified rows in the interface table.[top]
Q6. Can Requisition Import handle multiple currencies?A: Requisition Import is capable of handling multiple currencies, provided that all rate types and currency conversions have been defined.[top]
Q7. Can Requisition Import handle multiple distributions?A: Requisition Import can handle multiple distributions. [top]
Q8. Is it possible to have all requisitions created from MRP to be imported with a status of INCOMPLETE?A: It is not possible to have Requisitions created from MRP imported into the Oracle Purchasing application with a status of INCOMPLETE. The MRP Application inserts all data into the PO_REQUISITIONS_INTERFACE_ALL table with an AUTHORIZATION_STATUS of APPROVED. Therefore, when the Requisition Import program runs, all requisition lines from MRP are created with a Status of APPROVED. If requisitions are created from MRP and the AUTHORIZATION_STATUS is not APPROVED, then please contact support for assistance. [top]
Q9. Is it possible to have all requisitions created from Inventory - Min-Max Planning to be imported with a status of INCOMPLETE?A: Yes, it is possible to have all requisitions created from Min-Max Planning with a status of INCOMPLETE. If the desired outcome is Min-Max requisitions showing a status of INCOMPLETE, it is necessary to set the profile option: INV: MinMax Reorder Approval to Incomplete. Conversely, if this profile option is set to Approved, all requisitions imported from Min-Max Planning will be imported with an approval status based on the approval authority of the user initiating the Requisition Import process. [top]
Q10. How can I achieve creating 10 requisitions for 10 lines populated into the interface table, instead of 1 req. with 10 lines?A: Requisitions are grouped according to the selection chosen by the initiator of the process, based on the parameter of 'GROUP BY’. If this parameter is left blank, the value will default from the Default alternate region of the Purchasing Options form. - Responsibility: Purchasing Super User - Navigation: Setup -> Organizations -> Purchasing Options Default alternate region If the value selected is ALL, then all requisition lines will be on the same requisition. Any other value will group the lines on requisitions based on the value selected. [top]
Q11. Is Requisition Import organization-specific?A: Requisition Import is operating unit-specific. Within the PO_REQUISITIONS_INTERFACE_ALL table lies the column ORG_ID.Upon Initiating the Requisition Import program, the profile 'MO: Operating Unit' is queried to derive the value of ORG_ID tied to the login running the program. Then the Requisition Import program executes, all records in the interface table which are the same as the organization listed in the 'MO: Operating Unit' profile will be processed. If you don't see any valid Import source when you launch Reqimport but if you had already populated the Interface table then you have to check the org_id Column you populated. this org_id will be your operating unit tied to your Applications log-in responsibility. If the org_id is NULL then you can see you record in the Import Source. [top]
Q12. When using encumbrance, is there any validation on the GL Date, ensuring the appropriate periods are open?A: The Requisition Import program will perform date integrity checks against the date value in the PO_REQUISITIONS_INTERFACE_ALL.GL_DATE field. This field GL_DATE, is reserved for systems operating under Encumbrance Accounting constraints. It is necessary to ensure that the encumbrance year is opened for the GL_DATE being specified. [top]
Q13. How can I achieve grouping by Vendors?A: First check to see if any records in PO_REQUISITIONS_INTERFACE_ALL have a value for the GROUP_CODE or REQ_NUMBER_SEGMENT1 columns. If there is no value in either of these two columns, then the Requisition Import Program uses the Default Group By that you setup to group requisition lines. Also Navigate to Purchasing -> Setup -> Purchasing Options and Check the group by setting.[top]
Q14. Why some times Requisition Import Process fails to create Requisitions when the Data is imported from MRP?A: Ensure that you use revision number for the item. This is mandatory when you use the profile option “Purchasing by Revision”. The value will indicate whether to pass on item revision to the purchase requisition. You can update this profile at the site level. If this profile is set to Yes, then the item used for requisition import process should have a revision number. Now when you repeat the process the Requisition Import works and the requisitions will be created Successfully from MRP. [top]
Q15. How does Requisition Import Process generate Accounts? A: It can be either one of 2 methods for accounts to be generated:1. By a valid CCID or 2. By a valid combination of account segments. We do not generate the accounts using the Account generator process. We only validate the charge_account_id or by a valid combination of Account segments which are populated in the interface table. This is the existing functionality.[top]
Q16. How can automatically approve the Requisitions I am creating?A: There are two ways of doing this: 1. You can populate records in the Interface table with status as APPROVED. In this case the Approval process is not called after creating the Req. with APPROVED status. 2. If you still want the Requisitions created to go through the approval process then you have to set Requisition Import Parameter 'Initiate Approval after Reqimport' to 'Yes' when Launching the Requisition Import Concurrent Program. For the Requisition to be automatically Approved, the APPROVER_ID value from PO_REQUISITIONS_INTERFACE_ALL must have authority to approve the Requisition. If that user does not have approval authority, then the Requisition will be in status = IN PROCESS and forwarded up that user's Approval Hierarchy. [top]
Q17. How will I get the trace and detailed log for the Requisition Import Process?A: You have to set the profile 'PO: Set Debug Concurrent On' to 'Yes to get the detailed log and Database level for the Requisition Import Process. [top]
Q18. When I load the Requisition Interface and create Requisitions it always does Sourcing. How can I stop sourcing from happening?A: You have to set the autosource_flag in the Requisition interface to 'N' to avoid vendor Sourcing[top]
Q19. How can I avoid sourcing from overriding my vendor information?A: You have to set the autosource_flag to 'P' for partial sourcing. [top]
Q20. How does Requisition Import process use the Group-By parameter while launching Requisition Import?A: The Requisition Import process will first look at the Group By parameter selected when the process is submitted; should this parameter be left blank, the system will then look to the Group-By field residing in the Purchasing Options form. To setup in Purchasing option Form the Navigation is Setup/Organizations/Purchasing Options - Default Alternate Region Requisition Import Group-By Field. [top]
Q21. What does the 'MRP: Purchasing by Revision' and 'INV: Purchasing by Revision' do?A: The profile 'MRP: Purchasing by Revision' is maintained by MRP and the 'INV: Purchasing by Revision' profile is maintained by Inventory. This profile option is mainly used by the respective products to determine if the Item Revision needs to be populated while loading the Requisition Interface Tables. Most of the bugs related to these profiles are that sourcing gets affected during Req Import. If the Blanket PO has the Item Revision and the Item in the Interface table does not have the Item Revision field populated, then Sourcing could be a Issue and Releases will not be created. [top]
Q22. How do I get the Tax log file for the Requisition Import process?A: To get the log file please follow the steps below. Step 1: ------- Set Profile Option 'Tax: Debug File Directory' Set the profile option Tax: Debug File Directory to a server side directory where a file that contains log messages will be created. You can set this profile option only at the Site level. Note: This directory must be set as the value of one of the Oracle initialization parameters, 'UTL_FILE_DIR' To see the current value of UTL_FILE_DIR, issue the following SQL statement in the apps schema: select value from v$parameter where name = 'utl_file_dir' If this parameter does not contain a value, modify the initialization parameter file init.ora to add the parameter and a value for it (where is the name of your database). Step 2: ------- Set Profile Option Tax: Debug Flag Set the profile option Tax: Debug Flag to Yes to create a file with debugging information. Set this profile option at the User level. A log file called .log will be created in the directory specified by the profile option Tax: Debug File Directory (where is your login username). Note: The form should be closed after the transaction is saved.[top]
FAQ: Autocreate Purchase Orders
Q1. Does autocreate copies descriptive flexfields from the requisition to the document you create? A: Yes, but it does not validate the information. For example: If in the requisition desc flex is not mandatory and in the purchase order it is mandatory, autocreate will not error out. It will just copy as is.[top]
Q2. Does autocreate copy Notes from the requisition to the document you are creating?A: Yes, Notes are copied from the requisition lines and the corresponding requisition header. [top]
Q3. What are the columns on which autocreate combines the requisition lines into a single document lines?A: For purchase order, Purchasing combines the quantities of all requisition lines that have the same item, item revision, line type, transaction reason, and unit of measure onto a single document line. For RFQ’s, quantities of all requisition lines that have the same item, revision, and line type are combined.[top]
Q4. What price becomes the actual price in case multiple requisition lines with different prices are combined to single PO line?A: The lowest unit price from the combined requisition lines becomes the actual price of the purchase order line. [top]
Q5. What are the columns based on which Shipping information is combined in case of autocreate? A: For purchase orders and releases, Purchasing combines shipment information only if the requisition lines have the same need–by date, ship–to location, organization, Accrual type (period–end or on–line), and shipment type [top]
Q6. Does autocreate add to an existing PO shipment that has been encumbered? A: Purchasing does not add to an existing purchase order shipment if that shipment has been encumbered even though all the grouping columns necessary to combine shipping information are there. [top]
Q7. What can be done to open the created document directly once autocreate is done successfully?A: Set the profile option PO: Display the autocreated Document to Yes, Purchasing displays the Purchase Orders, Releases, or RFQ window, as appropriate, after creating your document lines. [top]
Q8. Can requisition line with item number and without item number [one time item] be combined to single document line in autocreate?A: If you want to combine two requisition lines for the same item, one with an item number and one without, you have to manually autocreate the document and use Modify on the Tools menu to add the predefined item to the requisition line for the one–time item. Note: You cannot use Modify with outside processing items or if you are using encumbrance or budgetary control. [top]
Q9. Can you autocreate a release if the description of the requisition created in PO is different of the description of the Blanket? A: No, If we do not choose an item, that is if the requisition and blanket are created with one time/expense items the autocreate process tries to match the descriptions as item id's are null. The only differentiating factor in one time items (item id null) is the description. [top]
Q10. How do you prevent autocreate from seeing requisitions from another organization? A: Requisitions and Purchase Orders are not organization specific. If you do not want to be able to see or access requisitions across different organizations, then you need to set up different operating units with different responsibilities tied to each one. [top]
Q11. Can you autocreate from a quotation and tie the PO to the associated quotation and requisition?A: Yes, you can autocreate from a Quotation.Navigation: 1. Create and approve a requisition. 2. Go to the AutoCreate Screen, chose the requisition form the pool of approved requisitions. 3. Change the Document Type field to RFQ and click the automatic button. 4. The RFQ is created and appears on the screen. 5. Enter the required fields on the RFQ (quote affectivity), click on the Supplier button and choose the list of suppliers. Change status to active and save. 6. To enter the vendor responses a Quote must be created. Go to the RFQ screen and query up the RFQ you just created. Click Special on the Tool bar and choose Copy Document. This will create your quotation. 7. Go to the Quotation screen and query up the new quotation and enter the price break information. Change the description (if PO attribute is set to allow the description to be changed). 8. Approve the quotation. 9. AutoCreate the PO from the requisition. Delete the description if the quote has a description different than the requisition Click on the catalog button - Receive message Your can update only the price for the saved record. Open the Catalog to select price only Click YES 10. Select the quote. 11. You will now have both the requisition and quote tied to the PO. [top]
Q12. Where does the note to buyer show on an autocreated PO? A: On the AutoCreate form, go to the Folder menu and choose Show Field. Select Note to Buyer and click OK. The field will now be displayed. If you would like this field to be displayed every time you use autocreate, go to Folder -> Save As... Give the folder a name and check the Open as Default box. [top]
Q13. Does the supplier name from a requisition get carried over to an autocreated purchase order? A: The standard functionality is that if the requisition has a the "suggested supplier name" field populated, it would carry over to the autocreated PO. The "suggested supplier name" field will only carry to the autocreated PO if it was selected from the list of values on the requisition. If it is typed in manually, it will not carry over. [top]
Q14. What causes the APP-14090 error when autocreating a requisition?A: There are several things that must be performed to address this issue: * Profile Option in MRP must be set as follows: - MRP: Sourcing Rule Category Set value must be set to Purchasing in the Purchasing application.
* AutoCreate Blanket PO - Revisions do not default for Items when autocreating Blanket PO and the Item Revision # must be entered. - The Item Revision number on the requisition must match the Item Revision number on the PO.
* Navigate: Setup -->Organization -->Financial Options; and in the Alternate Region ENCUMBRANCE, verify if the REQUISITION ENCUMBRANCE checkbox is checked.
* In the Sys Admin Responsibility navigate to: Profiles=> query for the Profile Option PO: AUTOCREATE GL DATE.
If using the Encumbrance for Requisitions, then this Profile Option can be set to either AUTOCREATE DATE or REQUISITION GL DATE. If not using Encumbrance, then you may set it to NULL. This will solve the problem. The Profile Option PO: AUTOCREATE GL DATE is applicable only if you are using Encumbrance for Requisitions. [top]
Q15. How do you autocreate a requisition with a document type as blanket release when requisitions were imported from a 3rd party system?A: Ensure the line types selected for Requisitions are appropriate. You need to have Requisition Line types and PO Line types correctly associated. Rerun the process and verify that the system does not error out. Submit the request for requisition import and use the AutoCreate window to create document with type as Blanket Release against the requisition. Navigation: Purchasing -> Reports -> Submit a request for Requisition Import Purchasing -> AutoCreate[top]
Q16. How do you autocreate MRP generated requisitions to a blanket purchase order? A: First initiate the Release Purchase Requisitions from the Planners Workbench. Navigation: Material Planning -> MRP -> Workbench Second, in the Purchasing Responsibility, AutoCreate the requisition to a Blanket PO. Navigation: AutoCreate For Autocreate to find these requisition lines from MRP, the Blanket PO line type must be set to Goods because the MRP Purchase Requisition is always created with a line type of Goods. The reason that MRP uses the line type of Goods is because Goods is seeded data and because the MRP Planner Workbench uses MRPPRELB.pls to insert a record into the PO_REQUISITION_INTERFACE table. [top]
Q17. Can you autocreate more than one standard PO in one autocreate session? A: Yes, 1) Find the requisition lines to be autocreated. 2) Choose a line. 3) Autocreate the purchases order using the automatic button. 4) Do not leave the requisition lines screen. 5) Choose a different line. 6) Try to autocreate another standard purchase order by clicking the automatic button. 7) The system gives the message: app-14090: no requisition lines were autocreated. [top]
Q18. Try to autocreate, but the system hangs, how to cancel the requisition that are locked? A: Check if there is a lock on the PO related tables. Select object_id, session_id, oracle_username, os_user_name, Process, locked_mode From sys.v_$locked_object;
Select a.object_name, b.oracle_username From all_objects a, v$locked_object b Where a.object_id = b.object_id And a.object_name like 'po%';
If you have any records returned, you have a lock. To disable the lock, kill the session. Regenerating the form and bouncing the database will unlock all the objects. [top]
Q19. What is the package or procedure that stores the autocreate process?A: POXBWP1B.pls - autocreate po package body. Description: this package contains all the functions to create purchase orders, releases and rfq's from data stored in the po_headers_interface, po_lines_interface and po_distributions_interface tables. When a user selects a line to be autocreated, it loads the above interface tables. At that point the functions which are part of this package are called and move to create the req line into a release or purchase order.[top]
Q20. What does the grouping method 'Default' indicate in the autocreate form?A: With the grouping method 'default' requisition lines for the same item, revision, line type, unit of measure, and transaction reason are combined into individual purchase order lines; and requisition lines for the same item, revision, and line type are combined into individual rfq lines.[top]
Q21. I autocreated a PO with two lines. When I go to the purchase order entry screen and query the PO, instead of showing the lines created, it only shows a new line with number 3. Why? A: Make sure Inventory organization field is populated in Financial Options
Q1. What is the Basic Purchasing Setup for Requisition Import?A: If importing requisitions from Inventory, input a value for the profile option INV: Minmax Reorder Approval. If the value of INCOMPLETE is selected, the result will be imported Requisitions that require an approval. If the value is APPROVED, then the requisitions cannot be queried in the Requisition entry form; rather, the Requisition Summary form will have to be utilized to view information on the imported approved requisitions.
If importing requisitions from MRP, input a value for the profile option MRP: Purchasing By Revision. This profile option is important if you are using multiple revisions per item and using sourcing rules to create Purchase Orders or Releases. This profile option indicates whether or not to pass on the item revision to the purchase requisition.
Setup/Organizations/Purchasing - Default Alternate Region Requisition Import Group-By Field. The Requisition Import process will first look at the Group By parameter selected when the process is submitted; should this parameter be left blank, the system will then look to the Group-By field residing in the Purchasing Options form. If you expect releases to be created from the requisitions, which you import, make sure the profile option PO: Release During Req Import is populated with the correct value. The choices for this profile are Yes or No. If the profile is set to Yes and all sourcing rule information is properly set up, then blanket releases will be created via the Create Releases process. If the profile is set to No, the Create Releases process will not run at the completion of Requisition Import and all releases will have to be created manually via Auto Create.[top]
Q2. How does Requisition Import determine the grouping method for incoming pieces of data?A: This function groups requisitions. It first assigns values to REQUISITION_LINE_ID and REQ_DISTRIBUTION_ID; the function then groups Requisitions based on the REQ_NUMBER_SEGMENT1 column. All requisitions with the same NOT NULL REQ_NUMBER_SEGMENT1 are assigned the same REQUISITION_HEADER_ID. The function then groups Requisitions based on the GROUP_CODE column. All requisitions with the same value in the GROUP_CODE column are assigned the same REQUISITION_HEADER_ID. It then groups based on the GROUP_BY parameter, which takes on the value of DEFAULT_GROUP_BY if not provided. GROUP_BY could be one of the following: BUYER, CATEGORY, ITEM, VENDOR, LOCATION or ALL. [top]
Q3. How is the PO_INTERFACE_ERRORS table purged and does this data have any dependencies?A: Oracle Purchasing provides the Requisition Import Exceptions Report, which can be used to diagnose records in Error in the PO_REQUISITIONS_INTERFACE_ALL table. It also has an option to purge the Error records in PO_REQUISITIONS_INTERFACE_ALL and the corresponding Error message in the PO_INTERFACE_ERRORS table: - Responsibility: Purchasing Super User- Navigation: Reports/Run, then select Requisition Import Exceptions Report There is a parameter titled 'Delete Exceptions'. If you select 'Yes', then records in the PO_REQUISITIONS_INTERFACE_ALL table with a status of ‘ERROR' and the corresponding records in the PO_INTERFACE_ERRORS table will be deleted. You can also restrict the deleted records by selecting the Batch_id and the Interface Source code. The dependency is between PO_REQUISITIONS_INTERFACE_ALL (transaction_id) and PO_INTERFACE_ERRORS (interface_transaction_id) [top]
Q4. How is the list of values derived for the Import Source column within the Requisition Import report parameters window?A: The list of values for the Import Source parameter drives off of the records, which currently reside in the PO_REQUISITIONS_INTERFACE_ALL table. Within this table is the column, INTERFACE_SOURCE_CODE, which contains the source from where the data was created and in turn is the same value that shows in the list of values. Example: Say that there are currently 20 rows In PO_REQUISITIONS_INTERFACE_ALL.Ten of the rows have an INTERFACE_SOURCE_CODE of 'INV', and the other ten rows have an INTERFACE_SOURCE_CODE value of 'WIP'. When the user then goes to view the list of values, it will show 'INV' and 'WIP' in the list, as those are the only sources currently loaded and unprocessed in the interface table. [top]
Q5. What methods are available in the application to resolve errored records in the PO_INTERFACE_ERRORS table?A: Oracle Purchasing provides the Requisition Import Exceptions Report, which can be used to diagnose problems with the records, which have currently errored out in the PO_REQUISITIONS_INTERFACE_ALL table. - Responsibility: Purchasing Super User - Navigation: Reports/Run, then select Requisition Import Exceptions Report There is a parameter titled 'Delete Exceptions’. If this is populated with 'Yes', then all records in the PO_REQUISITIONS_INTERFACE_ALL table with a status of ‘ERROR’will be deleted when the report is executed. If the parameter is set to ‘No', then you will see the errors from the report and be able to manually fix the data in the table, if so desired; then, upon completion of the data correction, run Requisition Import again to process the modified rows in the interface table.[top]
Q6. Can Requisition Import handle multiple currencies?A: Requisition Import is capable of handling multiple currencies, provided that all rate types and currency conversions have been defined.[top]
Q7. Can Requisition Import handle multiple distributions?A: Requisition Import can handle multiple distributions. [top]
Q8. Is it possible to have all requisitions created from MRP to be imported with a status of INCOMPLETE?A: It is not possible to have Requisitions created from MRP imported into the Oracle Purchasing application with a status of INCOMPLETE. The MRP Application inserts all data into the PO_REQUISITIONS_INTERFACE_ALL table with an AUTHORIZATION_STATUS of APPROVED. Therefore, when the Requisition Import program runs, all requisition lines from MRP are created with a Status of APPROVED. If requisitions are created from MRP and the AUTHORIZATION_STATUS is not APPROVED, then please contact support for assistance. [top]
Q9. Is it possible to have all requisitions created from Inventory - Min-Max Planning to be imported with a status of INCOMPLETE?A: Yes, it is possible to have all requisitions created from Min-Max Planning with a status of INCOMPLETE. If the desired outcome is Min-Max requisitions showing a status of INCOMPLETE, it is necessary to set the profile option: INV: MinMax Reorder Approval to Incomplete. Conversely, if this profile option is set to Approved, all requisitions imported from Min-Max Planning will be imported with an approval status based on the approval authority of the user initiating the Requisition Import process. [top]
Q10. How can I achieve creating 10 requisitions for 10 lines populated into the interface table, instead of 1 req. with 10 lines?A: Requisitions are grouped according to the selection chosen by the initiator of the process, based on the parameter of 'GROUP BY’. If this parameter is left blank, the value will default from the Default alternate region of the Purchasing Options form. - Responsibility: Purchasing Super User - Navigation: Setup -> Organizations -> Purchasing Options Default alternate region If the value selected is ALL, then all requisition lines will be on the same requisition. Any other value will group the lines on requisitions based on the value selected. [top]
Q11. Is Requisition Import organization-specific?A: Requisition Import is operating unit-specific. Within the PO_REQUISITIONS_INTERFACE_ALL table lies the column ORG_ID.Upon Initiating the Requisition Import program, the profile 'MO: Operating Unit' is queried to derive the value of ORG_ID tied to the login running the program. Then the Requisition Import program executes, all records in the interface table which are the same as the organization listed in the 'MO: Operating Unit' profile will be processed. If you don't see any valid Import source when you launch Reqimport but if you had already populated the Interface table then you have to check the org_id Column you populated. this org_id will be your operating unit tied to your Applications log-in responsibility. If the org_id is NULL then you can see you record in the Import Source. [top]
Q12. When using encumbrance, is there any validation on the GL Date, ensuring the appropriate periods are open?A: The Requisition Import program will perform date integrity checks against the date value in the PO_REQUISITIONS_INTERFACE_ALL.GL_DATE field. This field GL_DATE, is reserved for systems operating under Encumbrance Accounting constraints. It is necessary to ensure that the encumbrance year is opened for the GL_DATE being specified. [top]
Q13. How can I achieve grouping by Vendors?A: First check to see if any records in PO_REQUISITIONS_INTERFACE_ALL have a value for the GROUP_CODE or REQ_NUMBER_SEGMENT1 columns. If there is no value in either of these two columns, then the Requisition Import Program uses the Default Group By that you setup to group requisition lines. Also Navigate to Purchasing -> Setup -> Purchasing Options and Check the group by setting.[top]
Q14. Why some times Requisition Import Process fails to create Requisitions when the Data is imported from MRP?A: Ensure that you use revision number for the item. This is mandatory when you use the profile option “Purchasing by Revision”. The value will indicate whether to pass on item revision to the purchase requisition. You can update this profile at the site level. If this profile is set to Yes, then the item used for requisition import process should have a revision number. Now when you repeat the process the Requisition Import works and the requisitions will be created Successfully from MRP. [top]
Q15. How does Requisition Import Process generate Accounts? A: It can be either one of 2 methods for accounts to be generated:1. By a valid CCID or 2. By a valid combination of account segments. We do not generate the accounts using the Account generator process. We only validate the charge_account_id or by a valid combination of Account segments which are populated in the interface table. This is the existing functionality.[top]
Q16. How can automatically approve the Requisitions I am creating?A: There are two ways of doing this: 1. You can populate records in the Interface table with status as APPROVED. In this case the Approval process is not called after creating the Req. with APPROVED status. 2. If you still want the Requisitions created to go through the approval process then you have to set Requisition Import Parameter 'Initiate Approval after Reqimport' to 'Yes' when Launching the Requisition Import Concurrent Program. For the Requisition to be automatically Approved, the APPROVER_ID value from PO_REQUISITIONS_INTERFACE_ALL must have authority to approve the Requisition. If that user does not have approval authority, then the Requisition will be in status = IN PROCESS and forwarded up that user's Approval Hierarchy. [top]
Q17. How will I get the trace and detailed log for the Requisition Import Process?A: You have to set the profile 'PO: Set Debug Concurrent On' to 'Yes to get the detailed log and Database level for the Requisition Import Process. [top]
Q18. When I load the Requisition Interface and create Requisitions it always does Sourcing. How can I stop sourcing from happening?A: You have to set the autosource_flag in the Requisition interface to 'N' to avoid vendor Sourcing[top]
Q19. How can I avoid sourcing from overriding my vendor information?A: You have to set the autosource_flag to 'P' for partial sourcing. [top]
Q20. How does Requisition Import process use the Group-By parameter while launching Requisition Import?A: The Requisition Import process will first look at the Group By parameter selected when the process is submitted; should this parameter be left blank, the system will then look to the Group-By field residing in the Purchasing Options form. To setup in Purchasing option Form the Navigation is Setup/Organizations/Purchasing Options - Default Alternate Region Requisition Import Group-By Field. [top]
Q21. What does the 'MRP: Purchasing by Revision' and 'INV: Purchasing by Revision' do?A: The profile 'MRP: Purchasing by Revision' is maintained by MRP and the 'INV: Purchasing by Revision' profile is maintained by Inventory. This profile option is mainly used by the respective products to determine if the Item Revision needs to be populated while loading the Requisition Interface Tables. Most of the bugs related to these profiles are that sourcing gets affected during Req Import. If the Blanket PO has the Item Revision and the Item in the Interface table does not have the Item Revision field populated, then Sourcing could be a Issue and Releases will not be created. [top]
Q22. How do I get the Tax log file for the Requisition Import process?A: To get the log file please follow the steps below. Step 1: ------- Set Profile Option 'Tax: Debug File Directory' Set the profile option Tax: Debug File Directory to a server side directory where a file that contains log messages will be created. You can set this profile option only at the Site level. Note: This directory must be set as the value of one of the Oracle initialization parameters, 'UTL_FILE_DIR' To see the current value of UTL_FILE_DIR, issue the following SQL statement in the apps schema: select value from v$parameter where name = 'utl_file_dir' If this parameter does not contain a value, modify the initialization parameter file init
FAQ: Autocreate Purchase Orders
Q1. Does autocreate copies descriptive flexfields from the requisition to the document you create? A: Yes, but it does not validate the information. For example: If in the requisition desc flex is not mandatory and in the purchase order it is mandatory, autocreate will not error out. It will just copy as is.[top]
Q2. Does autocreate copy Notes from the requisition to the document you are creating?A: Yes, Notes are copied from the requisition lines and the corresponding requisition header. [top]
Q3. What are the columns on which autocreate combines the requisition lines into a single document lines?A: For purchase order, Purchasing combines the quantities of all requisition lines that have the same item, item revision, line type, transaction reason, and unit of measure onto a single document line. For RFQ’s, quantities of all requisition lines that have the same item, revision, and line type are combined.[top]
Q4. What price becomes the actual price in case multiple requisition lines with different prices are combined to single PO line?A: The lowest unit price from the combined requisition lines becomes the actual price of the purchase order line. [top]
Q5. What are the columns based on which Shipping information is combined in case of autocreate? A: For purchase orders and releases, Purchasing combines shipment information only if the requisition lines have the same need–by date, ship–to location, organization, Accrual type (period–end or on–line), and shipment type [top]
Q6. Does autocreate add to an existing PO shipment that has been encumbered? A: Purchasing does not add to an existing purchase order shipment if that shipment has been encumbered even though all the grouping columns necessary to combine shipping information are there. [top]
Q7. What can be done to open the created document directly once autocreate is done successfully?A: Set the profile option PO: Display the autocreated Document to Yes, Purchasing displays the Purchase Orders, Releases, or RFQ window, as appropriate, after creating your document lines. [top]
Q8. Can requisition line with item number and without item number [one time item] be combined to single document line in autocreate?A: If you want to combine two requisition lines for the same item, one with an item number and one without, you have to manually autocreate the document and use Modify on the Tools menu to add the predefined item to the requisition line for the one–time item. Note: You cannot use Modify with outside processing items or if you are using encumbrance or budgetary control. [top]
Q9. Can you autocreate a release if the description of the requisition created in PO is different of the description of the Blanket? A: No, If we do not choose an item, that is if the requisition and blanket are created with one time/expense items the autocreate process tries to match the descriptions as item id's are null. The only differentiating factor in one time items (item id null) is the description. [top]
Q10. How do you prevent autocreate from seeing requisitions from another organization? A: Requisitions and Purchase Orders are not organization specific. If you do not want to be able to see or access requisitions across different organizations, then you need to set up different operating units with different responsibilities tied to each one. [top]
Q11. Can you autocreate from a quotation and tie the PO to the associated quotation and requisition?A: Yes, you can autocreate from a Quotation.Navigation: 1. Create and approve a requisition. 2. Go to the AutoCreate Screen, chose the requisition form the pool of approved requisitions. 3. Change the Document Type field to RFQ and click the automatic button. 4. The RFQ is created and appears on the screen. 5. Enter the required fields on the RFQ (quote affectivity), click on the Supplier button and choose the list of suppliers. Change status to active and save. 6. To enter the vendor responses a Quote must be created. Go to the RFQ screen and query up the RFQ you just created. Click Special on the Tool bar and choose Copy Document. This will create your quotation. 7. Go to the Quotation screen and query up the new quotation and enter the price break information. Change the description (if PO attribute is set to allow the description to be changed). 8. Approve the quotation. 9. AutoCreate the PO from the requisition. Delete the description if the quote has a description different than the requisition Click on the catalog button - Receive message Your can update only the price for the saved record. Open the Catalog to select price only Click YES 10. Select the quote. 11. You will now have both the requisition and quote tied to the PO. [top]
Q12. Where does the note to buyer show on an autocreated PO? A: On the AutoCreate form, go to the Folder menu and choose Show Field. Select Note to Buyer and click OK. The field will now be displayed. If you would like this field to be displayed every time you use autocreate, go to Folder -> Save As... Give the folder a name and check the Open as Default box. [top]
Q13. Does the supplier name from a requisition get carried over to an autocreated purchase order? A: The standard functionality is that if the requisition has a the "suggested supplier name" field populated, it would carry over to the autocreated PO. The "suggested supplier name" field will only carry to the autocreated PO if it was selected from the list of values on the requisition. If it is typed in manually, it will not carry over. [top]
Q14. What causes the APP-14090 error when autocreating a requisition?A: There are several things that must be performed to address this issue: * Profile Option in MRP must be set as follows: - MRP: Sourcing Rule Category Set value must be set to Purchasing in the Purchasing application.
* AutoCreate Blanket PO - Revisions do not default for Items when autocreating Blanket PO and the Item Revision # must be entered. - The Item Revision number on the requisition must match the Item Revision number on the PO.
* Navigate: Setup -->Organization -->Financial Options; and in the Alternate Region ENCUMBRANCE, verify if the REQUISITION ENCUMBRANCE checkbox is checked.
* In the Sys Admin Responsibility navigate to: Profiles=> query for the Profile Option PO: AUTOCREATE GL DATE.
If using the Encumbrance for Requisitions, then this Profile Option can be set to either AUTOCREATE DATE or REQUISITION GL DATE. If not using Encumbrance, then you may set it to NULL. This will solve the problem. The Profile Option PO: AUTOCREATE GL DATE is applicable only if you are using Encumbrance for Requisitions. [top]
Q15. How do you autocreate a requisition with a document type as blanket release when requisitions were imported from a 3rd party system?A: Ensure the line types selected for Requisitions are appropriate. You need to have Requisition Line types and PO Line types correctly associated. Rerun the process and verify that the system does not error out. Submit the request for requisition import and use the AutoCreate window to create document with type as Blanket Release against the requisition. Navigation: Purchasing -> Reports -> Submit a request for Requisition Import Purchasing -> AutoCreate[top]
Q16. How do you autocreate MRP generated requisitions to a blanket purchase order? A: First initiate the Release Purchase Requisitions from the Planners Workbench. Navigation: Material Planning -> MRP -> Workbench Second, in the Purchasing Responsibility, AutoCreate the requisition to a Blanket PO. Navigation: AutoCreate For Autocreate to find these requisition lines from MRP, the Blanket PO line type must be set to Goods because the MRP Purchase Requisition is always created with a line type of Goods. The reason that MRP uses the line type of Goods is because Goods is seeded data and because the MRP Planner Workbench uses MRPPRELB.pls to insert a record into the PO_REQUISITION_INTERFACE table. [top]
Q17. Can you autocreate more than one standard PO in one autocreate session? A: Yes, 1) Find the requisition lines to be autocreated. 2) Choose a line. 3) Autocreate the purchases order using the automatic button. 4) Do not leave the requisition lines screen. 5) Choose a different line. 6) Try to autocreate another standard purchase order by clicking the automatic button. 7) The system gives the message: app-14090: no requisition lines were autocreated. [top]
Q18. Try to autocreate, but the system hangs, how to cancel the requisition that are locked? A: Check if there is a lock on the PO related tables. Select object_id, session_id, oracle_username, os_user_name, Process, locked_mode From sys.v_$locked_object;
Select a.object_name, b.oracle_username From all_objects a, v$locked_object b Where a.object_id = b.object_id And a.object_name like 'po%';
If you have any records returned, you have a lock. To disable the lock, kill the session. Regenerating the form and bouncing the database will unlock all the objects. [top]
Q19. What is the package or procedure that stores the autocreate process?A: POXBWP1B.pls - autocreate po package body. Description: this package contains all the functions to create purchase orders, releases and rfq's from data stored in the po_headers_interface, po_lines_interface and po_distributions_interface tables. When a user selects a line to be autocreated, it loads the above interface tables. At that point the functions which are part of this package are called and move to create the req line into a release or purchase order.[top]
Q20. What does the grouping method 'Default' indicate in the autocreate form?A: With the grouping method 'default' requisition lines for the same item, revision, line type, unit of measure, and transaction reason are combined into individual purchase order lines; and requisition lines for the same item, revision, and line type are combined into individual rfq lines.[top]
Q21. I autocreated a PO with two lines. When I go to the purchase order entry screen and query the PO, instead of showing the lines created, it only shows a new line with number 3. Why? A: Make sure Inventory organization field is populated in Financial Options
Subscribe to:
Posts (Atom)