AGIS Tables

SELECT * FROM FUN_TRX_BATCHES WHERE batch_number=<<AGIS BATCH NUMBER>>

SELECT * FROM FUN_TRX_HEADERS WHERE BATCH_ID=<<batch_id>>

SELECT * FROM FUN_TRX_LINES

SELECT * FROM FUN_DIST_LINES

SELECT * FROM APPS.GL_LEDGER_LE_V  WHERE LEDGER_ID =<<LEDGER_ID>>    AND LEGAL_ENTITY_ID=<<LEGAL_ENTITY_ID>>

Oracle OAF Blogs

OAF

https://blogs.oracle.com/prajkumar/entry/personalization_and_extensions_for_oaf

http://iwidi.org/index.php/other-useful-articles

http://oracledot.blogspot.com/p/1-copy-project-from-app-server-to.html

https://blogs.oracle.com/prajkumar/entry/oaf_developer_guide

https://blogs.oracle.com/prajkumar/entry/oaf_hello_world_tutorial

http://oracleanil.blogspot.com/

http://dilipoaf.blogspot.com/

http://sushantsharmaa.blogspot.com/p/home-page.html

http://chiranjeevioaf.blogspot.com/

http://kohlivikram.blogspot.com/

http://rpforacle.blogspot.com/2013/03/creating-dependent-lov-in-oaf-page.html

http://yesyespatil.blogspot.com/

http://gyanoracleapps.blogspot.com/

http://adforajit.blogspot.com/

https://dineshnair.wordpress.com/2009/06/02/integrating-workflow-and-oaf/

http://rajubandam.blogspot.com/

http://www.oracleappsdeveloper.com/2012/03/oaf-basics.html

https://en.wordpress.com/tag/programatically-add-rows-in-advanced-table-in-oaf/

http://mahmoudoracle.blogspot.com/

http://www.blogadda.com/blogs/SQL_PLSQL_Oracle_Apps_OAF_Tutorials-nisheeth84_3

http://appsphor.appspot.com/blogger.jsp?blogName=OAF&subBlogName=0001%20Introduction%20To%20OAF&blogLevel=third

http://www.fatihtufekcioglu.com/fatihtufekcioglu/tag/oaf/

http://www.adivaconsulting.com/blog-oracle-application-framework/item/120-setting-up-the-development-environment.html

http://blog.chain-sys.com/?p=287

http://oracle-fusion-blogs.info/?p=20

http://blog.oureducation.in/oracle-oaf-training/

http://h30499.www3.hp.com/t5/Project-and-Portfolio-Management/Migrating-OAF-pages-using-Oracle-Apps-in-HP-PPM/td-p/5290031#.VZWbN_lVhBc

http://www.techartifact.com/blogs/2009/03/oaf-versus-adf.html#sthash.QjWdFIdw.dpbs

http://sreenijakkula.blogspot.com/2014/07/how-to-make-dff-fields-to-mandatory-in.html

https://community.oracle.com/thread/1124874

http://bhaskarreddyapps.blogspot.com/2012/05/how-to-add-descriptive-flexfields-dff.html

http://sushantsharmaa.blogspot.com/2013/05/16-controller-extension-in-oaf.html

http://andrejusb.blogspot.com/2009/12/conditionally-required-fields-in-oracle.html

http://chiranjeevioaf.blogspot.com/

http://plansoft.org/wp-content/uploads/knowledge/narzedzia/OAF-personalizacje.pdf

Java Augmenter chain sys

http://www.ncoaug.org/NCOAUG%20Training%20Day%20Feb%202010/INTERFACE_ALL_YOUR_ENTERPRISE_APPS_TO_R12-NCOAUG.pdf

http://www.chain-sys.com/echain_DemoCD/brochure/c3augmenter_brochure.pdf

http://oracle-hack.blogspot.com/2008/11/defaultsetrequired-dff-segments-in-r12.html

http://www.techhoney.com/oaf-miscellaneous/how-to-put-validation-in-oaf-page/

http://vigt.com/oa-framework-basic-personalizations/

Personalising Oracle Applications using the the new Framework of 11.5.10
http://nzoug.org/files/papers/TAYLOR+-+DAVID.PDF

