Discrete Jobs End to End Cycle with Cost Roll-up in Standard Cost Organization in R12.2

Discrete Jobs End to End Cycle with Cost Roll-up in Standard Cost Organization in R12.2

STEP 1: CREATE ITEMS

Responsibility: Inventory Navigation: Items > Master Items

Select the Organization as "M1 - Seattle Manufacturing"

Create the below items;

Item	Item Template (Type)
DYS_CAR	Finished Goods
DYS_ENGINE	Purchased Item
DYS_CHASIS	Purchased Item
DYS_WHEEL	Purchased Item
DYS_SEAT	Purchased Item

Item : DYS_CAR Template/Type: Finished Goods

Item : DYS_ENGINE Template/Type: Purchased Item

Item : DYS_CHASIS Template/Type: Purchased Item

Item : DYS_WHEEL Template/Type: Purchased Item

Item : DYS_SEAT Template/Type: Purchased Item

STEP 2: DEFINE ITEM COST

Define the Item Costs like below;

Item	Item Template (Type)	Item Cost (USD)
DYS_CAR	Finished Goods
DYS_ENGINE	Purchased Item	500
DYS_CHASIS	Purchased Item	300
DYS_WHEEL	Purchased Item	100
DYS_SEAT	Purchased Item	50

Responsibility: Inventory Navigation: Costs > Item Costs

Click on "New"

Item: DYS_ENGINE Cost Type: Pending

Click on "Open"

Click on "Costs"

Cost Element / Sub-Element: Material Unit Cost: 500 USD

Save

Query the Item "DYS_ENGINE"

Can see two records for this item. One record will be in "Frozen" Cost Type and the another one will be in "Pending" Cost Type. Currently "Frozen" cost type will show only zero (0) cost. Once we run the "Update Standard Costs" then the cost will be updated in Frozen type from Pending cost.

Note: M1 - "Seattle Manufacturing" is a Standard Costing Organization. So, we need to enter the cost in "Pending" cost type.

Likewise we can enter the Item Cost for remaining items

Item: DYS_CHASIS Unit Cost: 300 USD

Item: DYS_WHEEL Unit Cost: 100 USD

Item: DYS_SEAT Unit Cost: 50 USD

STEP 3: DEFINE RESOURCES

Define the Resources like below;

Resources Name	Resource Type	Rate	UOM
DYS_ASMLY	Machine	100	HR
DYS_LBR	Person	50	HR
DYS_PNTR	Person	25	HR

Responsibility: Bills Of Material Navigation: Routing > Resources

Select the Organization as "M1 - Seattle Manufacturing"

Enter the Resource Name, Resource Type, Charge Type and enable the "Costed" & "Standard Rate" check box and enter the Absorption Account and Variance Account.

Click on "Rates"

Likewise create the remaining Resources and enter the Resource Rates.

Resource Name: DYS_LBR Type: Person Rate: 50 USD

Resource Name: DYS_PNTR Type: Person Rate: 25 USD

STEP 4: DEFINE DEPARTMENTS

Create the new Departments and assign the Resources to each Departments like below;

Department Name	Resources
DYS_ASMLY	DYS_ASMLY DYS_LBR
DYS_PAINT	DYS_PNTR

Responsibility: Bills Of Material Navigation: Routing > Departments

Select the Organization as "M1 - Seattle Manufacturing"

Click on "Resources"

Create the another department for Painting and assign the resource.

Department Name: DYS_PAINT Resources: DYS_PNTR

Click on "Resources" and assign the Resource

Note: For this case, only Machine Resource (DYS_ASMLY) is available for 24 Hours. Person Resources (DYS_LBR and DYD_PNTR) are available only in normal day shift.

STEP 5: CREATE STANDARD OPERATIONS

Create the Standard Operations and assign the Departments like below;

Standard Operations	Department	Resources	Usage
DYSA	DYS_ASMLY	DYS_ASMLY DYS_LBR	1 2
DYSP	DYS_PAINT	DYS_PNTR	1

Responsibility: Bills Of Material Navigation: Routing > Standard Operations

Operation Code: DYSA Department: DYS_ASMLY

Click on "Operation Resources" and assign the Resources and it's "Usage/Inverse"

Note:

1. "DYS_ASMLY" Machine Resource will produce 1 Unit in 1 Hour (UOM = HR)
2. "DYS_LBR" Person resource will produce only half (0.5) unit in 1 hour. That means, 2 resources are required to complete this operation in 1 hour. So, the Inverse (Output/Hour) becomes 0.5

Likewise create one more Standard Operation and assign the Department and it's Resources.

Operation Code: DYSP Department: DYS_PNTR Resource: DYS_PNTR Usage: 1

Click on "Operation Resources" and enter the Usage

Note: Painter Resource will paint 1 Unit in 1 Hour

STEP 6: DEFINE OVERHEADS

Define one Overhead and enter the Rate/Unit

Responsibility: Inventory Navigation: Setup > Costs > Sub-Elements > Overheads

Overhead Name: DYS_OVRHED Cost Element: Overhead

Click on "Resources" and enter the Cost Type and then assign the Resources

