Concurrent Program

A program that implements a business functionality and needs to be executed again and again at regular interval or as per business needs is called concurrent program. They can be implement in PL/SQL, Shell Script, C/C++ etc..

Concurrent Manager

Now when a concurrent program is written, it needs to be executed daily at particular time. If we do it manual, there might be chances of delays or it might happen that two different people run the same program at the same time which might lead problems. So we need a manager which can do all this tasks for us. The responsibility for execution of concurrent programs is given to Concurrent Manager, which ensures that each concurrent program can run successfully without any conflicts. They also ensures that the applications are not overwhelmed with requests. They also manages the batch processing and report generation.

The default installation of Oracle Applications comes with a number of pre defined concurrent managers however you can create your custom concurrent managers to spread out the load of your job processing. Apart from taking care of the load of your jobs the concurrent managers can also schedule the jobs periodically. Also we can assign specific priority and specific times to the different programs, so that the concurrent managers can run them in specific workshifts.

Concurrent managers also allows you to tweak the number of concurrent process that it can handle concurrently. If any request exceed this prescribed limit they are automatically put on pending state. The processing of a request takes place based on the time of request submission and priority of the request submitted.

There are many pre-configured Concurrent Managers, each governing flow within each Oracle Apps areas. In addition there are "super" Concurrent Managers whose job is to govern the behavior of the slave Concurrent Managers. The Oracle e-Business suite has three important master Concurrent Managers:

• Internal Concurrent Manager — The master manager is called the Internal Concurrent Manager (ICM) because it controls the behavior of all of the other managers, and because the ICM is the boss, it must be running before any other managers can be activated. The main functions of the ICM are to start up and shutdown the individual concurrent managers, and reset the other managers after one them has a failure.
  
• Standard Manager — Another important master Concurrent Manager is called the Standard Manager (SM). The SM functions to run any reports and batch jobs that have not been defined to run in any specific product manager. Examples of specific concurrent managers include the Inventory Manager, CRP Inquiry Manager, and the Receivables Tax Manager.
  
• Conflict Resolution Manager — The Conflict Resolution Manager (CRM) functions to check concurrent program definitions for incompatibility rules. However, the ICM can be configured to take over the CRM's job to resolve incompatibilities.
  

Apart from these three concurrent manages there is another type of concurrent manager known as the Transaction Manager also exists. The transaction manager is responsible for taking the load off the concurrent request table for pooling the request submitted by the user.The transaction manager takes care of these requests and sends it to standard manager directly.In a RAC environment the Transaction manager is required to be activated on each node of the RAC environment.

From the front end you could view the status of your concurrent manager by logging with the System Administration responsibility and going to the Concurrent Manager administer screen.

The status of concurrent managers and the nodes on which they are configured can also be known from the Oracle Applications manager.

Concurrent Manager Processes

The concurrent managers are like other process which run on the oracle applications executable FNDLIBR. The FNDLIBR executable is located at $FND_TOP/bin.

You could also grep the FNDLIBR executable to check if any concurrent manager process are running
$ ps -ef|grep FNDLIBR

The $FND_TOP/sql/afcmstat.sql script gives you a list of concurrent managers and their respective status.
Below is the list of Most of the Concurrent manager processes.

FNDLIBR
manages following Managers

• Marketing Data Mining Manager
  
• Transportation Manager
  
• Session History Cleanup
  
• UWQ Worklist Items Release for Crashed session
  
• Collections Manager
  
• OAM Metrics Collection Manager
  
• Contracts Core Concurrent Manager
  
• Standard Manager
  
• WMS Task Archiving Manager
  
• Oracle Provisioning Manager
  

INVLIBR
manages following Managers

• Inventory Manager
  

MRCLIB
manages following Managers

• MRP Manager
  

PALIBR manages following Managers

• PA Streamline Manager
  

FNDSM
The Generic Service Management Framework Process

• FNDSM is executable and core component in GSM ( Generic Service Management Framework discussed above). You start FNDSM services via application listener on all Nodes in Application Tier in E-Business Suite.
  

Concurrent Manager Scripts

Oracle supplies several useful scripts, (located in $FND_TOP/sql directory), for monitoring the concurrent managers:

