TRX_NUMBER Throug will get customer detail and order details in oracle apps R12.1.3

 Accounts Recevibles Based on TRX_NUMBER, through will get customer detail and order details in oracle apps R12.1.3


SELECT   hp.party_id,
         hp.party_number,
         hp.party_name,
         hp.status active,
         hp.address1 address1,
         hp.address2 address2,
         hp.city     city,
         hp.county   county,
         hp.country  country,
         hp.postal_code postalcode,
         rcta.trx_number,
         rctta.name,
         apsca.trx_date
FROM     HZ_PARTIES HP,
                 HZ_CUST_ACCOUNTS_ALL HCAA,
                 HZ_CUST_ACCT_SITES_ALL HCASA,
                  RA_CUSTOMER_TRX_ALL RCTA,
                   RA_CUST_TRX_TYPES_ALL RCTTA,
                  AR_PAYMENT_SCHEDULES_ALL APSCA
WHERE    hp.party_id = hcaa.party_id
AND      hcaa.cust_account_id = hcasa.cust_account_id
AND      hcaa.cust_account_id = rcta.bill_to_customer_id
AND      rcta.cust_trx_type_id = rctta.cust_trx_type_id
AND      apsca.customer_trx_id = rcta.customer_trx_id
AND      hcaa.party_id ='1048'
AND      rcta.trx_number ='2428'

Oracle Apps Receivables (AR) Tables

Oracle Apps Receivables (AR) Tables 

TRANSACTIONS TABLES
===========================================================
SELECT * FROM RA_CUSTOMER_TRX_ALL
SELECT * FROM RA_CUSTOMER_TRX_LINES_ALL
SELECT * FROM RA_CUST_TRX_TYPES_ALL
SELECT * FROM RA_CUST_TRX_LINE_GL_DIST_ALL
SELECT * FROM RA_TERMS
============================================================
RECEIPTS TABLES
============================================================
SELECT * FROM AR_RECEIPTS_ALL
SELECT * FROM AR_RECEIVABLE_APPLICATIONS_ALL
SELECT * FROM AR_CASH_RECEIPT_HISTORY_ALL
SELECT * FROM  AR_PAYMENT_SCHEDULES_ALL

Transactions
RA_CUSTOMER_TRX_ALL	Transaction Header table
RA_CUSTOMER_TRX_LINES_ALL	Transaction Lines table along with Tax lines.
RA_CUST_TRX_LINE_GL_DIST_ALL	Distribution for Transaction Lines
RA_CUST_TRX_LINE_SALESREPS_ALL	Salesrep information for Transaction Lines
Transaction Interface Tables
RA_INTERFACE_LINES_ALL	Transaction Lines interface
RA_INTERFACE_SALESCREDITS_ALL	Transaction Sales credit information
RA_INTERFACE_DISTRIBUTIONS_ALL	Transaction Distribution information
RA_INTERFACE_ERRORS_ALL	Transaction errors table
AR_PAYMENTS_INTERFACE_ALL	Interface table to import receipts
AR_INTERIM_CASH_RECEIPTS_ALL	Lockbox transfers the receipts that pass validation to the interim tables
AR_INTERIM_CASH_RCPT_LINES_ALL	Lockbox transfers the receipts that pass validation to the interim tables
Receipts tables
AR_CASH_RECEIPTS_ALL	Cash Receipt Header tables
AR_RECEIVABLE_APPLICATIONS_ALL	stores Receipt Application details
AR_PAYMENT_SCHEDULES_ALL	This table is updated when an activity occurs against an invoice, debit memo, chargeback, credit memo, on-account credit, bills receivable
AR_CASH_RECEIPT_HISTORY_ALL	This table stores all of the activity that is contained for the life cycle of a receipt. • Each row represents one step. • The status field for that row tells you which step the receipt has reached. • Possible statuses are Approved, Confirmed, Remitted, Cleared, and Reversed.
Customer Tables
HZ_PARTIES	A party is an entity that can enter into a business relationship.
HZ_CUST_ACCOUNTS	This table stores information about customer/financial relationships established between a Party and the deploying company.
HZ_PARTY_SITES	This table links a party (HZ_PARTIES) and a location (HZ_LOCATIONS) and stores location-Specific party information such as a person’s mail stops at their work address.
HZ_CUST_ACCT_SITES_ALL	This table stores information about customer/financial account sites information.
HZ_CUST_SITE_USES_ALL	This table stores information about the business purposes assigned to a customer account site
HZ_LOCATIONS	A location is a point in geographical space described by an address and/or geographical Indicators such as latitude or longitude.
Setup tables
RA_CUST_TRX_TYPES_ALL	This table stores information about each transaction type for all classes of transactions, for example, invoices, commitments, and credit memos.
AR_RECEIPT_CLASSES	This table stores the different receipt classes that you define.
AR_RECEIPT_METHODS	This table stores information about Payment Methods, receipt attributes that you define and assign to Receipt Classes to account for receipts and their applications

