Daily Archives: August 26, 2025

Journals Uploaded Twice into Oracle Apps r12

Introduction/ Issue: The Same details Journals Uploaded Twice into Oracle. Why We need to do / Cause of the Issue: User was uploaded the same GL File Twice into Oracle.…

Read More

In the AP Interfile file Program Getting Duplicate Invoice Error.

Why we need to do /Cause of the issue: When we are uploading the AP Invoice Refund data into Oracle. In the Payables Open Interface Import Program We are getting…

Read More

Lot Genealogy Report

Introduction: This blog has the SQL query that retrieves the complete lot genealogy, detailing the full lifecycle of product creation. Cause of the issue: Business wants a report that contains…

Read More

Quality Test Sample Throughput Report

Introduction: This blog has the SQL query that retrieves all Quality test samples along with their corresponding results. Cause of the issue: Business wants a report that contains the details…

Read More