Cost Type: Pending Resource: DYS_ASMLY

Save and Close the "Resource" Form

Click on "Rates" button and enter the Amount  

Basis: Item

Now, close the form and navigate to "Resources" form in Bills Of Materials

Note:

1. If we define Overheads based on "Basis = Item" then, the Formula is

Overhead Cost Calculation = Overhead Rate or Amount

2. If we define the Overheads based on "Basis = Resource Basis" then the formula is

Resource Overhead Cost = Resource Usage  X   Resource Cost  X  Overhead Cost

Responsibility: Bills Of Materials Navigation: Routing > Resources

Query the Resource " DYS_ASMLY" (This resource was attached in Overheads)

Click on "Overheads" button

Now, we can see the Overhead "DYS_OVRHED" which was created in the pervious step has been assigned here.

STEP 7: DEFINE ROUTING

Create the Routing for our Finished Goods "DYS_CAR"

Seq	Operation Code	Department	Resources	Usage	Inverse
10	DYSA	DYS_ASMLY	DYS_ASMLY DYS_LBR	1 2	1 0.5
20	DYSP	DYS_PNTR	DYS_PNTR	1	1

Responsibility: Bills of Materials Navigation: Routings > Routings

Click on "Operation Resources" and make sure all the assigned Resources are displaying or not for that Operation Seq.

STEP 8: DEFINE BILLS

Define the Bills of Materials for "DYS_CAR"  to produce 1 Unit

Bills	Components	Required Qty
DYS_CAR	DYS_CHASIS	1
DYS_CAR	DYS_ENGINE	1
DYS_CAR	DYS_WHEEL	5
DYS_CAR	DYS_SEAT	3

Responsibility: Bills Of Materials Navigation: Bills > Bills

Save

STEP 9: UPDATE STANDARD COST

Responsibility: Inventory Navigation: Costs > Standard Cost Update > Update Cost

Select "M1" Organization

" Update Standard Costs" program will be submitted and Running

Now, query the Item Costs for all our items

Navigation: Costs > Item Costs

Note:

1. When we run the "Update Standard Costs" program for "Pending" Cost Type, it will pull the Pending costs and push it into "Frozen" cost type.  
2. "DYS_CAR" doesn't reflect any cost. Because, the Cost Roll-up has not happened.

STEP 10: COST ROLL-UP

Responsibility: Cost Management

Navigation: Supply Chain Costing > Supply Chain Cost Rollup

Select the Organization as "M1 - Seattle Manufacturing"

Submit a single request and submit " Supply Chain Cost Rollup - Print Report"

Enter the parameters like below

Parameters:

Ran this report for "Pending" Cost Type for Specific Item "DYS_CAR"

View Output of "Supply Chain Cost Rollup - Print Report":

Material Cost Calculation:

Components	Qty	Item Cost	Total Cost
DYS_CHASIS	1	300	300
DYS_ENGINE	1	500	500
DYS_WHEEL	5	100	500
DYS_SEAT	3	50	150
MATERIAL COST			1450

Resource Cost Calculation:

Resources Name	Resource Type	Rate	UOM	Usage	Cost
DYS_ASMLY	Machine	100	HR	1	100
DYS_LBR	Person	50	HR	2	100
DYS_PNTR	Person	25	HR	1	25
Total Resource Cost					225

Overhead Cost Calculation:

Resource Name	Overheads	Department	Rate or Amount
DYS_ASMLY	DYS_OVRHED	DYS_ASML	10

Total Cost Calculation:

Cost Element	Value
Total Material Cost	1450
Total Material Overhead Cost	0
Total Resource Cost	225
Total Overhead Cost	10
Total Outside Processing Cost	0
Total Cost	1685

Add Additional Resource Overhead Cost based on Resource Usage:

Responsibility: Bills Of Materials Navigation: Routings > Resources

Query the Resource "DYS_LBR"

Add something existing overheads by clicking "Overheads" button

Added "Indirect" Overheads under "Pending" Cost Type.

Assign Overheads to Department/Resources:

Responsibility: Inventory Navigation: Setup > Costs > Sub-Elements > Overheads

Query the "Indirect" overhead

Click on "Resources"

Select "Pending" Cost Type and check our Resource "DYS_LBR"

Our Resource is available.

Close this form

Click on "Rates"

Select "Pending" Cost Type and add our Department "DYS_ASMLY"

Basis: Resource Value

Note:

Previously we have defined one Overhead "DYS_OVRHED" that is based on the "Basis = Item". Now, we have defined one Overhead based on "Basis = Resource Value". The Overhead Cost Calculation will be different in both the cases.

For Item Basis, cost is direct. Whatever the Rates we have entered in Overheads form that is a Cost

For Resource Basis, cost calculation is based on the below formula.

Resource Overhead Cost Calculation = Resource Usage  X   Resource Cost  X  Overhead Cost

STEP 11: UPDATE STANDARD COST

Repeat the step 10

Responsibility: Cost Management

Navigation: Item Costs > Standard Cost Update > Update Costs

Run "Update Standard Costs " program for specific item "DYS_CAR"

Submit the program

Once it's completed, do Cost Roll-up for this Item

