RCV_TRANSACTIONS: Table Details such as columns, Indexes and a few tips to query the table used in Oracle Fusion for receiving transactions.
Blog
RCV_SHIPMENT_LINES: Columns, Indexes & Few Tricks
RCV_SHIPMENT_LINES: Table Structure, Indexes and a few salient points to query the table used by Oracle Fusion to hold shipment line details.
RCV_SHIPMENT_HEADERS: Columns & Indexes
RCV_SHIPMENT_HEADERS: Table Structure, Indexes and a few salient points about the table used by Oracle Fusion to store the Shipment Data
OE_ORDER_HEADERS_ALL: Column, Index & Few Tricks
OE_ORDER_HEADERS_ALL: The table used by Oracle Fusion to store the Sales Order Header level data. You would need to query OE_ORDER_HEADERS_ALL table if you have implemented O2C Cycle. So you can say that this is the equivalent of table DOO_HEADERS_ALL table in Oracle Fusion. In this post, we will discuss the columns and indexes present… Continue reading OE_ORDER_HEADERS_ALL: Column, Index & Few Tricks
Accounting Detail Query for AP Invoice
Accounting Detail Query: How to fetch the accounting details of an AP Invoice such as Accounting Date, Dr/ Cr Amount in Oracle Fusion and R12