FUN Intercompany Transaction Upload – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

FUN Intercompany Transaction Upload ================================== Creates, updates and submits Advanced Global Intercompany System (AGIS) intercompany batches as entered on the Intercompany Super User > Transactions > Outbound pages: the batch with its initiator, the transactions to each recipient, and their initiator and recipient distributions.

Each row is one initiator distribution and/or one recipient distribution of a transaction. Batch columns repeat on every row of the batch and transaction columns on every row of the transaction. Rows are grouped into a batch by Initiator and Batch Number. With automatic batch numbering (Intercompany System Options) the entered Batch Number only groups the rows and the batch receives the next number, which the result file shows.

Rows are loaded into the intercompany open interface and imported by Oracle’s Intercompany Import Program, which applies the same validations as the Outbound pages. A batch is imported completely or not at all, and the rows of a rejected batch show the import’s rejection reasons.

Submit = Yes imports the batch as sent, which starts the intercompany approval workflow, as the Submit button does.

Upload Mode

Create

Opens an empty spreadsheet to enter new batches.

Create, Update

Additionally downloads existing batches. Only batches with status New can be changed or submitted. An updated batch is imported again as a whole, including its transactions and distributions not present in the upload, and replaces the existing batch once the import has accepted it. It keeps its batch number but gets a new batch id. Distributions cannot be deleted.

Only batches of initiators the user is an intercompany contact for are listed, and the user must be assigned to an employee.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Upload Mode, Initiator, Batch Number, Batch Status, GL Date From, GL Date To

Oracle EBS Tables Used

fun_trx_batches, hz_parties, fun_trx_types_vl, gl_daily_conversion_types, fun_trx_headers, fun_dist_lines, gl_code_combinations_kfv

Report Categories

Enginatics, R12 only, Upload

GL Account Distribution Analysis, GL Account Analysis (Drilldown), GL Account Analysis (Drilldown) (with inventory and WIP), AR Transaction Upload, GL Account Analysis

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output Example
Blitz Report™ XML Import FUN_Intercompany_Transaction_Upload.xml
SQL Source FUN Intercompany Transaction Upload.sql
Full Report on Enginatics www.enginatics.com/reports/fun-intercompany-transaction-upload/

© Enginatics GmbH