Know Oracle – Full list of Articles till date



Shivmohan Purohit's Oracle ERP BLOG

To generate comma or pipe delimited output for tools such as Excel, Access, and so on while spooling from SQL*Plus, use settings from SQL*Plus such as:


SET COLSEP ,

Or

SET COLSEP |

Example:

set pages 0 feed off
set colsep ,
select
object_name,
object_type,
status,
created
from all_objects
where owner='PUBLIC'
and rownum < 10 /* 9 rows for Sample Output */
;

Output:

ALL_ALL_TABLES ,SYNONYM ,VALID ,01-APR-2004
ALL_ARGUMENTS ,SYNONYM ,VALID ,01-APR-2004
ALL_ASSOCIATIONS ,SYNONYM ,VALID ,01-APR-2004
ALL_CATALOG ,SYNONYM ,VALID ,01-APR-2004
ALL_CLUSTERS ,SYNONYM ,VALID ,01-APR-2004
ALL_CLUSTER_HASH_EXPRESSIONS ,SYNONYM ,VALID ,01-APR-2004
ALL_COLL_TYPES ,SYNONYM ,VALID ,01-APR-2004
ALL_COL_COMMENTS ,SYNONYM ,VALID ,01-APR-2004
ALL_COL_PRIVS ,SYNONYM ,VALID ,01-APR-2004

For pipe delimited output:

set colsep |
select
object_name,
object_type,
status,
created
from all_objects
where owner='PUBLIC'
and rownum < 10 /* 9 rows for Sample Output */
;

Output:

ALL_ALL_TABLES |SYNONYM |VALID |01-APR-2004 ALL_ARGUMENTS |SYNONYM |VALID |01-APR-2004 ALL_ASSOCIATIONS |SYNONYM |VALID |01-APR-2004 ALL_CATALOG |SYNONYM |VALID |01-APR-2004 ALL_CLUSTERS |SYNONYM |VALID |01-APR-2004 ALL_CLUSTER_HASH_EXPRESSIONS…

View original post 85 more words

Oracle R12 : Receivables : Party / Accounts / Site – More about customer definition


Confused by the Customer Form in Release 12??  Read on, to get some insight into the evolution of this screen, and how it links in with Trading Community Architecture.

Historically, the customer data model was owned by Oracle Receivables (AR).  However, as the data model changed and more complex relationships and attributes had to be tracked and monitored, the Trading Community Architecture (TCA) product was created.  All applications within the E-Business suite that require interaction with a customer integrate with TCA.

Customer information is no longer stored in the individual applications but rather in a central repository/registry maintained within TCA.  It is important to understand the following entities/concepts stored in TCA:

Party: A party is an entity with whom you can have a potential business relationship.  A party can be either a Person or an Organization.  The Party entity is completely independent of any business relationship; this means that a Party can exist even if you have no transactions with it.   The Party is the “umbrella” entity under which you capture all other attributes listed below.

Customer: A customer is a party with whom you have an existing business relationship.  From an AR perspective, you can simplify the concepts by thinking of a Customer as a Party. This definition however does not apply to all other applications. In the Oracle Receivables Customer form, the information displayed at the Customer level is from TCA’s Party information record.

Customer Account (also called Account): An account contains information about how you transact business with a particular customer.  You can create multiple accounts for a customer.  When you create invoices and receipts you associate it to a particular Account of a Customer.

Location: A Location is an address.  It is a point in space, typically identified by a street number, a street name, a city, a state or province, a country.  A location is independent of what it is used for – you do not associate a purpose to a location.

Party Site: A Party Site is associated to a Party.  It is the location where a party is physically located.  When defining sites for a Party, only one can be an identifying address.  However, you can define other party sites associated to a party. You can define purposes/usage for Party Sites.

Account Site: An Account Site is associated to a Customer Account. It is the location associated to the account you are transacting business with. You can define business purposes (also called site uses) for an Account site

Oracle R12 : AP : AR : How To Create A Customer And A Supplier Under A Single Party


Here are the steps that you should follow to create a customer account and supplier account under one party.

Note:  You have to setup the profile option ‘AR: Show parties without Accounts in DQM’ to Yes before you can try the below solution.

STEP 1 – Log in to Payables application and create a new supplier. This will create a new party record in HZ_PARTIES which is linked to the supplier record in vendors table.

STEP 2 – Log in to Receivables application and go to Customer UI. Here query the party by name you used when creating the supplier in step 1. The search results should show the party created.

STEP 3 – Select the party in question and click on the button ‘Create Account’ and continue to create the customer account under the same party.

.