http://www.oracleport.com/installing-and-setting-up-jdeveloper-of-oaf-customization-r12x/


http://newtonapples.com/unit/vo-extension-oaf/

Oracle Apps Tables

Tables in Procure to Pay Flow






Tables in Order to Cash Flow





Tables in Record to Report

Oracle Costing Blogs

Oracle SCM & Oracle Procurment

http://vipulsharmaoracleapps.blogspot.com/


Oracle Costing Basics

http://sriramapps.blogspot.com/2013/05/types-of-costing.html

http://www.theglobaltutors.com/cost-accounting/methods-of-costing.aspx

http://www.volzconsulting.com/oaugcostsig.html

http://appsonwalk.blogspot.com/2013/03/standard-cost-update.html

http://oracletestingsolutions.com/oracle-apps-tutorial-understanding-cost-elements-cost-types-cost-groups-and-costing-methods-in-cost-management/

http://applearn.blogspot.com/2008/09/oracle-cost-management-standard-costing.html

http://www.appsbi.com/tag/oracle-cost-methods

http://www.projectp.com/ppblog/tag/standard-costing/


https://eqextportal.qantas.com.au/OA_HTML/help/state/content/locale.en/navId.2/navSetId.iHelp/vtTopicFile.iHelp%7CHelpServlet%7CUS%7CBOM%7C@t_waeexts/

http://www.appsbi.com/tag/oracle-cost-methods

http://oracleappsilearn.blogspot.com/2009/07/oracle-cost-management-client.html

https://www.youtube.com/watch?v=IAfsZq2SAdE

http://oraapps-raghuraman.blogspot.com/2011/12/costing-of-inventory-in-r12-and-end-to.html

http://neocortex.com/interact/?p=50

http://oracleappsdna.com/2011/10/how-costing-is-performed-on-inventory-material-transactions/

http://appsfinancialtraining.blogspot.com/2012/12/oracle-cost-management.html

http://trinamix.com/oracle-cost-management/713

http://3lyoracleapps.blogspot.com/2012/05/cost-cutoff-date.html

http://www.oraappsguide.com/oracle-costing-layer-cost-worker-2/

http://kishorecboracleapps.blogspot.com/2013/03/oracle-inventory-transactions-and-cost.html

http://oracleapps88.blogspot.com/2012/10/oracle-inventory-costing-overview.html

http://gauravmagade.blogspot.com/2013/09/fifo-costing-overview-and-cost.html

http://oraclekey.blogspot.com/2010/10/how-to-define-cost-type-in-oracle.html

http://nayeemsappsdba.blogspot.com/2011/10/how-to-stopstart-cost-manager.html

http://gauravmagade.blogspot.com/2013/09/fifo-costing-overview-and-cost.html

http://www.learningwerks.com/OracleTutorials/oracle-e-business-suite/oracle-supply-chain-management/oracle-cost-management/

http://www.oracleug.com/user-guide/cost-management/item-costing

http://oraclea2z.blogspot.com/2010/12/inv-cost-group-disabled-in-inventory.html

http://oraclea2z.blogspot.com/2010/12/inv-cost-group-disabled-in-inventory.html

http://www.oracle-apps-training-online.com/customizing-transactions.html

http://www.oracleappshub.com/general-ledger/inventory-transfer-to-gl/

http://www.learnoracle.in/2014/04/difference-in-wms-cost-group-and.html

http://madhappan.blogspot.com/2012/06/oracle-ebs-valuation-and-other-accounts.html

http://accounting-financial-tax.com/2009/02/journal-entry-for-inventory-transactions/

Oracle Inventory Terminology

Terms used in the conventional Inventory system and as referred in Oracle Inventory may be different. A brief explanation of the ‘Oracle Inventory’ term’s vis-à-vis the existing terminology is provided the following paragraphs. These terms are extensively used in documenting the ‘Inventory - To Be’ flows and it is recommended that the various users of this system get acquainted with the same.

Item Validation Organization: The organization that contains your master list of items. You define it by setting the OE: Item Validation Organization profile option.

