Match Approval Level (Matching of Invoices with Purchase Orders)

Match Approval Level (Matching of Invoices with Purchase Orders)

If we use Oracle Payables with Oracle Purchasing or another integrated purchasing product, we can perform online matching of invoices and original purchase orders or purchase order receipts. Matching ensures that we only pay for the goods and services you ordered and that our suppliers do not over bill us. If we are billed for an item over the amount and quantity invoice tolerances that we define in the Invoice Tolerances window in Payables then Invoice validation applies holds to the invoice and prevents payment until we release the holds.

For 3 Way matching to work, we must set a value for Quantity received in the Invoice Tolerances window , and the item needs to be set to receipt required.

2 - Way- When we match to purchase order or receipt, Invoice validation performs these control checks.
1. Quantity Billed <= Quantity Ordered.
2. Invoice Price <=Pruchase Order Price.

3 Way- 
1. Quantity Billed <= Quantity Ordered.
2. Invoice Price <=Pruchase Order Price.
3. Quantity Billed <= Quantity Received.

4 Way-
1. Quantity Billed <= Quantity Ordered.
2. Invoice Price <=Pruchase Order Price.
3. Quantity Billed <= Quantity Received.
4.Quantity Billed <=Quantity Accepted.

AR Profile Options

AR Profile Options

AR: Allow Update of Existing Sales Credits
This profile option determines whether a user can update existing sales credits or if additional sales credit records need to be created to maintain an audit trail.

AR: Application GL Date Default
This profile option determines how Receivables determines the default GL Date when you apply receipts. Choose one of the following values:

Later of Receipt GL date and Invoice GL date:
Choose this value to use either the receipt GL date or the invoice GL date, whichever is later, as the default GL date for your receipt applications. This is the default value.

Later of Invoice GL date, and Current date:
Choose this value to use the receipt GL date, the invoice GL date, or the current date, whichever is later, as the default GL date for your receipt applications.This profile option can be set by the system administrator at the site, application, and responsibility levels but cannot be updated by the user.

AR: Automatic Contact Numbering
If you want to require users to provide a value for the Contact Number field, then enter No.If you enter Yes or leave this profile option blank, then Receivables automatically assigns a number to the field, and users cannot change it.The value for this option can be set by the system administrator at the site, application, responsibility, and user levels.


AR: Bills Receivable Batch Source
This profile option determines the default bills receivable transaction batch source to use for bills receivable transactions. Enter a bills receivable batch source that you previously defined to default to the Bills Receivable window and the Bills Receivable Transaction Batches window.This profile option can be set only at the user level and can be updated by the user.

AR: Bills Receivable Batch Source
This profile option determines the default bills receivable transaction batch source to use for bills receivable transactions. Enter a bills receivable batch source that you previously defined to default to the Bills Receivable window and the Bills Receivable Transaction Batches window.This profile option can be set only at the user level and can be updated by the user.


AR: Change Customer on Transaction
This profile option determines whether you can update customer names in the Transaction windows. If this option is Yes, you can update the bill–to and ship–to names of customers on your transactions.Note: You cannot update the customer bill–to or ship–to information if the transaction is a chargeback, has activity against it, or has been posted, even if this profile option is set to Yes.The value for this option can be set by the system administrator at the site, application, responsibility, and user levels, but cannot be updated by the user.


AR: Change Customer Name
This profile option allows you to change the party name in the customer standard form when set to Yes. When this option is set to no you cannot change the party name in the customer standard form once it is entered.

AR: Commit Between Validations in Lockbox
This profile option determines whether the AutoLockbox program will commit (save) after validating each record in a Lockbox transmission. If you set this profile option to No, AutoLockbox will only commit after validating all of the records in the transmission. This profile option can be set by the system administrator at the site, application, and responsibility levels.

AR: Create Bank Charges
This profile option determines whether users can create bank charges when entering receipts in Receivables. Other operations that this profile can affect include the following:

QuickCashPostBatch
The value for this option can be set by the system administrator at the site, application, and responsibility levels, but cannot be updated by the user.

