Oracle Techno & Functional

AP/AR Netting Tables in R12

What tables are involved?

AP/AR Netting engine is owned by ‘Oracle Financials Common Modules’ (FUN) Product. All tables behind the scene will be stored under the FUN schema. Information related to Netting is stored in the following
tables:

Table Name    Table Purpose

FUN_NET_AR_TRX_TYPES_ALL    Netting Agreement – Transaction types of AR

FUN_NET_AP_INV_TYPES_ALL     Netting Agreement – Transaction types of AP

FUN_NET_AGREEMENTS_ALL       Netting Agreement – Details

FUN_NET_SUPPLIERS_ALL Netting Agreement – Supplier Details

FUN_NET_CUSTOMERS_ALL         Netting Agreement – Customer Details

FUN_NET_BATCHES_ALL    Netting Batch – Details

FUN_NET_AR_TXNS_ALL    Netting Batch – Details of AR transactions

FUN_NET_AP_INVS_AL                    Netting Batch – Details of AP invoices

R12 : Web ADI Account Segment Columns Width not increasing individual KFF Segments width

Symptoms:

Web ADI Account Segment Columns Width not increasing individual KFF Segments width

Layout definition using following navigation:

1) Desktop Integration - Responsibility
2) Define Layout
3) General Ledgers - Journals
4) Budgets - Single
5) Update
6) Under Line the width of Accounts is fixed

Increasing the width does not affect the column width during document creation.

Solution

1) Take the backup of the system
2) Apply Patch 12947598
3) Validate the version of following files:
BneVBALayout.java -- 120.11.12010000.15
BneVBALayoutColumn.java -- 120.9.12010000.3
Following commands can be used
strings - a $JAVA_TOP/oracle/apps/bne/integrator/document/macro/msoffice/excel/BneVBALayout.class|grep Header
strings -a $JAVA_TOP/oracle/apps/bne/integrator/document/macro/msoffice/excel/BneVBALayoutColumn.class|grep Header
4) Test the solution
5) Migrate the patch to the other environments.

6) Bounce the server and apache.