STEP 12: COST ROLL-UP:

Navigation: Supply Chain Costing > Supply Chain Cost Rollup

Run "Supply Chain Cost Rollup - Print Report" program

Submit and View Output for "Supply Chain Cost Rollup - Print Report"

There are no changes in the Material and Resource Costs. But, there are some changes in the Overheads.

Overhead Cost for "DYS_OVRHED" = 10 USD

Overhead Cost for "Indirect" = Resource Usage  X   Resource Cost  X  Overhead Cost

Indirect Overhead Cost = 2 X 50 X 15 = 1500 USD

Total Overhead Cost = 10 USD + 1500 USD = 1510 USD

STEP 13: INCREASE ONHAND QTY FOR COMPONENTS

Do Miscellaneous Receipts or PO Receipts for Purchased Items

Save and Close the form

STEP 14: CREATE DISCRETE JOBS

Responsibility: Work In Process Navigation: Discrete > Discrete Jobs

Create a New Discrete Job for Assembly "DYS_CAR" and Save

STEP 15: RELEASE DISCRETE JOBS

Responsibility: Work In Process Navigation: Discrete > Discrete Jobs

Query the Discrete Job# 262860 that was created in the previous step

STEP 16: WIP ISSUE

Sine this Assembly's Supply Type is "Assembly Pull", it doesn't require to perform WIP Issue. System automatically issue the components upon completion of this Assembly

STEP 17: MOVE TRANSACTIONS

Responsibility: Work In Process Navigation: Move Transactions > Move Transactions

Query the JOb# 262860 and Move the Materials from Operation Seq 10 "Queue" to Operation Seq 10 "To Move"

Move the Materials from Operation Seq 10 "To Move" to Operation Seq 20 "To Move"

Save

STEP 18: ENTER QUALITY RESULTS_

If you have enabled Quality Collection Plan then enter those Quality Results

Click "OK"

To enter the Quality Results;

Navigation: Tools > Enter Quality Results or click on button from Menu bar

Enter the Quality Results

Click OK and Save

STEP 19: WIP COMPLETION

Responsibility: Work In Process Navigation: Material Transaction > Completion Transactions

Enter the Discrete Job number# 262860 and select the Transaction Type as "WIP Completion"

Click "Continue"

Sub-Inventory: FGI Qty: 10

Click "Done"

STEP 20: CLOSE DISCRETE JOBS

Responsibility: Work In Process

Navigation: Discrete > Close Discrete Jobs > Close Discrete Jobs (Forms)

Query the Discrete Jobs# 262860 which we have completed recently

Before closing the Discrete Jobs, check the Pending Transactions. To check the Pending Transactions

Navigation: Tools > Pending Actions

Select the "Pending Actions" option from Tools Menu and check for any pending actions

Only "Material Transactions" and "Resource Transactions" are enabled.

If anything other than the below mentioned actions are enabled then that means there are some pending actions

1. Material Transactions
2. Resource Transactions
3. PO Requisitions

In our Discrete Jobs, there are no pending actions. So, it's eligible to Close

To Close the Discrete Jobs, Navigate to Tools Menu and select the Close option

Select "Summary" and click "OK"

Discrete Job Status = Pending Close

Navigation: Tools > View > Request

Can see two requests

1. Close Discrete Jobs
2. Discrete Job Value Report - Standard Costing

If there are any pending actions then the second request will not run

Select the second request "Discrete Job Value Report - Standard Costing" and check the output

View Output:

Costing:

Material Cost: 1450 USD/Unit X 10 Qty = 14,500 USD

Resource Cost: 225 USD/Unit X 10 Qty = 2,250 USD

Overhead Cost: 10 USD + 1500 USD = 1510 USD/Unit X 10 Qty = 15,100 USD

Total Cost for 1 Qty = 1450 + 225 + 1510 = 3,185 USD

Total Cost for 10 Qty = 14,500 + 2,250 + 15,100 = 31,850 USD

BEGIN
GO_BLOCK('XXPRG_IS');
FIRST_RECORD;
LOOP
IF :XXPRG_IS.DIS_HEADID  <> :XXPRG_IS.BS_ID_CHECK AND :XXPRG_IS.DIS_HEADID  <> :XXPRG_IS.ID_CHECK THEN
INSERT INTO XXPRG_REPORT(XXPRG_REPORT.HEADNAME,XXPRG_REPORT.HEADID)
VALUES(:XXPRG_IS.DIS_HEADNAME,:XXPRG_IS.DIS_HEADID);
END IF;
EXIT WHEN :SYSTEM.LAST_RECORD='TRUE';
NEXT_RECORD;
END LOOP;
FIRST_RECORD;
END;

Background Processing/Transaction Processor Error On Transactions Interface And Pending Material Transactions Tables (Doc ID 1220763.1)

SELECT 'MTL_MATERIAL_TRANSACTIONS_TEMP' table_name, COUNT(*)
FROM MTL_MATERIAL_TRANSACTIONS_TEMP
WHERE ERROR_CODE = 'Transaction Processor Error'
AND TRANSACTION_BATCH_ID IS NOT NULL
UNION
SELECT 'MTL_TRANSACTIONS_INTERFACE' table_name, COUNT(*)
FROM MTL_TRANSACTIONS_INTERFACE
WHERE ERROR_CODE = 'Transaction Processor Error'
AND TRANSACTION_BATCH_ID IS NOT NULL ;


