iProcurement charge account defaulting

There is a common question; how are the accounts generated? The answer for the iProcurement Charge account is below:

How Is Charge Account Defaulted On iProcurement Requisition Lines?[ID 455847.1]
If an Inventory Organization is specified for the location, then this is considered an Inventory Location.

If Inventory Organization is blank, then this is considered an Expense Location.

For items delivered to inventory location the charge account is defaulted from the following settings in the order shown

Charge account specified in the subinventory to which the inventory item will be delivered affected by the following:
The profile 'POR : Preferences -Selected Items Default to Inventory'
The subinventory location specified in iProcurement Preferences
The Deliver To Subinventory checkbox available during iProcurement checkout
Charge account specified in the item definition in Master Items form.
Charge account specified in the Employee setup form (Human Resources / People / Enter and Maintain / Assignment / Purchase Order Information)
Charge account specified as Primary Favorite Charge Account in iProcurement Preferences
- used only if none of the above defaults are specified

For items delivered to expense location the charge account is defaulted from the following settings in the order shown

For items charged to Projects, the project based charge account will be used based on customizations implemented in the requisition account generator workflow.
Charge account specified in the item definition in Master Items form.
Charge account specified in the Employee setup form (Human Resources / People / Enter and Maintain / Assignment / Purchase Order Information)
- affected by Expense Account Rules setup in Purchasing / Setup / Financials / Accounting / Expense Account Rules. Expense account rules can replace one of more of the defaulted charge account segments with a new segment value(s) specified in the expense account rule(s)
Charge account specified as Primary Favorite Charge Account in iProcurement Preferences
- used only if a default employee account is not specified
- affected by Expense Account Rules only if the profile POR Apply Expense Account Rules To Favorite Charge Account = Yes.

Tax table

For tax calculations there is a new module in R12 and there are some changes. There is a table for transaction related attributes used for tax calculation and reporting which is not known commonly and i dont want to forget it so here it is: zx_lines_det_factors. Each row stores a transaction line of an event class.

Workflow Persons

Workflows don' t work as expected sometimes like not following the right course, not sending notifications to correct people or sometimes workflow can't find an existing person. In these cases two concurrent programs may resolve the problem:
1- Synchronize WF LOCAL tables; this works most workflows
2- Fill Employee Hierarchy; this works for purchasing hierarchy of purchasing documents like Requisitions, Blanket Agreements etc.

Materialized View

When you want to query a large volume data performance may not satisfy you because of the high cost of query. What should you do in such a situation? One solution is using Materialized View. It is a view which can be refreshed periodically with the frequency you define. You can prepare your query and create a materialized view then in reports or screens you can select results from it just like a table instead of your costly query. What is the advantage? The answer is quite clear: Performance. What is the disadvantage? Results are snapshot of last time of query refresh, so if you need fresh data this may not be the solution.

To track your assets in EBS solution is Installed Base. Here are some sample questions you can find answers with Installed Base:
"Where exactly is my Copier that’s making me money & what’s happened to it?
Where is that Car we leased out & customer wants us to repair? How many cars?
Where do I have copiers installed at various offices across country & how many copies did we print in last 3 months in division xxx?"

Following link covers the subject in detail so i will not repeat the info:
http://apps2fusion.com/at/rs/362-oracle-install-base-track-your-assets-and-items

How to add unused columns to Descriptive Flex Fields?

1- Reach the screen: Application Developer responsibility> Flexfield> Register> Descriptive Flex Field
2- Control attributes: press F11> write %AP_INVOICES_ALL> press Ctrl+F11> control unused global_attributes where structure=ATTRIBUTE_CATEGORY lets assume global_attribute10 is unused
3- Uncheck: uncheck global_attribute10 where structure=GLOBAL_ATTRIBUTE_CATEGORY
4- Check: check global_attribute10 where structure=ATTRIBUTE_CATEGORY

Suppliers in TCA

Supplier, customer etc structures had major changes in R12 and it is called TCA: Trading Community Architecture. It is a complicated structure and here is a link to understand supplier part of this structure: http://oracle.anilpassi.com/suppliers-in-tca-a-dive-into-vendor-tables-in-r12-2.html

Read only screens

For security reasons customers may want screens to be read only for some users (Ex: External users - internal users of system or for different departments) This is not easy for OAF screens though quite easy for Forms screens. There are various options for Forms; custom pll, personalization, GRC module and function definition. The easiest way is adding QUERY_ONLY=YES value to form function parameters.