Customer List in Oracle Apps R12.1.3

SELECT hp.party_name Customer_Name
     , hca.account_number Customer_Number
     , hl.address1
     , hl.address2
     , hl.address3
     , hl.city
     , hl.state
     , hl.postal_code ZIP
     , hl.country
FROM   hz_parties hp
     , hz_party_sites hps
     , hz_locations hl
     , hz_cust_accounts_all hca
     , hz_cust_acct_sites_all hcsa
     , hz_cust_site_uses_all hcsu
WHERE  hp.party_id = hps.party_id
AND    hps.location_id = hl.location_id
AND    hp.party_id = hca.party_id
AND    hcsa.party_site_id = hps.party_site_id
AND    hcsu.cust_acct_site_id = hcsa.cust_acct_site_id
AND    hca.cust_account_id = hcsa.cust_account_id
AND    hp.status = 'A'
AND    hps.status = 'A';

Oracle Linux 6.5 MPEG 4 AAC DECODER FOR PLAYING MOVIE PLAYER RPM

for x64:
yum install http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm

for x86:
yum install http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.3-1.el6.rf.i686.rpm

Then:
rpm --import http://apt.sw.be/RPM-GPG-KEY.dag.txt

For instance:

yum install http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm
rpm --import http://apt.sw.be/RPM-GPG-KEY.dag.txt
yum search mpg

mpg123-devel.x86_64 : Header files, libraries and development documentation for mpg123.
perl-Audio-Play-MPG123.noarch : Frontend to mpg123
mpg123.x86_64 : MPEG audio player
mpgtx.x86_64 : MPEG ToolboX

If anyone's looking for future updates: AdditionalResources/Repositories/RPMForge - CentOS Wiki or RepoForge Project

adoacorectl.sh , adformsctl.sh , adoafmctl.sh – exiting with status 204

http://appsdbaworkshop.blogspot.in/2012/11/adoacorectlsh-exiting-with-status-204.html

[oracle@r12ebs ~]$ ls
11107_DB.env  1122.env  APPSVIS_r12ebs.env  Desktop  Downloads  jre1.7.0_67  oradiag_oracle  oraInventory  utlu112i.sql  VIS_DB.env
[oracle@r12ebs ~]$ . ./APPSVIS_r12ebs.env
[oracle@r12ebs ~]$ cd $ORA_CONFIG_HOME/10.1.3/j2ee/oacore
[oracle@r12ebs oacore]$ ls
application-deployments  config  persistence  tldcache
[oracle@r12ebs oacore]$ rm -rf persistence/
[oracle@r12ebs oacore]$ ls
application-deployments  config  tldcache
[oracle@r12ebs oacore]$  adopmnctl.sh status

You are running adopmnctl.sh version 120.6.12010000.4

Checking status of OPMN managed processes...
Error connecting to OPMN (is it running?): No route to host

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /u01/oracle/VIS/inst/apps/VIS_r12ebs/logs/appl/admin/log/adopmnctl.txt for more information ... 

[oracle@r12ebs oacore]$ mkdir persistence
[oracle@r12ebs oacore]$ cd ..
[oracle@r12ebs j2ee]$ ls
forms  forms-c4ws  oacore  oafm
[oracle@r12ebs j2ee]$ cd oafm/
[oracle@r12ebs oafm]$ ls
application-deployments  config  log  persistence  tldcache
[oracle@r12ebs oafm]$ rm -rf persistence/
[oracle@r12ebs oafm]$ mkdir persistence
[oracle@r12ebs oafm]$ oacorectl.sh status
bash: oacorectl.sh: command not found
[oracle@r12ebs oafm]$ cd ..
[oracle@r12ebs j2ee]$ ls
forms  forms-c4ws  oacore  oafm
[oracle@r12ebs j2ee]$ cd forms
[oracle@r12ebs forms]$ ls
application-deployments  config  persistence  tldcache
[oracle@r12ebs forms]$ rm -rf persistence/
[oracle@r12ebs forms]$ mkdir persistence
[oracle@r12ebs forms]$ ls
application-deployments  config  persistence  tldcache
[oracle@r12ebs forms]$ cd persistence/
[oracle@r12ebs persistence]$ ls
[oracle@r12ebs persistence]$ adformsctl.sh status