SELECT 'MTL_MATERIAL_TRANSACTIONS_TEMP' table_name, COUNT(*)
FROM MTL_MATERIAL_TRANSACTIONS_TEMP
WHERE ERROR_CODE = 'Transaction Processor Error'
AND TRANSACTION_BATCH_ID IS NOT NULL
UNION
SELECT 'MTL_TRANSACTIONS_INTERFACE' table_name, COUNT(*)
FROM MTL_TRANSACTIONS_INTERFACE
WHERE ERROR_CODE = 'Transaction Processor Error'
AND TRANSACTION_BATCH_ID IS NOT NULL ;





UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
SET TRANSACTION_BATCH_ID = NULL,
    PROCESS_FLAG = 'Y',
    LOCK_FLAG = 'N',
    ERROR_CODE = NULL,
    TRANSACTION_MODE = 3
WHERE ERROR_CODE = 'Transaction Processor Error'
  AND Transaction_Temp_id = &YourTransactionID;
 
 
UPDATE MTL_TRANSACTIONS_INTERFACE
SET TRANSACTION_BATCH_ID = NULL,
    PROCESS_FLAG = 1,
    LOCK_FLAG = 2,
    ERROR_CODE = NULL,
    TRANSACTION_MODE = 3
WHERE ERROR_CODE = 'Transaction Processor Error'
AND Transaction_Interface_id = &YourTransactionID;
 
  

Oracle APPS Important Tables

ONT- Order Management

Table Name Description
OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_ALL stores header information for orders in Order Management.
OE_ORDER_LINES_ALL OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management.
OE_ORDER_SOURCES Feeder System Names that create orders in Order Management tables.
OE_ORDER_HOLDS_ALL This table stores information of all the orders and lines that are on hold and the link to hold sources and hold releases.
OE_SALES_CREDITS This table stores information about sales credits.
OE_TRANSACTION_TYPES_ALL This table stores information about the order and line transaction types
WSH_DELIVERY_ASSIGNMENTS Delivery Assignments
WSH_DELIVERY_DETAILS Delivery Details
WSH_NEW_DELIVERIES Deliveries
WSH_TRIPS Trips
WSH_TRIP_STOPS Trip Stops

                  Interface Tables

• OE_HEADERS_IFACE_ALL
• OE_LINES_IFACE_ALL

                    
PO - Purchasing
Table Name Description
PO_ACTION_HISTORY Document approval and control action history table
PO_AGENTS Buyers table
PO_DISTRIBUTIONS_ALL Purchase order distributions
PO_HEADERS_ALL Document headers (for purchase orders, purchase agreements, quotations, RFQs)
PO_LINES_ALL Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)
PO_LINE_LOCATIONS_ALL Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs)
PO_RELEASES_ALL Purchase order releases
PO_LINES_ARCHIVE_ALL Archived purchase order lines
PO_LINE_LOCATIONS_ARCHIVE_ALL Archived purchase order shipments
PO_HEADERS_ARCHIVE_ALL Archived purchase orders
PO_LINE_TYPES_B Line types
PO_RELEASES_ARCHIVE_ALL Archived releases
PO_REQUISITION_HEADERS_ALL Requisition headers
PO_REQUISITION_LINES_ALL Requisition lines
PO_REQ_DISTRIBUTIONS_ALL Requisition distributions
RCV_TRANSACTIONS Receiving transactions
RCV_SHIPMENT_HEADERS Shipment and receipt header information
RCV_SHIPMENT_LINES Receiving shipment line information


 PO_ RFQ_VENDORS             (it holds list of suppliers to whom RFQ is sent relation po_headers_all -->header_id)   
 PO_QUOTATION_APPROVALS_ALL (list of approved quotations  relation po_line_locations_all --> line_location_id) 

               
                        Interface Tables

• PO_REQUISTIONS_INTERFACE_ALL
• PO_HEADERS_INTERFACE (Purchasing documents open interface)
• PO_LINES_INTERFACE (Purchasing documents open interface)
• PO_DISTRIBUTIONS_INTERFACE (Purchasing documents open interface)
• RCV_HEADERS_INTERFACE (Receipts Interface)
• RCV_TRASACTION_INTERFACE (Receipts Interface)
• RCV_LOTS_INTERFACE (Receipts Interface)
• RCV_SERIALS_INTERFACE (Receipts Interface)
• PO_INTERFACE_ERRORS

