For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
This spreadsheet is published by Oracle OTBI Development.
Release: R13.19A, R13.19B, R13.19C, R13.19D
Information Covered:
- Documents Fusion SCM and Procurement OTBI subject areas, the corresponding View Objects and database tables and columns.
Customers can use this spreadsheet to search for reporting fields in OTBI subject areas or trace the lineage from subject area to database tables, columns and view objects or vice versa.
This documentation is published by Oracle OTBI development. This document provides users a functional understanding of SCM and Procurement subject areas - what they contain, key business questions that can be answered with the analyses built using the subject areas, the primary navigation paths in the application UI that contain information related to specific subject areas, and other useful information. This document also contains information on the duty and job roles that provide access to each subject area.
The spreadsheets apply to SCM and Procurement R13.
This spreadsheet is published by Oracle OTBI Development. This spreadsheet documents Fusion SCM and Procurement OTBI subject areas, the corresponding View Objects and database tables and columns. Customers can use this spreadsheet to search for reporting fields in OTBI subject areas or trace the lineage from subject area to database tables, columns and view objects or vice versa.
This spreadsheet also documents subject area security duty roles and job roles for 17D and 18A.
These spreadsheets are published by Oracle OTBI Development. These spreadsheets document Procurement and Supply Chain Management OTBI subject areas and the corresponding View Objects and database tables and columns. Customers can use these spreadsheets to search for reporting fields in OTBI subject areas or trace the lineage from subject areas to database tables, columns and view objects or vice versa.
The spreadsheets apply to Fusion PRC and SCM Release 12.
Please note In R12 users can search for a field in a subject area in OTBI.
We want a report that shows the same information as you can see in the 'Adjust Receipt Accrual Balances menu'.
It has to show the amounts that are displayed in this screen per reference date, PO and business unit.
Desired columns:
- Business unit
- Purchase order
- Accrual Adjustment
- Item Price (net received and invoiced)
- NonRecoverable tax (net received and invoiced)
- Recoverable Tax (net received and invoiced)
- Total Receipt Value (net received and invoiced)
- Accrual Balance Quantities (Net received and invoiced)
- Quantity Difference
- Supplier
- Supplier Site
- Inventory Organization
- Item
- Item Description
Hi,
Is there any report for Inventory issuance including the Cost ( Item list price * Quantity issue ) Month or with the date range.
Sample manual report attached.
HI,
This analysis will help to extract the details for sub-inventories for expense/ Asset and their attributes wise.
Thanks
Is it possible to do a customization on the AP invoice to validate certain fields and making some fields required based on filling of other fields?