AR: Credit Limit Selection
Use this profile option to enable cross currency credit check. By default, this profile option is set to Single. If this profile option is set to Single, your credit exposure will include only those transactions with currency that match the currency of the central credit limit. If this profile option is set to Multi, you can set up a central credit limit in one currency and calculate the exposure for all transactions.

AR: Customer Merge Commit Size
This profile option determines how many site uses are included in a merge set when you run the Customer Merge program from the Standard Request Submission windows. This profile option is not used when you submit the program from the Customers Merge window. A merge set contains one or more pairs of customer accounts to merge and is created based on these two rules, with the first rule taking precedence: Site uses for a customer account cannot be split between two merge sets.

AR: Customer Text Last Successful
This profile option stores the last successful run date of the customer text data creation and indexing process . You must run this customer text data creation and indexing process to acquire good search results in the Text tabbed region of the Find/Enter Customers window.

AR: Customers – Enter Alternate Fields
This profile option controls whether users can enter information in the Alternate Name field in the Customers and Customer Addresses windows. This field lets you enter a phonetic representation of a customer name. Alternate names are used primarily in Japan to enter and sort customer information using Kana characters.Receivables also uses this information when you choose Customer Name Sort as a parameter when printing certain Receivables reports (for example, the Customer Listing – Detail or Summary report). Refer to the AR: Sort Customer Reports by Alternate Fields profile option in this section.

AR: Debug Level for PostBatch
This profile option determines whether PostBatch is run in debug mode. If this option is set to Yes, enter one of the following values to indicate how extensive the debugging information saved to the log file will be:-Save only the most severe messages and errors (default setting).-Save messages that indicate entering and exiting various functions.–Save any useful and informative messages.-Save all other debug messages, including printing values of several important variables.


AR: Default Exchange Rate Type
This option determines the default exchange rate to use when converting foreign currency transactions to your functional currency. Valid values are:

Corporate Exchange Rate –
An exchange rate you define to standardize rates for your company. This rate is usually a standard market rate determined by senior financial management for use throughout the organization.

Spot Exchange Rate – An exchange rate you enter to perform a conversion based on the rate on a specific date.

User Specified Rate – An exchange rate you specify when entering a foreign currency transaction.

AR: Deposit Offset Account SourceThis option indicates which accounting source to use for a deposit’s offset account. Receivables can use either AutoAccounting or the deposit’s transaction type as the accounting source for the offset account.

AR: Disable Receivable Activity Balancing Segment SubstitutionThis profile option lets you disable balancing segment substitution for receivable activities. This profile option does not affect the gain, loss, and rounding accounts that you define at the system options level.The default value is No. If you set this profile option to Yes, then you must define a suspense account in the event that your activities and original transactions do not post to the same balancing segment value.This profile option affects these activities:

Activity Applications These options are receipt write–off activity, short term debt, and claims investigation. See: Oracle Receivables Doc Update RELEASE 11i - Using the Account Generator in Oracle Receivables.The value for this option can be set by the system administrator at the site, application, responsibility, and user levels but
cannot be updated by the user.


AR: Enable Debug Message Output
Use this profile option to help resolve errors that can occur when generating iReceivables pages, such as web pages that appear with missing fields or data that displays incorrectly. This profile option activates a debugging program that inserts comments into your HTML source files to help your system administrator determine the cause of any errors. This profile option can be set only at the user level and can be updated by the user.

AR: Enable SQL TraceUse this profile option to activate SQL Trace, a program that creates a log file of each SQL procedure performed while executing Oracle Receivables functions. If this profile option is enabled and a SQL–related error occurs, Oracle Applications developers and your system administrator can use the log file the program creates to identify the cause. Accept the default setting of No for optimum performance during normal day–to–day processing. Enable this profile option before reproducing and researching SQL errors.


AR: Enable Debug Message Output
Use this profile option to help resolve errors that can occur when generating iReceivables pages, such as web pages that appear with missing fields or data that displays incorrectly. This profile option activates a debugging program that inserts comments into your HTML source files to help your system administrator determine the cause of any errors. This profile option can be set only at the user level and can be updated by the user.


