R12 – E-Business Tax – ZX

Oracle E-Business Tax covers “standard” procure to pay and order to cash transaction taxes, with the exception of withholding taxes and those taxes handled by the Latin Tax Engine solution.
In general the limited per module 11i setup has been changed to become a proper self-contained tax engine. With that however comes complexity to the extent [...]

R12 – Subledger Accounting – XLA

Back to R12 – Upgrade Overview
Subledger Accounting is a new application that provides an accounting abstraction layer for subledgers – between subledger accounting events and GL journal entries.
This functionality was in 11i placed in each of the subledgers implemented in different way resulting in different reconciliation processes for each of the subledgers.
Subledger Accounting also [...]

R12 – Payments – IBY

Back to R12 – Upgrade Overview
This is a completely new module to provide a central payment capture and disbursement facility.
Overview

New Concepts: Payment Processing Profile, Payment Request and Payment Instruction
Payment disbursement functionality for Payables
Credit card functionality for Advanced Collections and Receivables
Bank account transfer functionality for Cash Management
Secure storage and encryption of payment [...]

Posted in: Payments by Kent No Comments , ,

R12 – Cash Management – CE

Back to R12 – Upgrade Overview
The new centralized bank account model provides a single point for defining and managing internal bank accounts for Oracle Payables, Oracle Receivables, Oracle Payroll, Oracle Cash Management, and Oracle Treasury.
Biggest change in cash management is for the users as many screens are now as OAF forms:
Screens has been converted into [...]

R12 – Upgrade Overview

This is a my personal log of changes from 11i to R12.
It is my intent to go through core financials in R12 as an internal project in order to make a structured approach to new features and changes in the new release.
So the notes below only applies to core Financials modules in scope.
This should prove [...]

R12 – Payables – AP

Back to R12 – Upgrade Overview
Many changes has been made to AP but all great improvements though.
Overview

Suppliers: are now defined in Trading Community Architecture – TCA
Invoice lines: entity added between header and distributions
Banks and bank accounts: now part of Cash Management
Banks and branches: are now defined in TCA like suppliers
Payment document [...]

Posted in: Payables by Kent No Comments , ,

R12 – Virtualbox Connection

So you got R12 up and running and want to connect to it from a Vbox machine?
I’m running R12.0.4 on OEL5.3 with Virtualbox 2.2.2 having a Windows 7 machine.
R12
R12 is installed on OEL with the hostname: localhost.localdomain
Firefox works locally against R12 so the EBS stack in working at this point.
Start the database, listener and apps. [...]

Windows 7

This post is written in Windows 7 RC running in Virtualbox inside Oracle Enterprise Linux (OEL) 5.3 – good fun!
OEL is in reality a Red Hat Enterprise Linux, which is a bit amputated in term of applications and drivers.
The reason for this constellation is OEL 5.3 Supports eBusiness Suite R12 and RDBMS 10g.
Next step is [...]

R12 – Firefox and Java

I recommend you to start with this article to get R12 up and running.
Firefox
Firefox 3 does not work with R12. I could get forms to work however framework pages had problems with buttons. So install Firefox 2 instead.
Java Plug-in
For R12.0.4 on OEL desktop you want to use JRE 1.5.0.13 otherwise you have to fiddle with [...]

R12 – OEL Login Script

Use this script (vis.sh) to initialise the Oracle environment.
I recommend you to start with this article to get R12 up and running.
Run as Oracle user:
$ . ./vis.sh
Note the dot and space in front of a script to assign variables to the current environment.

#!/bin/bash
shopt -s expand_aliases
ORACLE_SID=VIS
ORACLE_HOST=`hostname -s`
CONTEXT_NAME=${ORACLE_SID}_${ORACLE_HOST}
TECH_HOME=/oracle/${ORACLE_SID}/db/tech_st/11.1.0
APPS_HOME=/oracle/${ORACLE_SID}/apps/apps_st/appl
alias techenv=’. ${TECH_HOME}/$CONTEXT_NAME.env’
alias appsenv=’. ${APPS_HOME}/$CONTEXT_NAME.env’
APPSENV=”$APPS_HOME/$CONTEXT_NAME.env”
if [ ! -f $APPSENV ];
then
echo [...]