How is Receiving supported across multiple operating units in Release 12?
When the Receipts form is opened, the list of values (LOV) will be displayed of the inventory organizations which are available to the user through the security profile. Receiving forms unlike other transaction entry forms in Oracle Purchasing, does not make it mandatory for the user to choose an operating unit even after selecting the inventory organization to receive the shipment. User will still be allowed to change to an operating unit which may not necessarily include the inventory organization chosen initially. For eg. if M1 is an inventory organization which is not included in an operating unit 'Vision Communications (USA)', and if M1 is chosen initially as the receiving inventory organization, user is still allowed to select the operating unit context as Vision Communications (USA). This is an intended feature in Release 12.
Terms and Definitions Used in Intercompany Accounting
Intercompany Journal
This is a journal entry which has transactions for at least
two different companies (or balancing segment values).
Intercompany Journal Out of Balance
An out of balance intercompany journal is one which does not have equal
credit and debit totals for each group of lines by company.
Balancing Segment
This is the accounting flexfield segment that has the balancing segment
qualifier assigned to it. Typically the balancing segment stores the company
values. However, it could represent the cost center, the department or some
other values.
The terms balancing segment and company segment are usually interchangeable.
It is mandatory that one segment of your accounting flexfield be designated
as the balancing segment.
Intercompany Segment
The intercompany segment is the accounting flexfield segment that has
the intercompany segment qualifier assigned to it. This qualifier is only
available in release 11i and is optional. This segment shares the same
value set as the balancing segment.
Clearing Account
A clearing account is a temporary account that holds amounts to be
transferred to another account.
Clearing Company
This is the company value used to clear payables or receivables transactions.
General Ledger uses this company to balance intercompany transactions.
Trading Partner
Trading partner is the company against which the line transaction is made.
Transaction Types
Transactions types are the classifications for journal entries based on
the number of companies involved in the credit and debit side
of the transaction.
The different transaction types are:
One to One: Two different companies in the journal. One company
has the net debit balance and the other has a net credit balance.
Many to One: Different companies have net debit balance and one
company has net credit balance.
One to Many: One Company has net debit balance and more than one
companies have net credit balance.
Many to Many: Two or more companies have net debit balance and
two or more companies have net credit balance.
What are the components of the standalone Oracle Forms product?
The standalone Oracle Forms product is composed of the following:
Forms Builder - this program is used to create and modify Forms modules.
Forms Compiler - this program is used to generate your FMX files.
Forms Runtime - this program is the engine that runs your Form logic when you form is deployed in client/server.
Forms Metric Server - this program is used in Forms load balancing.
Forms Metric Client - this program is used in Forms load balancing.
Forms CGI - this program dynamically generates the applet html that defines your form.
Forms Server - this program listens for Forms Runtime engine requests.
Forms Web Runtime - this program is the engine that runs your Form logic when your form is deployed over the web.
How to identify Receipts on Bank Account Number in Lockbox Process?
A Magnetic Ink Character Recognition (MICR)
An MICR number consists of two segments.
1. The first segment is the Transit Routing Number.
The transit routing number should be filled in the field Bank Branch Number of the Banks window (NAV Setup/Receipts/Banks). When this number is not available in Applications, a Bank Branch will automatically be generated by the Lockbox process.
2. The second segment identifies the Bank Account of the customer.
A Customer Bank should be defined in Bank Accounts window
Responsibility: Receivables Manager
Navigation: Setup > /Receipts > Banks - Customer Bank
Also make sure this Bank Account is defined with the Customer on Customer level
Responsibility: Receivables Manager
Navigation: Customers > Customers
The MICR number is used to identify the Customer.
The MICR numbers used are shown on the Lockbox Execution Report.
The ACCOUNT (customer bank account number) and the TRANSIT_ROUTING_NUMBER (bank branch number) should be available in the lockbox interface table AR_PAYMENTS_INTERFACE_ALL in order to get identified receipts.
Remark that when the receipt batch is queried after validation, and when the application type is changed from Unidentified to On Account and a Customer is added, the system will automatically add the customer bank to the Bank Accounts window and the Customer window.
Can I update an imported Internal Order through order import?
The functionality of the Update of the Internal Order through the Order
Import is not supported. The code has a valid purpose for 'INSERT'
operation, other operations are not supported and can return the right
or wrong result depending on the data passed for that operation
which is not supported.
Is it possible to keep the legacy order number through order import?
You can create a transaction type and associate the manual sequence
number for that (see the manual for how to associate the sequence for the
transaction type). Or, the other option is to store the old order
number in orig_sys_document_ref.
How can the user decrease the log file size for Order Import?
Verify the following settings:
1. ONT_DEBUG_LEVEL = 0 in all levels
2. QP:Debug is Zero in all levels
3. The Parameter for for the debug level is aslo Zero at the concurrent
program definiton.
4. OM:Debug log directory value set to null.
If it is not resolved, bounce the web server using the applmgr or any
relevant account. The script to do this is adapcctl.sh in unix. The
web server needs to be bounced for the value of the variable to be
reset in ONT_DEBUG_PUB.
Important Features of Multi org
- Multiple Organizations in a Single Installation
- You can define multiple organizations and the relationships among them in a single installation of Oracle Applications. These organizations can be sets of books, business groups, legal entities, operating units, or inventory organizations.
- Secure Access - You can assign users to particular organizations. This ensures accurate data transactions to the correct operating unit.
- Sell and Ship Products From Different Legal Entities You can sell from one legal entity and ship from another, posting to each organization’s set of books.
- Purchase and Receive Products Between Organizations
- You can enter purchase orders and assign for receipt any inventory organization that uses the same set of books.
- Automatic Accounting for Internal Requisitions
- You can create an internal requisition (sales order) in one organization, then ship from another organization, with accurate inter company invoicing.
- Improved Database Architecture
- Beginning with Release 10.6, there is one Applications All Objects Oracle schema, referred to as the APPS schema. You can secure data by implementing the Multiple Organization Support
- Verify Your Enterprise Structure - After you have implemented the Multiple Organization Support feature, you can execute a report to identify setup problems. The Multiple Organization Setup Validation Report identifies errors and, if you choose, automatically makes adjustments to your enterprise setup.
- Automatic Seed Data Replication The Multiple Organization Support feature will automatically replicate seed data to the new business units you define.
Type of Organizations in Oracle Apps
Every enterprise has an organizational hierarchy for easy management and process streamlining. Each sub organizations serve a different purpose and improves efficiency of the enterprise. To acheive this efficiency oracle apps provies 6 Types of Organizations.
Set of Books
A financial reporting entity that uses a particular chart of accounts, functional currency, and accounting calendar. Oracle General Ledger secures transaction information (journal entries, balances) by set of books. When you use Oracle General Ledger, you choose a responsibility that specifies a set of books. You then see information for that set of books only.
Business Group
Represents the consolidated enterprise, a major division, or an operation company. Human resources information is secured by business group. For example, when you request a list of employees, you see all employees assigned to the Business Group of which your organization is a part.
Legal Entity
Represents a legal company for which you prepare fiscal or tax reports. You assign tax identifiers and other legal entity information to this type of organization.
Balancing Entity
An entity for which you prepare a balance sheet, represented as a balancing segment value in your accounting flex field. Each legal entity can have one or more balancing entities. You can use Flex field Value Security rules to restrict data entry of balancing segment values by legal entity or operating unit.
How does Requisition Import determine the grouping method for incoming pieces of data?
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.
Recent Posts
- Oracle Nukes ETRM
- Urgent Required- IT MNC- Oracle Apps SCM Professionals-Bangalore,Pune,Chennai,Hyderabad
- Account Receivables Tables list oracle r12.2
- General Ledger tables
- Account Payables Tables
Recent Comments
Archives
- April 2021
- June 2015
- April 2015
- March 2015
- July 2014
- April 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- August 2013
- January 2013
- June 2012
- May 2012
Categories
- Account Payables
- Advanced Pricing
- General Ledger
- implementation
- Inventory
- jobs
- Multi Org
- Oracle apps general
- oracle fnd
- oracle forms
- oracle hrms
- Order Management
- Purchasing
- Receivables
- Uncategorized
- vision instances