Oracle Applications Blog

The TCA party model is being used to model banks and bank branches as parties with the associated attributes of Relationships, Address, Contact and Locations. The TCA tables used by Cash Management for modeling Banks and Bank Branches are listed below: HZ_PARTIES - Bank, Bank Branch, Account attribute, Contact Person. HZ_RELATIONSHIPS - Storing Relationships HZ_RELATIONSHIP_TYPES - Storing Relationship Type HZ_ORG_CONTACTS - Stores the contact titles HZ_ORG_CONTACT_ROLES - Stores the contact purpose or role HZ_CONTACT_POINTS - Contact detail and contact point HZ_PARTY_SITES - Stores Party Site HZ_LOCATIONS - Stores Address HZ_ORGANIZATION_PROFILES - Store additional attributes of banks and bank branches Cash Management Tables - CE_BANK_ACCOUNT - Stores Bank account attribute CE_BANK_ACCOUNT_USES_ALL- Stores the bank account attributes specific to OU and LE CE_GL_ACCOUNTS_CCID - The accounting data pertaining to the bank account use will be stored in the table. Extern...

ü   To find the patch set level of an application (module): 1.        Get the application ID select application_id , application_name from fnd_application_tl where application_name like <application_name> for eg. if Application Name is ‘Oracle Quoting’ select * from fnd_application_tl where application_name like ‘%Oracle Quoting%’ 2.        Get the Patch Set Level for the application (field: PATCH_LEVEL). Select * from fnd_product_installations where application_id = <application_id> For e.g. Application_id of Oracle Quoting is 880 Select * from fnd_product_installations where application_id = 880 ü   Finding all installed applications The query to be used for obtaining this information is as follows: SELECT application_name, application_short_name, decode (status, ‘I’, ‘Installed’, ‘S’, ‘Shared’, ‘Not Installed’) status, a.application_id FROM fnd_application_all_view a, f...

Status control describes whether certain status attributes have default values that appear when you assign a status code to an item, and whether status codes control those attribute values after the defaults are assigned to an item. The status attributes are: Status Attribute Item Defining Attribute Functional Area / Oracle Product Functionality Stockable Inventory Item Inventory Enables you to store the item in an asset subinventory. Transactable Inventory Item Inventory, Order Management, Purchasing, Work in Process Enables you to transact the item in Oracle Inventory, Oracle Order Management, Oracle Purchasing and Oracle Work in Process. Purchasable Purchased Purchasing Enables you to place the item on a purchase order. Build in WIP NA Work in Process Enables you to build the item on a discrete job, a repetitive schedule, or both. Customer Orders Enabled Customer Ordered Item Order Management Enables you to place the item on a sales order. Internal Orders Enabled Internal...