INV – Inventory
Table Name Description
MTL_CATEGORIES_B Code combinations table for Item Category
MTL_CATEGORY_SETS_B Category Sets
MTL_CUSTOMER_ITEMS Customer item Information
MTL_CUSTOMER_ITEM_XREFS Relationships between customer items and inventory items
MTL_DEMAND Sales order demand and reservations
MTL_DEMAND_HISTORIES Sales order demand and reservations
MTL_ITEM_LOCATIONS Definitions for stock locators
MTL_ITEM_REVISIONS_B Item revisions
MTL_ITEM_TEMPLATES_B Item template definitions
MTL_ITEM_TEMPL_ATTRIBUTES Item attributes and attribute values for a template
MTL_LOT_NUMBERS Lot number definitions
MTL_MATERIAL_TRANSACTIONS Material transaction table
MTL_MATERIAL_TRANSACTIONS_TEMP Temporary table for processing material transactions
MTL_ONHAND_QUANTITIES_DETAIL FIFO quantities by control level and receipt
MTL_PARAMETERS Inventory control options and defaults
MTL_RESERVATIONS Reservations
MTL_SECONDARY_INVENTORIES Subinventory definitions
MTL_SECONDARY_LOCATORS Item-subinventory-locator assignments
MTL_SERIAL_NUMBERS Serial number definitions
MTL_SYSTEM_ITEMS_B Inventory item definitions
MTL_TRANSACTION_ACCOUNTS Material transaction distributions
MTL_TRANSACTION_TYPES Inventory Transaction Types Table
MTL_TXN_REQUEST_HEADERS Move Order headers table
MTL_TXN_REQUEST_LINES Move order lines table
MTL_UNIT_TRANSACTIONS Serial number transactions
 

MTL_ITEM_SUB_INVENTORIES
MFG_LOOKUPS

                      Interface Tables

• MTL_TRANSACTIONS_INTERFACE (Inventory/Transactoin)
• MTL_TRANSACTION_LOTS_INTERFACE
• MTL_SERIAL_NUMBERS_INTERFACE
• MTL_SYSTEMS_ITEM_ITERFACE (Items)
• MTL_ITEM_CATEGORIES_INTERFACE (Item categories)
• MTL_INTERFACE_ERRORS

               

GL- General Ledger
Table Name Description
GL_CODE_COMBINATIONS Stores valid account combinations
GL_SETS_OF_BOOKS Stores information about the sets of books
GL_IMPORT_REFERENCES Stores individual transactions from subledgers
GL_DAILY_RATES Stores the daily conversion rates for foreign currency
GL_DAILY_CONVERSION_TYPES 

                      Interface Tables

• GL_INTERFACE
• GL_DAILY_RATES_INTERFACE

Transactions
GL_PERIODS Stores information about the accounting periods
GL_JE_HEADERS Stores journal entries
GL_JE_LINES Stores the journal entry lines that you enter in the Enter Journals form
GL_JE_BATCHES Stores journal entry batches
GL_BALANCES Stores actual, budget, and encumbrance balances for detail and summary accounts
GL_BUDGETS Stores Budget definitions
GL_INTERFACE Import journal entry batches
GL_BUDGET_INTERFACE Upload budget data from external sources
GL_DAILY_RATES_INTERFACE Import daily conversion rates

      GL_LEDGERS
       gl_lookups

AR- Accounts Receivables
Table Name Description
RA_CUST_TRX_TYPES_ALL Transaction type for invoices, commitments and credit memos
RA_CUSTOMER_TRX_ALL Header-level information about invoices, debit memos, chargebacks, commitments and credit memos
RA_CUSTOMER_TRX_LINES_ALL Invoice, debit memo, chargeback, credit memo and commitment lines
RA_CUST_TRX_LINE_GL_DIST_ALL Accounting records for revenue, unearned revenue and unbilled receivables
RA_CUST_TRX_LINE_SALESREPS_ALL Sales credit assignments for transactions
AR_ADJUSTMENTS_ALL Pending and approved invoice adjustments
RA_BATCHES_ALL
AR_CASH_RECEIPTS_ALL Detailed receipt information
AR_CASH_RECEIPT_HISTORY_ALL History of actions and status changes in the life cycle of a receipt
AR_PAYMENT_SCHEDULES_ALL All transactions except adjustments and miscellaneous cash receipts
AR_RECEIVABLE_APPLICATIONS_ALL Accounting information for cash and credit memo applications
AR_TRANSACTION_HISTORY_ALL Life cycle of a transaction
HZ_CUST_ACCOUNTS Stores information about customer accounts.
HZ_CUSTOMER_PROFILES Credit information for customer accounts and customer account sites
HZ_CUST_ACCT_SITES_ALL Stores all customer account sites across all operating units
HZ_CUST_ACCT_RELATE_ALL Relationships between customer accounts
HZ_CUST_CONTACT_POINTS This table is no longer used
HZ_CUST_PROF_CLASS_AMTS Customer profile class amount limits for each currency
HZ_CUST_SITE_USES_ALL Stores business purposes assigned to customer account sites.
HZ_LOCATIONS Physical addresses
HZ_ORG_CONTACTS People as contacts for parties
HZ_ORG_CONTACT_ROLES Roles played by organization contacts
HZ_PARTIES Information about parties such as organizations, people, and groups
HZ_PARTY_SITES Links party to physical locations
HZ_PARTY_SITE_USES The way that a party uses a particular site or address
HZ_RELATIONSHIPS Relationships between entities
HZ_RELATIONSHIP_TYPES Relationship types




               Interface Tables

