Oracle EBS Functional Financials - Accounts Receivable setups - R12

 1. Oracle Receivables -> Setup -> System ->System Options 

   a. Receivable GL related setup

   b. Transaction and Customer-related setup

   c. Miscellaneous

   e.g., Vision Operations (USA)

   

2. Oracle Receivables -> Setup -> Transactions -> Transaction Types 

   a. Unit, Class, Transaction status, Invoice Type mapping

   b. Receivable Account GL 

   c. Revenue Account GL

   d. Tax Account GL 

   e. other GL setups

   e.g. Auto SRV CHG Invoice , BR - Drawee Issued

 

3. Oracle Receivables -> Setup -> Transactions -> Sources

   a. Transaction Source naming & Setup

   e.g. Intercompany, Manual Order Entry

4. Oracle Receivables -> Setup -> Transactions -> Memo Lines

   a. Standard Memo Lines ( Name, Type, Revenue Account definition)

5. Oracle Receivables -> Setup -> Transactions -> Accounting Rules 

   a. Type and Schedule 

6. Oracle Receivables -> Setup -> Transactions -> Payment Terms 

   a. Billing Cycle, Payment schedule, Amount, Discounts 

7. Oracle Receivables -> Setup -> Transactions -> AutoAccounting

   a. Operating Unit, Type and Segment setup

8. Oracle Receivables -> Setup -> Receipts -> Receivable Activities

   a. Operating Unit, Type, Accounting Mapping 

9. Oracle Receivables -> Setup -> Receipts -> Receipt Classes

   a. Collection Method, Remittance Method, Clearance Method mapping

   b. Remittance Banks and GL Account Mapping 

10. Oracle Receivables -> Setup -> Receipts -> Receipt Sources 

   a. Automatic & Manual, Batch numbering 

11. GL Super User Responsibility -> Setup -> Financials -> Flexfields -> Key -> Values

    a. Find Key Flexfield Segment (First Window)

       Application: General Ledger

       Title: GL Ledger FlexField

    b. Segment values ( Second Window)

Oracle Receivables Implementation Guide

https://docs.oracle.com/cd/E18727-01/doc.121/e13510/T447343T355914.htm

https://www.oracleerpappsguide.com/2013/01/r12-receivables-setups-ar-in-oracle-apps.html

BI Publisher Advance Features

 TO DECLARE/SET A VARIABLE VALUE:

-------------------------------

<?xdoxslt:set_variable($_XDOCTX, 'variable name', value)?>

<?xdoxslt:set_variable($_XDOCTX,’V_EMP’,0)?> 

TO PERFORM CALCULATIONS.

------------------------------------

