Friday, May 4th, 2012 by Robin Harris
After an upgrade to E-Business suite R12.1.3 on one of our test servers we encountered an issue with the Invoice Workbbok form (APXINWKB.fmb).
When trying to enter an invoice line it would error when saving or performing other tasks which involved validating the data. (e.g. Calculate Tax)
The error encountered was:
ERROR
———————–
Invalid argument to LINE_SUM_FOLDER_ITEMS_ITEM.ASSET_BOOK: EVENT=’WHEN-VALIDATE-ITEM’
Read the rest of this entry »
Tags: APXINWKB, E-Business Suite, FRM-40735, Payables, R12.1.3
Posted in Apps DBA, E-Business Suite, Functional, Technical | No Comments »
Friday, February 17th, 2012 by Ian Boyling
If you are experiencing difficulties in seeing all your required Legal Entities as a List of Values (LoV) within the bank account definition form in Oracle Cash Management, following these simple steps will rectify the issue and unlock the LoV. This process will also explain how to grant permissions to a specific role or responsibility based on bank account use and maintenance.
- Login to Oracle Applications as sysadmin
- Select the User Management Responsibility
- Select the navigation path of ‘Roles and Role Inheritance’
- Within the field ‘Type‘, select Roles and Responsibilities
- Following step 4, a new field appears called ’Category‘, select ‘Miscellaneous’ as the value
- Within the ‘Application‘ field, select ‘Cash Management‘. Note: Add the name of the role or responsibility if known
- Click Go

- Search for the role or responsibility that you intend to use to create bank accounts. Note: The permissions you assign during the rest of this procedure will be aligned to the choice you make here.
- Click on the update icon against the desired role or responsibility
- A new window (update Role) will be displayed. Click the ‘Security Wizards‘ button
- Click Save and Proceed (if requested)
- Click the ‘Run Wizard‘ icon against ‘CE UMX Security‘ row
- Bank Account Security Management Window: In this window you can add all legal entities to which you wish to grant access and assign permissions based on the selected role or responsibility. Click the ‘Add Legal Entities‘ button and select any required legal entities that are not already listed.
- Choose each permission that you wish to assign to the Legal Entity for the role or responsibility relating to bank accounts and further use within the applications. Choices include Use, Maintenance and Bank account Transfers. Note: Each permission is explained at the foot of this procedure.
- Apply the changes and then verify in the Cash Management responsibility if you are now able to see the Legal Entities in bank account creation form.

Bank Account Grants: Permissions
Use: Allows the user to view the bank accounts for the selected legal entity in Cash Positioning, Cash Forecasting and Cash flows, as well as reconcile cash flows for the selected legal entity.
Bank Account Transfer: Allows the user to transfer funds from and to the bank accounts for the selected legal entity.
Maintenance: Allows the user to create and update bank accounts for the selected legal entity
Tags: Bank Account definition, Bank Accounts, Banks, Cash Management, CE, E-Business Suite, EBS, Legal Entities, Legal Entity, LoV, Oracle, Oracle Cash Management, Payables, R12, R12.1.2, Release12, Roles and Role Inheritance, User Management
Posted in E-Business Suite, Functional | No Comments »
Tuesday, January 31st, 2012 by Ian Boyling
Oracle Internet Expenses comes seeded with three Mileage ‘Unit of Measures‘, namely Miles, Kilometers and Swedish Miles. Without trying to offend our friends from Sweden, it is often the case that an end user of Oracle i-Expenses will only want to see and use the unit of measure(s) that are relevant to the business expense policy or geographical region in which they operate. When creating an expense claim and selecting the expense type of ‘Mileage’ users often ask the questions:
Why do I see Swedish Miles?
or
Can I just have Miles?
or
Can you remove all values in the Unit of Measure list and just keep the one that is relevant for our T&S policy?
For users in other regions, the same question may well include the desire to remove Miles (e.g. regions in mainland Europe) or Kilometers (e.g. UK). The screenshot below shots the seeded view of values a user is presented with when entering a mileage claim.
Read the rest of this entry »
Tags: E-Business Suite, EBS, Expense Claim, Expense Report, Expense Types, i-Expenses, Internet Expenses, Kilometers, Mileage, Miles, OIE, Payables, Swedish Miles
Posted in E-Business Suite, Functional | No Comments »
Tuesday, July 7th, 2009 by Andy Coates
As a Projects user, an annoyance that I continue to encounter with Payables is that the pa_addition_flag is not shown as a column for Payables invoice distributions. The pa_addition_flag shows the status of Projects-coded invoice distributions, and among other things, indicates whether an invoice distribution has interfaced successfully to/from Projects. Therefore, if this flag were shown in the form, it would be immediately useful for functional Projects users trying to reconcile discrepancies with Payables. I was hoping that this flag would appear in R12.1.1, alas it has not.
For more information on the pa_addition_flag and for the meanings of the values it holds please refer to Metalink note 226881.1
Read the rest of this entry »
Tags: Invoices, Payables, pa_addition_flag, Projects, R12, Reconciliation, Release12
Posted in E-Business Suite, Functional, Technical | 4 Comments »