Application Object Library(AOL)

1.     Creation of USER:

NAVIGATION: SYSTEM ADMINISTRATOR à SECURITY à USER à DEFINE

CREATE A NEW USER:

Enter user name, password and Re-enter the password. 

QUERIES TO GET BOM DETAILS || ITEM DETAILS || SOURCING RULE|| Sales Order Details|| BOM For Items || Bom Resource|| Routing Details

----------Query For Sales order Details-----------

SELECT    OOHA.HEADER_ID

                ,OOHA.ORDER_NUMBER

               , OOLA.LINE_ID

              , OOLA.ORDERED_ITEM

              ,OOLA.QUANTITY

      ,OOLA.UNIT_PRICE

              , OOLA.ORG_ID

             , MSIB.ORGANIZATION_ID

            , MSIB.SEGMENT1

            , MSIB.INVENTORY_ITEM_ID   

  FROM OE_ORDER_HEADERS_ALL OOHA

             , OE_ORDER_LINES_ALL OOLA

    , MTL_SYSTEM_ITEMS_B MSIB

    , MTL_PARAMETERS MP

WHERE 1=1

  AND OOHA.HEADER_ID = OOLA.HEADER_ID

  AND OOLA.ORDERED_ITEM = MSIB.SEGMENT1

  AND MSIB.ORGANIZATION_ID=MP.ORGANIZATION_ID;

Creation of XML Report | XML Report | XML Publisher Report |XML P Report | BI Publisher | Oracle Apps R12 | Oracle EBS | EBS

                                                                  XML REPORT

An XML report definition typically refers to a structured document that outlines the layout, structure, and content of a report using XML (extensible Markup Language). XML is a popular format for defining such structures due to its flexibility and ease of parsing.

The specifics of an XML report definition can vary widely based on the reporting system or tool being used. Different systems might have their own XML schemas or structures to define reports.

In a generic sense, an XML report definition might include elements to describe:

1. Report Metadata: Information about the report, such as its title, author, description, creation date, etc.

PO Master Detailed Report in Oracle EBS | PO Master Detailed Report in Oracle Apps R12 | Purchasing | Purchase Order | XML | EBS | Oracle Apps R12 | Oracle EBS

 

PO MASTER DETAILED REPORT

 

Registration steps for Oracle Reports

1.   Once we get the Requirement from Business, develop a query in TOAD/SQL Developer.

2.   Once Query has been done, place the query in Data Model SQL Block

       3.   After Adding the Parameter in User Parameters tab and successfull compilation, save the report XXRBCSAMPLE.rdf as extension

     4.     Move the .rdf to Custom Top /reports/US Folder with Executable Permissions by Using WINSCP Tool

       5.     After Login to the Application,Switch to Application Developer--> Concurrent --> Executable, give name, Short Name, application would be Custom Top Application, type is Oracle Reports , Execution file name should be given .rdf name and Save the Changes

Block Structure & Variables in PL/SQL| Basics of PL/SQL | PL/SQL

 

Block & Variables

Q : What is Block?

A : It is a unit of code that is to declare a data operation and create a logical operation for database.

syntax:

Declare

Begin

End;

Declare:  Declare section means, we can write the variables.

Triggers in PL/SQL | BEFORE Triggers | AFTER Triggers | Row-Level Triggers | Statement-Level Triggers | Instead of Triggers | PL/SQL

 

Triggers

 

A collection of instructions that are automatically carried out (or "triggered") in reaction to specified occurrences on a given table or view is known as a trigger. 

 

Triggers are used in databases to maintain data integrity, carry out extra tasks, and enforce business rules. 

 

They can be programmed to run before or after particular events, such INSERT, UPDATE, and DELETE.

 

          Here is a general definition of triggers in PL/SQL:

 

SQL Indexes | Types of indexes | Creating an Index | Dropping an Index | OLAP | LOCKS | Basics of Oracle SQL | SQL

 

INDEXES

What is an Index?

• An index is a schema object.
• Is used by the Oracle server to speed up the retrieval of rows by using a pointer.
• Can reduce disk I/O by using a rapid path access method to locate data quickly. 
•  Is independent of the table it indexes. 
•  Is used and maintained automatically by the Oracle server.

Note: When you drop a table, corresponding indexes are also dropped.

LISTAGG Funcation | Basics of Oracle SQL | Oracle SQL | SQL

 

Listagg

What is the Listagg?

The LISTAGG function is used to aggregate a set of string values within a group into a single string by appending the string-expression values based on the order that's specified in the 'WITHIN GROUP' clause.

As a single-set aggregate function, LISTAGG operates on all rows and returns a single output row.