AR: GL Transfer Balance Test
This profile option controls whether the General Ledger Interface program will reject debit and credit balances that are not equal before posting to the general ledger. Available values are:Yes: Receivables will reject unbalanced debits and credits before posting to the general ledger. These rejected unbalanced debits and credits will be listed in the Unposted Items Report which runs automatically during the posting program.No: Receivables will not reject unbalanced debits and credits before posting to general ledger.The value for this option can be set by the system administrator at the site, application, responsibility, and user levels but cannot be updated by the user.

AR: Include Receipts at Risk in Customer Balance
This profile option controls whether Receivables displays items at risk and includes them when calculating customer account balances in the Account Details, Account Overview, and Customer Account windows.Set this option to No if you do not want to view items at risk in these windows or include them when calculating the balance due.

AR: Invoices with Unconfirmed Receipts
This profile option lets you choose whether to adjust or credit invoices selected for automatic receipt. You can adjust transactions that have been approved, but not confirmed. The options available are:Adjust:^(Further explanation forthcoming)Adjust and Credit:^(Further explanation forthcoming)Credit:^(Further explanation forthcoming)None:^(Further explanation forthcoming)The value for this option can be set by the system administrator at the site, application, responsibility, and user levels, but cannot be updated by the user.

AR: Item Flexfield Mode
This profile option lets you choose the format to use for entering flexfield information for Line Items for commitments in the Transactions and Item Tax Rate Exceptions windows. Available values are:Always Pop a Flexfield Window: The item flexfield always pops up as you navigate through the field.Concatenated Segment Entry: The item flexfield never pops up as you navigate through the field. Instead, you can type the item flexfield information directly into the field.No Window for a Single Segment Flexfield: The item flexfield will only pop if it has more than one segment enabled.The value you specify for this profile option at the user level takes precedence over the value that is set for this profile option by the system administrator at the site, application, responsibility, or user level.

AR: Mask Bank Account Numbers
Use this profile option to control the display of bank account numbers in Receivables windows. If you accept credit cards as payment for open debit items, Receivables displays the credit card number in the Bank Account field of the Customers, Transactions, and Receipts windows. You can limit access to this information by displaying only a portion of the number.No Masking: Do not mask any portion of the number.Mask – First Four Digits Visible: Show only the first four digits of the number. Display the remaining digits as asterisks(*).Mask – Last Four Digits Visible: Show only the last four digits of the number. Display the preceding digits as asterisks (*).The value you specify for this profile option at the user level takes precedence over the value that is set for this profile option by the system administrator at the site, application, responsibility, or user level.

AR: Maximum Lines per AutoInvoice Worker
This profile option lets you set a maximum number of lines per AutoInvoice worker.The value for this option can be set by the system administrator at the site, application, responsibility, and user levels, but cannot be updated by the user. This profile option has no default value.

AR: Oracle Exchange Database Link Name
This profile option lets you enter the name of the database link between Oracle Exchange and Receivables when they are on two separate database instances. Set this profile option in Receivables after you create the database link to Exchange. You must set this profile option if you want to integrate your Exchange billing data with Receivables.The value for this option can be set by the system administrator at the site level only, and cannot be updated by the user. This profile option has no default value. Please refer to the Oracle Exchange and Oracle Sourcing System Operator Implementation Guide, Release 6.2.2 and above, for complete information on the Oracle Exchange Billing integration with Receivables.

AR: Override Adjustment Activity Account Option
This profile option lets you choose whether you can override the default adjustment account when entering or updating manual adjustments and when updating automatic adjustments. These changes must be made before posting to the general ledger.The value for this option can be set by the system administrator at the site, application, responsibility, and user levels, but cannot be updated by the user.

AR: Receipt Batch Source
This is the default receipt source for the Batch field in the Receipts and Receipt Batches windows. Only Receipt sources with a Receipt Source Type of ’Manual’ will be displayed in the list of values. The value that you specify for this profile option at the user level takes precedence over the value that is set for this profile option by the system administrator at the site, application, responsibility, or user level.

