Posted on July 3rd, 2008 by admin
ERP tables - WF (Work Flow)
brief ( and important ) details of WorkFlow tables.
lets first learn some definations.
A process activity is a modelled workflow process, which can be included as an activity in
other processes to represent a sub–process.
A notification activity sends a message to a performer.
A functions activity performs an automated function that is […]
No Comments »
Filed under: 11i, ERP, Glossary, Interview Questions(& answers), Oracle Apps
Posted on June 30th, 2008 by admin
Interview Questions - Oracle AR (Functional)
Accounts Receivables Interview Questions AND aSWERS
1.What are the Key Flex Fields in Oracle Receivables? Sales tax Flexfields
Territory Flexfields
2.What is the Payment Term in AR?
How You are going to Receive the Amount from Customers […]
1 Comment »
Filed under: 11i, ERP, Interfaces, Interview Questions(& answers), Oracle Apps
Posted on June 17th, 2008 by admin
How to find a column in database
Once, at a client site I was asked to do a drill through report from Purchasing to Fixed Assets. I don’t remember the exact details but it had something to do with Purchase orders. I knew little bit about Oracle Purchasing but had not worked enough on Fixed Assets. […]
1 Comment »
Filed under: 11i, Business Intelligence, DataWarehousing, Discoverer, ERP, Oracle Apps, PL/SQL, SQL
Posted on June 12th, 2008 by admin
What two program responsible for creating events in R12 CM
They are
bank account transfers
bank statement cash flows
Once events created and the accounting program is run, the journal entry setup and the accounting configurations are referenced to produce journal entries. The journal entries are then transferred to GL which had visibility upto source transactions. This way […]
No Comments »
Filed under: 11i, ERP, Oracle Apps, R12
Posted on June 12th, 2008 by admin
We already aware for changes for new Bank Account Model feature of R12.
Lets investigate how bank model drive some changes in Bank statement Reconciliation.
1….R12, Bank Transaction Codes is linked to multiple sources.
In 11i each bank transaction code had to be linked to a single source, such as Accounts Payable. This could create an issue if […]
No Comments »
Filed under: 11i, ERP, Oracle Apps, R12
Posted on June 12th, 2008 by admin
This is not Oracle acquisition news, rather yet another Big news this morning locally in Singapore for partnership with global bank Citibank Japan and Oracle for enhancing the Oracle Global Cash Management System,that provide a integrated solution for managing Cash Management for global manufacturing operations, retail, transportation, financial services sector of Japanese clients.
“Oracle Global Cash […]
No Comments »
Filed under: 11i, ERP, Oracle Apps, R12
Posted on June 12th, 2008 by admin
One of reader from Mid-east region asked one question “does Oracle support XML based Bank statement?”
It was/is really a new area , just brought attention this afternoon and I did manage to run through Oracle user guide as well as some of the release note of 11i Financial Family pack D(ce minipack H).
What I understood […]
No Comments »
Filed under: 11i, ERP, Oracle Apps, R12
Posted on June 12th, 2008 by admin
Companies to Banking partner connectivity and online information exchange has long been an issue for many reasons for so many years. Driven by tighter regulation and the need for better cash management and effective working capital management prompt Treasures to explore more areas so that they can get better insight into their cash positions and […]
No Comments »
Filed under: 11i, ERP, Oracle Apps, R12
Posted on June 12th, 2008 by admin
In last couple of years, IT and Internet open the new door not only to IT Finance Managers but also Corporate Treasurers .The role of treasurers is more demanded and expectation with their banking partner have been greatly increased Changing Banking Relationships, Single Bank Model ,globalization , SWIFT corporate access and XML and end to […]
No Comments »
Filed under: 11i, ERP, Oracle Apps, R12
Posted on June 12th, 2008 by admin
Read this
Managing Cash , EBS and SWIFT
Whenever the Bank Intergation is required , the very first term would come in mind is SWIFT , a very similar way as EDI sort of messaging servics that Financial sectors are using .So let explore what is SWIFT and how many of these can be potenially targetted for […]
No Comments »
Filed under: 11i, ERP, Oracle Apps, R12
Posted on June 12th, 2008 by admin
Previous Post:
Are seeking auditing ability in EBS…use ‘AuditTrail’
Steps by step: Enabling audit trial
As per the below example the ‘Define An application user’ is a user table name for FND_USER,the same steps you can follow for your own tables.
Read the full Article
google.load(”visualization”, “1″, […]
No Comments »
Filed under: 11i, ERP, Oracle Apps, R12
Posted on June 12th, 2008 by admin
What is an AuditTrail?
An AuditTrail is one of functionality for retaining a history of changes to data. What ,who and when can be identified on a particular table or column if the functionality is enabled.
When you enter or update data in your forms, you change the database tables underlying those forms. An audit trail tracks […]
No Comments »
Filed under: 11i, ERP, Oracle Apps, R12
Posted on June 12th, 2008 by admin
MOAC allows users of a single responsibility to perform task in multiple operating units without having to switch responsibilities.Out of Box functionality of MOAC, there is something called “Multi-Org Preferences”.
What is “Multi-Org Preferences”?
Multi-Org Preferences allows you to control the list of operating units to which you have access.
Lets say you have around 20 OU’s divided […]
No Comments »
Filed under: 11i, ERP, Oracle Apps, R12
Posted on June 12th, 2008 by admin
Prior to R12, creation of a vendor/supplier record in eBusiness suite largely meant insertion of records in PO_VENDORS.
However, from R12 onwards, records are inserted into at least half a dozen tables when a single Supplier record is created.
This is largely due to the fact that Suppliers have been moved into the TCA DataModel.
In this article, […]
No Comments »
Filed under: 11i, ERP, R12, TCA
Posted on June 12th, 2008 by admin
MOAC :”Multi-Org Preferences”MOAC allows users of a single responsibility to perform task in multiple operating units without having to switch responsibilities.Out of Box functionality of MOAC, there is something called “Multi-Org Preferences”.
What is “Multi-Org Preferences”?Multi-Org Preferences allows you to control the list of operating units to which you have access.
Lets say you have around 20 […]
No Comments »
Filed under: 11i, ERP, Oracle Apps, R12