Blitz Report™ Library
Module GL 143 AP 146 AR 123 FA 138 CE 25 PO 116 INV 130 OM 89 MFG 215 COST 175 PA 131 HR 182 PAY 152 SYS 162
33 reports
| Description | Download | ||
|---|---|---|---|
| CSI Asset Tracking listing of pending transactions with specific transaction ID parameter | When a transaction is successfully interfaced to Oracle Assets, the transaction's status will be updated from 'PENDING' to 'COMPLETE'. The majority reasons are:
1) OAT related set ups are not completed/correct, e.g asset category, asset location, asset name.
2) Previous transaction for the same asset is still in pending, e.g. asset is not created by create asset program so move transaction will not be processed.
3) Asset is updated from Oracle Asset which caused asset status, location out of sync with OAT record.
Erro message - 'Prior transactions are in pending status for this item… full description | Draft |   |
| CSI Asset Tracking pending error transactions for all serial number/instance in your system | When OAT is installed, INV transactions are interfaced to create/update related instances in Installed Base, then the transactions further interfaced to FA to create/update the related fixed assets.
Whether a INV transaction need be interfaced to FA is determined by the installed base transaction_status. If it is at 'PENDING' then it need be processed to FA.
There are two concurrent programs to process 'PENDING' install base transactions to Oracle Assets: 'Create Asset: Interface Inventory Transaction to Oracle Assets' and 'Interface Move Transaction to Oracle Assets' | Draft | |
| FA Asset Category Listing | Fixed Asset categories overview report with asset category, general ledger accounts, depreciation method, expected life and depreciated life. | Assets Draft | |
| FA Asset% | Detail report with retirement ID, asset ID, date retired, cost retired, status, retirement prorate convention, number of units, cost, gain or loss amount, proceeds and retirement type. | Assets Draft | |
| AP Supplier Closing Balance | Payables Draft | | |
| BOM Models | Master data report showing the exploded Bill of Materials | Manufacturing Draft | |
| CST Item Costs | Flexible costing set of reports - analyze item costs for any cost type. Choose from the following options: Activity Summary - Report item costs by activity.
Activity by Department - Report item costs by activity and department.
Activity by Flexfield Segment Value - Report item costs by the descriptive flexfield segment you enter.
Activity by Operation - Report item costs by activity and operation sequence number.
Element - Report item costs by cost element and cost level.
Element by Activity - Report item costs by cost element and activity.
Element by Department - Report item costs by cost… full description | Cost Management Draft | |
| FA Depreciation by period | Detail report with asset ID, depreciation run date, depreciation amount per period and depreciation YTD. | Assets Draft | |
| GMD MUV Detail | Draft | | |
| GMF MUV Detail | Manufacturing Draft | | |
| ONT DIFOT | Sales order header and line details with additional logic to measure the order shipping performance metric: delivered in full and on time (DIFOT). | Order Management Draft | |
| OPM Actual Item Cost Transaction | Manufacturing Draft | | |
| OPM Batch Material Transactions | Manufacturing Draft | | |
| OPM Batch Steps | Listing of batch steps and status | Manufacturing Draft | |
| OPM Batches | Detail report showing the status of the OPM Batches, including basic information
such as plant code, batch number, batch type (0 for normal batches or 10 for firm planned orders), and batch status. Batches have many steps which are found in GME_BATCH_STEPS. It's not in the
example query; but, the operation name can be found in GMD_OPERATIONS_B
which is linked by OPRN_ID.
Steps have many activities which are found in GME_BATCH_STEP_ACTIVITIES.
Activities have many resources which are found in GME_BATCH_STEP_RESOURCESS.
Resources have many process parameters which are found… full description | Manufacturing Draft | |
| OPM Formulas | Summary listing of all active formulas | Manufacturing Draft | |
| OPM Product Qty in batches | Query to Find out Quantity of Products and Ingredients of all Batches in particular Month. | Manufacturing Draft | |
| PA Project Tasks and Budgets | Summary project report showing operating unit, project number, project name, description, type, status, start date, completion date, closed date, task information, budget information. | Projects Draft | |
| PAY Employee Bank Accounts | Payroll Draft | | |
| PAY Employee Salary | Profile report showing the employee demographic information including name, gender SSN, birthdate, age, nationality, effective start date, and additional profile information. | Payroll Draft | |
| PAY SARS Codes | Payroll Draft | | |
| PER Employee Approved Leave History | Human Resources Draft | | |
| PER Employee Details | Detail listing of employee details | Human Resources Draft | |
| PER Organizations & Managers | Organizations, their locations, their managers. | Human Resources Draft | |
| PER Pay Element Details | Master data report showing HR payroll element details.
Elements are the units used to build all the earnings, deductions and benefits that companies can give to employees. | Human Resources Draft | |
| PO Purchase Requisition Interface | Purchase requisitions interface listing with status for support and operational purposes. | Purchasing Draft | |
| PO Receiving Transactions Pipeline | PO Receiving Transactions Pipeline | Purchasing Draft | |
| RK: AP Invoices and Lines | Application: Payables
Source: Invoice Aging Report and Invoice Detail Report
Check for Avalara | Draft | |
| RK: AR Transactions and Lines | Receivables transactions and line details including additional columns specifically for service (OKS) and lease (OKL) contracts.
Note: This report shows completed transactions only as it is based on table ar_payment_schedules_all. | Draft | |
| RK: Avalara Report | In development | Draft | |
| Rakesh Supply Chain - Draft Works | Rakesh : Supply chain Query BOM Indented Cost of Materials | Draft | |
| Testing Zero Cost Items SQL | Draft | | |
| XXEN: FND User Login History with Geolocation | Audit history of application user logins.
EBS user logon audit is controlled by profile 'Sign-On:Audit Level'.
The most detailed audit level setting is 'FORM'.
Unfortunately, this audit tracks access to individual forms only, but not to different JSPs (HTML / OAF / ADF Pages).
As a workaround, the report SQL also joins to icx_sessions, which contains a record for each login (in fact, it also stores a record for each access to the login page before login. These records are marked with guest='Y').
The function retrieved from icx_session however, just shows the latest OAF function accessed by… full description | Draft | |
No reports match. Try fewer words or categories.
Also found in SQL, tables and columns
These reports don't mention the search in their name or description, but their SQL does.
Searching SQL…