How to move OTBI report from one instance to another?

Oracle Fusion has provided a feature to migrate OTBI reports from one Instance to another Instance. Source code migration is very easy process in Oracle fusion. Migration process helps in Cloud Implementation projects where we have to migrate hundreds of reports from one instance to another instance like from Dev instance to Prod instance. This is one of the great feature for OTBI reports migration.

Step1: Go to the OTBI Report which you want to migrate from one Instance to Another.

Step2: Select the OTBI Report.

Go to Source Instance(means from which instance you want to migrate)

Select report and click More. Click on Archive

System will ask these below options that if you want to keep same permissions like this instance then you should check this checkbox. like the same for Timestamps.

Check both and click Ok

It will be saved. You can save this report in your local desktop.

Step 3: Go to the Target Instance in which we want to migrate this Report Source Code.

This is the Folder in which I want to upload these Reports Source.

Select folder and click Unarchive

Select the file which you saved the file on desktop and then click ok.

OTBI Report has been Upload in the Folder in the Target Instance.

Our OTBI report migration process has now completed and we can see the OTBI reports in Target Instance.

Masking of Bank Account Numbers in Oracle Fusion

There could be a business requirement in any organization where in the bank account information should not be displayed completely for all the users, only the users who setup the bank account might have or should have access. Only last few or first few digits of the bank account to be displayed and remaining digits should be masked.

We have different setups for internal bank accounts and external bank accounts masking.

Internal Bank Accounts Masking

Internal Bank Accounts are those we use to make payments to suppliers or to receive cash collections from customers.

Set the profile option “Mask Internal Bank Account Numbers” using Task “Manage Cash Management Profile Options”

Setup

Go to Setup and Maintenance à Search à Task: Manage Cash Management Profile Options

Search

This can be set at Site level and we would like to set the “Display Last Four” and remaining to be masked.

Save and Close à Done

Go to Internal Bank Account Setup Screen

Task: Manage Bank Account à search for any bank accounts

We can see the digits are masked, not only in this screen, wherever applicable like in AP, AR Receipts screen or Cash Management or any Bank statement screen. In all the screens we will be able to see only last four digits and other digits as masked.

External Bank Accounts Masking

In order to mask the External Bank Account Numbers we need to use the setup called “Manage System Security Options”

Task: Manage System Security Options

Save and Close

Click Yes (Process takes some time to complete it).

Check Supplier and Customer bank accounts

ss

Order To Cash (O2C) Process in Oracle Fusion

The Order to Cash flow is the complete process of entering an order into the system (Sales Order), delivery the good(s) (Shipping), and then producing the Invoice for the goods. 

O2C Flow: Modules Involved

O2C Process Steps

• Receive Sales Order
• Book Sales Order
• Pick Release
• Ship Confirm
• Sales Returns
• Sales Invoice
• Receipt
• Reconciliation

Book Sales Order: Booking of the Sales order is done through Order Management and as the order progresses, users can track the status of the order.

Pick Release: Moving stock from Sub Inventory to Staging Area. Pick Release finds and releases the order and creates a move order request. The process of transacting move orders creates a reservation against the source sub inventory.

Ship Confirm: Moving stock from staging to customer address. Ship confirm is the process of confirming that items have shipped. Shipping Execution confirms that the delivery lines associated with the delivery have shipped.

Sales Returns: if are there are any returns from customers, they are recorded as Sales Returns.

Sales Invoice: Sales Invoice is created in AR based on Sales Order information in OM. Auto Invoice is a program which is used to import the Sales Orders from OM to AR as Sales Invoices.

Receipt: Customers make the payments based on sales invoices which is recorded as a receipt in AR.

Reconciliation: Receipt is reconciled with a bank statement line in Cash Management.

Some Key Setups in O2C

AR

• Assign Inventory Organization to BU
• Complete Invoice and Customer related setups

OM

• Setup Order Management Parameters
• Release Sequence Rules
• Pick Slip Grouping Rules
• Define Ship Confirm Rules
• Picking Rules and Rule Assignments
• Create Pick Wave Release Rules
• Create Staging Sub Inventory
• Shipping Parameters
• Create Carriers (Shipping Methods)

Pricing

• Price List
• Pricing Segment
• Pricing Strategy
• Customer Pricing Profile
• Pricing Segment
• Pricing Strategy Assignment