• RA_CUSTOMERS_INTERFACE(Customer interface)
• RA_CUSTOMER_PROFILES_INTERFACE (Customer Interface)
• RA_INTERFACE_LINES_ALL (Invoice interface)
• RA_INTERFACE_DISTRIBUTIONS_ALL (Invoice inteface)
• RA_INTERFACE_SALESCREDITS_ALL (Invoice interface)
• AR_PAYMENTS_INTERFACE_ALL (Receipts Interface)
• RA_INTERFACE_ERRORS_ALL

CE- Cash Management
Table Name Description
CE_BANK_ACCOUNTS This table contains bank account information. Each bank account must be affiliated with one bank branch.
CE_BANK_ACCT_BALANCES This table stores the internal bank account balances
CE_BANK_ACCT_USES_ALL This table stores information about your bank account uses.
CE_STATEMENT_HEADERS Bank statements
CE_STATEMENT_LINES Bank statement lines
CE_STATEMENT_HEADERS_INT Open interface for bank statements
CE_STATEMENT_LINES_INTERFACE Open interface for bank statement lines
CE_TRANSACTION_CODES Bank transaction codes
AP- Accounts Payables
Table Name Description
AP_ACCOUNTING_EVENTS_ALL Accounting events table
AP_AE_HEADERS_ALL Accounting entry headers table
AP_AE_LINES_ALL Accounting entry lines table
AP_BANK_ACCOUNTS_ALL Bank Account Details
AP_BANK_ACCOUNT_USES_ALL Bank Account Uses Information
AP_BANK_BRANCHES Bank Branches
AP_BATCHES_ALL Summary invoice batch information
AP_CHECKS_ALL Supplier payment data
AP_HOLDS_ALL Invoice hold information
AP_INVOICES_ALL Detailed invoice records
AP_INVOICE_LINES_ALL AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface.
AP_INVOICE_DISTRIBUTIONS_ALL Invoice distribution line information
AP.AP_INVOICE_PAYMENTS_ALL Invoice payment records
AP_PAYMENT_DISTRIBUTIONS_ALL Payment distribution information
AP_PAYMENT_HISTORY_ALL Maturity and reconciliation history for

Payments
AP_PAYMENT_SCHEDULES_ALL Scheduled payment information on invoices
AP_INTERFACE_REJECTIONS Information about data that could not be loaded by Payables Open Interface Import
AP_INVOICES_INTERFACE Information used to create an invoice using Payables Open Interface Import
AP_INVOICE_LINES_INTERFACE Information used to create one or more invoice distributions
AP_SUPPLIERS AP_SUPPLIERS stores information about your supplier level attributes.
AP_SUPPLIER_SITES_ALL AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes.
AP_SUPPLIER_CONTACTS Stores Supplier Contacts

FA – Fixed Assets
Table Name Description
FA_ADDITIONS_B Descriptive information about assets
FA_ADJUSTMENTS Information used by the posting program to generate journal entry lines in the general ledger
FA_ASSET_HISTORY Historical information about asset reclassifications and unit adjustments
FA_ASSET_INVOICES Accounts payable and purchasing information for each asset
FA_BOOKS Financial information of each asset
FA_BOOK_CONTROLS Control information that affects all assets in a depreciation book
FA_CALENDAR_PERIODS Detailed calendar information
FA_CALENDAR_TYPES General calendar information
FA_CATEGORIES_B Default financial information for asset categories
FA_CATEGORY_BOOKS Default financial information for an asset category and depreciation book combination
FA_DEPRN_DETAIL Depreciation amounts charged to the depreciation expense account in each distribution line
FA_DEPRN_PERIODS Information about each depreciation period
FA_DEPRN_EVENTS Information about depreciation accounting events.
FA_DEPRN_SUMMARY Depreciation information at the asset level
FA_DISTRIBUTION_ACCOUNTS Table to store account ccids for all distributions for a book
FA_DISTRIBUTION_DEFAULTS Distribution set information
FA_DISTRIBUTION_HISTORY Employee, location, and Accounting Flexfield values assigned to each asset
FA_DISTRIBUTION_SETS Header information for distribution sets
FA_FORMULAS Depreciation rates for formula-based methods
FA_LOCATIONS Location flexfield segment value combinations
FA_MASS_ADDITIONS Information about assets that you want to automatically add to Oracle Assets from another system
FA_METHODS Depreciation method information
FA_RETIREMENTS Information about asset retirements and reinstatements