You are running adformsctl.sh  version 120.16.12010000.3

Checking status of OPMN managed FORMS OC4J instance ...
Error connecting to OPMN (is it running?): No route to host

adformsctl.sh: exiting with status 0

adformsctl.sh: check the logfile /u01/oracle/VIS/inst/apps/VIS_r12ebs/logs/appl/admin/log/adformsctl.txt for more information ... 

[oracle@r12ebs persistence]$ oafmctl.sh status
bash: oafmctl.sh: command not found
[oracle@r12ebs persistence]$ adoafmctl.sh ststus

You are running adoafmctl.sh version 120.8


adoafmctl.sh: exiting with status 1

adoafmctl.sh: check the logfile /u01/oracle/VIS/inst/apps/VIS_r12ebs/logs/appl/admin/log/adoafmctl.txt for more information ... 

[oracle@r12ebs persistence]$ cd ..
[oracle@r12ebs forms]$ ls
application-deployments  config  persistence  tldcache
[oracle@r12ebs forms]$ cd ..
[oracle@r12ebs j2ee]$ ls
forms  forms-c4ws  oacore  oafm
[oracle@r12ebs j2ee]$ cd oafm/
[oracle@r12ebs oafm]$ ls
application-deployments  config  log  persistence  tldcache
[oracle@r12ebs oafm]$ cd persistence/
[oracle@r12ebs persistence]$ ls
[oracle@r12ebs persistence]$ cd ..
[oracle@r12ebs oafm]$ ls
application-deployments  config  log  persistence  tldcache
[oracle@r12ebs oafm]$ rm persistence/
rm: cannot remove `persistence/': Is a directory
[oracle@r12ebs oafm]$ rm -rf persistence/
[oracle@r12ebs oafm]$ mkdir persistence
[oracle@r12ebs oafm]$ adoafmctl.sh status

You are running adoafmctl.sh version 120.8

Checking status of OPMN managed OAFM OC4J instance ...
Error connecting to OPMN (is it running?): No route to host

adoafmctl.sh: exiting with status 0

adoafmctl.sh: check the logfile /u01/oracle/VIS/inst/apps/VIS_r12ebs/logs/appl/admin/log/adoafmctl.txt for more information ... 

Oracle Apps R12 Techno - Functional: Oracle 10g Installation Guide

Oracle Apps R12 Techno - Functional: Oracle 10g Installation Guide: http://students.heinz.cmu.edu/docs/Oracle_10g_Installation.pdf

Oracle 10g Installation Guide

http://students.heinz.cmu.edu/docs/Oracle_10g_Installation.pdf

Define Subinventory

Define Subinventory:

Subinventories are unique physical or logical separations of material inventory, such as raw inventory, 

finished goods, or defective material. All material within an organization is held in a subinventory therefore, 

you must define at least one subinventory.

Navigation : Inventory Responsini

Define Grouping Rules in Oralce apps

Define Grouping Rules

Navigation :Accoutions Recivables Manager -->setup -->Transactions -->AutoInvoice-->Grouping Rules

Grouping rules specify attributes that must be identical for lines to be created as one transaction. Grouping rules always include the mandatory attributes, and to this is added optional attributes that you define in the grouping rule.

Grouping rules tell AutoInvoice how you want to group records in the interface tables into invoices, debit memos, and credit memos. Grouping rules specify which attributes must be identical for lines to appear on the same transaction.

In the figure below, the grouping rule specifies that items must have the same currency, Bill-To address, and Order Type to appear on the same invoice. Items A and B share the same currency and Order Type, so they appear on the same invoice (Invoice 1). Item C has the same currency as A and B, but it has a different order type, so it appears on its own invoice (Invoice 2). Items D and E share the same currency and Order Type, so they appear on the same invoice (Invoice 3).

Responsibility: Receivables Manager
Navigation: Setup > Transactions > AutoInvoice > Grouping Rules