ePrivacy and GPDR Cookie Consent by Cookie Consent

Saturday, December 19, 2020

What is P2P Cycle ?

P2P Cycle


Create Requisition: The requisition is nothing but a formal request to buy something (like Inventory material, office supplies etc.) needed for the enterprise. Only an employee can create one. 

There are two types of requisitions: 

Internal Requisition: Internal requisitions provide the mechanism for requesting and transferring material from one inventory to another inventory. 

 Purchase requisition: Unlike Internal requisitions, Purchase requisitions are used for requesting material from suppliers. Create Purchase Order: 

 There are 4 types of Purchase Orders: 

1. Standard PO: A Standard PO is created for one–time purchase of various items.

2. Planned PO: A Planned PO is a long–term agreement committing to buy items or services from a single source. You must specify tentative delivery schedules and all details for goods or services that you want to buy, including charge account, quantities, and estimated cost. 

3. Blanket agreement: A Blanket PO is created when you know the detail of the goods or services you plan to buy from a specific supplier in a period, but you do not know the detail of your delivery schedules. 

4. Contract agreement: Contract purchase agreements are created with your suppliers to agree on specific terms and conditions without indicating the goods and services that you will be purchasing. 

Types Of PO In Short :

STANDARD PO - ONE TIME PO 

PLANNED - LONG TERM AGREEMENT WITH SINGLE VENDOR - TENTATIVE SCHEDULES ON DELIVERY 

BLANKET - SPECIFIC SUPPLIER, NO DETAILS ON DELIVERY 

CONTRACT - AGREEMENT WITH SUPPLIER, WITHOUT KNOWING GOODS 

 Create Receipt: Create a receipt to receive the items in the Purchase Order. Create an Invoice in Payables: Once the goods are received, it’s time to pay the vendor for the goods purchased and hence the invoices are created. Making a Payment: Transfer to General Ledger:

What is ERP ?

What is ERP? The acronym ERP stands for enterprise resource planning. It refers to the systems and software packages used by organizations to manage day-to-day business activities, such as accounting, procurement, project management and manufacturing. ERP systems tie together and define a lot of business processes and enable the flow of data between them. By collecting an organization’s shared transactional data from multiple sources, ERP systems eliminate data duplication and provide data integrity with a “single source of truth.”
Examples: PeopleSoft , Oracle Fusion , SAP , JD Edwards , EBS

Monday, March 18, 2019

Customer related tables in Oracle R12

HZ_PARTIES :
This table holds important information related to party like party name, party number and party type. Party type can be organization , person or relationship between organization and person. The primary key of the table is PARTY_ID.

HZ_CUST_ACCOUNTS

This table hold information related to customer account like account_number. The primary key in this table is cust_account_id. We can join this table with HZ_PARTIES using partying.

HZ_LOCATIONS:
This table holds the address information related to party . Important fields in this table are address, address2 , address3 , city, state, county , country, address_style. Primary key in this table location_id .

HZ_PARTY_SITES
HZ_PARTY_SITE_USES_ALL
HZ_CUST_ACCT_SITES_ALL
Hz_CUST_SITE_USES_ALL
HZ_RELATIONSHIPS
HZ_CONTACT_POINTS
HZ_CUST_ACCOUNT_ROLES
HZ_CUSTOMER_PROFILES
HZ_CUST_PROFILE_CLASSES

Query:

Select hp.party_name,hp.party_id,hca.account_number
,hca.cust_account_id
,hl.address1
, hl.address2
, hl.city
, hl.country
,hl.state
,hps.party_site_id
From
HZ_PARTIES hp
, HZ_CUST_ACCOUNTS hca
, HZ_LOCATIONS hl
, HZ_PARTY_SITES hps
Where 1=1
and hp.party_id=hca.party_id
and hp.party_id=hps.party_id
and hl.location_id=hps.location_id

Order management tables in Oracle R12

Order Management:

OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
OE_ORDER_HOLDS_ALL
OE_PRICE_ADJUSTMENTS
OE_TRANSACTION_TYPES_ALL
OE_TRANSACTION_TYPES_TL
WSH_DELIVERY_DETAILS
WSH_DELIVERY_ASSIGNMENTS
OE_ORDER_SOURCES
WSH_NEW_DELIVERIES
Wsh_carriers


PRICING TABLES:

QP_LIST_HEADERS_B
QP_LIST_LINES
QP_QUALIFIERS

Interview questions on Oracle Apps PL/SQL

1)Difference between truncate , delete and drop?

2)Types of cursors?
Implicit cursors
Explicit cursors

3)what is user defined and pre defined exceptions?

4)difference between view and materialized view?

5)what are the cursor attributes?

%NOTFOUND
%FOUND
%ROWCOUNT
%ISOPEN

6)explain few predefined exceptions in Oracle?

TOO_MANY_ROWS
NO_DATA_FOUND
INVALID_CURSOR
ZERO_DIVIDE

7)what is the purpose of bulk collect?

8)explain difference between case and decode function in Oracle

9) explain group by and having in Oracle ?

10)difference between union and union all?

11)What are aggregate functions and character functions in Oracle ?

12) what is the purpose of explain plan in sql developer?
Explain plan is used during performance tuning of sql Query. Explain plan explain the cost of the query, any full table scan.

13)explain different constraints in Oracle ?
NOT NULL
UNIQUE
PRIMARY KEY
FORIEGN KEY
CHECK

14)what is the difference between fast refresh and complete refresh in materialized views

15)how to refresh a materialized view in Oracle.

16) what is the purpose of trigger and different types of triggers in Oracle?

17)what is mutating error ?

18)what is pragma autonomous transaction ?

19)Difference between pre Query and post Query in Oracle Forms?

20)Difference between form personalisation and custom pll?

21)Difference between request group and request set in Oracle apps?

22)Have you worked on developing concurrent program? Explain complete process?

24)How to generate trace file for concurrent program?

25)how to call concurrent program from plsql block?

26)what are mandatory parameters for package which called from concurrent program?

27)Explain xml bursting concept in Oracle apps?

28)what is the purpose of utl_file?

29)what is the link between concurrent program and xml publisher template and data definition?

30)which will be fired first whether form personalisation or custom pll?

First form personalisation will be fired.

31)explain KFF and DFF in Oracle apps ?

32)Explain different triggers in Oracle RDF Reports?

33)How to display messages in rdf reports?

SRW.MESSAGE()

34)What are the profile options we need to check to enable Oaf personalisation?

35)What is difference between form or function level in form personalisation?

36)what are different types of valuesets in Oracle apps?

37)what are the tables which store data definition and data templates information in Oracle apps?