Dell PowerEdge T20 Notes

Bought one of these for running various business services.

image

Got it cheap with cashback for less than the CPU would cost in retail.

The CPU and motherboard supports:

  • VT-x: Hardware virtualization
  • VT-d: Direct I/O virtualization
  • vPro: Active management technology (AMT)

Standard specifications:

  • Intel Xeon E3-1225V3
  • Ram 4Gb
  • 1Gb hard disk

Additional components:

  • Kingston 2x8Gb Ram KTD-PE313E/8G
  • Syba SATA III 4 Port PCI-e x1 Controller Card
  • Inateck 2x 2.5 Inch SSD to 3.5 Inch Internal Hard Disk Drive Mounting Kit Bracket
  • HP NC364T 436431-001 435506-003 – Quad / 4 Port Gigabit Ethernet Card Adapter

Hardware Notes

The quad NIC adapter is to enable physical separation of intranet and internet traffic.

ESXi likes to use a single NIC for a single virtual switch for a single subnet.

Hence if you want intranet and internet physically separated for VM’s you just have two virtual switches – one for intranet and one for internet – each mapped to a physical NIC.

The router the isolated the physical ports to virtual networks.

This means it is very hard to break in to the intranet even if the internet VM is compromised.

Details about this belongs in a dedicated network and router post later.

AMT Notes

Enabling AMT

During boot press ctrl-P to enable.

Connecting to AMT: http://{hostname}:16992/logon.htm

Even better download Meshcommander

Looks like this:

image

AMT and VPN Issues

If you connect via VPN you may find you cannot connect to AMT.

It took me a while to find out why not…

This may be caused by you assigned a fixed IP address to the server, which is a normal thing to do for server, however it just doesn’t work then.

Be sure to use DHCP and then use the router to force the IP address using bind to IP:

image

So do as above…

Posted in: Server, Technical Knowledge by Kent Willumsen Comments Off on Dell PowerEdge T20 Notes , ,

ESXi Notes

Having previously worked with Oracle VirtualBox I thought this this would be an easy transition – but no way.

ESXi feel much more like a enterprise ready product, with complexities at that level as well.

Most of the things in here will be related to the CLI interface of ESXi version 6.5.

It is work in progress so there will be errors and things I have misunderstood below as it is for my own use.

Storage

Storage is provisioned in 3 layers starting from lowest level:

  1. Physical Disks (or raid/nas/san drives)
  2. Datastores: collection of physical disks making a logical disk
  3. Virtual Disks: VM storage placed in datastores as vmdk files

Simplified diagram:

image

Physical Disks (devices)

Physical disks are located in directory:

/vmfs/devices/disks

Physical hard disks maps to files in /vmfs/devices/disks like this:

t10.SanDisk00Ultra_Fit000000000000004C531001491102119083

Partitions maps to the above filename but ending with “:” and number like this:

t10.SanDisk00Ultra_Fit000000000000004C531001491102119083:1

Listing disks only:

ls -lh /vmfs/devices/disks | grep -v ":[0-9]$" | grep -v "vml\." | grep -v "total"

Datastores

Datastores are located in directory:

/vmfs/volumes

Datastores are having names like this:

587949b5-46baef34-fb63-1866da2041ef

When a datastore is created and names then it gets a link from the name to the file above like:

SSD -> 587949b5-46baef34-fb63-1866da2041ef

Within the datastore you will find the virtual disks.

Virtual Disks

Virtual disks are located in directory:

/vmfs/volumes/{datastorename}/{vmname}

Together with other VM related files.

Main virtual disk names:

  • {diskname}.vmdk: disk configuration file
  • {diskname}-flat.vmdk: thin provisioned file (full file)
  • {diskname}-rdmp.vmdk: raw provisioned file (link only)

Raw Device Mapping (RDM)

A physical disk can be mapped directly to a VM by creating a link.

Use this command:

vmkfstools -z /vmfs/devices/disks/{physical disk} /vmfs/volumes/SSD/{vmname}/{vmdkname}.vmdk

For example:

vmkfstools -z /vmfs/devices/disks/t10.SanDisk00Ultra_Fit000000000000004C531001491102119083 /vmfs/volumes/SSD/windows/hdd1.vmdk

Creates the following files:

  • {diskname}.vmdk: disk configuration file
  • {diskname}-rdmp.vmdk: raw provisioned file (link only)

Equally to remove the links to a VM do the following:

rm /vmfs/volumes/SSD/windows/hdd1.vmdk
rm /vmfs/volumes/SSD/windows/hdd1-rdmp.vmdk

Virtual Disk Backup

It is easy to do a “cold” backup when the VM is shut down.

Using the command to clone the original disk:

vmkfstools –i /vmfs/volumes/{datastorename}/{vmname}/{vmdkname}.vmdk {backupdest}/{vmdkname}.vmdk -d thin

This command should only be used with thin provisioned disks.

VM Upgrade

When importing a VM from other sources you will find the VM version is older.

I had this problem where I got a warning about the Linux version was not correct.

I could only pick Debian 6 where I was using Debian 8.

This is caused by the VM version is older.

To upgrade the VM version run the following command:

vim-cmd vmsvc/upgrade {vmid} vmx-13

The {vmid} can be obtained by running this command:

vim-cmd vmsvc/getallvms

Extending Virtual Disk

Well you don’t really extend but add another one instead.

Click on the VM details:

image

Click Add hard disk – New hard disk:

image

Adjust disk size:

image

Reboot the VM

List the disk:

# lsblk

NAME               MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT
sda                  8:0    0  100G  0 disk
|-sda1               8:1    0  428M  0 part /boot
|-sda2               8:2    0 18.2G  0 part
| |-turnkey-root   254:0    0   99G  0 lvm  /
| `-turnkey-swap_1 254:1    0  512M  0 lvm  [SWAP]
`-sda3               8:3    0 81.4G  0 part
  `-turnkey-root   254:0    0   99G  0 lvm  /
sdb                  8:16   0  100G  0 disk

So new hard disk is: sdb

Initialise the physical volume:

# pvcreate /dev/sdb
  Physical volume "/dev/sdb" successfully created

Extend volume group in LVM:

# vgextend turnkey /dev/sdb
  Volume group "turnkey" successfully extended

Extend size of logical volume – first try failed as slightly less than 100GB available so just use extents option instead:

# lvextend -L+100G /dev/turnkey/root
  Insufficient free space: 25600 extents needed, but only 25599 available
# lvextend -l 25599 /dev/turnkey/root
  Size of logical volume turnkey/root changed from 99.02 GiB (25348 extents) to 100.00 GiB (25599 extents).
  Logical volume root successfully resized

Resize the file system:

# resize2fs /dev/turnkey/root
resize2fs 1.42.12 (29-Aug-2014)
Filesystem at /dev/turnkey/root is mounted on /; on-line resizing required
old_desc_blocks = 7, new_desc_blocks = 7
The filesystem on /dev/turnkey/root is now 26213376 (4k) blocks long.

All done:

# lsblk
NAME               MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT
sda                  8:0    0  100G  0 disk
|-sda1               8:1    0  428M  0 part /boot
|-sda2               8:2    0 18.2G  0 part
| |-turnkey-root   254:0    0  100G  0 lvm  /
| `-turnkey-swap_1 254:1    0  512M  0 lvm  [SWAP]
`-sda3               8:3    0 81.4G  0 part
  `-turnkey-root   254:0    0  100G  0 lvm  /