AR: Sort Customer Reports by Alternate Fields
This profile option controls whether Receivables will sort information using the value of the Alternate Name field in the Customers window when you run certain reports. To use this option, the AR: Customers Enter Alternate Fields profile option must also be set to Yes. Reports that can use this option include: the Customer Profiles Report, Receipt History Report, Applied Receipts Register, Unapplied Receipts Register, Automatic Receipts Awaiting Confirmation, Print Statements, Transaction Register, and the Customer Listing Detail and Summary reports.

AR: Transaction Batch Source
This profile option determines the default invoice source that will appear in the Batch field of the Transaction and Credit Memo windows. Receivables only displays batch sources with a Transaction Source Type of ’Manual’ in the list of values for this option.The value you specify for this profile option at the user level in this window takes precedence over the value set for this profile option by the system adminis
trator at the site, application, responsibility, or user level.

AR: Update Due Date
This profile option determines whether you can update the due date (payment schedule) of a transaction in the Installments and Account Details windows. Available values are:Yes: Receivables lets you update the due date of a debit item to any date that is greater than the transaction date of this item. If you change the due date of your debit item.

AR: Use Invoice Accounting For Credit Memos
This profile option determines whether to assign your credit memo to the same accounts that are assigned to the invoice you are crediting.The value for this option can be set by the system administrator at the site, application, responsibility, and user levels, but cannot be updated by the user.

Oracle 11i Account Receivabls(AR)Key Reports

Oracle 11i Account Receivabls(AR)Key Reports

AR Application provides more than 100 Reports to assist with accounting , collections, execution, printing documents, listings, tax reporting, and miscellaneous activities.

Accounting Reports- These Reports assist with recording the history of transactions, balancing the AR Subledger internally, and recording entries into the General Ledger.

Accounting Reports in AR
Adjustment Apporval- Use this report to see information about transacitons adjustments.
Adjustment Register- Review approved adjustments with this report. This is one of the reports used to balance the system.
Aging By Account Report- This is variation of the aging reports to show open items in summary or detail by accounting flexfieldvalue. This is one of the reports used to balance the system.
Applied Receipts Register-This report shows all activity of receipt. This is one of the reports used to balance the system.
Automatic Receipt Batch Managment- This report is used to review the status of Automatic Receipt Batches.
Automatic Receipt Awaiting Confirmation-This report lists automatic receipts that have been formatted and have been assigned a payment method with a receipt class with Require confirmaiton.
Bad Debt Provision Report- This report can calculate a bad debt exposure from the percent collectable value in the customer profile class.
Billing and Receipt History- Use this report to see detailed list of transaction for the date range.
Billing History Report- This report shows a summary of transaction in an account.
Commitment Balance Report- This is a summary listing of information about commitments.
Invoice Exception Report- This report shows transaction where open Receivables is equal to NO. These transactions do not appear on an aging report but are on the transaction register.
Invoices Posted to Suspence Report- This is listing of invoices where the revenue account is a suspence account.
Journal Entries Report- Use this report to reconcile the AR subledger to the General Ledger.
Journal With GL Detail Report- Use this report to show journal entries for specific transacitons in AR.
Miscellaneus Transaction Report- List miscellaneous receipts activity with this report.
Receipts Register- This is a listing receipts for a date range.
Receipts Journal Report- This reports lists the details of the receipts that have been included in a journal entry.
Sales Jounal by Customer Report- This report lists all transactions by customer.
Sales Journal by GL Account- This report is similar to the transaction register by GL account. Use this report when you balance the AR aging to the General Ledger.
Transaction Reconciliation Report- This is a report to show GL journal entry lines created from specific AR transactions.
Transaction Register- This register to verify that possible items are included in the sales journal. This is one of the key reports used to balance the system.
Unapplied Receipts Register- This report lists the details of on account and unapplied receipts.
Unposted Items Report- This report to see items not posted to General Ledger for a date range.

Invoice Reports In Oracle Payables

Invoice Reports In Oracle Payables