HRMS- Human Resource Management System
Table Name Description
HR_ALL_ORGANIZATION_UNITS Organization unit definitions.
HR_ALL_POSITIONS_F Position definition information.
HR_LOCATIONS_ALL Work location definitions.
PER_ADDRESSES Address information for people
PER_ALL_PEOPLE_F DateTracked table holding personal information for employees, applicants and other people.
PER_ALL_ASSIGNMENTS_F Allocated Tasks
PER_ANALYSIS_CRITERIA Flexfield combination table for the personal analysis key flexfield.
PER_ASSIGNMENT_EXTRA_INFO Extra information for an assignment.
PER_ASSIGNMENT_STATUS_TYPES Predefined and user defined assignment status types.
PER_CONTRACTS_F The details of a persons contract of employment
PER_CONTACT_RELATIONSHIPS Contacts and relationship details for dependents, beneficiaries, emergency contacts, parents etc.
PER_GRADES Grade definitions for a business group.
PER_JOBS Jobs defined for a Business Group
PER_PAY_BASES Definitions of specific salary bases
PER_PAY_PROPOSALS Salary proposals and performance review information for employee assignments
PER_PEOPLE_EXTRA_INFO Extra information for a person
PER_PERIODS_OF_PLACEMENT Periods of placement details for a non-payrolled worker
PER_PERIODS_OF_SERVICE Period of service details for an employee.
PER_PERSON_ANALYSES Special information types for a person
PER_PERSON_TYPES Person types visible to specific Business Groups.
PER_PERSON_TYPE_USAGES_F Identifies the types a person may be.
PER_PHONES PER_PHONES holds phone numbers for current and ex-employees, current and ex-applicants and employee contacts.
PER_SECURITY_PROFILES Security profile definitions to restrict user access to specific HRMS records

PAY- Payroll
Table Name Description
PAY_ACTION_INFORMATION Archived data stored by legislation
PAY_ALL_PAYROLLS_F Payroll group definitions.
PAY_ASSIGNMENT_ACTIONS Action or process results, showing which assignments have been processed by a specific payroll action, or process.
PAY_ELEMENT_CLASSIFICATIONS Element classifications for legislation and information needs.
PAY_ELEMENT_ENTRIES_F Element entry list for each assignment.
PAY_ELEMENT_ENTRY_VALUES_F Actual input values for specific element entries.
PAY_ELEMENT_LINKS_F Eligibility rules for an element type.
PAY_ELEMENT_TYPES_F Element definitions.
PAY_ELEMENT_TYPE_USAGES_F Used to store elements included or excluded from a defined run type.
PAY_ORG_PAYMENT_METHODS_F Payment methods used by a Business Group.
PAY_PAYMENT_TYPES Types of payment that can be processed by the system.
PAY_PAYROLL_ACTIONS Holds information about a payroll process.
PAY_PEOPLE_GROUPS People group flexfield information.
PAY_PERSONAL_PAYMENT_METHODS_F Personal payment method details for an employee.
PAY_RUN_RESULTS Result of processing a single element entry.
PAY_RUN_RESULT_VALUES Result values from processing a single element entry.
PAY_SECURITY_PAYROLLS List of payrolls and security profile access rules.
PAY_INPUT_VALUES_F Input value definitions for specific elements.

BOM – Bills Of Material
Table Name Description
BOM_DEPARTMENTS Departments
BOM_DEPARTMENT_CLASSES Department classes
BOM_DEPARTMENT_RESOURCES Resources associated with departments
BOM_OPERATIONAL_ROUTINGS Routings
BOM_OPERATION_NETWORKS Routing operation networks
BOM_OPERATION_RESOURCES Resources on operations
BOM_OPERATION_SEQUENCES Routing operations
BOM_OPERATION_SKILLS
BOM_RESOURCES Resources, overheads, material cost codes, and material overheads
BOM_STANDARD_OPERATIONS Standard operations
BOM_ALTERNATE_DESIGNATORS Alternate designators
BOM_COMPONENTS_B Bill of material components
BOM_STRUCTURES_B Bills of material
BOM_STRUCTURE_TYPES_B Structure Type master table

WIP – Work in Process
Table Name Description
WIP_DISCRETE_JOBS Discrete jobs
WIP_ENTITIES Information common to jobs and schedules
WIP_LINES Production lines
WIP_MOVE_TRANSACTIONS Shop floor move transactions
WIP_MOVE_TXN_ALLOCATIONS Move transaction allocations for repetitive schedules
WIP_OPERATIONS Operations necessary for jobs and schedules
WIP_OPERATION_NETWORKS Operation dependency
WIP_OPERATION_OVERHEADS Overheads for operations in an average costing organization
WIP_OPERATION_RESOURCES Resources necessary for operations
WIP_OPERATION_YIELDS This table keeps all costing information for operation yield costing.
WIP_TRANSACTIONS WIP resource transactions
WIP_TRANSACTION_ACCOUNTS Debits and credits due to resource transactions

FND – Appication Object Library
Table Name Description
FND_APPLICATION Applications registered with Oracle Application Object Library
FND_CONCURRENT_PROGRAMS Concurrent programs
FND_CONCURRENT_REQUESTS Concurrent requests information
FND_CURRENCIES Currencies enabled for use at your site
FND_DATA_GROUPS Data groups registered with Oracle Application Object Library
FND_FLEX_VALUES Valid values for flexfield segments
FND_FLEX_VALUE_HIERARCHIES Child value ranges for key flexfield segment values
FND_FLEX_VALUE_SETS Value sets used by both key and descriptive flexfields
FND_FORM Application forms registered with Oracle Application Object Library
FND_FORM_FUNCTIONS Functionality groupings
FND_ID_FLEXS Registration information about key flexfields
FND_ID_FLEX_SEGMENTS Key flexfield segments setup information and correspondences between table columns and key flexfield segments
FND_ID_FLEX_STRUCTURES Key flexfield structure information
FND_LOOKUP_TYPES Oracle Application Object Library QuickCodes
FND_LOOKUP_VALUES QuickCode values
FND_MENUS New menu tabl for Release 10SC
FND_PROFILE_OPTIONS User profile options
FND_PROFILE_OPTION_VALUES Values of user profile options defined at different profile levels
FND_REQUEST_SETS Reports sets
FND_REQUEST_SET_PROGRAMS Reports within report sets
FND_REQUEST_SET_STAGES Stores request set stages
FND_RESPONSIBILITY Responsibilities
FND_RESP_FUNCTIONS Function Security
FND_USER Application users