sdb                  8:16   0  100G  0 disk
`-turnkey-root     254:0    0  100G  0 lvm  /

Posted in: Server, Technical Knowledge by Kent Willumsen Comments Off on ESXi Notes

Lenovo X1 Carbon Tips and Notes

Very happy with this computer and only have very few issues as per below.

Sierra Wireless EM7345 4G LTE

This WLAN unit seems very unstable and tend to disconnect just after connecting.

It does not help to disable any power settings.

The solution I found was simple – run ping in the background.

Open a command prompt and enter: ping –t bbc.com

Or any other internet address that return the ping:

image 

Just keep this running also when you close the lid and it re-connects when you re-open the lid.

Posted in: General News and Tips, Laptops by Kent Willumsen Comments Off on Lenovo X1 Carbon Tips and Notes

HP ProLiant MicroServer Notes

This server is getting a bit old now but still works well except for some minor problems I will start to record in here.

Excessive disk I/O caused by audiodg.exe

The Microserver does not have a soundcard when using Remote Desktop on Windows 10 it creates a Remote Audio driver .

This remote Remote Audio driver should be disabled using the Device Manager console as per below:

image

Disable by right-clicking and chose “Disable”

Don’t ask me why the disk I/O happens – it’s one of those things…

KVM Viewer does not open

This is a Java based tools and only really works in Internet Explorer.

However IE has changed over time so the pop-up does not work any more.

This is especially true in this case for:

  • Windows 8.1 64-bit  or Windows 10 64-bit
  • Java 6 (if you have any newer then de-install these)
  • Internet Explorer 11
1. Click Launch KVM Viewer

image

2. Click Open

image

3. Pick Application

image

Click: More Options

image

Default Open With./.. windows opens

Click: Look for another app on this PC

image

However this points to x64 programs so change to: Program Files (x86)

image

Click on Java (which is now a 32-bit Java) and go down to the bin directory:

image

Pick the Java Web Start executable: javaws.exe

And the KVM should start just fine…

Posted in: Technical Knowledge by Kent Willumsen Comments Off on HP ProLiant MicroServer Notes

Budgetary Control and Funds Checking Notes

Overview

Modules supporting budgetary control:

  • General Ledger
  • Payables
  • Purchasing
  • Inventory
  • Projects

Limitations:

  • Budgetary control is only available for the primary ledger functional entered currency
  • Budgetary control requires the use of encumbrance or budgetary accounting

Funds checking levels:

  • Detail budgetary control: budget per code combination assigned at budget organization range level
  • Summary budgetary control: budget by summary accounts assigned at summary account template level

Budgetary controls possible:

  • None: no funds checking and no funds reservation
  • Advisory: funds checking and if no funds, warning is issued and funds are reserved
  • Absolute: funds checking and if no funds, transaction is blocked and funds are not reserved

Budget Control Group

The budget control group is assigned at site or responsibility profile level and can set limits for:

  • Funds check level
  • Tolerance Percent: overspend allowed on budget in percent
  • Tolerance Amount: overspend allowed on budget in amount
  • Override amount: maximum override amount per account for failed absolute level

Note: tolerances only work in an encumbrance environment.

Amount Types and Boundaries:

  • Amount Type: cumulative balance for funds checking interval
  • Boundary: end point of the interval so budget cannot be spent beyond this point
  • Some examples:
    • PTD + Period: PTD budget is checked against current period (any previous periods underspend is ignored)
    • YTD + Period: Accumulated YTD budget is checked for current period (YTD underspend can be used until current period)
    • QTD + Quarter: Accumulated QTD budget is checked for current quarter (QTD underspend can be used within current quarter)
    Boundary      
    Period Quarter Year Project
Amount Type PTD: Period-to-date OK      
  QTD: Quarter-to-date OK OK    
  YTD: Year-to-date OK OK OK  
  PJTD: Project-to-date OK OK OK OK

Funds Available Calculation:

Encumbrance Accounting:

  • Funds Available = Budget – Encumbrance – Expenditures

Budgetary Accounting:

  • Funds Available = Budget – Expenditures

Detail Budget Control

To define detailed budget control you must create a budget organisation with a specific range and assign budgetary control that range.

Any ranges not assigned to budget control will not have budgetary control enabled so care must be taken when defining ranges to ensure all accounts are covered if full budgetary control is required.

Each of the budget organisation assignments having budgetary control enabled should have a budget amount allocated.

In practice, this may become a huge task. Just imagine you have an account for "stamps", then you must assign a budget amount for "stamps" per cost centre and per company per any code combination, your account structure may have.

Therefore, detail level budgetary control assumes you have a budget amount per code combination.

To limit the number of code combinations requiring budget amounts it is recommended to switch off "dynamic insert" so only pre-defined code combinations can be used.

A simple setup would be (based on the chart of accounts in the appendix):

Purpose

Range from

Range to

Budgetary control

Insurance

10-100-6400

10-100-6499

Advisory

Travel

10-100-6500

10-100-6599

Absolute

With this setup, you are required to enter a budget amounts for:

  • 10.100.6510
  • 10.100.6520
  • 10.100.6530

And optionally amounts for:

  • 10.100.6410
  • 10.100.6420

Budgets > Define > Budget:

image

Note: "Require Budget Journals" must be enabled for budgetary control budgets.

Budgets > Define > Organization:

image

Note: Use the "Maintain" button to update code combination assignments when budget organisation ranges are changed or new accounts are added.

Click: Ranges

image

Click: Budgetary Control (line 10)

image

Click: Budgetary Control (line 20)

image

Process for adding a new account, which is inside an existing budget organisation range with budgetary control:

  1. Add new account
  2. Create code combinations manually
  3. Add budget amount for the code combination
  4. Run " Program – Maintain Budget Organization"
  5. Check if code combination exists in budget organisation assignment with correct budget control assignment

Only code combination assignments will have budget control enabled hence, it is important to run: "Program – Maintain Budget Organization". This program is run when clicking the button "Maintain" in the "Define Budget Organization" screen.

Summary Budget Control

Summary level control is managed at summary account level. Summary accounts are always assigned at parent account level.

This makes it easier to enter budget amounts as this can be entered at a higher level.

Also the budget organisations can now be arranged independently of the budgetary control.

To ensure we only budget at one account we specifically add a budget account for this purpose with "Posting = No" and "Budget = Yes" and set all other accounts to "Budget = No" and "Posting = Yes".

For example using our chart of accounts below, we define:

  • Insurance Budget: 6401
  • Travel Budget: 6501

Then we define summary accounts for 6400 and 6500 to summarise both actual and budget amounts in the parent account range.

First, we define a rollup group to control the summarisation.

Setup>Financials>Flexfields>Key>Groups:

image

Name the rollup groups the same as the segment values so you can refer to these in the same way as an account.

Setup>Financials>Flexfields>Key>Values:

image

Assign the rollup group to the parent account.

The rollup can be assigned to any level in a hierarchy so the account hierarchy is important for the level of budgeting as well as reporting.

Accounts>Summary:

image

These summary accounts will have a total for "Travel" or "Insurance" for total of company and cost centre. TBD as company should be "D".

Click: Budgetary Control (Insurance)

image

Click: Budgetary Control (Travel)

image

The budget control can be performed at these summary levels per segment:

  • D: Detail – sum per segment value
  • T: Total – sum per segment (normally applied to a 4th segment like "Analysis")
  • {rollup group}: Sum of the accounts assigned to the rollup group

In the above example the calculation will be:

D.D.6400 =

10.100.6401 +

10.100.6410 +

10.100.6420

The amounts are added for each balance type of actual, budget and encumbrance.

Funds available = Budget – Encumbrance – Actuals = 100 – 0 – (10 + 20) = 70

All made simple thanks to the summary account.

The amounts can be checked using the funds inquiry screen.

Inquiry>Funds:

image

As the budgetary control is on D.D.6400 then there is no need for a budget on 6410 and 6420 making it simpler to maintain on just one account: 6401.

When a new account/combination is added it will inherit the budget assigned to the summary account hence dynamic insert can be enabled.

So for example, we add account 6430 to the above example then there would still be a budget covered by the amount on 6401.

However, you still need to ensure the summary account template is updated by running: Program – Maintain Summary Templates

Process for adding a new account, which is inside an existing budget organisation range with budgetary control:

  1. Add new account

Simple and clean.

Optional you can run: "Program – Maintain Summary Templates" but this is automatically run during the posting process anyway.

Not if you change the hierarchy, which is part of a summary group you need to run: Program – Incremental Add/Delete Summary Templates

Chart of Accounts

Note this is not the full chart of accounts but only listing accounts relevant for the above examples.

COA structure:

Segment

Qualifier

Length

Company

Balancing

2

Cost Centre

Cost Center

3

Account

Account

4

Company values:

Value

Description

10

ACME Limited

Cost Centre values:

Value

Description

000

Balance Sheet

100

Finance

Account values:

Value

Description

Type

Parent

Child Range

6000

Operating Expenses

Expense

Yes

6000-6999

6400

Insurance Expense

Expense

Yes

6400-6499

6401

Insurance Budget

Expense

No

 

6410

Liability Insurance

Expense

No

 

6420

Property Insurance

Expense

No

 

6500

Travel

Expense

Yes

6500-6599

6501

Travel Budget

Expense

No

 

6510

Trains

Expense

No

 

6520

Planes

Expense

No

 

6530

Automobiles

Expense

No

 
Posted in: Functional Knowledge, General Ledger by Kent Willumsen Comments Off on Budgetary Control and Funds Checking Notes , , ,

Interface Strategy – a Functional Approach

Interfaces are mostly assumed being a technical exercise however been on the receiving end of that there is several shortcomings to this approach.

image

When interfacing two systems the transactional flow can become quite complex in terms of functional interaction – an interaction, which is beyond what most technical people can contemplate. Just imagine how to design a purchase order interface:

  • In what system do we enter the invoices in order to track purchase order fulfilment?
  • Do we need to match or part match the invoice to the purchase order?
  • When a purchase order is closed do we need to relay this to both systems?
  • Is receiving being used and if so in what system?

Beyond that, there are the implications of change – like changes to the purchase order – how is this managed and interfaced?

When it comes to multi-phased implementations, the scenarios can become even more complicated. Careful functional consideration must be taken, as if done wrong the transactional flow may be broken or the interfaced system may be impossible to reconcile, essentially breaking business continuity.

Overview

The interface strategy is part of the overall project key deliverables setting out scope and project outcome expectations. The documents below are directly related but should be kept separate:

image

  • Interface Strategy: Define system scope and integration need
  • Data Migration Strategy: Define data retention for decommissioned systems or systems not being interfaced
  • Cut-over Strategy: Define how to orchestrate close down of decommissioned systems and their data migration, switch-over of retained systems and related interfaces, and commence use of new systems

The "strategy" nomenclature indicates these documents are likely to have a significant impact on the overall project plan. Each of the above documents may also spawn a number of functional and technical specifications based on decisions made.

Purpose

The primary purpose of the interface strategy is to facilitate management decisions caused by system change – decisions to ensure:

  • Continuation of daily business activities
  • Correct management reporting
  • Correct legal reporting and compliance

The responsibility of ensuring the above is not a technical decision but a high-level management decision. If the decision is taken at the wrong level or in the wrong perspective, the result can be serious for the business, which again falls back on management.

So therefore, the target audience and signee of the interface strategy is upper management.

A secondary purpose of the interface strategy is to give project management an idea of the effort ahead – both in terms of functional and technical work.

Therefore, the interface strategy must be created early in the project either during a pre-analysis phase or as first phase in an already started project.

Technical aspects are only considered where circumstances require technical assistance to gauge feasibility to accomplish the task due to complexity or extremely high volumes.

The interface strategy may indicate the need for a custom interfaces or an integration hub, which requires functional specification setting out the detailed requirements and then if custom/in-house made/built then a technical specification is needed.

Scope

The scope of the interface strategy is highly dependent on the overall project scope and timeline. Often projects are phased and may have intermediate system scenarios during which the business need to continue to operate.

On a large-scale project, you may want to split the interface strategy according to the implementation phases or sub-project schedules.

Scope Example:

image

The above example is a project looking to replace an old finance; payroll and treasury system with a new integrated finance and payroll system. The business seek to prioritise the business critical retail system and in a later phase to replace payroll and treasury systems.

If the phases are treated as two separate projects it may be convenient to have two interface strategies – one for phase one and one for phase 2. In case of parallel run; parallel implementations or downstream dependency of a decommissioned system, the interfaces may impact each other and should therefore be in one document.

Contents

These are the recommended top level chapters in the interface strategy:

  • General Overview: Upper management and general interest
  • System Analysis: Middle management and functional interest
  • Interface Analysis: Functional interest mainly

In some rare cases a technical considerations part maybe required to describe impacts of very high volume or space requirements.

General Overview

First part of the document should describe general scope and limitations enabling a high-level executive to create an overview of the decisions ahead.

For instance, use these sub-chapters:

  • Purpose
  • Scope
  • Limitations

Purpose: Explains about the overall project and how the interface strategy fits into this.

Scope: Lists key objectives; target systems and high-level project plan with timeline; phases and milestones.

Limitations: This describes both high-level business and legal limitations. Business limitations can the areas like seasonal impacts; other projects; reorganisations and mergers and acquisitions. Legal limitations are mainly based on statutory reporting like year-end; quarterly VAT reporting. In addition, Sarbanes-Oxley; data protection and sector specific rules may impact the interface strategy.

System Analysis

Second Part should contain short description of systems impacted by the above changes and an analysis of these changes and an overview of logical entities involved in the change. This will enable middle management to understand the overall impact on their functional area.

For instance, use these chapters:

  • Interface Diagram
  • System Descriptions
  • Interface Descriptions
  • Change Analysis

Interface Diagram: This is a complete as-is and to-be diagram of systems and interfaces between them. The interface diagram should focus on functional system blocks and logical interfaces.

A functional system block would be a function within a system like "Oracle Payroll" rather than "Oracle" as a physical system. Same goes for logical interfaces which would be "Payroll Journal" or "Salary Payment" rather than "GL data" or "BACS file". Also internal flows within a physical system should not be shown, as that would not constitute an interface in scope, so no flow is depicted between "Oracle Payroll" and "Oracle General Ledger".

A simple interface diagram example based on the scope example from above:

image

Note that the interface flow direction is the logical flow, as an interface can have bidirectional handshakes and feedback loops, which are considered technical rather than functional flows.

System Description: Each system and the specific module used in the interface should be described to a level so the decision maker understands the functionality and importance of this.

Interface Description: Each interface should be described to a level so the decision maker understands what is interfaced and what purpose this interface serves and how critical it is.

Change Analysis: Analysis of the as-is to the to-be transition and how to mitigate business continuity during the transition process.

Interface Analysis

For this chapter I would normally have a table per interface. In most cases this should only be to-be interfaces assuming knowledge of the as-is interface will feed into the to-be interface.

If many interfaces are required, the chapter can be divided into sub-chapters based on the source system or logical entity being interface depending on what is convenient.

The interface analysis should be kept at a high level but detailed enough for decisions to be made without pre-empting any required functional design. The information in the interface analysis should create a basis for the functional design, but not limit it.

These table sections are recommend:

  • Interface Name
  • Source system
  • Target system
  • Logical Entities
  • Structure Analysis
  • Dependencies
  • Trigger/Frequency
  • Volumetrics/Statistics
  • Transformations
  • Process
  • Controls
  • Security/Data Protection

Interface Name: Name of the interface. Ensure unique, consistent and precise naming like “new supplier invoice” or “payroll journal”. For instance the name “payroll interface” is bad, as it may cover multiple interfaces like “new employee”, “payroll journal” and “expense report invoice”.

Source system: Source system and module/sub-system where the interface logically originates.

Target system: Target system and module/sub-system where the interface logically terminates.

Logical Entities: What type of data is interfaced? Any sub-types or all data? For example, for the entity "invoice" is that "new invoices" or "amended invoices". In real life you may find each of these, may require a separate interface due to the nature of the data and how the interface is triggered.

Structure Analysis: Explain differences in entities between the two systems if needed. If the structure is very complex, a logical entity diagram may be needed. This is often very important for customer data as different structures may impact the level of customer information retained between two systems.

Dependencies: Dependencies on other interfaces or any functional dependencies. Like if another interface must be run before this or if the period must be closed before running the interface.

Trigger/Frequency: When and/or how often will the interface be run. Like "run daily at 3am" or functional event triggers like "when new customer is entered" or triggered by another interface "run when customer interface has completed".

Volumetrics/Statistics: How much data by time period. Time period is typically per day/week/month/year. This is important information for deciding on frequency, process and controls. For instance reconciling 1,000 records can be a manual task but if it is 100,000 records or more, some kind of automated reconciliation may be required.

Transformations: Changes to data between the two systems. This can be anything from data mapping to data cleansing like address validation and lookup. At this point only high-level transformation should be highlighted so no need to detail field level transformation.

Process: Automated transfer or any manual steps required for instance some bank interfaces may require manual load into a banking desktop system

Controls: How to reconcile the two systems and how to verify data has been successfully transferred. This may include reconciliation reports or automated controls or feedback loops. Also in case of error if manual check is needed or if automated alert is required.

Security/Data Protection: Any special functional security considerations. This may be encryption or masking of certain data or ensuring the data transferred is not generally accessible.

Conclusion

The above sections may not all be needed as it depends on the complexity of the project but one should ask yourself:

Does the quality of this interface strategy document ensure the right decision can be made?

Posted in: Functional Knowledge, Interfaces, Technical Knowledge by Kent Willumsen Comments Off on Interface Strategy – a Functional Approach ,

R12.2.x Functional Issues and Major Bugs

Trying to collect the major non-technical R12.2.x issues and bugs in a single note…

UPDATE 2014-03-26: R12.3 seems to be on the way; its referred to in many notes on Metalink so bugs below might not get fixed until then.

Topics covered in this note:

  • Flexfield Value Set Security: Enabled by Default
  • Report Manager Excel Publishing: Compile error on SAXXMLReader30

Flexfield Value Set Security: Enabled by Default

This is enabled by default and you will find that you are not able to view and update any segment values.

  1. Login as: SYSADMIN
  2. Use responsibility: User Management
    image
    And click: Users
  3. Find your user and click update:
    image
  4. Click: “Assign Roles” and search for role: “Flexfield Value Set Security: All privileges”
  5. Select role and enter justification and click: Apply
    image

Report Manager Excel Publishing: Compile error on SAXXMLReader30

This is described in note: 1077728.1 but is hard to find. Key is to search for: SAXXMLReader30

According to Oracle support:

R12.1.3: Apply patch 17429169

R12.2.2: NO PATCH EXISTS (yet)

So a really big issue for R12.2.x implementations.

The error happens on all Windows 8 clients when publishing a report to MS Excel:

image

Supplier Entry: Server Not Found

When activating the Supplier Entry html form you get:

image

On Vision you will get the reference: fa5099-obiee.oracleads.com

This is caused by an OBIEE personalization.

Click “Personalize Page”:

image

Scroll down to:

image

and click delete and same for:

image

Click return to application and all looks as in the “good old days”:

image

Posted in: Functional Knowledge, New Features by Kent Willumsen Comments Off on R12.2.x Functional Issues and Major Bugs , ,

Java with Internet Explorer 11 incompatible?

After upgrading to Windows 8.1 you will find it impossible to use Java with internet explorer.

This is particularly bad for Oracle E-Business Suite that depends of the use of Java for its professional applications.

Problem Identification

You may get the warning:

Java(tm) Plug-In 2 SSV Helper’ from ‘Sun Microsystems, Inc.’ isn’t compatible with Internet Explorer’s enhanced security features and has been disabled:

Or you might just get stuck on:

In order to access this application, you must install the J2SE Plugin version 1.6.0_27…

Click tools: image 

Manage add-ons: image

And it shows:

image

Notice I’m using the 64-bit Java plug-in here.

And it’s incompatible…

Do not despair – there is a solution.

Solution

Enhanced Protected Mode 

Click tools: image

Internet Options: image

Select Advanced tab and scroll down to Security:

image

Uncheck “Enable Enhanced Protected Mode” as above.

Click OK and restart the browser.

In “Manage add-ons” you should now have:

image

If it is still disabled click on the Enable button: image

Compatibility View

Click tools: image 

Compatibility View Settings: image

Add current site:

image

Click: Add

Reconnect to your site.

You may get a pop-up warning – just click Always Allow:

image

And re-try.

In case it still doesn’t help, ensure:

  • Only to install JRE 6.0.27
  • In case you installed JRE 7.0.45 – when you open a R12.2 Java screen for the first time it will automatically install JRE 6.0.27. This is in spite R12.2 should have built-in support for JRE 7.0.45…
  • Add site to: Trusted Sites
  • Set security for Trusted Sites to Medium-Low

If it still doesn’t work it may be due to policy settings from your IT department…

Posted in: Office Tools, Technical Knowledge by Kent Willumsen Comments Off on Java with Internet Explorer 11 incompatible? , ,

E-Business Tax Notes

These are my personal notes which is a mix of experience and excepts from Metalink.

This note is focused on Oracle functionality and not tax law.

These notes applies mainly to R12.1.x.

Beware these notes may be out of date so please check with http://support.oracle.com for changes.

There are many notes on just one page so be sure to use {ctrl-f} to search.

General Notes

Different Input and Output Recoverable Accounts

How to set up different Input And Output recoverable tax accounts in Ebtax [ID 752248.1]

Applies to

Oracle E-Business Tax – Version: 12.0.5

Information in this document applies to any platform.

Goal

In Ebtax it is only possible to configure a single tax recoverable account per rate. Is there

anyway to configure a different Input Tax recoverable account for Payables tax lines and an

Output Tax recoverable for Receivables?

Solution

User wants to account the tax liability ( For AR ) and tax recoverability ( in AP) in different

code combinations. Normally both these values are taken from Recoverability/Liability Account

defined at Tax Rate level.

However if user specifies a different code combination at the Tax Recoverability Account in the

associated recovery rate , then recovery in AR would get accounted in a that account. Tax

liability in AP would continue to get accounted in tax rate liability account.

Ship From/To Determination

Use of Bill From/To and Ship From/To varies by module.

Payables/Purchasing:

  • Legal Establishment: Ship/Bill To
  • Supplier: Ship/Bill From

Payables:

  • Bill From: Invoice Header
  • Ship From: Invoice Header
  • Bill To: Invoice Header
  • Ship To: Invoice Line

Receivables/Sales:

  • Legal Establishment: Ship/Bill From
  • Warehouse: Ship From
  • Customer: Ship/Bill To
  • Salesrep: Point of Origin (POO)
  • Operating Unit: Point of Acceptance (POA)

So when testing for country this must be done for each type of transaction classification:

Payables: Purchasing Transaction

Receivables: Sales Transaction

Tax Recoverable/Liability Accounts

Set tax level accounts to default these onto tax rate level accounts saving a lot of setup.

Tax -> Tax Rate

Receivables: Tax Rate Recoverable/Liability Account

Payables: Tax Rate Recoverable/Liability Account and Tax Recovery Rate Recoverable/Liability Account

VAT Classification Defaults

Application Tax Options – Tax Hierarchy (note from E-Business Tax Purchasing Whitepaper [464243.1])

Prior to E-Business tax, a tax hierarchy would be defined either in payable options or in purchasing options, which would determine the source and the order of defaulting on purchase orders.

The tax hierarchy is now available in E-Business tax through ‘Application Tax Options’ available by each operating unit for Purchasing application.

This is similar to defining the tax hierarchy in ‘Purchasing Options’ prior to release 12.

The tax will be defaulted based on the defaulting order and the source option specified. Application Tax Options is available only for backward compatibility of the former Tax Defaulting Hierarchy.

If you are using complex tax rules you may choose to disable the application tax options. This is a one-time option. Once the application tax option has been disabled, it would not possible to re-enable this option again for that operating unit.

VAT Classification is either entered directly on the transaction or defaulted from via the Application Tax Options:

Purchasing:

  • Payables Financial Options
  • Item
  • Supplier
  • Supplier Site
  • Ship to Location

Payables:

  • Payables Financial Options
  • Supplier
  • Supplier Site
  • Invoice Header
  • Natural Account
  • Reference Document
  • Expense Report Template

Receivables:

  • Product (=item or memo line)
  • Revenue Account
  • Customer Site
  • Receivables System Options

Projects:

  • Project
  • Customer Site
  • Receivables System Options
  • Expenditure Type/Event Type/Retention
  • Client Extension

Application Tax Options cannot be reactivated

If the Application Tax Options has been deactivated it cannot be re-activated from the forms.

In order to re-activate run the following script:

UPDATE zx_product_options_all
SET USE_TAX_CLASSIFICATION_FLAG = ‘Y’
WHERE application_id = ?
AND org_id = ?

Tax Rule Naming

When building tax rules:

  • Rule Code: Must be unique within one combination of "Configuration Owner"+"Tax Regime Code"+"Tax" across all rule types.
    Extra care must be taken when using a Global Configuration Owner.
    So must also be distinct per rule type and per event class code. Also add tax determination set to name.
    Naming:
    • Naming: {rule type code}_{tax determination set}_{event class code}
      If not transaction flow specific: {rule type code}_{tax determination set}
      If with Global Configuration Owner: {tax regime code}_{rule type code}_{tax determination set}_{event class code}
    • Example1: APP_VAT_TAX_RULES_POT
    • Example2: STA_VAT_TAX_RULES_OMT
    • Rule Type Codes:
      • Direct Tax Rate Determination: DTR
      • Determine Place of Supply: POS
      • Determine Tax Applicability: APP
      • Determine Tax Registration: REG
      • Determine Tax Status: STA
      • Determine Tax Rate: RAT
      • Determine Taxable Basis: BAS
      • Calculate Tax Amounts: AMT
      • Determine Recovery Rate: REC
    • Event Class Codes (from Event Class Category = Tax Event Class):
      • Booking: BOT
      • Expense Report: EXT
      • Intercompany Transaction: ICT
      • Purchase Prepayment Transaction: PPT
      • Purchase Transaction: POT
      • Sales Transaction: OMT
      • Sales Transaction Adjustment: SAT
  • Determining Factor Set Code: The fewer DFS – the simpler rule creation as determination sets can be grouped
  • Tax Determination Set: Same rule set can be used in multiple tax rules as long as the tax rule code is unique

Tax Condition Set Naming

Tax condition sets (TDS) should normally be used only within one tax regime.

In case of one OU with multiple tax regimes be sure to prefix with tax regime code.

Example: DK_VAT_EU_G for Danish VAT goods transaction inside EU

The TDS name should be oriented toward purpose and content of the DTS.

Include transaction direction to avoid PO and OM rule clashes for same area.

Direction will also be given by event class in the tax rule.

HOWEVER if tax conditions are the same for two sets you may get:

The same tax conditions already exist in another tax condition set

So if this is the same you may want to denormalize the naming to like: DK_VAT_BILL_TO

If condition is bill_to = DK only.

Things to include in name are:

  • Tax Regime Code: NO_SK_VAT
  • Geography: Domestic = DO, European Union = EU, Outside EU = EX
  • Product Type: GOODS/SERVICES = G/S when mixed then assume G

Basic Default Rules

As per table zx_evnt_cls_mappings:

EVENT_CLASS_CODE

APPLICATION_ID

ENTITY_CODE

TAX_EVENT_CLASS_CODE

EXPENSE REPORTS

200

AP_INVOICES

EXPENSE_REPORT

PREPAYMENT INVOICES

200

AP_INVOICES

PURCHASE_PREPAYMENTTRANSACTION

STANDARD INVOICES

200

AP_INVOICES

PURCHASE_TRANSACTION

Applications supporting these defaults are:

  • Payables
  • Purchasing
  • Receivables
  • Trade Management
  • Cost Management
  • Lease and Finance Management

So order management does not support TRX_BUSINESS_CATEGORY.

So outgoing VAT tax rules should be based on:

  • Event Class Category = Tax Event Class
  • Event Class = Sales Transaction

Tax Rules Not Affecting Transactions

When altering tax rules you must re-select your responsibility for the tax rules changes to take effect as they seems to be cached for performance reasons.

Tax Classification Code = Tax Rate Code

This code is available on:

  • Supplier Site
  • Customer Site
  • AP Invoice Line
  • AR Invoice Line

Based on "Tax Rate Code" defined in "Tax Rates" screen.

Place of Supply

Place of supply drives the use of Tax Jurisdiction.

So if you have setup tax rules for a country A then you must ensure the POS rule also returns country A based on "Bill To" or "Bill From" otherwise your tax rules will render "Not Applicable" which is what you want in some cases though.

Self-Assessed Flag Set

First we need to understand the Self Assessed tax functionality. When a buyer procures goods from an unregistered seller, the buyer is liable to calculate and pay the tax on that invoice. The self-assessed tax amount is not even displayed on the invoice total and can be viewed only at the tax details window. You can obviously uncheck the flag for one item line making it a regular tax.

In a real life scenario I doubt if there can be a case where from a same supplier and for a same invoice some lines can be self-assessed and some lines to have normal tax.

As per the current functionality it is not possible to unchecked the SA flag for any particular line is a transaction.

Functionally we believe that self-assessment is driven by Supplier registration status and not item.

This functionality is not currently supported. Any change in the existing code has to be logged as an ER.

How Tax Determining Factors Work with Tax Rules in R12 E-Business Tax [ID 1108463.1]

Determining Factor Class

Class Qualifier

Determining Factor Names

Values

Setup and Troubleshooting Note

Accounting

Accounting segments
of the selected ledger

Line Account

Account Combination of the Class qualifier

Note 1109436.1, How To Setup and Troubleshoot a Tax Rule using Accounting Segments in R12 E-Business Tax (EBTax)

Document

Document Fiscal Classification Level

Document Subtype

Document fiscal classification codes of
the class qualifier level; or all document
fiscal classification codes if there is no class qualifier.

 

Geography

Bill From

Bill To

Point of Acceptance(AR transactions)

Point of Origin (AR transactions)

Ship From

Ship To

TCA geography types

TCA geography names of the geography type belonging to the location identified by the class qualifier

Note 1110427.1, How To Setup and Troubleshoot a Tax Rule Based Upon Geography Types such as Bill To and Ship To in R12 E-Business Tax (EBTax)

Legal Party Fiscal Classification

First Party

Legal Activity Codes
for

Chile

Colombia;

Peru

United

Kingdom

Venezuela

Legal classification codes of the legal classification activity.

Note 1109325.1, How To Setup and Troubleshoot a Tax Rule using Legal Classifications (Activity) Codes in R12 E-Business Tax (EBTax)

Party Fiscal Classification

Bill From Party

Bill To Party

Point of Acceptance

Party (AR transactions)

Point of Origin Party (AR transactions)

Ship From Party

Ship To Party

Party fiscal classification types

Fiscal classification codes of the party fiscal classification type assigned to the party identified by the class qualifier.

Note 729486.1
How to Setup and Troubleshoot a Party Fiscal Classification Tax Rule in R12 E-Business Tax (EBTax)

Product – Inventory Linked

N/A

Oracle Inventory-based
product fiscal classification types

Fiscal classification codes of the
applicable product fiscal classification
type

Note 1107666.1 How to Setup and Troubleshoot A Product Fiscal Classification Tax Rule in R12 E-Business Tax

Product – Non-Inventory Linked

Product fiscal
classification level
(Levels 1-5)

Product Category product fiscal classification types

Product fiscal classification codes of
the class qualifier level; or all product
fiscal classification codes if there is no
class qualifier.

NOTE 1108547.1 How to Setup and Troubleshoot a Product Fiscal Classification (Non-Inventory Based) Tax Rule in R12 E-Business Tax (EBTax)

Registration

Bill From Party

Bill To Party

Ship From Party

Ship To Party

Registration Status

Status of Agent (withholding agent),
Registered, or Not Registered (seeded values only) for the party identified by the class qualifier. You can use lookup codes to add registration statuses.

Note 1112412.1 How To Setup and Troubleshoot a Tax Rule using Tax Registration Status in R12 E-Business Tax (EBTax)

Transaction Fiscal Classification

N/A

Transaction fiscal classification types

Codes used to assign attributes across the transaction business category hierarchy described in the line below.

Note 1114923.1 How To Setup and Troubleshoot a Tax Rule using Transaction Business Categories and Transaction Fiscal Classifications in R12 E-Business Tax (EBTax)

Transaction Generic Classification

Classification Level (Levels 1-5)

Transaction Business Category (seeded value only) with option to add additional levels to hierarchy

Transaction business category fiscal
classification codes of the class qualifier level; or all fiscal classification codes if
there is no class qualifier.

Note 1114923.1 How To Setup and Troubleshoot a Tax Rule using Transaction Business Categories and Transaction Fiscal Classifications in R12 E-Business Tax (EBTax)

Transaction Input Factor

N/A

Line Class

Product Type

Intended Use

Tax Classification Code

User Defined Fiscal Classification

LC = Transaction event classes and activities.

PT = Goods or Services
(seeded values only).

IU = Product Intended Use fiscal classification codes

TCC = Tax classification codes.

UDFC = User Defined fiscal classification codes.

LC = WIP

PT = WIP

IU = WIP

TCC = Note 801535.1 How To Setup and Troubleshoot a Tax Rule using Tax Classification Codes in R12 E-Business Tax

UDFC = WIP

User Defined Geography (Tax Zone)

Bill From

Bill To

Point of Acceptance

Point of Origin

Ship From

Ship To

Tax Zone Types

Tax zones of the tax zone type  belonging to the location identified by the class qualifier.

Note 1124208.1 How To Setup and Troubleshoot Tax Zones and User Defined Geography Tax Rules in R12 E-Business Tax (EBTax)

How does the tax registration number validation work? [ID 761250.1]

Applies to:

Oracle E-Business Tax – Version: 12.0 and later [Release: 12.0 and later ]

Information in this document applies to any platform.

Symptoms

— Problem Statement:

In release 12 when adding a tax registration number to a party tax profile, the system throws an error stating that the number is not valid but does not explain why. How can I determine the validation failure reason?

Cause

This problem only occurs for the 26 countries listed below which have validation defined.

EU Countries:

  • AT – Austria
  • BE – Belgium
  • CV – Cyprus
  • DK – Denmark
  • EE – Estonia
  • FI – Finland
  • FR – France
  • DE – Germany
  • GR – Greece
  • HU – Hungary
  • IE – Ireland
  • IT – Italy
  • LT – Lithuania
  • LU – Luxembourg
  • LV – Latvia
  • MT – Malta
  • NL – Netherlands
  • PL – Poland
  • PT – Portugal
  • SK – Slovakia
  • SI – Slovenia
  • ES – Spain
  • SE – Sweden
  • GB – United Kingdom

Non-EU Countries:

  • AR – Argentina
  • BR – Brazil
  • CL – Chile
  • CO – Colombia
  • RU – Russia
  • CH – Switzerland
  • TW – Taiwan
Solution

— To implement the solution, please execute the following steps::

At this time, validation is not documented in any reference document. Documentation Bug 7708946 has been logged to request that this information be documented in the next release of Oracle documentation.

If you believe that you have a valid registration number that is being rejected, first apply the latest version of the file zxctaxregnb.pls from step 3 in note 875894.1 Using and Troubleshooting Tax Registration Number Issues with R12 E-Business Tax.

Note 564428.1 also has been written to show an example of the validation used in the UK

Note: Tax registration number validation is based upon the country associated with the tax regime (not the customer address).

Module Specific Notes

Purchasing

None

Payables

None

Order Management

None

Receivables

None

Inventory

None

Projects

Projects does not support:

  • Product Type
  • Transaction Business Category

General Ledger

None

Trade Management

None

Cost Management

None

Lease and Finance Management

None

Bugs and Features

Patch 9794557: Support of NULL and NOT NULL Operators in Condition Sets

This patch is included in R12.2.x.

Patch Description

1. Functional Description

Old Behavior

————-

Need to support the Null Not Null Operator in Condition Sets.

New Behavior

————-

Added validations to support Null and Not Null Operator in Conditions Sets.

2. Pre-requisite or Co-requisite which is not included with this patch:

Co-requisite patch: 10018848:R12.ZX.B

3. Patch Applicable for versions/releases:

Oracle Applications Release 12.1.1

4. Target Mini-pack/Family Pack/Release

Oracle Applications Release 12.1.4

Tax Codes not Enabled for Internet Expenses OIE [ID 1312692.1]

The flag: Enable for Internet Expenses Is only visible during tax rate creation.

Add tax codes after tax rate creation by:

Go to Tax Managers Responsibility->Advance Setup Options->Tax look up codes

Query by entering code: ZX_WEB_EXP_TAX_CLASSIFICATIONS

How to Setup and Troubleshoot Offset Taxes in R12 E-Business Tax (EBTax) [ID 1368206.1]

An offset tax calculates and records third party Payables tax liabilities for reverse charges, self-assessments, and, in the United States, Consumer’s Use tax. An offset tax record is a matching, duplicate record with negative amounts that reduces or completely offsets the tax liability recorded in the tax transaction. Use offset taxes when the tax requirement includes creating offset general ledger postings.

You cannot update the recovery rate on an offset tax line. The recovery rate is always 100% in order to create credit entries that match the original tax amounts. When you create an offset tax, you enter a primary recovery type with a recoverable rate of 100% and a 100% recovery rate.

In some Jurisdictions, Offset is also called as Reverse Charge or Self Assessed Tax.

image

Transaction Business Category does not default in as expected [ID 1290195.1]

Applies to:

Oracle E-Business Tax – Version: 12.1.2 and later [Release: 12.1 and later ]

Information in this document applies to any platform.

Form:ARXTWMAI.FMB – Transactions

Symptoms

Transaction Business Category incorrectly defaults for Receivable and Payable Invoices in the transaction workbench.

Cause

Bug 10399114 – TAX RULE ON FRANCE IS NOT WORKING

Solution

Apply patch 10399114:R12.ZX.B and Transaction Business Category will now default correctly in as

SALES_TRANSACTION for Receivable Invoice

PURCHASE_TRANSACTION for Payables Invoice

INTERCOMPANY_TRANSACTION for Intercompany Transactions

File Version

After applying the patch please check the version of the following files:

(Versions must not be lower than the versions mentioned below)

$ZX_TOP/patch/115/sql/zxpservb.pls 120.32.12010000.12

Ebus Tax: Sales Order Does Not Reflect The Tax As Per The Tax Rule [ID 1381151.1]

Applies to:

Oracle E-Business Tax – Version: 12.1.3 and later [Release: 12.1 and later ]

Oracle Order Management – Version: 12.1.1 to 12.1.3 [Release: 12.1 to 12.1]

Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, E-Bus Tax Integration for OM

Even after applying these patches:

Patch 12612699

Patch 9544144

Patch 8936101

Patch 11686403

Patch 10179680

Tax calculated on sales order is not as per the Tax Rule.

ERROR

E: unspported category: p_fsc_cat_rec.classification_category= TRX_GENERIC_CLASSIFICATION get_prod_trx_cate_value(-)

Cause

OM development provided the cause in OM forum:

"I understand that you have defined tax rules setup based on Transaction Business Category.

OM does not support tax rules based on additional tax attributes.

Refer to Enhancement Rrequest Bug 9036865."

Solution

Monitor ER Bug 9036865 – Allow customers to enter tax determining factors on sales orders and quotes – for this functionality in a future release.

R12:Financial Tax Register Report Ended With No Data Found [ID 1329695.1]

Applies to:

Oracle Payables – Version: 12.1.3 and later [Release: 12.1 and later ]

Information in this document applies to any platform.

Symptoms

On : R12 version, EB Tax

ACTUAL BEHAVIOR

Financial Tax register Report ended with No data found.

EXPECTED BEHAVIOR

Expected report to show the records.

STEPS

The issue can be reproduced at will with the following steps:

1. Tax Manager Super User

2. Submit the Request

3. Financial Tax register report.

BUSINESS IMPACT

The issue has the following business impact:

Due to this issue, users cannot check the data in the report.

Cause

The data type of trx_line_id in zx transaction table is NUMBER.

The data type in zx_rep_trx_detail_t was NUMBER(15)

So, during data insertion into zx_rep_trx_detail_t table, the value of trx_line_id was getting rounded. e.g. trx_line_id in zx_rec_nrec_dist was 23.86 in zx_rep_trx_detail_t table it is stored as 24.

So the cursor trx_dist_ccid was failing.

Solution

1) Please download and review the readme for Patch 10362073 .

Please log a SR with Oracle Support if a password is required to download the patch.

2) Please apply 10362073 along with its pre-requisites in a test environment.

3) Check the file versions , they have to be the same as given below.

File version:

For R12.0.X

$ZX_TOP/patch/115/xdf/zx_rep_trx_detail_t.xdf 120.12.12000000.5

For R12.1.X

$ZX_TOP/patch/115/xdf/zx_rep_trx_detail_t.xdf 120.12.12010000.4

4) Please retest the issue.

5) If the issue is resolved, please migrate the solution, as appropriate, to other environments

Tax for intra EU vat is not working [ID 1291425.1]

Applies to:

Oracle Receivables – Version: 12.1.1 and later [Release: 12.0 and later ]

Information in this document applies to any platform.

Goal

Why isn’t tax for Intra EU VAT not working?

Solution

As you can see from tax debug logfile below bill from registration status is showing as not registered, whereas, the tax rule condition is looking for status of registered in order to evaluate to true.:

ZX_TDS_RULE_BASE_DETM_PVT: evaluate_alphanum_condition(+)

p_Operator_Code: =, p_condition_value:REGISTERED, p_trx_value: NOT REGISTERED, p_value_low: Registered, p_value_high: , p_det_factor_templ_code: REGISTRATION, p_chart_of_accounts_id: 50389

ZX_TDS_RULE_BASE_DETM_PVT: evaluate_condition(-)

condition is false

To correct this, navigate via Legal Entity Manager -> query back legal entity manager -> click on legal establishment -> click on Registration tab -> click on tax registration -> create tax registration make sure to input tax registration status of registered. After doing this, create new transaction to re-test.

Include Accounting Segments Parameter On Financial Tax Register Returns No Data Found [ID 1292273.1]

Applies to

Oracle Payables – Version: 12.1.3 and later [Release: 12.1 and later ]

Information in this document applies to any platform.

Symptoms

=== ODM Issue Clarification ===

Run the Financial Register with parameter ‘Include Accounting Segments’ = No, and data returned.

If you run the Financial Register with parameter ‘Include Accounting Segments’ = Yes, no data found.

Cause

=== ODM Cause Determination ===

Bug 9571195: REW:FINANCIAL TAX REGISTER REPORT "TRANSFER TO GL" AND "ACCOUNTING STATUS" PARAM

Solution

=== ODM Solution / Action Plan ===

On TEST instance apply patch 10303566:R12.ZX.B

If the patch is password protected, log SR with Oracle Support.

This patch will deliver:

zxricoreplugpvtb.pls 120.12.12010000.44

zxriextractwpkgb.pls 120.43.12010000.18

After patch application, verify you have the new versions, than re-test your issue.

If successful, migrate solution to other instances.

Customer Form, Site Issue: Tax Profile Button is Missing in the Site Details Page When Viewed Via a Custom Responsibility [ID 864403.1]

Applies to

Oracle Receivables – Version 12.0.6 and later

Information in this document applies to any platform.

Information in this document applies to any platform.

Goal

When maintaining Site Details using the Seeded Receivables Manager Responsibility, you can see the Tax Profile Button that allows you to maintain the Tax information. However, when you are using a Custom Receivables Responsibility, you do not see the Tax Profile Button.

What are the steps required to add this button?

Fix

To enable the Tax Profile Button for your Customer Receivables responsibility, do the following:

Responsibliity: System Administrator

Navigation: Security > Responsibility > Define

Query for your Custom Responsibility

Check that in the Menu Exclusions section, you do not have an entry for Name = Customer Overview: Tax Profile (FS)

Take note of the value in Menu, for example: AR_NAVIGATE_GUI, you need if for the next step

The following will traverse through the Sub-menus

Navigation: Application > Menu

Query for the Menu from previous step

Review the SubMenus listed, there should be one with Prompt = Customer, take note of the Submenu value, for example: AR_CUSTOMERS_GUI

Run another Query for the menu from previous step

Review the SubMenus listed, there should be one with Submenu = Customers Function Security Menu

Run another Query for User Menu Name = Customers Function Security Menu

In this list check that the Function = Customer Overview: Tax Profile exists

The menu structure above needs to be in place for the Menu your Custom Responsibility is using.

Also note that you can also maintain the Tax Registration Number using

Responsibility: Tax Manager

Navigation: Parties > Party Tax Profile

Query your customer and maintain the tax information.

Tax Info AR Invoice Line Product Type Defaults To Goods When It Item Flag Inventory Item=No [ID 1231873.1]

Tax Info AR Invoice Line Product Type Defaults To Goods When It Item Flag Inventory Item=No [ID 1231873.1]

Applies to:

Oracle Receivables – Version: 12.1.3 and later [Release: 12.1 and later ]

Information in this document applies to any platform.

Goal

How is the product type of an inventory item defaulted to "Service" in an AR invoice?

Solution

Following is the logic of defaulting Product Type :-

If the CONTRACT_ITEM_TYPE_CODE is equal to ‘SERVICE’, ‘WARRANTY’, ‘USAGE’, default ‘SERVICE’

If the CONTRACT_ITEM_TYPE_CODE is equal to ‘SUBSCRIPTION’ use ‘GOODS’

Else ‘GOODS’.

You can use the same determining factor class and class qualifier as often as necessary

This is not always a correct error. This can also occur when you have been searching for a condition set first.

The error can be avoided by entering the form without a prior search and then immediately click create.

Rules with null evaluators do not work if bill-to is used multiple times [ID 1184613.1]

The note description is wrong as this is a bug that hits many condition detail combinations as long as you are using the same tax condition set.

R12.ZX.A and R12.ZX.B: Patch 10018848

KNOWN ISSUES IN E-BUSINESS TAX REPORTING [ID 1305895.1]

https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_adf.ctrl-state=11eip9v8z3_170&_afrLoop=793316825236922

Posted in: E-Business Tax, Functional Knowledge by Kent Willumsen Comments Off on E-Business Tax Notes

Installing Oracle E-Business Suite R12.2

Being a non-DBA and non-developer it is not easy to install Oracle E-Business Suite R12.2.

I did have to try a few times before succeeding but it is possible and hopefully now a bit easier with the guide.

On the surface is looks straight forward but I would recommend to set aside a full week to complete the full installation and patching cycle.

What you need to do is:

I usually skip the step “Install Server” but from R12.2 a Oracle Weblogic Server is included so you will need a lot more power to install R12.2 in a reasonable time. You could install and run R12.1 on a 4Gb Atom CPU based server but for R12.2 I would recommend minimum 8Gb and ideally 16Gb running on a i7 or Xeon CPU.

Posted in: Installation, R12 Installation, Technical Knowledge by Kent Willumsen Comments Off on Installing Oracle E-Business Suite R12.2 , , , , ,