Payment Batch Control Report
Payment batch control report to review detailed information about the payments printed in one or more payment batches. We can submit this report after every payment batch to compare it with actual payment information.
Credit Memo Matching Report
This report lists credit memos and debit memos that match the supplier and date parameters we specify. This report also lists the total of the distribution line amounts of each credit memo in our entered currency and our functional currency. It also lists total credit memo amounts for each supplier and a total amount for the supplier.
Invoice Aging Report
This report is used to analyze the cash flows of our unpaid invoices. This report provides information about invoice payments due within four weeks periods our specify in aging periods window.
Invoice Audit Listing by Voucher Number
This report to review our invoices with assigned sequential voucher numbers. Either we are payables can assign a unique, sequential number to an invoice during invoice entry, if we enable the sequential numbering profile option.
Invoice Audit Listing
This report to audit invoices for duplicates. We should audit invoices periodically to ensure control of invoice payments. We can sort this listing in six different ways. For example we may want to only audit invoices over $500. We can specify a minimum invoice amount, and sort invoices by amount then the supplier name and date.
Invoice Audit Report
This report lists invoices that appear as potential duplicates according to several criteria. One criterion we specify is the number of characters in the invoice number which two or more invoice have in common. The report lists invoices which meets this criteria and have the same invoice amount, the same invoice date, and same supplier. We can limit the search by checking for duplicate invoices within a time period we specify.
Invoice History Report
The invoice history report is needed to justify the balance for a given range of invoices. It helps us to quickly identify and review a detailed list of all activities pertaining to a specific invoice including all payments, gain/loss, credit , debit memos and discounts.
It also helps us to identify activities on prepayments and credit ,debit memos.
The balance of the invoices in then summed for each supplier site for each supplier and for the entire report.







Invoice on Hold Report
This report to review detailed information about invoices on hold. We can submit the approval process before submitting this report to obtain the most up to date hold info. To obtain additional detail for invoices on matching hold, we can submit the matching hold detail report.
This report is divided into three sections. The first section gives us supplier , invoice, purchase order, amount and hold information for each invoice o hold. Payables subtotals the invoices on hold by supplier or by hold code. The subtotal information includes the number of invoices, total original amount and total amount remaining for the invoices on hold. The report does not include cancelled invoices.
Second section, invoice hold code description, lists all predefined and user defined hold codes that are in the first section of report, description of each code and whether the hold allows posting. The third section the report, invoices with no exchange rates lists foreign currency invoices without exchange rates.
Invoice Register
This report shows detailed information about invoices.
We can use this report to view the offsetting liability accounts that payable creates for each invoice distribution when our approve an invoice. Payables orders the report by invoice currency and invoice batch name. Within the currency and batch name the report orders by the supplier name and invoice number.
Posted Invoice Register
This report to review invoices posted in particular period. We post invoices by submitting the payable transfer to general ledger program. The posted invoice register lists each accounts payable liability account and the invoice posted to the account along with the supplier and amount information for each invoice listed.
Payables displays the invoice amount and posted distribution amount in the invoice currency. Payables also displays the posted distribution amount in our functional currency for easier reconciliation with our general ledger. We can also use this report to reconcile variances between an invoice amount and its distribution amount. Variances can result from reversing distribution or correcting entries.
Invoice Validation Report
This invoice validation report to review the total number of matching and variance holds that payables applies and releases after we submit invoice validation. If we use budgetary control payables also lists any funds control holds.
Matching Hold Detail Report
This matching hold detail report to review detailed accounts payables and purchasing information for invoices with matching holds and matching hold releases. We can print this report before initiating a payment batch to determine whether to manually release any invoices for payment. We can print this report for all invoices with matching hold and releases during a time period we specify, or we can print this report to review only invoices with matching holds applied or released since the last time we submitted for approval.
Open Items Revaluation Report
This report to revaluate our open items, for example invoices, prepayments and credit memos and debit memos that are not fully paid. This report takes into account the changes of the value due to changes in the foreign currency rates.
Recurring Invoices Report
This report to review recurring invoice templates we defined during a specific time period. We can review this report to determine the amount we have authorized for a recurring invoice template, how much we have released, and the next amount we have scheduled. The report also lists the number of periods remaining for a recurring invoice and the next period we have scheduled.
This report lists recurring invoice templates by supplier and supplier site.