JA - Asia/Pacific Localizations
Table Name Description
JAI_CMN_BOE_HDRS Stores BOE header info when a BOE Invoice is created through IL
JAI_CMN_BOE_DTLS Detail table for BOE Invoices
JAI_CMN_TAXES_ALL Master table for Localization Taxes
JAI_CMN_TAX_CTGS_ALL Stores tax categories and their link to excise ITEM classes.
JAI_CMN_TAX_CTG_LINES Stores the tax lines for defined tax categories
JAI_CMN_VENDOR_SITES Stores excise account related information about vendors.
JAI_RGM_DEFINITIONS Stores regime information.
JAI_RGM_TAXES This table stores tax details for transactions having TCS tax type.
JAI_CMN_RG_23AC_I_TRXS Stores Information of RG23A/C records and known as Quantity Register.
JAI_CMN_RG_23AC_II_TRXS Stores Information of RG23A/C Part II Details. Also known as Amount Register
JAI_CMN_RG_23D_TRXS Quantity register for Trading Organizations
JAI_CMN_RG_BALANCES Store the current balances of RG23A, RG23C and PLA Registers
JAI_CMN_RG_PLA_TRXS Stores the Transaction Information of PLA Register.
JAI_CMN_RG_PLA_HDRS Stores PLA header Infomation when a PLA invoice is created in AP module
JAI_CMN_RG_PLA_DTLS Stores PLA Detail Information when a PLA Invoice is created in AP Module

QP – Advanced Pricing
Table Name Description
QP_LIST_HEADERS_B QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions.
QP_LIST_LINES QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B.
QP_PRICE_FORMULAS_B QP_PRICE_FORMULAS_B stores the pricing formula header information.
QP_PRICE_FORMULA_LINES QP_PRICE_FORMULA_LINES stores each component that makes up the formula.
QP_PRICING_ATTRIBUTES QP_PRICING_ATTRIBUTES stores product information and pricing attributes.
QP_QUALIFIERS QP_QUALIFIERS stores qualifier attribute information.

XLA - Subledger Accounting
Table Name Description
XLA_EVENTS The XLA_EVENTS table record all information related to a specific event. This table is created as a type XLA_ARRAY_EVENT_TYPE.
XLA_TRANSACTION_ENTITIES The table XLA_ENTITIES contains information about sub-ledger document or transactions.
XLA_AE_HEADERS The XLA_AE_HEADERS table stores subledger journal entries. There is a one-to-many relationship between accounting events and journal entry headers.
XLA_AE_LINES The XLA_AE_LINES table stores the subledger journal entry lines. There is a one-to-many relationship between subledger journal entry headers and subledger journal entry lines.
XLA_DISTRIBUTION_LINKS The XLA_DISTRIBUTION_LINKS table stores the link between transactions and subledger journal entry lines.
XLA_ACCOUNTING_ERRORS The XLA_ACCOUNTING_ERRORS table stores the errors encountered during execution of the Accounting Program.
XLA_ACCTG_METHODS_B The XLA_ACCTG_METHODS_B table stores Subledger Accounting Methods (SLAM) across products. SLAMs provided by development are not chart of accounts specific. Enabled SLAMs are assigned to ledgers.
XLA_EVENT_TYPES_B The XLA_EVENT_TYPES_B table stores all event types that belong to an event class.
XLA_GL_LEDGERS This table contains ledger information used by subledger accounting.


xle_entity_profiles
xle_registrations

Register Custom New Form In Oracle EBS

     1.  Prepare your own custom form. Make sure no bugs and error.

      

   












2. Put your custom form (e.g. XXX_NEW_FORM.fmb) in oracle ebs server using ftp tools. Upload this file to $AU_TOP/12.0.0/forms/US/

      

  3. Compile your fmb file using this script:

frmcmp_batch module=XXX_NEW_FORM.fmb userid=apps/apps output_file=$<custom_directory>_TOP/forms/US/XXX_NEW_FORM.fmx module_type=FORM compile_all=YES

4.  Register your custom form (file fmx) in oracle ebs

Navigation : Application Developer  -> Application  ->  Form

For example, please see image below.

5. Register your form to form function.

Navigation : Application Developer  ->  Application  ->  Function.

For example, please see image below.

   

   












      
6. Register your form function to oracle application menu.  In this case, I put this custom form in responsibility “Receivables Manager”

Navigation : Application Developer  ->  Application  ->  Menu.

7.     Please go to form responsibility (Receivables Manager) to run your custom form.