afcmstat.sql	Displays all the defined managers, their maximum capacity, pids, and their status.
afimchk.sql	Displays the status of ICM and PMON method in effect, the ICM's log file, and determines if the concurrent manger monitor is running.
afcmcreq.sql	Displays the concurrent manager and the name of its log file that processed a request.
afrqwait.sql	Displays the requests that are pending, held, and scheduled.
afrqstat.sql	Displays of summary of concurrent request execution time and status since a particular date.
afqpmrid.sql	Displays the operating system process id of the FNDLIBR process based on a concurrent request id. The process id can then be used with the ORADEBUG utility.
afimlock.sql	Displays the process id, terminal, and process id that may be causing locks that the ICM and CRM are waiting to get. You should run this script if there are long delays when submitting jobs, or if you suspect the ICM is in a gridlock with another oracle process.

Adjust the payment terms to run from the date that a service was provided

The 'Payment Terms' field is linked to the Transaction 'Date' field. This field can be backdated to the date that the service was provided; the standard 30 days payment terms will start from that date and the due date will be adjusted accordingly.

Check when payment is due for an invoice

To see a summary of a Transaction (invoice), enter the AR responsibility and select Collections, followed by Transaction Overview. Enter the invoice number if known, or use one of the range of other search fields, then click on 'Find'. Due date is one of the fields displayed.

Obtain a copy of an invoice I've raised

Enter the AR responsibility; under Transactions, Transactions. From the Transactions screen, select the 'View' menu, then 'Requests'. From the 'Find Requests' screen, click on 'Submit a New Request'. Make sure 'Single Request' is selected and click on 'OK'. In the 'Name' box enter 'DCC Emailed Transaction (Copy)'. Enter the Invoice number you wish to view; the email address field is pre-populated with your email address although the address can be changed if necessary. Submit the request. The copy purchase order will then be issued.

Please note that although the invoice will be marked 'Copy', it will not be printed on controlled stationery and as such should not be used to re-issue an invoice to a customer. If a customer contacts you having misplaced an invoice please ask Oracle Admin to reissue the invoice to the customer on your behalf.

View a list of invoices raised to customers which are currently outstanding

Follow the steps above and select 'Single Request'. In the 'Name' box, enter 'Aging – 7 Buckets – By Salesperson'. A list of Parameters will appear. For 'Report Summary', select 'Invoice Summary'. For 'Report Format', select 'Detailed'. For 'Aging Bucket Name', select 'Collections'. Under 'Salesperson', select the name of your school. Submit the request. The subsequent report gives an aged debtor report for each of your invoices.

Cancel an invoice that I've raised

On occasion you may raise an invoice in error; perhaps the invoice was issued to the wrong customer, or sent to the wrong address. The problem can easily be rectified in Oracle by issuing a credit note to the customer.

To raise a credit for the entire value of the invoice, first select 'Transactions', then 'Credit Transactions' from the Accounts Receivable responsibility in Oracle. Enter the invoice number you wish to credit in the 'Number' field and click on 'Find.

If the number entered is valid a window labelled 'Credit Transactions' will open; enter a reason for the credit, and a contact name and telephone number to appear on the credit note. Click on the button marked 'Credit Balance'; Oracle will automatically credit the outstanding balance on the invoice. Click on 'Complete and make a note of the credit memo 'Number; a credit note will be sent to the customer.

Change the value of an invoice that I've raised

Although you can't amend an invoice once it has been issued, you can either raise a credit, or an additional charge, to the customer.

If you've overcharged a customer on an invoice, you are able to issue a credit note against part of the value of that invoice. Follow the steps above to locate the invoice you wish to credit and add a reason and contact details to the credit note.

Click on 'Credit Lines'; enter the amount you wish to credit as a minus figure against the line or lines that the credit relates to. Close the 'Lines' window and click on 'Complete'. Make a note of the credit memo 'Number' for future reference.

If you have undercharged the customer on the original invoice you will need to raise a new invoice to charge the customer for the balance.

In General Ledger 11i your functional currency referred to the currency of your set of books, it was one of your three Cs (Calendar, Currency and Chart of Accounts). In R12 we changed the terminology, there is no more set of books that is now renamed Ledger and the Currency of your Ledger is referred to as the Accounting Currency of the Ledger.

This is a subtle change and I'm sure experienced 11i practitioners are still using the term functional currency but you all need to stop because it's confusing people.

In Financial standards (IAS 21 and FAS 52), Functional Currency is a test for the integration of your overseas and home businesses. If the businesses share a Functional currency, they are integrated, and you must use a financial statement conversion method called "remeasurement". If the businesses do not share a Functional Currency, they are stand alone, and you must use a financial statement conversion method called "translation". To determine the Functional currency, there are a series of cash flow related tests: it is an objective, situational determination, and not an optional choice.