Oracle Payable Accounting Events

Oracle Payable Accounting Events

Invoice EventInvoice Adjustment Event
Invoice Cancellation Event
Prepayment Application Event.
Prepayment Unapplication Event.

The Accounting events for the payment document class are 
Payment Event.
Payment Matruity Event.
Payment Adjustment Event.
Payment Cancellation Event.
Payment Clearing/Unclearing Event.

Invoice Event.AP_ACCOUNTING_EVENTS_ALL

Accounting_Event_id Event Type Code Acounting Date Event Status Code Source Table
49999 INVOICE XXXXXXXX ACCOUNTED AP_INVOICES


AP_AE_HEADERS_ALLAE_Header_id Accounting_event_id Accounting_Date Ae_Category
54544 49999 xxxxxxxxx PurchaseInvoice

AP_AE_LINES_ALL
Ae_line_id Ae_header_id Ae_Line_number Ae_line_type_code entered_dr entered_cr source_table
89898 54544 1 Charge 100 ap_inv_distribution
89899 54544 2 Liability 100 ap_invoices

Invoice Adjustment Event
In AP_ACCOUNTING_EVENTS_ALL

Event_Type Code is “Invoice Adjustment” and Source_Table is “AP_INVOICES”

Invoice Cancellation Event
In AP_ACCOUNTING_EVENTS_ALL

Event_Type_Code is “Invoice Cancellation” and Source_Table is “AP_INVOICES”

Prepayment Application/Unapplication Event
In AP_ACCOUNTS_EVENTS_ALL Event_Type_Code is “PREPAYMENT APPLICATION” for prepayment Unapplicaiton EventType_Code “PREPAYMENT UNAPPLICAITON”. Source_Table is “AP_INVOICES”.

Payment /Payment Cancellation Event

In AP_ACCOUNTING_EVENTS_ALL event_type_code “PAYMENT” for Payment and .For Payment Cancellation event type code “PAYMENT CANCELLATION” . Source_Table is “AP_CHECKS”.

PAYMENT MATURITY and PAYMENT CLEARING
In AP_ACCOUNTING_EVENTS_ALL event_type_code for Payment Maturity is “PAYMENT MATURITY” and for Payment Clearing is “PAYMENT CLEARING”.
Source_Table is “AP_CHECKS”.

Trial Balance Reports in General Ledger

Trial Balance Reports in General Ledger