Logical organization: A business unit that tracks items for accounting purposes but does not physically exist.

Organization: A business unit such as a plant, warehouse, division, department, and so on. Order Management refers to organizations as warehouses on all Order Management windows and reports.

Destination organization: An inventory organization that receives item shipments from a given Organization.

Workday calendar: A calendar that identifies available workdays for one or more organizations. Master Scheduling/MRP, Inventory, Work in Process, and Capacity plan and schedule activities based on a calendar’s available workdays.

Workday exception set: An entity that defines mutually exclusive sets of workday exceptions. For each organization, you can specify a workday calendar and exception set.

Primary unit of measure: The stocking unit of measure for an item in a particular organization.

Unit of measure: The unit that the quantity of an item is expressed.

Unit of measure class: A group of units of measure and their corresponding base unit of measure. The standard unit classes are Length, Weight, Volume, Area, Time, and Pack.

Unit of measure conversions: Numerical factors that enable you to perform transactions in units other than the primary unit of the item being transacted.

Category: Code used to group items with similar characteristics, such as plastics, metals, or glass items.

Category set A feature in Inventory where users may define their own group of categories. Typical category sets include purchasing, materials, costing, and planning.

Purchased item: An item that you buy and receive. If an item is also an inventory item, you may also be able to stock it.

Standard item: Any item that can have a bill or be a component on a bill except planning items, option classes, or models. Standard items include purchased items, subassemblies, and finished products.

Substitute item: An item that can be used in place of a component. Master Scheduling/MRP suggests substitutes items on some reports.

Inventory item: Items you stock in inventory. You control inventory for inventory items by quantity and value. Typically, the inventory item remains an asset until you consume it. You recognize the cost of an inventory item as an expense when you consume it or sell it. You generally value the inventory for an item by multiplying the item standard cost by the quantity on hand.

Item attribute control level: To maintain item attributes at the item master attribute level or the Organization specific level by defining item attribute control consistent with your company policies. For example, if your company determines serial number control at headquarters regardless of where items are used, you define and maintain serial number attribute control at the item master level. If each organization maintains serial number control locally, they maintain those attributes at the organization specific level.

Item attributes: Specific characteristics of an item, such as order cost, item status, revision control, COGS account, etc.

Item master level attribute: An item attribute you control at the item master level as opposed to controlling at the organization level.

Item status: Code used to control the transaction activity of an item.

Deletion constraint: A business rule that restricts the entities you can delete. A deletion constraint is a test that must succeed before an item, bill, or routing can be deleted.

Current on–hand quantity: Total quantity of the item on–hand before a transaction is processed.

On–hand quantity: The physical quantity of an item existing in inventory.

Subinventory: Subdivision of an organization, representing either a physical area or a logical grouping of items, such as a storeroom or receiving dock.

Locator: Physical area within a subinventory where you store material, such as a row, aisle, bin, or shelf.

Locator control: An Oracle manufacturing technique for enforcing use of locators during a material transaction.

Revision A particular version of an item, bill of material, or routing.

Revision control: An inventory control option that tracks inventory by item revision and forces you to specify a revision for each material transaction.

Lot: A specific batch of an item identified by a number.

Lot control: An Oracle Manufacturing technique for enforcing use of lot numbers during material transactions thus enabling the tracking of batches of items throughout their movement in and out of inventory.

Serial number: A number assigned to each unit of an item and used to track the item.

Serial numbers control: A manufacturing technique for enforcing use of serial numbers during a material transaction.

Min–max planning: An inventory planning method used to determine when and how much to order based on a fixed user–entered minimum and maximum inventory levels.

Reorder point planning: An inventory planning method used to determine when and how much to order based on customer service level, safety stock, carrying cost, order setup cost, lead time and average demand.

Safety stock: Quantity of stock planned to have in inventory to protect against fluctuations in demand and/or supply.

ABC classification: A method of classifying items in decreasing order of importance, such as annual dollar volume or your company’s transaction history.

Cycle counting: An inventory accuracy analysis technique where inventory is counted on a cyclic schedule rather than once a year.

Physicals inventory: A periodic reconciliation of item counts with system on–hand quantities.