<?xdoxslt:set_variable($_XDOCTX, 'x', xdoxslt:get_variable($_XDOCTX, 'x' + 1)?> 

This sets the value of variable 'x' to its original value plus 1, 

much like using "x = x + 1".

The $_XDOCTX specifies the global document context for the variables. 

In a multi-threaded environment there may be many transformations occurring 

at the same time, therefore the variable must be assigned to a single 

transformation.

<?xdoxslt:set_variable($_XDOCTX,’V_EMP’,xdoxslt:get_variable($_XDOCTX,’V_EMP’) + EMP)?>

TO RETRIEVE A VARIABLE VALUE:

----------------------------

<?xdoxslt:get_variable($_XDOCTX, 'variable name')?>

<?xdoxslt:get_variable($_XDOCTX,’V_EMP’)?>

IF THEN ELSE

-------------

<?xdofx:if EMP > 2  then ’Higher’

else

if EMP <2 then ’Lower’

else

’Equal’

end if?> 

ROW / COLUMN HIGHLIGHTING 

----------------------------

<?if@row:position() mod 2=0?> 

<xsl:attribute name="background-color" xdofo:ctx="incontext">green</xsl:attribute><?end if?>

EXTENDED SQL AND XSL FUNCTIONS

--------------------------------

<?xdofx:rpad(concat(FIRST_NAME,LAST_NAME),30, 'x')?>

Ref: Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher

https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-B39D756A-C54D-4C64-A822-DD2CFFC3A54E.htm#BIPRD3160

CREATION OF PAGE TOTAL ELEMENT

-------------------------------------------

<?add-page-total:TotalFieldName;'element'?>

Example:

<?add-page-total:totalemp;'EMP'?>

DISPLAYING PAGE TOTAL 

---------------------------------------

<?show-page-total:TotalFieldName;'number-format'?>

Example:

<?show-page-total:totalemp;$#,##0.00;($#,##0.00)?>

CREATING MULTIPLE OR COMPLEX HEADERS AND FOOTERS

--------------------------------------------------

If the template requires multiple headers and footers, then create them by using BI Publisher tags to define the body area of the report. You may also want to use this method if the header and footer contain complex objects that you want to place in form fields. When you define the body area, the elements occurring before the beginning of the body area compose the header. The elements occurring after the body area compose the footer.

Use the following tags to enclose the body area of the report:

<?start:body?>

<?end body?>

Use the tags either directly in the template, or in form fields.

The Payables Invoice Register contains a simple header and footer and therefore does not require the start body/end body tags. However, if you wanted to add another header to the template, define the body area.

To define the body area:

Insert <?start:body?> before the Suppliers group tag:

<?for-each:G_VENDOR_NAME?>

Insert <?end body?> after the Suppliers group closing tag:

<?end for-each?>

https://docs.oracle.com/cd/E29505_01/bi.1111/e22254/create_rtf_tmpl.htm#do_handf

https://www.youtube.com/watch?v=hzZoVsWTF8Q 

Serial, Sorting, Horizontal total, vertical total and Grand total in Oracle BI Publisher

 

ORACLE BI PUBLISHER

A. Please learn the steps of creating Matrix report from previous video

B. Now we will discuss about Position, Sorting, 

1. Position: 

<?position()?>

2. Sorting: 

<?sort:DNAME;'ascending'?><?DNAME?> 

<?sort:JOB;'ascending';data-type='text'?><?JOB?> 

3. Horizotal group Total 

<?sum(current-group()/EMP)?>

4. Vertical group Total

<?for-each-group@cell://G_DNAME;./JOB?>  

<?sum(current-group()/EMP)?>

5. Grant Total 

<?sum(EMP)?>

How to create Matrix report / Pivot Report using Oracle BI Publisher

 

How to create Matrix report / Pivot Report using Oracle BI Publisher

Step by step instruction:

1. Make data model using Oracle Reports Developer

2. Generate a XML output

3. Create a blank document in MSWord 

4. Load the XML file from BI Publisher tab

5. Create a simple report using the Table Wizard

6. Change the Properties of the column as per instruction

<?for-each-group:G_DNAME;./DNAME?><?variable@incontext:DNAME_;DNAME?>

<?for-each-group@column:G_DNAME;./JOB?> 

<?for-each-group@cell://G_DNAME;./JOB?><?if:count(current-group()[DNAME=$DNAME_])?><?end if?>

<?current-group()[DNAME=$DNAME_]/EMP?>

How to uninstall / completely remove Oracle 11g

Uninstall all Oracle components using the Oracle Universal Installer (OUI).

Run regedit.exe and delete the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE key. This contains registry entires for all Oracle products.

Delete any references to Oracle services left behind in the following part of the registry: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Ora* It should be pretty obvious which ones relate to Oracle.

Reboot your machine.

Delete the "C:\Oracle" directory, or whatever directory is your ORACLE_BASE.

Delete the "C:\Program Files\Oracle" directory.

Empty the contents of your "C:\temp" directory.

Empty your recycle bin.

Calling additional attention to some great comments that were left here:

Be careful when following anything listed here (above or below), as doing so may remove or damage any other Oracle-installed products.

For 64-bit Windows (x64), you need also to delete the HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE key from the registry.

Clean-up by removing any related shortcuts that were installed to the Start Menu.

Clean-up environment variables:

Consider removing %ORACLE_HOME%.

Remove any paths no longer needed from %PATH%.

This set of instructions happens to match an almost identical process that I had reverse-engineered myself over the years after a few messed-up Oracle installs, and has almost always met the need.

Note that even if the OUI is no longer available or doesn't work, simply following the remaining steps should still be sufficient.

https://stackoverflow.com/questions/8450726/how-to-uninstall-completely-remove-oracle-11g-client

How to exclude tables during import using impdp

 

How to exclude tables during import using impdp 

grant dba to labserp identified by labserp;

CREATE TABLESPACE LABSERP_TS
   DATAFILE 'LABSERP_TS.dbf'
    SIZE 100M
    REUSE
    AUTOEXTEND ON NEXT 10M ;

CREATE OR REPLACE DIRECTORY test_dir1 AS 'E:\personal\';

GRANT READ, WRITE ON DIRECTORY test_dir1 TO labserp;

impdp labserp/labserp  exclude=TABLE:\"IN (\'DO_AUDIT_DETAIL\', \'PR_DAY_WISE_ATTENDENCE_040720\', \'PR_DAY_WISE_ATTENDENCE_070720\', \'PR_DAY_WISE_ATTENDENCE_090720\', \'PR_DAY_WISE_ATTENDENCE_07073PM\', \'AC_DATA_LOG_BK\')\" directory=TEST_DIR1 dumpfile=expdp_28-07-Tue_23.00_PM.dmp logfile=impdpEMP_DEPT.log

Oracle EBS Vision Instance Installation on VirtualBox

A. 

Download and install VirtualBox There are possibilities of different versions based on your Operating System. Here we worked with VirtualBox-6.1.14-140239-Win

B. Download EBS Software

On the  Oracle Software Delivery Cloud page: https://edelivery.oracle.com/osdc/faces/SoftwareDelivery

1. Login with your credentials

2. Search by Oracle VM Virtual Appliance for Oracle E-Business Suite

3. Select Oracle VM Virtual Appliance for Oracle E-Business Suite 12.2.6

4. Continue in the Download Queue

5. Accept Licence & Download

6. A software for download will be downloaded name eg.Oracle_SSN_DLM_12130645.exe

7. Unzip All the files by any utility like winzip or 7zip etc.

8. Merge the unzip files with command prompt in the following way 

type Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.00 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.01 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.02 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.03 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.04 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.05 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.06 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.07 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.08 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.09 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.10 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.11 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.12 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.13 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.14 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.15 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.16 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.17 Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.18 > Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova

It takes at least 1 to 2 hours or even more based on your Processor/Memory to get the merged file.

9. Import Appliance

At this stage, you should have at least 400 gigabytes or the process aborts. You may need to delete the zip files to make room for the import.

10. 

Adjust RAM memory keep 30% for Main CPU. Also adjust Graphics controller to VMSVGA 

For Networking, you can attach Adapter as:

Bridged Adapter (the default setting)

NAT or Host-Only Adapter.

11. Start the VM

      Set the IP when it is prompted 

12. Login & Password reset

     

13. EBS demo Application install

At a certain point during the post-install process you will be prompted to:

select whether to add start or stop of the database and application tier processes to the OS boot script.

Enter VISION to configure the Vision Demo instance.

14. Step – 5 Access to E-Business suite VISION.

To access the EBS Application from your website you will have to make minor changes in the

Windows host file by:

Getting the IP address of the VM using ifconfig -a on the terminal.

Edit the file on your Windows, add a line in c:\windows\system32\drivers\etc\hosts

(You may have to temporarily change permissions if you do have Administrator privileges)

<IP address> apps.example.com apps

Use an SSH client, like Putty to ssh to the file system and explore the operating system installation.

To Start the application

/u01/install/APPS/fs1/inst/apps/EBSDB_apps/admin/scripts

./adstrtal.sh apps/apps

Use http://apps.example.com:8000 to access EBS Application

The default passwords are:

SYSADMIN/sysadmin

demo/demo

apps/apps

sys/manager

system/manager

WebLogic/welcome1

All these passwords could be changed but you can keep them as they are until you get used to the Apps.

But if you feel the need to change, connect to the VM through SSH as oracle:

Change directory to:  /u01/install/APPS/scripts

You will find a script to change the password for Sysadmin and for the Demo users.

[oracle@apps scripts]$ ./enableSYSADMIN.sh

[oracle@apps scripts]$ ./enableDEMOusers.sh

 

If you want to access the db 

export ORACLE_BASE=/u01/install/APPS

export ORACLE_HOME=/u01/install/APPS/12.1.0

export PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_SID=EBSDB

use sys as sysdba and enter the EBSDB schema.