Trial Balances reports to review balances for our general ledger accounts for budges, actuals and encumbrances for any currency. The same segment security rules defined to restrict user to access to segment values in our accounting flexfield are extended to these reports.
Average Balance Trial Balance Report
Review your General Ledger standard and average account balances. We can print functional, foreign entered, or translated average balances.
This report provides a listing of standard and average balances for selected accounts based on an as of date we specify. In addition, the report displays period, quarter and year average to date balances. We can also request a additional information on this report by specifying balancing segments and account ranges.
Parameters- Currency, Currency Type, Reporting Date, Accounting From/TO
Budget Trial Balance Report
Review your general ledger budget account balances and activity for a specific currency. We can run this report for balances and activity entered in our functional currency and foreign currency or STAT or translated to a foreign currency.
General Ledger prints a page for each balancing segment value and list our accounts in ascending order by account segment value. General Ledger reports debits as positive amounts and credits as negative amounts.
Parameters- Budget Name, From TO/Period, Type , Currency
Detail Trial Balance Report
Review your general ledger actual account balances and activity in detail. We can run this report for balances and activity entered in your functional currency or STAT or translated to a foreign currency.
This report prints a line for each of your a accounts and lists them in ascending order by account segment value. For each account, the report prints the account segment value, account segment value description, beginning balance, period activity and ending balance for the period you specify. General Ledger reports debits as positive amounts and credits as negative amounts.
Parameters - Pagebreak segment, Pagebreak segment low/high, Currency, Period, Amount Type.
Expanded Trial Balance Report
Review the beginning , ending and net balances as well as period activity for a set of accounts. View your actual balances and activity in your functional currency or translated to a foreign currency. You can also use this report to review your statistical account balances and activity.
The report prints a line for each account segment value and sorts them in ascending order. For each account segment value, the report prints the account description, beginning balances, period activity, ending activity, and ending balances for the period you request.
Parameters - Period Name, Account From /TO, Balancing Segment, Currency, Precision, Class level, Class and Sub class level, Class Sub Class and Group Level.
Foreign Currency Detail Trial Balance Report
Review actual general ledger account balances and activity entered in a foreign currency. The report prints a line for each of your accounts and lists them in ascending order by account segment value. For each account, the report prints the account segment value, account segment value description, beginning balance, period activity, and ending balance for amounts and credits as negative amounts.
Parameters- Pagebreak segment, Pagebreak segment low/high, Currency, Period, Amount Type.
Foreign Currency Summary 1 Trial Balance Report
Review summarized general ledger balances and activity entered in a foreign currency. The report summarizes balances and activity by account segment value.
The report sorts the account segment values in ascending order. For each account segment value, the report prints the value, description, beginning balance, net of all debit or credit transactions, and ending balance for the period you request.
Parameters -Pagebreak segment, Pagebreak segment low/high, Period , Amount Type.
Summary1 Trial Balance Report
Review general ledger actual account balances and activity summarized by account segment value. You can run this report for balances and activity entered in your functional currency or STAT or translated to a foreign currency.
This report prints a line for each account segment value and lists them in ascending order. For each account segment value, the report prints the value , description, beginning balance, net of all debit or credit transactions and ending balance for the period your request.
Parameters- Pagebreak segment, Pagebreak segment low/high,Currency, Period, Amount Type.
Summary 2 Trial Balance Report
Review general ledger account balances and activity for combinations of account segment values with the values of a secondary segment you specify. You also specify a range of values for a third segment, which are used to control report page breaks.
General Ledger prints a line for each combination and sorts the secondary segment values from the lowest or highest. For each Secondary segment value, General Ledger sorts the account segment values from the lowest to the highest. Totals are provided for both your secondary segment and your pagebreak segment.
You can run print this report for actual , budget and encumbrance balances and activity in your functional currency, a foreign currency, or statistical units.
Parameters - Balance Type, PageBreak segment, PageBreak segment low/high, Secondary segment, Currency Type, Currency, Period Name, Budget Start Period Name, Amount Type.

ITEM IMPORT BASED ON TEMPLATE R12

ITEM IMPORT BASED ON TEMPLATE R12

In this post, I tried to explain the steps to IMPORT an ITEM with its attributes based on ITEM TEMPLATE in R12 Oracle Apps.

STEP1: Get the template id using the below query 

SELECT template_id

      ,template_name

      ,description

FROM   MTL_ITEM_TEMPLATES; 

STEP2: Check the choosed template's related item attribute values using the below query

SELECT template_id

      ,attribute_name

      ,enabled_flag

      ,report_user_value

FROM   MTL_ITEM_TEMPL_ATTRIBUTES

WHERE  template_id = 107; 

STEP3:  Run the below insert script to create a record in the standard item interface table to create a item based on item template 

INSERT

INTO

  MTL_SYSTEM_ITEMS_INTERFACE

  (

    process_flag,

    set_process_id,

    transaction_type,

    organization_id,

    segment1,

    description,

    TEMPLATE_ID

  )

  VALUES

  (

    1,

    1,

    'CREATE',

    204,

    'TESTITEM01',

    'Testing Item Import With Template',

    107

  );

COMMIT; 

STEP4: Run the wrapper script given in the below link to submit the "IMPORT ITEMS" concurrent program from backend  Wrapper Script to Submit Item Import 

  

STEP5: Run the below query to verify the creation of the item 

SELECT *

FROM   mtl_system_items_b

WHERE  segment1 = 'TESTITEM01';