Account alias: An easily recognized name or label representing an account charged on miscellaneous transactions. You may view, report, and reserve against an account alias.

Inter–organization transfer: Transfer of items from one inventory organization to another You can have freight charges and transfer credits associated with inter–organization transfer. You can choose to ship items directly or have them go through intransit inventory.

Material transaction: Transfer between, issue from, receipt to, or adjustment to an inventory organization, subinventory, or locator. Receipt of completed assemblies into inventory from a job or repetitive schedule. Issue of component items from inventory to work in process.

Transaction cost: The cost per unit at which the transaction quantity is valued.

Transaction interface: An open interface table through which you can import transactions.

Transaction manager: A concurrent program that controls your manufacturing transactions.

Receipt: A shipment from one supplier that can include many items ordered on many purchase orders.

Return to supplier: A transaction that allows you to return to the supplier items from a fully or partially received purchase order and receive credit for them.

Supplier: Provider of goods or services.

Accounting period: The fiscal period a company uses to report financial results, such as a calendar month or fiscal period.

Average costing: A costing method which can be used to cost transactions in both inventory only and manufacturing (inventory and work in process) environments. As you perform transactions, the system uses the transaction price or cost and automatically recalculates the average unit cost of your items.

Standard costing: A costing method where a predetermined standard cost is used for charging material, resource, overhead, period close, job close, and cost update transactions and valuing inventory. Any deviation in actual costs from the predetermined standard is recorded as a variance

Oracle Inventory TRM

https://docs.oracle.com/cd/A88418_01/acrobat/invtrm.pdf

Oracle Inventory Exam

Overview of Oracle Inventory

• Describe the overall inventory process from receipt to issue
• Describe the key integration points between Oracle Inventory and other Oracle Applications

Inventory Structure

• Describe Inventory Organization
• Describe the structure of an Inventory Organization
• Describe the multi-organization structure in Oracle Applications
• Use the organization reports
• Set up Inventory parameters, sub inventories, and locators
• Set up the organization profile options
• Describe organization implementation considerations

Units of Measure

• Define units of measure
• Use units of measure reports
• Use units of measure setup options
• Describe units of measure implementation considerations

Defining and Maintaining Items

• Define, setup and maintain items,
• Use item templates
• Use item control levels
• Use item categories and catalogs
• Use organization reports
• Implement item profile options
• Describe implementation considerations for items

Lot and Serial Control

• Describe lots
• Describe parent and child lots
• Describe shelf life and lot actions
• Describe grade control
• Describe serial control
• Describe lot and serial genealogy
• Use the lot and serial reports
• Implement the lot and serial profile options
• Describe implementation considerations for lot and serial control

Transaction Setup

• Describe transactions and move orders
• Define transaction managers, transaction types, and transaction reasons
• Define inventory picking rules
• Define inventory account aliases
• Set up move orders
• Describe Period Close Process within Inventory
• Use Alerts Notifications and Reports
• Set up Profile Options
• Describe implementation considerations for transaction setup

Issuing and Transferring Material

• Perform Transactions
• Manage Receipts
• Perform Move Orders
• Understand Transactions Reports

On-hand and Availability

• Explain availability
• View on-hand quantities
• Describe the uses of the material workbench
• Create ATP rules, time fences and supply/demand sources
• Manage Reservation
• Implement on-hand and availability profile options
• Use on-hand and availability reports
• Describe on-hand and availability implementation considerations

Material Status Control

• Explain material status
• Set up material status properties
• Describe key material status implementation considerations

Inventory Replenishment

• Perform forecasting
• Explain reorder-point planning
• Perform min-max planning
• Perform replenishment counting
• Set up inventory planning profile options
• Generate kanban cards
• Identify Implementation Considerations for Inventory Replenishment

Inventory Accuracy

• Create an ABC compile
• Define and maintain a cycle count
• Define a physical inventory
• Demonstrate count adjustments and approvals
• Use inventory accuracy reports
• Set up inventory accuracy profile options
• Explain key inventory accuracy implementation considerations

Table Information

• Identify the Oracle Inventory tables
• Access eTRM