O2C Journal Entries

When customer places the order –No JE

When Booking the Sales Order –No JE

Pick Release- Check the available unit in Inventory and the quantity ordered by the customer

    Inventory Stage A/c……………Debit

    Inventory Finished goods a/c…..Credit

Ship Confirm(Sales order issues item): where we ship the product to customer site and decreases the Finished Goods inventory

    COGS A/c ……………Debit

    Inventory Valuation A/c………Credit

When invoiced customer

    Receivable A/c………………Debit

    Revenue A/c…………………Credit

AR Receipt

Receipt Confirmation A/c ………Debit

Receivables A/c………………….Credit

At Receipt Reconciliation

Cash A/C………………………Debit

Receipt Confirmation A/c…….Credit

Procure To Pay(P2P) Process in Oracle Fusion

What is P2P?

The Procure to Pay cycle is vital to an organization as in this process the organization buys and receive goods or services from its vendors and makes necessary payments. Procure to Pay refers to recording the journey of transactions from requisitioning and procuring goods and services from suppliers to receiving them at their destination. The supplier invoices are raised for the purchases, and payments are recorded and reconciled against bank statement, concluding the process.

Though the Procure to Pay process originates in the Procurement business area, it is an integral and essential part of the payables business function as well. Starting from collating requisitions into the purchase order to the final payment against goods or services procured, both procurement and accounts payables team members have a keen interest in ensuring that every process is well optimized for savings, efficiency and building value.

P2P Process: Modules involved

Financials: AP, FA, CM, GL

SCM: INV, PO

Where is the Procure to Pay Process performed?

The P2P process spans across multiple departments within an organization. It starts with an employee in any department requesting goods or services or with the Manufacturing department creating demand on planned/actual orders. From there, it flows through Purchasing and then ends in the Payables Department. 

P2P Process Steps

• Create Requisition
• Approve Requisition(by approver)
• Request for Quotation(RFQ)
• Receive Quotations
• Quote Analysis(chose best quote)
• Create Purchase Order
• Approve Purchase Order
• Send PO to Supplier
• Receive Material from Supplier(GRN)
• Purchase Returns (if any)
• Check on hand quantity
• Creation of Payable Invoice with Match PO Lines
• Invoice Payment to Supplier
• Transfer to GL
• Reconciliation with Cash Management

Some Key Setups

• Assign Business Unit Business Functions for Procurement and Inventory
• Create Item Master Organization
• Create Inventory Organization
• Configure Procurement Business Functions (Purchasing Options in EBS)
• Configure Requisitioning Business Functions

• Setup Common Options for Payables and Procurement

