report only returns current live inspection data
We have developed an Inspection Summary Report in Oracle Fusion (BI Publisher / OTBI) to retrieve inspection history for all items in our inventory organizations.
The report only returns current/live inspection data, and does not include historical inspection records. We need a complete inspection history, including:
- Items already inspected in previous periods
- Completed and rejected inspections
- Inspection details (quantity, lot/serial, characteristics, status, quality, inspector)
Expected Behavior:
The report should return all historical inspection data, not just current or live data.
Actual Behavior:
Only inspections from recent transactions are returned; older inspection history is missing.
0