Now just because your auditors tell you that your functional currency is Euro, this does not mean that you need to go about the tricky business of changing your Ledger Accounting Currency (or Set of Books functional currency) to Euro. What it means is that you need to remeasure in Euro rather than translate.

To do this re-measurement you can use

    ž The GL translation program
    ž A secondary Ledger
    ž A consolidation program such as Hyperion

It is not standard to have your Ledger Accounting currency different to you local currency, you will need to file local statutory reports in local currency, your bank will likely send you statements in local currency etc. so you really need your ledger operating in local currency to handle these easily.

So remember my Ledger Accounting Currency does not have to equal my functional currency.

Table Name	Description
PAY_ACCRUAL_BANDS	Length of service bands used in calculating accrual of paid time off.
PAY_ACCRUAL_PLANS	PTO accrual plan definitions, (Paid time off).
PAY_ACTION_CLASSIFICATIONS	Payroll Action Type classifications.
PAY_ACTION_CONTEXTS	Assignment Action Contexts.
PAY_ACTION_INFORMATION	Archived data stored by legislation
PAY_ACTION_INTERLOCKS	Assignment action interlock definitions to control rollback processing.
PAY_ACTION_PARAMETERS	Global parameters to control process execution.
PAY_ACTION_PARAMETER_GROUPS	Groups of Pay Action Parameters
PAY_ACTION_PARAMETER_VALUES	Values for the specified action parameters
PAY_AC_VENDOR_MAPPINGS	North American Table to control the mapping of internal Values to External Vendor Values
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_ASSIGNMENT_LATEST_BALANCES	Denormalised assignment level latest balances.
PAY_ASSIGNMENT_LINK_USAGES_F	Intersection between PAY_ELEMENT_LINKS_F and PER_ALL_ASSIGNMENTS_F.
PAY_AU_MODULES	Defines the processes that can be executed by the generic code caller.
PAY_AU_MODULE_PARAMETERS	Defines the parameters associated with the module used in the generic code
PAY_AU_MODULE_TYPES	Defines the module types used in the generic code caller
PAY_AU_PROCESSES	This table defines the processes that can be executed by the generic code caller.
PAY_AU_PROCESS_MODULES	Defines the intersection between processes and modules used by the generic code caller.
PAY_AU_PROCESS_PARAMETERS	Defines the parameters for a process.
PAY_BACKPAY_RULES	Balances to be recalculated by a RetroPay process.
PAY_BACKPAY_SETS	Identifies backpay, or RetroPay sets.
PAY_BALANCE_ATTRIBUTES	Holds mappings between attributes and defined balances.
PAY_BALANCE_BATCH_HEADERS	Batch header information for balance upload batch.
PAY_BALANCE_BATCH_LINES	Individual batch lines for the balance upload process.
PAY_BALANCE_CATEGORIES_F	Holds seeded categories for balances.
PAY_BALANCE_CLASSIFICATIONS	Information on which element classifications feed a balance.
PAY_BALANCE_CONTEXT_VALUES	Localization balance contexts.
PAY_BALANCE_DIMENSIONS	Information allowing the summation of a balance.
PAY_BALANCE_FEEDS_F	Controls which input values can feed a balance type.
PAY_BALANCE_SETS	Allows related balances to be grouped for reporting purposes.
PAY_BALANCE_SET_MEMBERS	Individual members of the balance set
PAY_BALANCE_TYPES	Balance information.
PAY_BALANCE_TYPES_EFC	This is a copy of the PAY_BALANCE_TYPES table which is populated by the EFC (Euro as a Functional Currency) process.
PAY_BALANCE_TYPES_TL	Translated balance type definitions
PAY_BALANCE_VALIDATION	Balance Validity information
PAY_BAL_ATTRIBUTE_DEFAULTS	Balance attribution defaulted according to values in this table.
PAY_BAL_ATTRIBUTE_DEFINITIONS	Balance attributes help to identify which balances should be usedin which reports.
PAY_BANK_BRANCHES	Stores bank branch information to enable entry of bank account details with the correct branch information (e.g. GB bank, sort code, branch).
PAY_BATCH_CONTROL_TOTALS	Holds user defined control totals for the Batch Element Entry process.
PAY_BATCH_HEADERS	Header information for a Batch Element Entry batch.
PAY_BATCH_LINES	Batch lines for a Batch Element Entry batch.
PAY_CALENDARS	Details of user defined budgetary calendars.
PAY_CA_EMP_FED_TAX_INFO_F	Canadian federal tax information
PAY_CA_EMP_PROV_TAX_INFO_F	Canadian provincial tax information
PAY_CA_FILE_CREATION_NUMBERS	Used by Canadian direct deposit
PAY_CA_LEGISLATION_INFO	Canadian legislation specific data
PAY_CA_PMED_ACCOUNTS	Canadian Provincial Medical account information
PAY_CE_RECONCILED_PAYMENTS	Holds reconciliation information for payments processed through Oracle Cash Management.
PAY_COIN_ANAL_ELEMENTS	Monetary unit quantities for automatic make-up of cash payments.
PAY_COMPARISON_ROWS
PAY_CONSOLIDATION_SETS	Consolidation set of results of payroll processing.
PAY_COSTS	Cost details and values for run results.
PAY_COSTS_EFC	This is a copy of the PAY_COSTS table which is populated by the EFC (Euro as a Functional Currency) process.
PAY_COST_ALLOCATIONS_F	Cost allocation details for an assignment.
PAY_COST_ALLOCATION_KEYFLEX	Cost Allocation key flexfield combinations table.
PAY_CUSTOMIZED_RESTRICTIONS	CustomForm restrictions for specific forms.
PAY_CUSTOM_RESTRICTIONS_TL	Translated data for the table PAY_CUSTOMIZED_RESTRICTIONS
PAY_DATED_TABLES	Holds details of datetracked columns
PAY_DATETRACKED_EVENTS	Stores details of events to track on HRMS Datetrack tables
PAY_DEFINED_BALANCES	Intersection between PAY_BALANCE_TYPES and PAY_BALANCE_DIMENSIONS.
PAY_DIMENSION_ROUTES	Stores balance dimension relationships.
PAY_ELEMENT_CLASSIFICATIONS	Element classifications for legislation and information needs.
PAY_ELEMENT_CLASSIFICATIONS_TL	Translated element classification definitions
PAY_ELEMENT_ENTRIES_F	Element entry list for each assignment.
PAY_ELEMENT_ENTRY_VALUES_F	Actual input values for specific element entries.
PAY_ELEMENT_ENTRY_VALUES_F_EFC	This is a copy of the PAY_ELEMENT_ENTRY_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process.
PAY_ELEMENT_LINKS_F	Eligibility rules for an element type.
PAY_ELEMENT_SETS	Element sets.  Used to restrict payroll runs, customize windows, or as a distribution set for costs.
PAY_ELEMENT_SPAN_USAGES
PAY_ELEMENT_TEMPLATES	Element Templates
PAY_ELEMENT_TYPES_F	Element definitions.
PAY_ELEMENT_TYPES_F_EFC	This is a copy of the PAY_ELEMENT_TYPES_F table which is populated by the EFC (Euro as a Functional Currency) process.
PAY_ELEMENT_TYPES_F_TL	Translated element definitions
PAY_ELEMENT_TYPE_EXTRA_INFO	Stores extra information for an element
PAY_ELEMENT_TYPE_INFO_TYPES	Types of extra information that may be held against an element.
PAY_ELEMENT_TYPE_RULES	Include and exclude rules for specific elements in an element set.
PAY_ELEMENT_TYPE_USAGES_F	Used to store elements included or excluded from a defined run type.
PAY_ELE_CLASSIFICATION_RULES	Intersection table for PAY_ELEMENT_SETS and PAY_ELEMENT_CLASSIFICATIONS.
PAY_ELE_PAYROLL_FREQ_RULES	Frequency rules for a deduction/payroll combination.
PAY_ENTRY_PROCESS_DETAILS	Internal processing details for certain element entries
PAY_EVENT_GROUPS	Provides grouping for user control of event monitoring
PAY_EVENT_PROCEDURES	Code to execute if event detected.
PAY_EVENT_QUALIFIERS_F	Event Qualification definitions
PAY_EVENT_UPDATES	Process event update transactions
PAY_EVENT_VALUE_CHANGES_F	Values changes that cause an event
PAY_EXTERNAL_ACCOUNTS	Bank account details that enable payments to be made.
PAY_FILE_DETAILS	Report file details that have been saved in the system
PAY_FORMULA_RESULT_RULES_F	Rules for specific formula results.
PAY_FREQ_RULE_PERIODS	Stores frequency rule for a deduction/payroll combination.
PAY_FR_CONTRIBUTION_USAGES	PAY_FR_CONTRIBUTION_USAGES holds the definition of statutory payroll contributions in the French legislation.
PAY_FUNCTIONAL_AREAS	Holds definitions of functional areas
PAY_FUNCTIONAL_TRIGGERS	Defines the triggers contained in a functional area
PAY_FUNCTIONAL_USAGES	Enables functional areas for specific legislations, business groups and payrolls
PAY_GB_SOY_OUTPUTS	Temporary table for GB Start of Year process outputs.
PAY_GB_TAX_CODE_INTERFACE	Interface table for the UK Start of Year process.
PAY_GB_YEAR_END_ASSIGNMENTS	Extraction table for UK End of Year processing, which holds information about assignments.
PAY_GB_YEAR_END_PAYROLLS	Payroll information for the UK EOY process.
PAY_GB_YEAR_END_VALUES	Extraction table for the UK End of Year process that holds information about the NI balances at the year end.
PAY_GL_INTERFACE	Costed details to be passed to the General Ledger
PAY_GRADE_RULES_F	Stores the values for grade or progression point rates.
PAY_GRADE_RULES_F_EFC	This is a copy of the PAY_GRADE_RULES_F table which is populated by the EFC (Euro as a Functional Currency) process.
PAY_GROSSUP_BAL_EXCLUSIONS	Stores balances which will be excluded for gross up by the net to gross process
PAY_IE_PAYE_DETAILS_F	PAY_IE_PAYE_DETAILS_F holds the PAYE Tax  Details for an assignment. It is a Date Tracked table.
PAY_IE_PRSI_DETAILS_F	PAY_IE_PRSI_DETAILS_F holds the PRSI Details for an assignment. It is a Date Tracked table.
PAY_IE_SOCIAL_BENEFITS_F	PAY_IE_SOCIAL_BENEFITS_F holds the social benefit details for an assignment.This is a date tracked table
PAY_IE_TAX_BODY_INTERFACE	PAY_IE_TAX_BODY_INTERFACE,Interface table used for uploading data into PAYE tables from a flat file.
PAY_IE_TAX_ERROR	PAY_IE_TAX_ERROR,Table used  to populate errors occured during uploading PAYE details.
PAY_IE_TAX_HEADER_INTERFACE	PAY_IE_TAX_HEADER_INTERFACE,Interface table used for uploading data into PAYE tables from a flat file.
PAY_IE_TAX_TRAILER_INTERFACE	PAY_IE_TAX_TRAILER_INTERFACE,Interface table used for uploading data into PAYE tables from a flat file.
PAY_INPUT_VALUES_F	Input value definitions for specific elements.
PAY_INPUT_VALUES_F_EFC	This is a copy of the PAY_INPUT_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process.
PAY_INPUT_VALUES_F_TL	Translated input value definitions
PAY_ITERATIVE_RULES_F	Holds the processing rules of iterative elements.
PAY_JOB_WC_CODE_USAGES	Workers Compensation codes for specific job and state combinations.
PAY_JP_BANKS	This table is used for Japanese bank information.
PAY_JP_BANK_BRANCHES	This table is used for Japanese bank branch information.
PAY_JP_PRE_TAX	This table is a temporary table for Japanese legislative reports.
PAY_JP_SWOT_NUMBERS	Holds Japanese Tax Special Withholding Obligation Taxpayer Numbers.
PAY_LEGISLATION_CONTEXTS	Maps core contexts to legislative names
PAY_LEGISLATION_RULES	Legislation specific rules and structure identifiers.
PAY_LEGISLATIVE_FIELD_INFO	Controls legislative rules on individual form fields
PAY_LINK_INPUT_VALUES_F	Input value overrides for a specific element link.
PAY_LINK_INPUT_VALUES_F_EFC	This is a copy of the PAY_LINK_INPUT_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process.
PAY_MAGNETIC_BLOCKS	Driving table for fixed format version of the magnetic tape process.
PAY_MAGNETIC_RECORDS	Controls the detailed formatting of the fixed format version of the magnetic tape process.
PAY_MESSAGE_LINES	Error messages from running a process.
PAY_MONETARY_UNITS	Valid denominations for currencies.
PAY_MONETARY_UNITS_TL	Translated data for the table PAY_MONETARY_UNITS_TL
PAY_MONITOR_BALANCE_RETRIEVALS	Monitors the source of balance retrievals
PAY_MX_EARN_EXEMPTION_RULES_F	Used to hold the Earnings exemption rules for Mexico
PAY_MX_LEGISLATION_INFO_F	Mexican legislation specific data
PAY_NET_CALCULATION_RULES	Element entry values which contribute to the net value of Paid Time Off.
PAY_NL_IZA_UPLD_STATUS	Holds the Status of the Data Records in the Processed IZA File
PAY_ORG_PAYMENT_METHODS_F	Payment methods used by a Business Group.
PAY_ORG_PAYMENT_METHODS_F_EFC	This is a copy of the PAY_ORG_PAYMENT_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process.
PAY_ORG_PAYMENT_METHODS_F_TL	Translated payment method information
PAY_ORG_PAY_METHOD_USAGES_F	Payment methods available to assignments on a specific payroll.
PAY_PATCH_STATUS	Used to track the application of patches.
PAY_PAYMENT_TYPES	Types of payment that can be processed by the system.
PAY_PAYMENT_TYPES_TL	Translated payment type details
PAY_PAYROLL_ACTIONS	Holds information about a payroll process.
PAY_PAYROLL_ACTIONS_EFC	This is a copy of the PAY_PAYROLL_ACTIONS table which is populated by the EFC (Euro as a Functional Currency) process.
PAY_PAYROLL_GL_FLEX_MAPS	Payroll to GL key flexfield segment mappings.
PAY_PAYROLL_LIST	List of payrolls that a secure user can access.
PAY_PEOPLE_GROUPS	People group flexfield information.
PAY_PERSONAL_PAYMENT_METHODS_F	Personal payment method details for an employee.
PAY_PERSONAL_PAYMENT_METHO_EFC	This is a copy of the PAY_PERSONAL_PAYMENT_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process.
PAY_PERSON_LATEST_BALANCES	Latest balance values for a person.
PAY_POPULATION_RANGES	PERSON_ID ranges for parallel processing.
PAY_PRE_PAYMENTS	Pre-Payment details for an assignment, including the currency, the amount and the specific payment method.
PAY_PRE_PAYMENTS_EFC	This is a copy of the PAY_PRE_PAYMENTS table which is populated by the EFC (Euro as a Functional Currency) process.
PAY_PROCESS_EVENTS	Process event capture table.
PAY_PROCESS_GROUPS	Defines groups of processes
PAY_PROCESS_GROUP_ACTIONS	Processes within the Process Group
PAY_PSS_TRANSACTION_STEPS	Table holding (denormalised) work-in-progress for Payroll Payments self-service.
PAY_PURGE_ACTION_TYPES	Details of the processing order required to purge action types.
PAY_PURGE_ROLLUP_BALANCES	Populated during Purge.  Stores details of the balance values being removed.
PAY_QUICKPAY_EXCLUSIONS	List of element entries that are to be excluded from a QuickPay run.
PAY_QUICKPAY_INCLUSIONS	List of element entries that can be included in a QuickPay run.
PAY_RATES	Definitions of pay rates, or pay scales that may be applied to grades.
PAY_RECORDED_REQUESTS	Dated process information.
PAY_REPORT_FORMAT_ITEMS_F	Individual items for the report mapping.
PAY_REPORT_FORMAT_MAPPINGS_F	Maps a report for a given jurisdiction to the fixed format defined for the magnetic tape.
PAY_REPORT_TOTALS
PAY_RESTRICTION_PARAMETERS	Restrictions to the rows retrieved by a customized form.
PAY_RESTRICTION_VALUES	The specific values to be used to customize a form.
PAY_RETRO_ASSIGNMENTS	Identifies assignment for reprocessing
PAY_RETRO_COMPONENTS
PAY_RETRO_COMPONENT_USAGES
PAY_RETRO_DEFINITIONS
PAY_RETRO_DEFN_COMPONENTS
PAY_RETRO_ENTRIES	Identifies the Entries required for re-processing.
PAY_RETRO_NOTIF_REPORTS	Populated and used in the RetroNotification Report
PAY_ROUTE_TO_DESCR_FLEXS	Store of routes to Descriptive Flexfields
PAY_RUN_BALANCES	Store of run level balances.
PAY_RUN_RESULTS	Result of processing a single element entry.
PAY_RUN_RESULT_VALUES	Result values from processing a single element entry.
PAY_RUN_RESULT_VALUES_EFC	This is a copy of the PAY_RUN_RESULT_VALUES table which is populated by the EFC (Euro as a Functional Currency) process.
PAY_RUN_TYPES_F	The different types of Payroll Run processing
PAY_RUN_TYPES_F_TL	Translated run type descriptions
PAY_RUN_TYPE_ORG_METHODS_F	Organisation level payment methods associated with a particular run type.
PAY_RUN_TYPE_ORG_METHODS_F_EFC	This is a copy of the PAY_RUN_TYPE_ORG_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process.
PAY_RUN_TYPE_USAGES_F	Holds child run types where the run type parent is of type Cumulative.
PAY_SECURITY_PAYROLLS	List of payrolls and security profile access rules.
PAY_SHADOW_BALANCE_CLASSI	Element Template Shadow Balance Classifications
PAY_SHADOW_BALANCE_FEEDS	Element Template Shadow Balance Feeds
PAY_SHADOW_BALANCE_TYPES	Element Template Shadow Balance Types
PAY_SHADOW_BAL_ATTRIBUTES
PAY_SHADOW_DEFINED_BALANCES	Element Template Shadow Defined Balances
PAY_SHADOW_ELEMENT_TYPES	Element Template Shadow Element Type
PAY_SHADOW_ELE_TYPE_USAGES	Element Template Shadow Element Type Usages
PAY_SHADOW_FORMULAS	Element Template Shadow Formulas
PAY_SHADOW_FORMULA_RULES	Element Template Shadow Formula Result Rules
PAY_SHADOW_GU_BAL_EXCLUSIONS	Element Template Grossup Balance Exclusions
PAY_SHADOW_INPUT_VALUES	Element Template Shadow Input Values
PAY_SHADOW_ITERATIVE_RULES	Element Template Shadow Iterative Rules
PAY_SHADOW_SUB_CLASSI_RULES	Element Template Shadow Sub-Classification Rules
PAY_STATE_RULES	US state tax information.
PAY_STATUS_PROCESSING_RULES_F	Assignment status rules for processing specific elements.
PAY_STAT_TRANS_AUDIT
PAY_SUB_CLASSIFICATION_RULES_F	Rules to determine the inclusion of an element in a secondary element classification.
PAY_TAXABILITY_RULES	Taxability rules for categories of earnings and deductions.
PAY_TAXABILITY_RULES_DATES	Maintains taxability rules date-effectively, to allow for end-of-year updates.
PAY_TEMPLATE_CORE_OBJECTS	Keeps track of  the core schema objects generated from an element template.
PAY_TEMPLATE_EXCLUSION_RULES	Controls the exclusion of an object from an Element Template
PAY_TEMPLATE_FF_USAGES	Allows multiple formulas to be associated with a shadow object.
PAY_TEMP_BALANCE_ADJUSTMENTS	Holds temporary data used by the balance initialization process.
PAY_TEST_CONTEXTS
PAY_TEST_EXPIRY_INFO
PAY_TEST_FEED_INFO
PAY_TEST_PARAMETERS
PAY_TEST_PARAMETER_USAGES
PAY_TEST_RUNS
PAY_TEST_STAGES
PAY_TEST_STEPS
PAY_TEST_SUITE_USAGES
PAY_TRIGGER_COMPONENTS	Stored procedures that are executed from dynamic triggers
PAY_TRIGGER_DECLARATIONS	Variables declared in dynamic triggers
PAY_TRIGGER_EVENTS	Definitions of triggers that are dynamically generated
PAY_TRIGGER_INITIALISATIONS	How dynamically generated triggers initialise their local variables
PAY_TRIGGER_PARAMETERS	Parameter mappings for dynamically generated procedure and function calls
PAY_TRIGGER_SUPPORT	Allows support package for dynamically generated trigger to be linked to the trigger
PAY_USER_COLUMNS	Column definitions for user defined tables.
PAY_USER_COLUMN_INSTANCES_F	Actual values for each row and column combination in a user defined table.
PAY_USER_ROWS_F	Row definitions for user defined tables.
PAY_USER_TABLES	Table definitions for user defined tables.
PAY_US_ASG_REPORTING	Denormalised performance table for accessing balances.
PAY_US_CITY_GEOCODES	Holds all distinct combinations of state code, county code and city code.
PAY_US_CITY_NAMES	US cities and their VERTEX geocodes, used to validate US addresses.
PAY_US_CITY_SCHOOL_DSTS	VERTEX geocodes for school districts within a city.
PAY_US_CITY_TAX_INFO_F	Holds city tax information.
PAY_US_CONTRIBUTION_HISTORY	Contribution History stores yearly consolidated contribution data for a Person per GRE per contribution type
PAY_US_COUNTIES	US counties and their VERTEX geocodes, used to validate US addresses.
PAY_US_COUNTY_SCHOOL_DSTS	VERTEX geocodes for school districts that span counties.
PAY_US_COUNTY_TAX_INFO_F	Holds county tax information.
PAY_US_EMP_CITY_TAX_RULES_F	City level tax details for employee assignments.
PAY_US_EMP_COUNTY_TAX_RULES_F	County level tax details for employee assignments.
PAY_US_EMP_FED_TAX_RULES_F	Federal level tax details for employee assignments.
PAY_US_EMP_STATE_TAX_RULES_F	State level tax details for employee assignments.
PAY_US_FEDERAL_TAX_INFO_F	Holds federal tax information.
PAY_US_GARN_ARREARS_RULES_F	Used for holding the Garnishment Arrears Rules
PAY_US_GARN_EXEMPTION_RULES_F	Used for holding the Garnishment Exemption Rules
PAY_US_GARN_FEE_RULES_F	Used for holding the Garnishment Fee rules
PAY_US_GARN_LIMIT_RULES_F	Used for holding the Garnishment Limit Rules.
PAY_US_GEO_UPDATE	To keep track of changes made to the user data by the geocode patch.
PAY_US_MODIFIED_GEOCODES	US cities and their VERTEX geocodes, used for showing modified geocodes.
PAY_US_RPT_TOTALS	A temporary table to be used in Payroll and Paper W2 Reports.
PAY_US_SCHOOL_DSTS_TAX_INFO_F	The Federal Liaison Services ( FLS ) agency codes have been mapped to the School District Jurisdiction Information  Codes
PAY_US_STATES	US states and their VERTEX geocodes, used to validate US addresses.
PAY_US_STATE_TAX_INFO_F	Holds the state tax information.
PAY_US_TAX_BALANCES	Tax balances used by US Payroll Tax balance reporting.
PAY_US_TAX_REPORT_BALANCES	Identifies tax balances for US Payroll Tax Summary Listing report.
PAY_US_TAX_REPORT_DIMENSIONS	Balance dimensions used by the US Payroll Tax Summary Listing report.
PAY_US_TAX_TYPES	US Tax Types used by US Payroll Tax Balance reporting.
PAY_US_ZIP_CODES	Valid zip code ranges for VERTEX cities, used to validate US addresses.
PAY_WCI_ACCOUNTS	Workers Compensation Accounts table.
PAY_WCI_OCCUPATIONS	Workers Compensation occupations table.
PAY_WCI_RATES	Workers Compensation rates table. NB. This table is currently used for Canadian workers compensation, but is designed to be used globally.
PAY_WC_FUNDS	Workers Compensation Funds table.
PAY_WC_RATES	Workers Compensation Rates table.
PAY_WC_STATE_SURCHARGES	Workers Compensation Surcharges table.
PAY_ZA_ACB_USER_GEN_NOS	PAY_ZA_ACB_USER_GEN_NOS holds the ACB generation number information needed when submitting magnetic tapes to ACB.
PAY_ZA_BRANCH_CDV_DETAILS	PAY_ZA_BRANCH_CDV_DETAILS stores Bank and Branch information used to verify Bank account numbers.
PAY_ZA_CDV_PARAMETERS	PAY_ZA_CDV_PARAMETERS holds information needed to perform the CDV on bank account numbers.
PAY_ZA_IRP5_BAL_CODES	Table holds codes for IRP5 balances
PAY_ZA_TAXREG_BAL_TEMP	Table holds balance types for specific assignments
PAY_ZA_TAX_REGISTERS	PAY_ZA_TAX_REGISTERS is used for the South African Tax Register Report.
PAY_ZA_TAX_TRACES	PAY_ZA_TAX_TRACES holds tax trace data calculated during the payroll run. Only the most recent run's data will be stored.
PAY_ZA_TEMP_BRANCH_DETAILS	PAY_ZA_TEMP_BRANCH_DETAILS is a temporary table that holds Bank and Branch information used to verify Bank account numbers, used in the population of PAY_ZA_BRANCH_CDV_DETAILS.
PAY_ZA_TYS_PROCESSES	PAY_ZA_TYS_PROCESSES stored information about each Tax Year Start Process that was run to ensure that the process will not be run for the same payroll and tax year, and to ensure that a rollback on the process will not occur if the specific