Inventory Item non Transactable query in oracle apps r12.1.3

 Inventory Item non Transactable query in oracle apps r12.1.3

SELECT   msib.segment1 item,
         msib.description,
         moq.subinventory_code,
         sum(moq.transaction_quantity) OHND_QTY,
         mp.organization_code,
         msib.primary_uom_code
FROM     MTL_SYSTEM_ITEMS_B MSIB,
         MTL_PARAMETERS MP,
         MTL_ONHAND_QUANTITIES MOQ
WHERE    1=1 --msib.segment1 = '70710FTOPAZ52'
AND      msib.inventory_item_id = moq.inventory_item_id
AND      msib.organization_id   = moq.organization_id
AND      mp.organization_code = :p_organization_code
AND                 msib.organization_id = mp.organization_id
AND                 msib.MTL_TRANSACTIONS_ENABLED_FLAG = 'N'
GROUP BY  msib.segment1,
                      msib.description,
                     mp.organization_code,
                    moq.subinventory_code,
                     msib.primary_uom_code
ORDER BY msib.segment1, mp.organization_code;

To find out Onhand quantity based on organization, and Subinventory Code:

To find out Onhand quantity based on organization, and Subinventory Code:


SELECT msib.segment1 ITEM_NAME,
       moq.inventory_item_id,
       moq.subinventory_code subinventory_code,
       mp.organization_code, 
       moq.organization_id,
       sum(moq.transaction_quantity)
FROM   MTL_ONHAND_QUANTITIES MOQ,
       MTL_SYSTEM_ITEMS_B MSIB,
       MTL_PARAMETERS MP
WHERE  msib.inventory_item_id = moq.inventory_item_id
AND    msib.organization_id = mp.organization_id
AND    msib.organization_id = moq.organization_id
AND    moq.organization_id = :p_organization_id 
GROUP BY msib.segment1,moq.inventory_item_id, moq.organization_id,moq.subinventory_code,mp.organization_code
ORDER BY msib.segment1, moq.organization_id,sum(moq.transaction_quantity);

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

Concurrent Program and Executable Details

SELECT b.user_concurrent_program_name, b.concurrent_program_name,
 APPLICATION_NAME,'$'||BASEPATH||'/'||'reports/US',
a.user_executable_name,
DECODE (a.execution_method_code,
'I', 'PL/SQL Stored Procedure',
'H', 'Host',
'S', 'Immediate',
'J', 'Java Stored Procedure',
'K', 'Java concurrent program',
'M', 'Multi Language Function',
'P', 'Oracle reports',
'B', 'Request Set Stage Function',
'A', 'Spawned',
'L', 'SQL*Loader',
'Q', 'SQL*Plus',
'E', 'Pearl concurrent Programm',
'Unkown Type'
) TYPE,
a.execution_file_name, a.execution_file_path, a.application_name,
c.basepath
FROM fnd_executables_form_v a,
fnd_concurrent_programs_vl b,
fnd_application c
WHERE a.application_id = c.application_id
AND a.executable_id = b.executable_id
AND a.application_id = b.application_id
AND a.executable_id > 4
AND b.user_concurrent_program_name LIKE '%Aging%';

Assigned user with respective responsibility

SELECT FURGA.USER_ID
, FU.USER_NAME
, FURGA.RESPONSIBILITY_ID
, FRTL.RESPONSIBILITY_NAME
, FURGA.RESPONSIBILITY_APPLICATION_ID
, FA.APPLICATION_SHORT_NAME
, FURGA.SECURITY_GROUP_ID
, FSG.SECURITY_GROUP_KEY
, FURGA.START_DATE
, FURGA.END_DATE
, FURGA.CREATED_BY
, FUCB.USER_NAME
, FURGA.CREATION_DATE
, FURGA.LAST_UPDATED_BY
, FULUB.USER_NAME
, FURGA.LAST_UPDATE_DATE
, FURGA.LAST_UPDATE_LOGIN
, FULUL.USER_NAME
FROM
FND_USER_RESP_GROUPS_ALL FURGA,
FND_USER FU,
FND_USER FUCB,
FND_USER FULUB,
FND_USER FULUL,
FND_APPLICATION FA,
FND_RESPONSIBILITY_TL FRTL,
FND_SECURITY_GROUPS FSG
WHERE
FURGA.USER_ID = FU.USER_ID (+)
AND FURGA.CREATED_BY = FUCB.USER_ID (+)
AND FURGA.LAST_UPDATED_BY = FULUB.USER_ID (+)
AND FURGA.LAST_UPDATE_LOGIN = FULUL.USER_ID (+)
AND FURGA.RESPONSIBILITY_APPLICATION_ID = FA.APPLICATION_ID (+)
AND FURGA.RESPONSIBILITY_ID = FRTL.RESPONSIBILITY_ID (+)
AND FRTL.LANGUAGE = 'US'
AND FURGA.SECURITY_GROUP_ID = FSG.SECURITY_GROUP_ID (+)
ORDER BY START_DATE;