The blog provides Oracle EBS R12 SQL to get AR and AGIS Invoices with consolidated and non consolidated batches based on the AGIS Batch Source Name , Org_id and Flex Value Set Name defined SELECT INTEF.ORG_ID, INTEF.INTERFACE_LINE_ID, INTEF.INTERFACE_LINE_ATTRIBUTE1 BATCH_ID, INTEF.INTERFACE_LINE_ATTRIBUTE2 TRX_ID, INTEF.INTERFACE_LINE_ATTRIBUTE3 LINE_ID, INTEF.INTERFACE_LINE_ATTRIBUTE4 BATCH_NUMBER, HEADERS.ATTRIBUTE1 , –trx_number in case of non-consolidated batches FDL.ATTRIBUTE1, — trx_number […]
Oracle EBS R12 SQL to get AR and AGIS Invoices
By oracleappsadminPosted on Posted in Oracle ReceivablesTagged AGIS and AR Invoices for Consolidated batches, AGIS and AR Invoices for Non Consolidated batches, AGIS Reconciliation with transactions created, AR and AGIS Invoice mapping in R12, Oracle Apps AGIS R12 invoice mappiing with AR