• Setup Receiving Parameters (Receiving Options in EBS)
• Setup Procurement Agent
• Manage Buyer Assignment Rules
• Setup Account Rules (PO-TAB: Transaction Accounting Builder
• Map Account Rules to Account Types
• Assign TAB to Primary Ledger
• Create Sub Inventories
• Create Item Class
• Create Item

P2P Journal Entries

Purchase Requisition no JE

Request for Quotation no JE

We prepare a Purchase Order against best RFQ no JE

At Goods Receipt Note(GRN)

    Receiving Inventory A/c………Debit
              AP Accrual A/C………Credit 

When we are moving the Goods from Staging area to Sub-Inv or Delivery happens

    Material A/C..............Debit 
              Receiving Inventory A/C....Credit
While Creating the Invoice

    AP Accrual A/c………….Debit
              Liability(Supplier) A/c………Credit

While making payment to supplier

Liability(Supplier) A/C…………… Debit
              Cash Clearing A/c…………….Credit 

When reconciling

Cash Clearing A/C...................Debit
              Cash A/C............................Credit

Customer Numbering in Fusion

I am going to explain about Customer Numbering in this post. When we create customers in Oracle, system automatically creates the customer number.

Customer number is the unique number assigned for each customer when it is created. We can also set our custom sequence for the customer number in Oracle.

How to set Customer Numbering for Party, Account and Site levels?

Best practice is to have 1XX series for Party, 2XX series for Account and 3XX series for Site. Generally clients have same series across application, we can still have customer numbering generated at LE/Ledger level(this is very unlikely). This can be achieved by selecting determining type while defining document sequence. Clients generally go for same series across application.

Task: Manage Document Sequences

BILLING_ACCOUNT_NUMBER = Customer Account Number

PARTY_SITE_NUMBER = Customer Site Number

REGISTRY_ID = Customer Party/Registry Number

BILLING_ACCOUNT_SITE_USE_NUM = Site Uses Number

How to override Customer Numbering? There is a profile option which allows to override customer numbers.

Task: Manage Administrator Profile Values

Below are the profile option codes used for generating the numbers for Party, Customer Account and Party Site

·       For Party Number: HZ_GENERATE_PARTY_NUMBER (Profile Option Name: Party Number Generation)

·       For Customer Account Number: HZ_GENERATE_CUSTOMER_NUMBER   (Profile Option Name: Customer Account Number Generation)

·       For Party Site Number: HZ_GENERATE_PARTY_SITE_NUMBER  (Profile Option Name: Party Site Number Generation)

What are the various available values for the above mentioned Profile Options?

Available Options:

• Auto numbering, update not allowed       - The number will be automatically generated and will not be editable
• Auto numbering, update allowed            - The number will be automatically generated and will be editable
• No auto numbering, update not allowed   - The number will not be automatically generated and will not be editable
• No auto numbering, update allowed        - The number will not be automatically generated and can be entered manually

Oracle Standard Reports in AR

Name	Description
Bad Debt Provision Report	Provides information for reviewing bad debt exposure and provisioning based on percent collectible assigned to the customer. Includes transaction number, balance due amount, and bad debt provision amount in the ledger currency.
Invoices Posted to Suspense Report	Provides a list of all transactions that have revenue amounts posted to suspense accounts as a result of running the Import AutoInvoice process. Includes information on transaction class, customer, transaction date, and transaction amount by business unit.
Potential Reconciling Items Report	Provides a list of journal items that may potentially post to incorrect general ledger accounts. Includes customer account number, payment number, transaction number, and credit and debit amounts by reporting level, reporting context, accounting date, and balancing segment.
Billing History Report	Provides a summarized history of transactions and activities against them by customer site for a specified date range. Includes information on original transaction amount, current balance due, sum of all payments applied to the transaction, total credit memo amounts against the transaction, and total adjustment amounts to the transaction.
Import AutoInvoice Execution Report	Report for the process that imports transactions from other source systems into Receivables. Includes information about both successful and rejected transactions by transaction type, customer, transaction number, and transaction date.
Print Adjustments Report	Prints information about adjustments associated with specified transactions and customers by business unit, adjustment number, and transaction number.
Transaction Details Report	Lists invoices, credit memos, debit memos, and chargebacks for review. Includes information about transaction header, transaction lines, sales credits, revenue accounts, account sets, and transaction flexfields by business unit, transaction number, and transaction type.
Automatic Receipt Creation and Remittance Execution Report	Report for the process that creates automatic receipts and receipt remittances in a batch. Includes information about automatically generated receipts, remitted receipts, and data validation errors by batch.
Bank Risk Report	Provides information about receipts that are currently at risk with the remittance bank. Includes information about the remittance batch, receipt, and receipt amount by business unit, remittance bank branch, and remittance bank account.
Clear Receipts Automatically Execution Report	Report for the process that clears receipts automatically. Includes information about the clearing of customer receipts by remittance bank account, receipt number, and customer.
Create Automatic Receipt Write-offs Execution Report	Report for the process that writes off unapplied amounts on selected receipts. Includes information about the receipt write-offs by currency, customer, receipt number, amount, and date.
Create Customer Statements Execution Report	Report for the process that generates customer statements. Prints customer billing information in a format presentable to the customer. Includes information on invoices, debit memos, chargebacks, payments, on-account credits, credit memos, adjustments, and past due information.
Customer Account Status Report	Provides a list of customer open items and the total balance due based on customer account status for the specified ledger currency.
Customer Balances Revaluation Report	Displays information related to the difference between the original customer balance and the revaluated balance for manually adjusting the general ledger. Includes the customer balance and the open items that make up that balance by business unit, revaluation period, and customer.
Document Number Audit Report	Provides a list of document numbers assigned to transactions, adjustments, and receipts to help identify missing document numbers for a business unit, document sequence name, and document number range. Includes information about the status, customer, currency, and amount of the transactions, adjustments, and receipts.
Format Automatic Receipts Report	Prints automatic receipts in a specified receipt batch so that they can be sent to customers for confirmation. Includes receipt number, receipt date, currency, and the transactions applied to each receipt.
Generate Late Charges Report	Prints information on late charges for transactions that are overdue or have late payments by batch name. Includes transaction number, due date, and overdue amount of transactions.
Process Receipts Through Lockbox Execution Report	Report for the process that creates receipts for payments made through lockbox. Includes information on lockbox receipts and data validation errors for each transmission from the bank.
Receipts Days Late Analysis Report	Provides the cost of late customer payments by calculating weighted average days late for each customer. Includes information about the transaction number, transaction type, due date, receipt number, receipt days late, and receipt weighted days late by business unit, customer, transaction number, and collector.
Receipts Awaiting Bank Clearance Report	Provides a list of receipts waiting to be cleared by the remittance bank. Includes information about the remittance bank account name, remittance batch date, maturity date, receipt number and receipt amount by business unit, maturity date, and currency.
Receipts Awaiting Remittance Report	Provides a list of receipts waiting to be remitted to the bank. Includes information about the remittance bank account name, maturity date, receipt number, and receipt amount by business unit, remittance bank account, maturity date, and currency.
Receivables Aging by General Ledger Account Report	Provides information about outstanding receivables balances by general ledger account as of a specific date. Includes information about customer, transaction number, due date, and outstanding amount by balancing segment, transaction as-of date, aging buckets, currency, and customer.
Receivables Open Items Revaluation Report	Displays the amount needed to manually adjust general ledger account balances to reflect the difference between the original and revalued customer open items. Includes information about transaction number, due date, currency, open original amount, conversion rate, open ledger currency amount, revaluation rate, and revaluation open amount by business unit, revaluation period, conversion rate type and balancing segment.
Receivables Projected Gains and Losses Report	Compares the revalued amount of foreign currency transactions with the entered amount and prints the projected unrealized gain or loss. Includes information about the currency, entered amount, ledger currency amount, revaluation rate, and the revaluation gain and loss by business unit, ledger currency, customer, and transaction number.
Recognize Revenue Execution Report	Report for the process that recognizes revenue and creates revenue distributions for transactions that use invoicing and revenue scheduling rules. Includes information about revenue accounting distributions and unprocessed or partially processed transactions for customer billing.
Reversal Status Report	Provides information about the status of automatic receipt reversals processed for a settlement batch. Includes the receipt date, receipt number, receipt amount, reversal reason code, and a description of automatic receipt reversals that were unsuccessful.
Automatic Bills Receivable Remittance Execution Report	Report for the process that creates a bills receivable remittance from bills receivable. Provides the details of bills receivable remitted to the bank to initiate collection from customers.
Automatic Bills Receivable Transactions Batch Report	Report for the process that creates bills receivable from transactions. Lists the transactions assigned to each bill receivable.
Close Matured Bills Receivable Execution Report	Report for the process that creates and applies receipts for standard remitted bills receivable, and applies receipts and eliminates risk on bills receivable factored with recourse. Lists the changes to each bill receivable and shows all receipts that were cleared by the process run.
Print Bills Receivable Report	Prints bills receivable either individually, belonging to a bills receivable batch, or belonging to a bills receivable remittance batch.
Prepare Receivables to General Ledger Reconciliation	Extracts and prepares transaction and accounting information for reconciling Receivables to the General Ledger. You must run this process before you can use the Receivables to General Ledger Reconciliation Report.
Receivables to General Ledger Reconciliation Report	Provides both summary and detailed reconciliation of receivables data to the general ledger. The summary report displays receivables and accounting beginning and ending balances, as well as summarized activity for the period and how this activity was accounted. The detail reports display the real-time details that make up balances from the summary report, and indicate potential causes for differences between actual and reconciling amounts.
Netting Settlement Letter	Prints a letter that provides details of Payables and Receivables transactions in a netting settlement.
Netting Reversal Letter	Prints a letter that provides details of Payables and Receivables reversed transactions in a netting settlement.
Netting Settlement Report	Lists the Payables and Receivables transactions belonging to a specific netting settlement in PDF format.
Netting Settlement Listing	Lists the Payables and Receivables transactions belonging to a specific netting settlement in spreadsheet format.