• RELEVANCY SCORE 4.59

    DB:4.59:What Are The Payment Tables In R12? m1





    Hello,

    What are the payments tables in R12,

    I need retrieve the below columns from tables in R12

    Payment_id,
    Invoice_num, Invoice_amount
    Payment_num, Payment_amount

    please help us,

    Thanks,
    Raj

    DB:4.59:What Are The Payment Tables In R12? m1

    Hello,

    Thanks for your helping,

    1). DUNS_NUMBER
    2). JP_DUNS_NUMBER
    3). CHECK_AMOUNT
    4). CHECK_NUMBER
    5). BANK_NUMBER
    6). DISB_BANK_ACCT
    7). COMPANY,
    8). VENDOR_NAME
    9). CMP_IDF

    Please help me to get this columns in payments

    If you know anything about NACHA Payment Format report customization in R12 please help me, Im struggling to customize this report in R12

    Thanx,
    -- Raj --

  • RELEVANCY SCORE 4.32

    DB:4.32:Need Help On Erp R12 Reporting az





    Hi,

    Any body have an idea about ERP R12 reporting on Error Tables in 10 g.

    Thanks

    DB:4.32:Need Help On Erp R12 Reporting az

    Hi,

    Any body have an idea about ERP R12 reporting on Error Tables in 10 g.

    Thanks

  • RELEVANCY SCORE 4.19

    DB:4.19:Absolute Tables 3z





    Hi tech guys,

    we are trying to upgrade oracle applications 11i to r12. Now we need absolute tables*
    under Manufacturying, Distibution and Finance all modules.

    I tried to search in google and other oracle sites.But i couldn't get the concept of Absolute tables*.

    Please help me how to find these absolute tables*.

    Thanks in advance,
    Giri

    DB:4.19:Absolute Tables 3z

    808699 wrote:
    Hi tech guys,

    we are trying to upgrade oracle applications 11i to r12. Now we need absolute tables*
    under Manufacturying, Distibution and Finance all modules.

    I tried to search in google and other oracle sites.But i couldn't get the concept of Absolute tables*.

    Please help me how to find these absolute tables*.Please also see.

    Identifying Data Model Changes Between EBS 12.1.3 and Prior EBS Releases
    https://blogs.oracle.com/stevenChan/entry/ebs_data_model_1213

    eTRM
    http://etrm.oracle.com

    Thanks,
    Hussein

  • RELEVANCY SCORE 4.07

    DB:4.07:11i Upgrade To R12 And Challenge In Ap Invoices Interface With Vertex a1


    Hi,

    Right now we are in the process of upgrading our application from 11i to R12.1.3.

    During the procure to pay upgrade, We are facing a challenge in interfacing R12 Oracle Payables invoices with Vertex Q Series Tax.

    The existing vertex interface process is working in R12 till tax calculation. That is, the TAX is getting calculated by the Vertex engine.
    But after tax calculation, the existing vertex interface process is not working because of the new tables in R12 and also some oracle standard packages (bellow listed) used by this program do not exist in R12 anymore.

    ap_tax_default_pkg.get_default_tax_code
    ap_tax_recovery_pkg.get_default_rate
    ap_mrc_engine_pkg.maintain_mrc_data
    ap_mc_info.round_dist_amounts
    ap_charge_allocations_pkg

    I am seeking help in identifying the required APIs to populate the ap_invoice_lines, ap_invoice_distributions and required ZX tables.
    Please help us if you came across similar challenge or any idea on R12 AP invoices interface with Vertex Q Series.

    Thanks
    Tamilselvan

    DB:4.07:11i Upgrade To R12 And Challenge In Ap Invoices Interface With Vertex a1

    Hi,
    I have calculated tax amounts using vertex Q. trying to find out ZX API's to populated the required ZX tables.
    Please help us if you have any idea on this matter.

    Thanks
    Tamil

  • RELEVANCY SCORE 4.06

    DB:4.06:Ebs Version Help j7


    Hi,

    Can any one please give me a query to get current version of oracle apps and the patches applied to our database.

    And also can any one please give me some link or document where I can find the list of tables in hrms that differ from R11 to R12

    Help very much appreciated
    Thank you very much

    Thanks
    Ravi

  • RELEVANCY SCORE 3.93

    DB:3.93:How To Deploy Webservice To Application Server In Ebs R12 9m


    Dear

    how to deploy webservice to application server in EBS R12,
    and
    how to manage application server ( oc4j ) in EBS R12.

    Please help me.
    Thanks

    DB:3.93:How To Deploy Webservice To Application Server In Ebs R12 9m

    Have a look at the following note, it may be helpful.

    Note: 557221.1 - Oracle WebCenter 10g Application Creation and Deployment Guide for Oracle E-Business Suite Release 12
    https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=557221.1

  • RELEVANCY SCORE 3.82

    DB:3.82:Link Between Zx Tax Tables And Gl_Code_Combinations Table In R12 9s


    Hi All,I am new to Oracle apps. We are upgrading from EBS 11i to R12.1.3. In it, ar_vat_tax is obolete. I know its replacement is ZX_rates_b table. But in 11i, they are connected using ar_vat_tax.tax_account_id = gl_code_combinations.code_combination_idNow I am not able to find the join between zx tax tables and gl_code_combinations. Can anyone please help how to link these ZX tax table to gl_code_combinations??? Regards,Swapnil K.

    DB:3.82:Link Between Zx Tax Tables And Gl_Code_Combinations Table In R12 9s

    Resolved the issue.There is a table called ZX_ACCOUNTS. Use the column tax_account_ccid in it. Link ZX_ACCOUNTS.tax_account_entity_id to ZX_RATES_B.tax_rate_id.Regards,Swapnil K.

  • RELEVANCY SCORE 3.80

    DB:3.80:Transfer To Gl From Payroll In R12 78


    Hi there , we are upgrading from 11i -- R12 and we are currently using Transfer to GL process to populate GL Interface table.

    Because Finance moving to SLA architecture , Does oracle still support Transfer to GL Process ? any changes required to be done for this process for R12.

    Also there are some custom reports based on the GL Tables .. Could some one please let me know what are the technical changes in GL that impact Payroll ?

    some thing like set_books_id replaced with ledger_id in GL_INTERFACE table ...etc

    Thanks in advance for your help on this .
    Raghav

    DB:3.80:Transfer To Gl From Payroll In R12 78

    Hi Raghav -

    I can answer the first part of the question:

    There is no change in the process for the transfer of payroll entries to GL, if the process used is "Transfer to GL".

    Additional setups in the SLA needs to be done, in case the organization needs to use the new functionality of the "Transfer to Sub Ledger Accounting".

    Best Regards, Nitin K

  • RELEVANCY SCORE 3.80

    DB:3.80:Customers / Suppliers Interfaces' Implementation On R12 ja


    Hi,

    I was trying to implement interfaces for loading customers and suppliers, by populating the following tables:

    ra_customers_interface_all
    ra_customer_profiles_all
    ap_suppliers_int
    ap_supplier_sites_int

    I've seen the content Integration Repository but I was looking for some sample codes related. Anybody could help me on this?

    Thanks a lot in advance!
    Best regards,
    Pablo

    DB:3.80:Customers / Suppliers Interfaces' Implementation On R12 ja

    Hi,

    I was trying to implement interfaces for loading customers and suppliers, by populating the following tables:

    ra_customers_interface_all
    ra_customer_profiles_all
    ap_suppliers_int
    ap_supplier_sites_int

    I've seen the content Integration Repository but I was looking for some sample codes related. Anybody could help me on this?

    Thanks a lot in advance!
    Best regards,
    Pablo

  • RELEVANCY SCORE 3.80

    DB:3.80:R12 Cash Management- Bank Accounts Tables s9


    Hi,

    Need some information, on R12 Cash Management.
    What are new equivalent tables and columns, it was so confusing.And any changes to ce.ce_system_parameters_all table?

    AP_BANK_BRANCHES
    AP_BANK_ACCOUNTS_ALL
    AP_BANK_ACCOUNTS_USES_ALL

    Thanks in Advance.

    DB:3.80:R12 Cash Management- Bank Accounts Tables s9

    Equivelants:

    CE_BANK_BRANCHES_V
    CE_BANK_ACCOUNTS

    for internal banks

    Use IBY tables for external banks

  • RELEVANCY SCORE 3.66

    DB:3.66:Compile Library c7


    i'm using oracle ERP R12

    when i compile the custom.pll library using apps/apps (userid and pwd) and compile the libary then it shows me error
    (database tables must be declared)

    plzz help what i do now??

    becoz i'm given already id and pwd for database but still not read and not compile

    DB:3.66:Compile Library c7

    Hi,

    Please post the command you issue and the complete error message.

    f60gen equalent in R12
    f60gen equalent in R12

    Thanks,
    Hussein

  • RELEVANCY SCORE 3.64

    DB:3.64:Ra_Customers.Customer_Id In 11i Related Column In R12 s3


    Hi,

    Could you let me know

    RA_CUSTOMERS.customer_id in 11i related column in R12 HZ_PARTIES tables.

    Thanks

    DB:3.64:Ra_Customers.Customer_Id In 11i Related Column In R12 s3

    plz see

    http://getanyhelp.blogspot.ru/2011/12/r-12-customer-tca-architechture.html?zx=164279d1434908c3

    Projects Uptake of the TCA Architecture in Release 12 [ID 417511.1]

  • RELEVANCY SCORE 3.57

    DB:3.57:Ap_Locations_Values,Ar_Location_Rates In Oracle Apps R12 mp


    Hi All
    Can anyone suggest me which tables to replace ap_locations_values,ar_location_rates in R12...asap

  • RELEVANCY SCORE 3.57

    DB:3.57:Ap And Ar Data According To Inventory Org cx


    Hi guys,
    I want data from AP_invoices_all according to specified inventory org but am finding only columns org_id that have operating unit value.
    can any body help me how i can get this.Is there any column data have inv org value as we have in rcv_transactions or some tables.
    there is same case with AR Data.

    I have both 11i and r12 instance.
    Kindly help me soon.Thanks

    DB:3.57:Ap And Ar Data According To Inventory Org cx

    A sample for AP side;

    SELECT DISTINCT aia.org_id,
    aia.vendor_id,
    aia.invoice_id,
    pll.ship_to_organization_id --inv org id
    FROM ap_invoices_all aia,
    ap_invoice_distributions_all aid,
    hr_all_organization_units haou,
    po_headers_all pha,
    po_lines_all pla,
    po_distributions_all pda,
    po_line_locations_all pll,
    mtl_system_items_b msi
    WHERE aia.invoice_id = aid.invoice_id
    AND haou.organization_id = aia.org_id
    AND aid.po_distribution_id = pda.po_distribution_id
    AND pha.po_header_id = pla.po_header_id
    AND pha.po_header_id = pda.po_header_id
    AND pha.po_header_id = pll.po_header_id
    AND pla.po_line_id = pda.po_line_id
    AND pla.po_line_id = pll.po_line_id
    AND pda.line_location_id = pll.line_location_id
    AND pla.item_id = msi.inventory_item_id
    AND pll.ship_to_organization_id = msi.organization_id
    AND aia.invoice_date BETWEEN '16-MAY-2010' AND '31-JUL-2010'

    ----------

    AR side

    SELECT rt.trx_number,
    rt.trx_date,
    rtl.extended_amount,
    rt.invoice_currency_code,
    rtl.interface_line_attribute1,
    rtl.interface_line_attribute2,
    rtl.interface_line_attribute3,
    rtl.interface_line_attribute4,
    rtl.interface_line_attribute6,
    rt.interface_header_attribute1,rt.interface_header_context,
    rtl.line_type
    FROM ra_customer_trx_lines_all rtl,
    ra_customer_trx_all rt,
    oe_order_lines_all ol
    WHERE rt.customer_trx_id = rtl.customer_trx_id
    and ol.line_id = rtl.interface_line_attribute6
    and rtl.line_type='LINE'
    ;

    be aware that ar side query returns only for lines, you need to add tax lines of corresponding lines.

    Hope this helps

    bilal sarioz

  • RELEVANCY SCORE 3.56

    DB:3.56:Changed Tables In R12 93


    hi all,
    please can some one guide me from where to find all the tables which have been changed from 11.5.7 version to R12

    example.

    gl_set_of_books table has been chnged to gl_ledgers like wise I want to know all the tables which have been changed in R12.

    thanks in advance

    DB:3.56:Changed Tables In R12 93

    Hi that means i have to search it then

    :(

  • RELEVANCY SCORE 3.55

    DB:3.55:Help With Sql Statement For R12 Ar Customer Listing k7


    I am using R12 and I am trying to extract the AR Customer Name, Full Address, Org ID and contact details from the receivables tables and can't seem to find the correct tables to do this. Has anyone created an SQL query similar to what is required? Any assistance would be greatly appreciated.

    Thanks

    DB:3.55:Help With Sql Statement For R12 Ar Customer Listing k7

    Sorry, forgot to include that I also need the operating unit that the customer was created under

  • RELEVANCY SCORE 3.50

    DB:3.50:Oracle Rkm Ebs Suite - Issue In Importing Metadata 7c


    Hi all,

    Am new to ODI. am trying to import oracle ebs wms tables using oracle RKM enterprise suite .

    issue am facing is SnpsReverseSetMetaData process is always in running status and also by the time designer window gets hung up. i could not be able to see imported tables.

    importing tables from oracle ebs R12

    please help me out to solve this issue.

    regards,
    nithya

    DB:3.50:Oracle Rkm Ebs Suite - Issue In Importing Metadata 7c

    Hi all,

    Am new to ODI. am trying to import oracle ebs wms tables using oracle RKM enterprise suite .

    issue am facing is SnpsReverseSetMetaData process is always in running status and also by the time designer window gets hung up. i could not be able to see imported tables.

    importing tables from oracle ebs R12

    please help me out to solve this issue.

    regards,
    nithya

  • RELEVANCY SCORE 3.50

    DB:3.50:Which Table Stores This Value Transmission Servlet Base Url f9


    Hi All,EBS r12 12.1.3 From the screen in PaymentUpdate Payment System: FirstDataNorth i am looking for table that stores this valueTransmission Servlet Base URLdid look in these tables FND_PROFILE*but not available.Please help!Regards,

    DB:3.50:Which Table Stores This Value Transmission Servlet Base Url f9

    Thank you all,the table to have the request infoIBY_BEPINFOBest Regards,

  • RELEVANCY SCORE 3.49

    DB:3.49:10gas 10.1.4.2 Oid Bulkload R12 Sso p9


    HI,
    I have Completed 10gAs Integration with EBS R12 Suessfully , When i Create User in R12 Application, its populate to OID, By Using SSO i can login by, newly Created USer .

    But Old Existing User in R12 cant login using SSO, Have to Load R12 old user Sechma into OID I doen WorkAround like ( oipprovtool,ldapsearch,ldifmigrator bulkload ). When Use Bulk load found message ( Following tables do not have all indexes CT_ORCLGUID.

    1) Anyone have an Idea how to Load user schema in OID.
    2) tables do not have all indexes CT_ORCLGUID

    thnks in Adv 4r Transfering Knldge

    DB:3.49:10gas 10.1.4.2 Oid Bulkload R12 Sso p9

    after rebuild indexes

    bulkload -connect connect_string -index

    i run following comman ( bulkload -connect asdb1 -load=true file=/export/home/oracle/users.ldif)

    orclldapinstanceid...
    orcldblsnumerictag...
    orcldbaqobjname...
    orclmailrenamedsharedfolder...
    ctcalxitemid...
    orclodipprofileexecgroupid...
    orclmailgroupisexternal...
    orclsuitetype...
    orclmailaddresscategory...
    orclwirelessaccountnumber...
    orclodipprofilename...
    mobile...
    ipnetmasknumber...
    orclodipcondirtype...
    description...
    orclmailfolderdn...
    orclrealmname...
    orcldasispersonal...
    orclmailaci...
    shadowflag...
    orclcalendarresourcenumber...
    ctcalorgunit3...
    gecos...
    orclassignedpermissions...
    orclmaillistsuspendedmember...
    orcldbaqpointerattr...
    ctcalorganization...
    secretary...

    ------------------------------------------------------------
    Data loaded successfully
    ------------------------------------------------------------

    ------------------------------------------------------------
    Verifying indexes ...
    ------------------------------------------------------------

    ------------------------------------------------------------
    Following tables do not have all indexes
    ------------------------------------------------------------
    CT_ORCLGUID

    ------------------------------------------------------------
    Generating Database Statistics ...
    ------------------------------------------------------------
    ...Setting OID server mode to read-write on "target" node...

  • RELEVANCY SCORE 3.47

    DB:3.47:Webutil In Apps R12 p9


    Hi any body help me to configure webutil in apps (R12) or tell me if exists a document step by step for configure Webutil in apps R12.

    Thanks
    Alejandro

    DB:3.47:Webutil In Apps R12 p9

    You should ask in the OA framework forum: OA Framework You are more likely to find people with WebUtil with Apps there. This forum is for bespoke Forms apps.

  • RELEVANCY SCORE 3.47

    DB:3.47:Gl Purge/Archive Tables In R12 1z


    Hi,

    in 11i the archive tables of Gl are:
    * gl_archive_balances
    * gl_archive_batches
    * gl_archive_headers
    * gl_archive_lines
    * gl_archive_references

    In R12 these tables are obsolete. In the eTRM I am unable to find the substitute tables.

    Does anyone know what tables are used for Purging/Archiving the GL Data?

    Best regards Roel.

    DB:3.47:Gl Purge/Archive Tables In R12 1z

    Hi,

    in 11i the archive tables of Gl are:
    * gl_archive_balances
    * gl_archive_batches
    * gl_archive_headers
    * gl_archive_lines
    * gl_archive_references

    In R12 these tables are obsolete. In the eTRM I am unable to find the substitute tables.

    Does anyone know what tables are used for Purging/Archiving the GL Data?

    Best regards Roel.

  • RELEVANCY SCORE 3.47

    DB:3.47:Replacement Of Tax Columns From Ap Tables To Zx Tables sz


    Explanation of Queries :

    11i Query:

    select DIST_MATCH_TYPE, LINE_TYPE_LOOKUP_CODE, AMOUNT_INCLUDES_TAX_FLAG, DISTRIBUTION_LINE_NUMBER, LINE_GROUP_NUMBER,

    TAX_CODE_OVERRIDE_FLAG,

    TAX_RECOVERY_OVERRIDE_FLAG,

    TAX_RECOVERY_RATE,

    VAT_CODE

    from AP_INVOICE_DISTRIBUTIONS_ALL where INVOICE_ID=2803856 -- This Query is fine in 11i Version and no modification is needed. All I need to modify the below R12 Query.

    ----------------------------------------------------------

    R12 Query:

    select

    aid.DIST_MATCH_TYPE, ail.LINE_TYPE_LOOKUP_CODE, zls.TAX_AMT_INCLUDED_FLAG AMOUNT_INCLUDES_TAX_FLAG,

    nvl(aid.OLD_DIST_LINE_NUMBER,aid.DISTRIBUTION_LINE_NUMBER) DISTRIBUTION_LINE_NUMBER,

    zls.OVERRIDDEN_FLAG TAX_CODE_OVERRIDE_FLAG,

    aid.TAX_RECOVERY_OVERRIDE_FLAG, --Need to get the mapping column in R12 from ZX Tables

    aid.TAX_RECOVERY_RATE, --Need to get the mapping column from in R12 from ZX Tables

    ail.TAX_CLASSIFICATION_CODE vat_code

    from

    ap_invoices_all ai,

    ap_invoice_lines_all ail,

    ap_invoice_distributions_all aid,

    ZX_LINES_SUMMARY zls

    where ai.invoice_id=ail.invoice_id

    and ail.invoice_id=aid.invoice_id

    and ail.line_number=aid.invoice_line_number

    and ai.invoice_id=zls.TRX_ID

    and aid.DISTRIBUTION_LINE_NUMBER=zls.SUMMARY_TAX_LINE_NUMBER

    and ai.invoice_id=2803856

    order by ail.line_number;

    Please suggest me on the columns to be replaced and help me out. Appreciate your help....

    Regards,
    Mohammed Manzur

    DB:3.47:Replacement Of Tax Columns From Ap Tables To Zx Tables sz

    Pl do not post duplicate threads - Replacement of Tax Columns in R12 Environment (12.1.3)

    Srini

  • RELEVANCY SCORE 3.45

    DB:3.45:R12 Link To Ap And Gl 11


    Hello,
    I am trying to link AP and GL in R12. I am totally new to R12 , so kind of lost. I tried to develop a query using subledger accounting tables as below but I am getting duplicates. Can someone pl correct me orhelp me build this. I actually need the check no attached to the invoice. please help!!!!

    select check_number, p.invoice_id, p.payment_num, jl.je_header_id, jl.je_line_num, i.invoice_num
    , i.gl_date, i.invoice_amount
    , al.code_combination_id XLA_CC_ID
    , jl.code_combination_id journal_CC_ID
    ,l.source_distribution_type
    --distinct applied_to_entity_code
    from xla_distribution_links l,
    ap_invoice_payments_all p,
    xla_ae_lines al,
    gl_import_references r,
    gl_je_lines jl,
    ap_checks_all c,
    ap_invoices_all i
    where l.applied_to_source_id_num_1 = p.invoice_id
    --and l.source_distribution_type= 'AP_INV_DIST'
    and l.ae_header_id = al.ae_header_id
    -- and l.ae_line_id = al.ae_line_id
    and al.gl_sl_link_id = r.gl_sl_link_id
    and r.je_header_id = jl.je_header_id
    and r.je_line_num = jl.je_line_num
    and p.check_id = c.check_id
    and p.invoice_id = i.invoice_id
    and invoice_num = '90283-070108'

    DB:3.45:R12 Link To Ap And Gl 11

    Do you just need the check no attached to an invoice, please confirm ? In this case you need not refer to any of the GL tables ?

    select check_number, p.invoice_id, p.payment_num, i.invoice_num, i.gl_date, i.invoice_amount
    from ap_invoice_payments_all p,
    ap_checks_all c,
    ap_invoices_all i
    where p.check_id = c.check_id
    and p.invoice_id = i.invoice_id
    and i.invoice_num = '90283-070108';

  • RELEVANCY SCORE 3.43

    DB:3.43:Seeded Roles In Fnd Roles Tables In R12 jd


    Dear Techies,Could you please help me with on how to list of the seeded roles in fnd roles tables in R12.Sql Query /script to find the Seeded roles in the R12.RegardsMohammed. Abdul Muqeet

    DB:3.43:Seeded Roles In Fnd Roles Tables In R12 jd

    Appreciate the Early response on this .RegardsMohammed. Abdul Muqeet

  • RELEVANCY SCORE 3.43

    DB:3.43:Link Help Need xp


    Hi all,

    Please guide me how to link OM -INV AND OM -AR tables for R12 Version

    Thanks and regards,
    Pallis

    DB:3.43:Link Help Need xp

    Hi all,

    Please guide me how to link OM -INV AND OM -AR tables for R12 Version

    Thanks and regards,
    Pallis

  • RELEVANCY SCORE 3.43

    DB:3.43:11i To R12 Tables Documentation sk


    Can Anyone tell me where i can find documentation for tables from 11i to related R12 tables.
    Its seems lot of tables have been changed in R12 and lot of tables has no data.
    like table/s IC_item_mst,IC_TRAN_PND,PM_BTCH_HDR etc .
    Please tell me where could i find columns related to these tables(11i) in R12.

    DB:3.43:11i To R12 Tables Documentation sk

    Hi,

    Then I would advise you to switch to another forum. Try this one:

    SCM - Process Manufacturing (OPM)

    And this one in particular:

    OPM R12 Docs

    Good Luck,

    Daan Bakboord

  • RELEVANCY SCORE 3.42

    DB:3.42:How To Setup Oracle Inventory In R12? cx


    Dear
    What is oracle inventory? How do i setup in R12?
    Please help me.

    DB:3.42:How To Setup Oracle Inventory In R12? cx

    You may alsow review:

    Oracle Inventory Overview, basic understanding!
    http://www.appsbi.com/2007/01/22/oracle-inventory-overview-basic-understanding/

    Overview of Inventory Setup (Oracle Inventory Help)
    http://download.oracle.com/docs/cd/A60725_05/html/comnls/us/inv/invset.htm

    Help Needed...Oracle Apps Inventory
    Help Needed...Oracle Apps Inventory

  • RELEVANCY SCORE 3.41

    DB:3.41:Re: Obsolete Tables j8


    Hi Nabi;

    please check below which could be helpful for your issue:

    What are the new tables in R12 for Payables and to what R12 objects are obsoleted 11i tables mapped [ID 1290116.1]
    Synchronize Wf Local Tables is obsolete and does not need to be run. [ID 1158212.1]

    Regard
    Helios

    DB:3.41:Re: Obsolete Tables j8

    Hi Sandeep Gandhi,
    we are migrating the our project from 11.5.10 to R12.for that just we have find the obseleted tables.
    my assignment is to find out the obseleted tables.I didn't do any thing.

    Thanks,
    Rasool

  • RELEVANCY SCORE 3.40

    DB:3.40:Re: Absolute Tables In R12 1f


    Hi;

    Please see below thread:
    Absolute tables
    Re: Absolute tables

    Regard
    Helios

    DB:3.40:Re: Absolute Tables In R12 1f

    hi all,

    use below link to see OBSOLETE TABLES in some modules

    http://www.scribd.com/doc/20894602/Oracle-R12-TableView-Changes

    Varma.

    Edited by: 843404 on Mar 17, 2011 2:26 PM

  • RELEVANCY SCORE 3.40

    DB:3.40:Table Relation For Oe_Order_Headers_All &Amp; Aso_Quote_Headers_All Table 91


    Hi All,

    I am working on oracle R12 implementation process.
    I have the Requirement for Matching the oe_order_headers_all table and aso_quote_headers_all table. Is there any sql query for matching or linking these two tables.

    Please help me on this.

    Thanks Regards,
    Prab

  • RELEVANCY SCORE 3.40

    DB:3.40:Reg: Bank Tables xz


    hi all,

    i want to know join conditions between following R12 tables.

    ap_checks_all asic,
    --apps.ap_bank_branches abb,
    CE_BANK_BRANCHES_V abb,
    --apps.ap_bank_accounts_all aba
    ce_bank_accounts aba,
    ce_bank_acct_uses_all cbau

    feel free and help me in the following r12 tables.

    Regards
    Swamy

    DB:3.40:Reg: Bank Tables xz

    hi all,

    i want to know join conditions between following R12 tables.

    ap_checks_all asic,
    --apps.ap_bank_branches abb,
    CE_BANK_BRANCHES_V abb,
    --apps.ap_bank_accounts_all aba
    ce_bank_accounts aba,
    ce_bank_acct_uses_all cbau

    feel free and help me in the following r12 tables.

    Regards
    Swamy

  • RELEVANCY SCORE 3.39

    DB:3.39:R12 Equivalent On This 11i Query ks


    All,

    I am working on an R12 upgrade project and by looking at the documentations, there are lot of tables in AP which are co-existing and changed but not getting a clear idea of what got changed and why multiple tables exist. Is there anyone here who can provide me the R12 query for this 11i query below?

    SELECT distinct
    ac.vendor_name,
    nvl(ac.address_line1,ac. address_line2) address_line1,
    decode(ac.city,null,'',ac. city||',')||ac.state||' '||ac.zip city_state_zip,
    pv.segment1 vendor_no,
    abb.bank_name payee_bank,
    ac.currency_code cur_code,
    ac.check_date pmt_date,
    ac.check_number pmt_number,
    ac.amount pmt_amount,
    ac.check_id
    FROM ap_checks_all ac,
    ap_bank_accounts_all aba,
    ap_bank_branches abb,
    po_vendors pv
    WHERE
    ac.PAYMENT_METHOD_LOOKUP_ CODE in ('EFT','WIRE')
    and ac.status_lookup_code in ('NEGOTIABLE','CLEARED BUT UNACCOUNTED','RECONCILED UNACCOUNTED')
    and ac.vendor_id=pv.vendor_id
    and ac.external_bank_account_id = aba.bank_account_id
    and aba.bank_branch_id = abb.bank_branch_id
    order by ac.check_date;

    Thanks for your help.

    DB:3.39:R12 Equivalent On This 11i Query ks

    Hi,
    Sorry I am not sure why oracle using two tables. BUT my observation and understanding is AP_CHECKS_ALL table is being used for the AP module, reconciliation with bank statement in Cash Management module and accounting. IBY_PAYMENTS_ALL table is mainly being used to process the payments in the Payments module.

    Thanks,
    Ram

  • RELEVANCY SCORE 3.34

    DB:3.34:Need R12 Table Info For Ic_Adjs_Jnl ,Ic_Jrnl_Mst fx


    Hi

    Need the equivalent table details in r12 to the bellow tables

    IC_ADJS_JNL ,IC_JRNL_MST

    Thanks,
    Sreekanth

    DB:3.34:Need R12 Table Info For Ic_Adjs_Jnl ,Ic_Jrnl_Mst fx

    Hi;

    For table integration,explanation and for more please see e-trm site.
    etrm.oracle.com

    Regard
    Helios

  • RELEVANCY SCORE 3.31

    DB:3.31:Discoverer In Oracle Apps R12 88


    Hi,

    Can anybody please help me, giving a step by step installation doc of Discoverer in R12

    Thanks
    Regards

    DB:3.31:Discoverer In Oracle Apps R12 88

    Hi,

    Refer to these documents.

    Note: 373634.1 - Using Discoverer 10.1.2 with Oracle E-Business Suite Release 12
    Note: 1074326.1 - Using Discoverer 11.1.1 with Oracle E-Business Suite Release 12

    Regards,
    Hussein

  • RELEVANCY SCORE 3.31

    DB:3.31:R12 On Windows: I Cannot Find The Om Tables In Vis - Please Help cs


    Hi,

    I have R12 installed on my Windows. I am using Oracle SQL Developer to browse the VIS tables but I cannot find the tables I need to browse.
    For example: oe_order_headers_all, oe_order_lines_all, wsh_delivery_details

    Thanks,
    Amorsolo

    DB:3.31:R12 On Windows: I Cannot Find The Om Tables In Vis - Please Help cs

    I can find those objects in my 12.1.3 Vision instance.

    SQL select owner, object_type, object_name
    from dba_objects
    where object_name in ('OE_ORDER_HEADERS_ALL', 'OE_ORDER_LINES_ALL', 'WSH_DELIVERY_DETAILS')
    order by 3;

    OWNER OBJECT_TYPE OBJECT_NAME
    ---------- ------------------- ------------------------------
    ONT TABLE OE_ORDER_HEADERS_ALL
    APPS SYNONYM OE_ORDER_HEADERS_ALL
    APPS SYNONYM OE_ORDER_LINES_ALL
    ONT TABLE OE_ORDER_LINES_ALL
    WSH TABLE WSH_DELIVERY_DETAILS
    APPS SYNONYM WSH_DELIVERY_DETAILS

    6 rows selected.Thanks,
    Hussein

  • RELEVANCY SCORE 3.30

    DB:3.30:Replacement Of Tax Columns In R12 Environment (12.1.3) 1p


    After Upgrade from 11.5.10 to R12.1.3 these following columns were picked in AP_INVOICE_DISTRIBUTIONS_ALL table and now the issue is about to replace these tax columns with R12 ZX tables.

    Table used in 11i AP_INVOICE_DISTRIBUTIONS_ALL
    TAX_RECOVERY_RATE,
    TAX_RECOVERY_OVERRIDE_FLAG

    ------------------------------------------------------------------------

    Have to replace columns with ZX tax tables... Need to know which table is populating in ZX tables.. Please suggest on this as it is very high important....

    Appreciate your help!

    Thanks,
    Anwar.

    DB:3.30:Replacement Of Tax Columns In R12 Environment (12.1.3) 1p

    After Upgrade from 11.5.10 to R12.1.3 these following columns were picked in AP_INVOICE_DISTRIBUTIONS_ALL table and now the issue is about to replace these tax columns with R12 ZX tables.

    Table used in 11i AP_INVOICE_DISTRIBUTIONS_ALL
    TAX_RECOVERY_RATE,
    TAX_RECOVERY_OVERRIDE_FLAG

    ------------------------------------------------------------------------

    Have to replace columns with ZX tax tables... Need to know which table is populating in ZX tables.. Please suggest on this as it is very high important....

    Appreciate your help!

    Thanks,
    Anwar.

  • RELEVANCY SCORE 3.30

    DB:3.30:R12 Tables jc


    Hi,

    Can any one tell me the new tables that need to be used instead of 11.5.10 tables in PO, OM, INV, AP and AR?

    Thanks,
    Raju Mantena

    DB:3.30:R12 Tables jc

    You cant get the datamodel of any module on any Oracle released document. You can check the table on ETRM [etrm.oracle.com]

  • RELEVANCY SCORE 3.30

    DB:3.30:Table Changes Of Opm Costing Between 11i And R12 d1


    Hi Guys,

    Please if any one can help me.

    I am working on upgrading an OPM report from 11i to R12, which shows transactions of items, including Quantity and Cost information.

    My questions are that:

    1. I know tables 'ic_tran_pnd', 'ic_tran_cmp' are substituted by 'MTL_MATERIAL_TRANSACTIONS' in R12.
    Do the tables, such as 'cm_acst_led', 'cm_cmpt_dtl', 'cm_whse_asc', 'cm_acst_led', 'cm_adjs_dtl', are still in use?

    2. How can I get the Cost of OPM item? Could I get it from table 'MTL_MATERIAL_TRANSACTIONS'?
    Now I can get Quantity from it, but after creating a Sales Order, Pick and Ship it, the columns 'ACTUAL_COST' of corresponding records in 'MTL_MATERIAL_TRANSACTIONS' are still Null.

    Please help me. Thanks in advance.

    Best Regards,
    Ganxin

    DB:3.30:Table Changes Of Opm Costing Between 11i And R12 d1

    Hi Ahmed,

    I have tried to run 'actual cost process' and 'cost update'. It seems that all transactions in 'mtl_material_transactions' which are in period and actual_cost 0 are collected for updating 'cm_cmpt_dtl' and 'cm_acst_led', and the cost of item is updated too.

    But after doing a SO, Pich and Ship, the actual_cost in 'mtl_material_transactions' is still NULL.
    Could you please explain it for me? Any steps I missed?
    Thanks a lot.

    Best Regards,
    Ganxin

  • RELEVANCY SCORE 3.29

    DB:3.29:Rewrite Ic Tables With Mtl Tables 7d


    Hi,

    Need to rewrite the below query with MTL tables in R12 i mean need to replace IC tables with MTL tables

    SELECT IWM.WHSE_CODE
    FROM IC_WHSE_MST IWM
    WHERE IWM.MTL_ORGANIZATION_ID =2722

    can any one please help me

    Nani

    DB:3.29:Rewrite Ic Tables With Mtl Tables 7d

    Hi,

    Question- Are you trying to findout the 11i warehouse code which has been migrated to R12 as inventory org?

    Regards
    Raghavendra

  • RELEVANCY SCORE 3.27

    DB:3.27:View Objects Performance Issue With Oracle Seeded Tables kx


    While i am writing a view object on a oracle seeded tables like MTL_PARAMETERS, its taking more time to show in the oaf page.I am trying to display all these view object columns in detail disclosure of advanced table. My Application is taking more than two minutes to display the view columns of the query which is returning just 200 rows. Please help me how to improve performance when my query using seeded tables.

    This issue is happening only in R12 view object and advanced tables.

    Edited by: vlsn on Jun 24, 2012 11:36 PM

    DB:3.27:View Objects Performance Issue With Oracle Seeded Tables kx

    While i am writing a view object on a oracle seeded tables like MTL_PARAMETERS, its taking more time to show in the oaf page.I am trying to display all these view object columns in detail disclosure of advanced table. My Application is taking more than two minutes to display the view columns of the query which is returning just 200 rows. Please help me how to improve performance when my query using seeded tables.

    This issue is happening only in R12 view object and advanced tables.

    Edited by: vlsn on Jun 24, 2012 11:36 PM

  • RELEVANCY SCORE 3.27

    DB:3.27:Enabling Archivelog On Apps R12 8a


    Hi,

    Can anyone please help me, How to enable Archivelog in R12

    Thanks
    Sagb

    DB:3.27:Enabling Archivelog On Apps R12 8a

    You can enable Archivelog on R12 as you do on any other database.

    For more details, please refer to the following:

    Note: 274302.1 - Log archive mode in 10G
    https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=274302.1

    Note: 371139.1 - How to enable/disable Archive Log Mode In 10g
    https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=371139.1

    Note: 69739.1 - How to Turn Archiving ON and OFF
    https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=69739.1

  • RELEVANCY SCORE 3.26

    DB:3.26:Link Between Po And So xd


    Hello ,

    Can anybody help me to find what is the link between sales order(SO) and purchase order(PO) tables in APPS R12 .

    Thanks,

    DB:3.26:Link Between Po And So xd

    check out for queries

    http://www.oracleappshub.com/oracle-purchasing/po-tips-and-useful-query/

  • RELEVANCY SCORE 3.26

    DB:3.26:R12 Hrms Upload Data Using Interface Tables 8m


    Hi all,

    Someone told me that in R12 the HR data are being uploaded using interface tables, so that we upload data to this interface table then use concurrent program to validate and upload this data to its proper apps tables

    Thanks for any help

    Ehab

    DB:3.26:R12 Hrms Upload Data Using Interface Tables 8m

    Its preferred tht u create ur custom table and populate legacy data in it. Then write custom proc using API to migrate data in Oracle HRMS from custom table.

  • RELEVANCY SCORE 3.25

    DB:3.25:Difference Between 11i And R12 da


    Hello

    Can anybody let me know what are all the difference between 11i and R12 with technical perspective like table changes, new tables etc..

    Thanks

    DB:3.25:Difference Between 11i And R12 da

    Please see old threads for similar discussion.

    Difference between 11i and R12
    http://forums.oracle.com/forums/search.jspa?threadID=q=Difference+between+11i+and+R12objID=c3dateRange=alluserID=numResults=15rankBy=10001

    Thanks,
    Hussein

  • RELEVANCY SCORE 3.25

    DB:3.25:How To Implement Configurator Module In Oracel Apps R12 fx


    Hi all,How can we Implement Configurator Module in Oracle Apps R12.Help on this Configurator Module implementation in Oracle Apps R12.Thanks,Ramaraju.

    DB:3.25:How To Implement Configurator Module In Oracel Apps R12 fx

    Oracle Configurator - Implementing the Functional Flow(Doc ID 1113054.1)http://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=177433269446759id=1113054.1displayIndex=2_afrWindowMode=0_adf.ctrl-state=o5b55of7i_76

  • RELEVANCY SCORE 3.24

    DB:3.24:Tables Or Views To Be Included In Discoverer 10g jk


    Hi,

    In our test environment we have migrated to R12 and using Discoverer 10g (10.1.2.55.26). Since there is a way the security has changed I require some help.

    In production we are using 11i and the same version of Discoverer. In production I could use the "_v" views or tables where there was in-built security. When a user queries in discoverer, the user would be able to view data only pertaining to his/her responsibility.

    In our test environment please can someone help me for the following (R12 with Disc 10g)

    Which is the "_v" views or tables or "where clause to restrict the access" to user in discoverer wherein based on the users responsibility, the data will be displayed.

    GL Balances
    GL Hearder Details

    AR Balances
    Receipts
    AR Invoice header lines distribution

    AP Balances
    AP Invoice header lines distribution
    Payment Overview
    Prepayment Enquiry

    Kindly note, regardless of the security setup in the R12, I would want a "_v" views or tables or "where clause" which can be used always.

    If there is solution based on "_v" views or tables and a solution also based on "where clause", which would be ideal to use in terms of performance.

    Any help will be highly appreciated.

    Thanks.
    Ajay

    DB:3.24:Tables Or Views To Be Included In Discoverer 10g jk

    Hi,

    In our test environment we have migrated to R12 and using Discoverer 10g (10.1.2.55.26). Since there is a way the security has changed I require some help.

    In production we are using 11i and the same version of Discoverer. In production I could use the "_v" views or tables where there was in-built security. When a user queries in discoverer, the user would be able to view data only pertaining to his/her responsibility.

    In our test environment please can someone help me for the following (R12 with Disc 10g)

    Which is the "_v" views or tables or "where clause to restrict the access" to user in discoverer wherein based on the users responsibility, the data will be displayed.

    GL Balances
    GL Hearder Details

    AR Balances
    Receipts
    AR Invoice header lines distribution

    AP Balances
    AP Invoice header lines distribution
    Payment Overview
    Prepayment Enquiry

    Kindly note, regardless of the security setup in the R12, I would want a "_v" views or tables or "where clause" which can be used always.

    If there is solution based on "_v" views or tables and a solution also based on "where clause", which would be ideal to use in terms of performance.

    Any help will be highly appreciated.

    Thanks.
    Ajay

  • RELEVANCY SCORE 3.21

    DB:3.21:Equivalent Tables Ar_Sales_Tax,Ra_Tax_Exemptions And Ar_Vat_Tax_Vl In R12 8a


    Hi,

    I am working for Oracle R12 Upgrade project. We are facing issue to finding the equivalent tables for the Oracle 11i tax related tables in Oracle R12.

    what are the equivalent tables for AR_SALES_TAX, RA_TAX_EXEMPTIONS and AR_VAT_TAX_VL in Oracle R12 E-Bussiness tax module

    Could you please help on this.

    Thanks,
    Rajesh

    DB:3.21:Equivalent Tables Ar_Sales_Tax,Ra_Tax_Exemptions And Ar_Vat_Tax_Vl In R12 8a

    Hi,

    I am working for Oracle R12 Upgrade project. We are facing issue to finding the equivalent tables for the Oracle 11i tax related tables in Oracle R12.

    what are the equivalent tables for AR_SALES_TAX, RA_TAX_EXEMPTIONS and AR_VAT_TAX_VL in Oracle R12 E-Bussiness tax module

    Could you please help on this.

    Thanks,
    Rajesh

  • RELEVANCY SCORE 3.21

    DB:3.21:Tables Involve In Program Synchronize Wf Local Tables z1


    Hi All,

    i am using ebs r12 12.1.1 on OUL5

    would like to know how to find out which tables involve in program
    " Synchronize WF LOCAL tables"

    other way, when running " Synchronize WF LOCAL tables" which tables would be updated.

    Thanks in advance.
    Regards,

    DB:3.21:Tables Involve In Program Synchronize Wf Local Tables z1

    You can set the trace on for the concurrent program (using sysadmin concurrent programs) screen and then run tkprof on the trace.
    It will not only give you the tables used but also the exact statements that are executed.

    Hope this helps
    Sandeep Gandhi
    Independent Techno-functional Consultant

  • RELEVANCY SCORE 3.20

    DB:3.20:Table Details p8


    Hi All

    Could you please tell me what are the tables used during place order a item in R12.

    Thanks
    Vivek

    DB:3.20:Table Details p8

    Hi Vivek

    Could you please tell me what are the tables used during place order a item in R12. For table integration, defination etc. You need to check e-trm site:
    etrm.oracle.com/

    Regard
    Helios

  • RELEVANCY SCORE 3.20

    DB:3.20:Oracle Payables - R12 Suppliers Conversion - Payment Method Update f8


    Hello Oracle World,

    We have implemented suppliers conversion in R12 through the standard interface tables AP_SUPPLIERS_INT and AP_SUPPLIER_SITES_INT.
    Now we face a business situation wherein, we need to include the DEFAULT_PAYMENT_METHOD_CODE to 'WIRE' for all the exisiting suppliers imported so far, and incorporate the changes in the conversion packages to reflect the same for the suppliers import, to follow.

    The second part is done and tested with, but regarding the updates on the existing ones, we are not sure of how to proceed.
    With some research we could figure out some of the R12 TCA tables holding the supplier's payment information as
    IBY_PAYMENTS_ALL,
    IBY_EXT_PARTY_PMT_MTHDS,
    IBY_EXTERNAL_PAYEES_ALL
    etc etc.

    We would like to know, if there is any standard API that does the above functionality.

    Thanks for the time and any help of any sorts would be highly appreciated.

    Regards,
    ATC
    Jeddah, Saudi Arabia

    DB:3.20:Oracle Payables - R12 Suppliers Conversion - Payment Method Update f8

    You can try evaluating the APIs available in AP_VENDOR_PUB_PKG.

  • RELEVANCY SCORE 3.19

    DB:3.19:Query To Take Data From Gl, Xla And Ap Tables In R12 zd


    Hi,

    I need data from GL , XLA and AP(Invoice Number) tables in R12. Can anyone help me how to join GL , XLA and AP tables in R12.

    Thanks,
    grandhi

    DB:3.19:Query To Take Data From Gl, Xla And Ap Tables In R12 zd

    Please refer to eTRM website.

    eTRM
    http://etrm.oracle.com

    Thanks,
    Hussein

  • RELEVANCY SCORE 3.18

    DB:3.18:Diff B/N 11i And R12 As Dba Considering Dba Tasks xd


    Hi Friends

    1).Can please tell me what are the main differences in between R12 and 11i,as prepect to dba tasks
    2).Is there any new features added in R12,if so what are those features
    3).Is there any new tables added in R12 as releted to dba,if so what are those tables
    4).Is there any new tools implemented in R12,if so can please let it be know those

    Regards
    Reddy

    DB:3.18:Diff B/N 11i And R12 As Dba Considering Dba Tasks xd

    Reddy,

    Check the following thread:

    What is the difference between REL 10.5.10 and REL 12
    what is the difference between REL 10.5.10 and REL 12

  • RELEVANCY SCORE 3.18

    DB:3.18:R12 Ap Invoice Payment Api Alternative jj


    Hi All,

    Currently I handle a project that would require loading of payment records from a staging table to OFIN R12. The issue is, Oracle itself doesn't provide an interface or API for AP Invoice Payments that load records from staging table or flat file to OFIN R12 payment tables. Is there any alternative or available API on R12 that can be utilize to performed similar functions?

    Our working environment:
    - EBS 12.1.1

    Any help much appreciated.

    Regards,
    Cyrus

    DB:3.18:R12 Ap Invoice Payment Api Alternative jj

    Hello Everyone,

    Any help from you guys?

    Regards,
    Cyrus

  • RELEVANCY SCORE 3.18

    DB:3.18:How To Register Objects In R12. j3


    HI,

    Is there any doc ID to understand the registration of objects(like tables, views etc) with oracle Apps R12?

    Thanks,
    Faziarain

    DB:3.18:How To Register Objects In R12. j3

    The process is described in the App Developers Guide http://download.oracle.com/docs/cd/B53825_03/current/html/docset.html

    HTH
    Srini

  • RELEVANCY SCORE 3.18

    DB:3.18:Chart Of Account kk


    i am new in Oracle EBS R12 and i am creating a web application and now i need to know about Oracle General Ledger Chart Of Account Tables.
    anybody know about COA tables please help me. i am also using Oracle ETRM General Ledger Section but there are 309 tables. i didn't find actual tables.

    Regards,
    GreenX

    DB:3.18:Chart Of Account kk

    Thank you very much Sandeep Gandhi. i highly appreciate you for your quick response.

    Regards,
    GreenX

  • RELEVANCY SCORE 3.18

    DB:3.18:How Do You Display The Tables Of Ebs R12 (Vis)? c3


    Hi,

    My sqlplus does not work but I have an Oracle sqldeveloper. How do you display the tables info of order management module in EBS R12 for windows?

    For example:
    Base tables
    oe_order_headers_all
    oe_lines_all
    oe_lot_serial_numbers
    oe_sales_credits
    oe_price_adjustments

    Interface tables:
    OE_HEADERS_IFACE_ALL
    OE_LINES_IFACE_ALL
    OE_RESERVTNS_IFACE_ALL
    OE_CREDITS_IFACE_ALL
    OE_PRICE_ADJS_IFACE_ALL
    OE_LOTSERIALS_IFACE_ALL
    OE_ACTIONS_IFACE_ALL

    Thanks,
    Fernando

    DB:3.18:How Do You Display The Tables Of Ebs R12 (Vis)? c3

    Check passwords with your DBA. Otherwise try ONT/ONT or ONT/APPS
    For Table Definitions, ERD models and other technical details see http://etrm.oracle.com

    Regards,
    Gareth

  • RELEVANCY SCORE 3.18

    DB:3.18:Customers / Suppliers Interfaces' Implementation For R12 mx


    Hi,

    I was trying to implement interfaces for loading customers and suppliers, by populating the following tables:

    ra_customers_interface_all
    ra_customer_profiles_all
    ap_suppliers_int
    ap_supplier_sites_int

    I've seen the content Integration Repository but I was looking for some sample codes related. Anybody could help me on this?

    Thanks a lot in advance!
    Best regards,
    Pablo

    DB:3.18:Customers / Suppliers Interfaces' Implementation For R12 mx

    Hi,

    I was trying to implement interfaces for loading customers and suppliers, by populating the following tables:

    ra_customers_interface_all
    ra_customer_profiles_all
    ap_suppliers_int
    ap_supplier_sites_int

    I've seen the content Integration Repository but I was looking for some sample codes related. Anybody could help me on this?

    Thanks a lot in advance!
    Best regards,
    Pablo

  • RELEVANCY SCORE 3.18

    DB:3.18:How To Get Abs_Attendance_Reason_Id From Hr_Api_Transactions 71


    Hi

    I am implementing the Absence management on R12(12.1.3) , i have Absence Type and absence reason.For Example , Absence Type is Flexi Leave and absence reasons are Sick Leave, Paternity Leave,casual.

    Now my requirement is do some validation based on the Absence reason selected in SSHR so i need to get the Absence Reason from hr_api_transactions table .I followed the note R12 : How To Get The Absence Reason Id From Transaction Tables In R12 [ID 782927.1] but in my case the transaction_document does not contain the Absence Reason.

    Kindly please help me to resolve the issue.

    Thanks
    Gaurav

    DB:3.18:How To Get Abs_Attendance_Reason_Id From Hr_Api_Transactions 71

    If you are looking on Absence Reason Id on OA Code then you can get using pageContext.getParameter(ABSENSE_REASON_ITEM_ID).

    Thanks

  • RELEVANCY SCORE 3.18

    DB:3.18:R12 - Equivalent Column For Gl_Transfer_Run_Id Of Table Ap_Ae_Headers_All xa


    Hi,

    GL_TRANSFER_RUN_ID is a column present in 11i AP table AP_AE_HEADERS_ALL.

    In R12 the equivalent table is XLA_AE_HEADERS. Can you please let me know if there is a equivalent column for the 11i column GL_TRANSFER_RUN_ID in R12 tables?

    Thanks,
    Rumi

    DB:3.18:R12 - Equivalent Column For Gl_Transfer_Run_Id Of Table Ap_Ae_Headers_All xa

    Right.
    But upg_batch_id is NULL or -9999 (coz UNDO accounting) is R12 data. If any other then migrated.
    Also at present there are GL interface tables (XLA_GL_group_id) are present.
    Not sure when Oracle will stop to retain them.
    These have been added for debugging purpose.
    To drop them you need to run "Purge Temporary Journal Import Interface Tables Created by Subledger Accounting"

    By
    Vamsi

  • RELEVANCY SCORE 3.18

    DB:3.18:Oracle 11i India Localization Upgrade To R12 xz


    Hi,

    When we upgrade India localization instance from 11i to R12 how is the tax upgrade taken care in new module eBusiness Tax. How and what are the tables gets impact due to upgardation. where can one find the upgraded taxes in R12 and the backend tables.

    Regards,
    Shashi.

    DB:3.18:Oracle 11i India Localization Upgrade To R12 xz

    Duplicate thread (please post only once).

    oracle 11i India Localization upgrade to R12
    Re: oracle 11i India Localization upgrade to R12

    Thanks,
    Hussein

  • RELEVANCY SCORE 3.18

    DB:3.18:Error Interface Mtl_Transactions_Interface 19


    Hi Team, I made OPM Inventory R12 by pour through data tables interface with type Inter Org. When I call request "Process transaction interface" of Inventory then error messager inFor this transaction row either the lot records are missing or the lot quantity does not match the transaction quantityPls, help me.Thanks in Advance Regards,TINHDT

    DB:3.18:Error Interface Mtl_Transactions_Interface 19


    user12193364 wrote:

    Thanks for your reply,
    I have slove this problem.

    It would be great if you share the solution with us.Thanks,Hussein

  • RELEVANCY SCORE 3.18

    DB:3.18:Joins For Quality Tables k1


    Hi,Could you give me joins for below tables, r12.qa_resultsqa_results_vcs_incidents_audit_bThanks.

    DB:3.18:Joins For Quality Tables k1

    You can get from etrm, refer this link: http://etrm.oracle.com/pls/et1211d9/etrm_fndnav.show_object?n_tabid=55117n_appid=250c_type=TABLE http://etrm.oracle.com/pls/et1211d9/etrm_search.search thanks

  • RELEVANCY SCORE 3.18

    DB:3.18:Migration Of Approved Invoices From 11i To R12 7c


    Hi All,

    I am migrating all approved invoices from 11i to R12 using Invoice Interface tables and "Payables Open Interface Import" Concurrent program.But in R12 the Approval status changes and to "Required" and the Accounted status of distribution line changes to Unprocessed. We do not have the set up for approval work flow process, So the invoice should be validated by "Force Validation" by checking the Allow Force Approval in payable options. But when I am running the "Invoice Validation" program the theere is no change in the Approval status.

    Please help.

    Thanks in Advance,

    Subhrakant

    DB:3.18:Migration Of Approved Invoices From 11i To R12 7c

    Hi All,

    I am migrating all approved invoices from 11i to R12 using Invoice Interface tables and "Payables Open Interface Import" Concurrent program.But in R12 the Approval status changes and to "Required" and the Accounted status of distribution line changes to Unprocessed. We do not have the set up for approval work flow process, So the invoice should be validated by "Force Validation" by checking the Allow Force Approval in payable options. But when I am running the "Invoice Validation" program the theere is no change in the Approval status.

    Please help.

    Thanks in Advance,

    Subhrakant

  • RELEVANCY SCORE 3.18

    DB:3.18:11i To R12 Tables/Views Replacement Or Obsoleted. x1


    All Gurus,

    How to find out easily that the table has changed or replaced from 11i to R12 from backend of the both database.

    Thanks,

    DB:3.18:11i To R12 Tables/Views Replacement Or Obsoleted. x1

    user11164339 wrote:
    All Gurus,

    How to find out easily that the table has changed or replaced from 11i to R12 from backend of the both database.

    Thanks,Please see these links/docs.

    Identifying Data Model Changes Between EBS 12.1.3 and Prior EBS Releases
    https://blogs.oracle.com/stevenChan/entry/ebs_data_model_1213

    EBS Data Model Comparison Report Overview [ID 1290886.1]

    EBS Seed Data Comparison Reports Now Available
    https://blogs.oracle.com/stevenChan/entry/ebs_seed_data_comparison_reports

    eTRM
    http://etrm.oracle.com

    https://forums.oracle.com/forums/search.jspa?threadID=q=Tables+AND+11i+AND+R12objID=c3dateRange=alluserID=numResults=15rankBy=10001

    Thanks,
    Hussein

  • RELEVANCY SCORE 3.18

    DB:3.18:11i To R12 Tables Documentation 89


    Can Anyone tell me where i can find documentation for tables from 11i to related R12 tables.
    Its seems lot of tables have been changed in R12 and lot of tables has no data.
    like table/s IC_item_mst,IC_TRAN_PND,PM_BTCH_HDR etc .
    Please tell me where could i find columns related to these tables(11i) in R12.

    DB:3.18:11i To R12 Tables Documentation 89

    In R12 oracle has merged the OPM inventory and Discrete Inventory so that
    ic_item_mst merge with mtl_system_items_b link is ic_item_mst .item_no = mtl_system_items_b.segment1

    Ic_tran_vw1 merge with mtl_material_transactions link is ic_tran_vw1.doc_id = mtl_material_transactions.transaction_source_id

    PM_batch_header link with gme_batch_header

    Please always communicate with your functional consultant then he will lead you on all those technical areas.

    If you want any more clarification on opm and inv, mail me to rehmanimt@gmail.com.

    Thanks Regards,
    Abdul Rahiman.

  • RELEVANCY SCORE 3.18

    DB:3.18:Work In Process- Ebs R12- Tables Versus Functionality 7f


    Hi all,

    I have doubts on the below tables as how data populated to them in Oracle Apps (WIP)

    WIP_BIS_PROD_ASSY_YIELD
    WIP_BIS_PROD_DEPT_YIELD
    WIP_BIS_PROD_INDICATORS

    I have searched in the internet, it doesn't return useful results. Can any one tell which functionality or which form in Work in Process populates data to these tables?

    Appreciate help.

    Regards
    SK

    DB:3.18:Work In Process- Ebs R12- Tables Versus Functionality 7f

    Hi,

    Thanks for update.

    I have already went through it, could not make out underlying form/Functionality. Is there any other way you know?

    Regards,
    SK

  • RELEVANCY SCORE 3.17

    DB:3.17:Oracle 11i India Localization Upgrade To R12 d7


    Hi,

    When we upgrade India localization instance from 11i to R12 how is the tax upgrade taken care in new module eBusiness Tax. How and what are the tables gets impact due to upgardation. where can one find the upgraded taxes in R12 and the backend tables.

    Regards,
    Shashi.

    DB:3.17:Oracle 11i India Localization Upgrade To R12 d7

    Hi Hussain,

    Thanks for the reply but these two links are giving more of general information about the ebtax rather specific India Localization.

    Regards,
    Shashi.

  • RELEVANCY SCORE 3.17

    DB:3.17:Configure Apex In R12 kj


    Hi,

    Can any one help me out in configuring Apex in R12 application instance.

    Thanks,
    kalyan

    DB:3.17:Configure Apex In R12 kj

    Still you have issue with APEX, I have configured with help of this forms, I can help you.

  • RELEVANCY SCORE 3.17

    DB:3.17:Using Backward Compatible 11i Tables cx


    Hi
    --when we use R12 tables sometimes we have 11i tables(which are backward compatible)
    and sometimes these 11i tables are views in R12.

    Are we absolutely OK for using these tables which are backward compatible?

    thanks
    kumar

    DB:3.17:Using Backward Compatible 11i Tables cx

    Would you be able to explain why exactly you think the new development should not use the backward compatible views/tables.If you continue to use a backward compatible view, you are unnecessarily adding a step in your query execution plan. The query has to jump from the synonym to the view to the base table.
    Also, Oracle has a reason why it uses a new table - maybe it has a new column. If someone wants to simply add the new column to an existing code, they will have to modify your query and change the table name.
    If that person does not know much about your code, he/she will be wary of changing the tablename. But if he/she has to simply add a new column in select, it may appear easier.

    Also, if one is retrofitting existing code in 11i while moving to R12, would using backward compatible views be a recommended approach?My personal preference is to start using new tables as soon as it is available. But if you are simply ensuring that the old code works in R12, I can understand that you don't want to touch it. That way, you don't have to test your changes.

    But if the old code needs changes, you might as well start using the new objects.

    Sandeep Gandhi

  • RELEVANCY SCORE 3.16

    DB:3.16:Ebs R12 Database Structure. 71


    Hello All,

    I am new to EBS R12, I have an R12(vission instance) copy running on my VM. I would like to look into the EBS tables, for example all the HR schema, tables, and data. For this information(schema, tables and data) which document in the Oracle Documentation Library I have to use? http://docs.oracle.com/cd/B34956_01/current/html/docset.html

    Other resources also helps.

    Thanks and regards,

    DK

  • RELEVANCY SCORE 3.16

    DB:3.16:R12 Tables Help ac


    Hi all,

    Currently we are migrating 11.0.3 system to R12. so in 11.0.3 we used

    So_line_details_all,
    so_picking_lines_all,
    so_picking_line_details,
    so_actions,
    so_cycle_actions,
    so_order_types_all tables.

    Can any one help me with the R12 tables for the above tables.

    Thanks,
    Ranga

    DB:3.16:R12 Tables Help ac

    Please also see eTRM website -- http://etrm.oracle.com/pls/etrm/

    I'm not sure how you are doing this migration (since direct update from 11.0.x to 12.1.x is not supported) however you may review the following links and see if it helps.

    Identifying Data Model Changes Between EBS 12.1.3 and Prior EBS Releases
    https://blogs.oracle.com/stevenChan/entry/ebs_data_model_1213

    EBS Seed Data Comparison Reports Now Available
    https://blogs.oracle.com/stevenChan/entry/ebs_seed_data_comparison_reports

    If you still have any further questions about 11.0.x to 12.1.x migration/upgrade then I would suggest you log a SR.

    Thanks,
    Hussein

  • RELEVANCY SCORE 3.16

    DB:3.16:Need Information On R12 Error Tables. mz


    Hi Friends,

    I need information on R12 Error Tables and Staging Error tables. Can you please send me any documention on this.

    Little bit urgent.

    Thanks

    DB:3.16:Need Information On R12 Error Tables. mz

    Thanks for you Reply.

    Actually i am new to Apps. I am a OBIEE Developer. Here i will tell you the process. From Flat files to Staging area they are Loading the Data using some Scripts. After that they are using some concurrent programes for clensing the data and load them in to the Interface Tables. Then Those tables are loaded in to the Main oracle Tables.

    Mean while when they loading the data from staging to Interface they clensing the data. If Any errors occur they are moving those tables into some Built in Tables like (MTL_Interface_Errors). This is the process.

    And i don't know how to find the error tables..

    Thanks.

    Edited by: 806756 on Nov 9, 2011 1:34 AM

  • RELEVANCY SCORE 3.14

    DB:3.14:Re-Org Tables In R12 xp


    E-BIZ R12.1.3 pcp 2 NodesDB : R11.2.0.2 with RAC 2 nodes ASMOS : RHEL 5.5Hi ,recently we have purged huge data from OE_PROCESSING_MSGS,OE_PROCESSING_MSGS_TL and with "Purge Obsolete workflow runtime data"Now when i check used space of all above tables its in Mbs and occupied space is in GBs . As we know that delete never frees the space .Is it safe to reorg these tables using " alter table owner.tablename move;" and then rebuild the corresponding indexes .If any one have followed this procedure please help in this .Or if any other solution please share.Becoz it is causing performance issue as well.thanksMapps

  • RELEVANCY SCORE 3.13

    DB:3.13:Oracle Financial Tables And Sap Tables az


    Hi Everybody,

    Does anybody have a document which lists the names of the Tables and Fields in either Oracle 11i or R12 wth their description(the functions of each table Field) as well as the Tables in SAP?
    We have both the SAP and Oracle database in our environment.

    I am working on a project and I essentially need to know the equicvalent of the table names and fields of the GL, AP, AR, PO, OTC modules in both Oracle and SAP.

    Thanks in advance for any help

    DB:3.13:Oracle Financial Tables And Sap Tables az

    user13343586, I think you will be hard pressed to find a document in public domain that explicitly links SAP and EBS tables side by side.

    It won't be easy to build such a list ; in fact it may be impossible.
    Both ERPs are based on industry standards and do have some similar characteristics/functionality. But the actual implementation of that is vastly different. You may have to find someone who has worked on both ERPs and build a list yourself.

    I am consulting at a place which has SAP and Oracle. I am working (mainly) EBS and SAP both. It is not easy.

    Good luck,
    Sandeep Gandhi

  • RELEVANCY SCORE 3.13

    DB:3.13:Tables In Wf And There Usage. 9j


    hi,

    please provide me all wf table and their complete usage.

    one more help.

    performance analysis document for 11i and R12.

    thanks in advacne

    DB:3.13:Tables In Wf And There Usage. 9j

    Hi;

    please provide me all wf table and their complete usage.You can check e-trm site and also below link:
    Diagram of Relationship between Core Workflow Tables [ID 444446.1]
    http://www.appsbi.com/oracle-workflow-tableswf_activities-wf_items-wf_notifications
    http://www.club-oracle.com/articles/workflow-tables-and-queries-301/

    performance analysis document for 11i and R12.How to monitor performance in Oracle E-Business suite R12 [ID 472443.1]

    Regard
    Helios

  • RELEVANCY SCORE 3.13

    DB:3.13:Payment Batches In R12 d9


    How to see the payment Batches in R12 . Can any one please tell me and the back end tables related to that ?

    DB:3.13:Payment Batches In R12 d9

    You can see the Payment batches that you have submitted from "Payments Manager". This is web based form available from the navigator. The information will be available from "Payments Dashboard" section, and you could also query from Payment Process Requests if you know the job that was submitted.

    For the back end tables, you can refer to the tables owned by owner "IBY" or tables beginning with "IBY".

  • RELEVANCY SCORE 3.13

    DB:3.13:Does Ebs 9.1.0.3 Support Ebs Version R12 3m


    Hi,
    Anyone knows if EBS/HRMS 9.1.0.3 support EBS/HRMS version R12. Please help me out

    Thanks

  • RELEVANCY SCORE 3.13

    DB:3.13:Supplier Creation Using Apis In R12 (Urgent) fp


    Hi All,

    I will be working on supplier interface in Payables of R12 version.i would like to use the below APIs

    1.AP_VENDOR_PUB_PKG.create_Vendor
    2.AP_VENDOR_PUB_PKG.Create_Vendor_Site
    3.AP_VENDOR_PUB_PKG.Create_Vendor_Contact

    for above APIs what are the mandatory fields/columns to use the suppler creation, suppler site creation and contact details creation.
    so that i can ask the client to provide the mandatory fields.
    when we use APIs to create suppler what are the tables get effected in R12 version.

    I have created supplier from front-end, i have given bank related information. when i query AP_SUPPLIERS Table, i have not see the BANK ACCOUNT related information in AP_SUPPLIERS TABLE. where can i see/find the bank related information for suppliers.

    please help me to sort out this issue.

    Thanks.

    DB:3.13:Supplier Creation Using Apis In R12 (Urgent) fp

    Suppliers in R12 are included within the TCA.
    Supplier Banks will now be categorized as Parties. You may validate it by checking that the bank information you have loaded into IBY_EXT_BANK_ACCOUNTS would also get loaded into HZ_PARTIES.
    Bank address information will be a part of the Party Site.
    Bank Site and Location information will have to be loaded into HZ_PATRY_SITES and HZ_LOCATIONS. For that, you will have to use the TCA APIs hz_party_site_v2pub.create_party_site and hz_location_v2pub.create_location

    Regards,

  • RELEVANCY SCORE 3.12

    DB:3.12:Collections Screen Tables In R12 ad


    Hi,

    I have a requirement to create a new Collector Call history in R12 as these report have been dicommissioned in R12. User is entering the data in Notes and Task tab in the Collection screen. When we select the Organization and select View -Customer- Then it will display all notes in notes tab. I am not able to find out the link between these two.How notes data is displaying customer wise.The table/view AST_NOTES_DETAILS_Vl is having source_object_id field which contains the Customer account ID but when when user enter the notes using Interaction screen then there is no cust_Accout_id. Then how it displays the data? I am really confused... What are the tables names of Interaction screen and what is the link???
    Please help..

    Thanks,
    Joohi

    DB:3.12:Collections Screen Tables In R12 ad

    Hi,

    I have a requirement to create a new Collector Call history in R12 as these report have been dicommissioned in R12. User is entering the data in Notes and Task tab in the Collection screen. When we select the Organization and select View -Customer- Then it will display all notes in notes tab. I am not able to find out the link between these two.How notes data is displaying customer wise.The table/view AST_NOTES_DETAILS_Vl is having source_object_id field which contains the Customer account ID but when when user enter the notes using Interaction screen then there is no cust_Accout_id. Then how it displays the data? I am really confused... What are the tables names of Interaction screen and what is the link???
    Please help..

    Thanks,
    Joohi

  • RELEVANCY SCORE 3.12

    DB:3.12:Ebs R12 f3


    dear all, i m new to oracle apps r12,is there any good book to study ebs r12? your help appreciated.thanks in advance.regards,

    DB:3.12:Ebs R12 f3

    Hi;Please dont forget to change thread status to answered if it possible when u belive your thread has been answered, it pretend to lose time of other forums user while they are searching open question which is not answered,thanks for understandingRegardHelios

  • RELEVANCY SCORE 3.12

    DB:3.12:Diff B/N 11i And R12 As Dba Considering Dba Tasks mm


    Hi Friends

    Can you please provide me
    1)what are the main differences in b/n 11i and R12 as considering dba tasks
    2).Is there any new features added in R12,If so let me know those new features
    3).Is there any new tables added in R12,if so please inform to me
    4).

    Regards
    Reddy

    DB:3.12:Diff B/N 11i And R12 As Dba Considering Dba Tasks mm

    Hello,

    Your question is not at all related to installation. Please post in an appropriate forum;

    Forum: EBS General Discussion
    General EBS Discussion

    Adith

  • RELEVANCY SCORE 3.12

    DB:3.12:Ap: Reconcile Upgraded Data kx


    Hi team,I want to know scripts/reports in R12 that will help reconcile data in XLA and GL tables post upgrade.I want to compare XLA and GL balances by period and verify that they are matching.Please help/suggest for source=Payables.I tried few scripts, but data is not perfectly matching.Regards,Siddhi

    DB:3.12:Ap: Reconcile Upgraded Data kx

    Hi George,This was Great help for me !I was able to perfectly match my data with this and resolve the business concerns.Thank you so much..!!!Stay in Touch!Regards,Siddhi

  • RELEVANCY SCORE 3.12

    DB:3.12:R12 Upgrade Data In Xla Tables For Old Purchase Orders 71


    Hi all,I see that we have XLA tables in R12 for accounting and that is where we have all the accounting information and they act a bridge between GL tablesand PO tables.My question is what happens to old PO's that were created in 11i?When we upgrade to R12 will the upgrade process create recordsfor old PO's in XLA tables?Thanks.

    DB:3.12:R12 Upgrade Data In Xla Tables For Old Purchase Orders 71

    Hi all,I see that we have XLA tables in R12 for accounting and that is where we have all the accounting information and they act a bridge between GL tablesand PO tables.My question is what happens to old PO's that were created in 11i?When we upgrade to R12 will the upgrade process create recordsfor old PO's in XLA tables?Thanks.

  • RELEVANCY SCORE 3.12

    DB:3.12:Help Needed - Implement Advanced Table Inline Form Edit 8p


    Hi,

    Im new to Oracle Apps r12 (Originally PeopleSoft developer) now my company is shifting to R12 / fusion.

    I have a requirement that details an editable table. However, users demand that any edit on the table must occur on the same page. I'm looking for an interface similar to those found in Zohocreator.com in which an edit icon reveals a hidden input form immediately below the row being edited. As much as possible this action should not reload the entire page. Can this be done in Apps 12?

    Is there a better way to implement editable tables in R12? Loading a secondary page is not an option.

    Please if this was answered already kindly show me the link as I tried looking for a better keyword than "inline form advance table edit" but it seems I'm not having any luck.

    DB:3.12:Help Needed - Implement Advanced Table Inline Form Edit 8p

    Hi Thank you for the timely feedback.

    Unfortunately the Dev Guide discussion on advanced table is quite a bit short and perhaps does not readily answer all of what I need. Perhaps a detailed description of my requirement is needed.

    Firstly, I'm creating a simple input form with complex master - detail structure.

    It has 3 main regions and is enclosed in a page wide form. It is important to note that user does not want popups or any redirects. All data entry must be done in this page alone. This includes the detail advance tables. The first region is the master data entry and the next two regions are linked detail tables. The save operation must be done in a batch mode. It means the entire page is saved once and only once when you hit the submit button. Any data entry or insert operation made in the detail tables must be repeatable and saved in the session.

    I'd like to know which specific events do I need to capture to simulate the following logic:
    1. The detail advance tables must require that the user completes the data in the master data entry region. For example the main record creation date is needed to be linked to this detail records as a default value without having the master record persist. (This will actually be done vis-a-vis with all the data inside the page)

    2. I need to make the insertion of data repeatable in the advanced detail tables validating against the master record without persisting it first. How is this possible?

    3. Some columns in the master table are too large to show, say for example a long memo note. I want ALL my data entry to happen in a "detail" subcomponent How do I invoke a show hide through a custom footer button? This is not mentioned in the Dev guide... I want to overrired the show hide link. Basically 2 things.
    - Show the detail page when the user hits the Add New Row custom button (Not the Add New Row footer action) Then initialize a new VO/EO row.
    - Inside the detail page of the Advanced table, I have 2 buttons Update and Cancel
    - Update commits the new row inserted, Cancel makes the table in the read only state.
    - I have a link that represents the edit icon on each rows. Clicking it will also display the record in edit mode with Update and Cancel rows.

    Currently if I use the Add New Row footer action then my column components must be readily editable. I do not want this. I want the table to be presented as read only and only show the detail table popup when necessary i.e. adding / updating existing rows.

    I have no problems creating the UI. My main problem is the programmatic approach that the Dev Guide still lacks.

    I have made a sample prototype the Add action in this is a popup but not in a traditional sense. How do I simulate this in R12, show/hide regions?

    http://creator.zoho.com/ojdelosreyes/address-book/view/1/

  • RELEVANCY SCORE 3.12

    DB:3.12:Hi, k8


    Hi , plse help me.. what is the difference between org_id in 11i and R12? and how to create operating unit in R12?

    DB:3.12:Hi, k8

    Thnx a lot...its helpful..

  • RELEVANCY SCORE 3.11

    DB:3.11:I Need The Box And Weight Columns From R12 Tables df


    Hi ,

    I need the BOX and WEIGHT columns
    I tried the table CSP_PACKLIST_BOXES
    But it shows no data

    Please help on this

    Thanks
    Kiran

    Edited by: Kiran on Apr 17, 2012 2:29 AM

    DB:3.11:I Need The Box And Weight Columns From R12 Tables df

    Kiran wrote:
    Hi ,

    I need the BOX and WEIGHT columns
    I tried the table CSP_PACKLIST_BOXES
    But it shows no data

    Please help on this

    Thanks
    Kiran

    Edited by: Kiran on Apr 17, 2012 2:29 AM what do you mean by box and weight columns??
    Are they physical attributes of an item??

    HTH
    Mahendra

  • RELEVANCY SCORE 3.11

    DB:3.11:Ebs R12 Database Documentation xa


    Are there any manuals to list all views and tables in the r12 financials database, i.e. tables, relationships with other tables, list of columns and descriptions etc? Also does anyone no from experience which are the key tables which details of payments and suppliers?

    DB:3.11:Ebs R12 Database Documentation xa

    Hussein, Your expert input to these questions most welcome:https://community.oracle.com/thread/3555971

  • RELEVANCY SCORE 3.11

    DB:3.11:Joins For Inv Tables R12 77


    Hi,

    Could you provide joins for below tables:

    mtl_system_items_b
    mtl_kanban_cards
    mtl_onhand_quantities_detail
    MTL_SECONDARY_INVENTORIES
    MTL_ITEM_CATEGORIES
    MTL_CATEGORY_SETS_TL
    MTL_CATEGORIES_B

    Thanks

    DB:3.11:Joins For Inv Tables R12 77

    Hi,

    Could you provide joins for below tables:

    mtl_system_items_b
    mtl_kanban_cards
    mtl_onhand_quantities_detail
    MTL_SECONDARY_INVENTORIES
    MTL_ITEM_CATEGORIES
    MTL_CATEGORY_SETS_TL
    MTL_CATEGORIES_B

    Thanks

  • RELEVANCY SCORE 3.10

    DB:3.10:11i To R12 Tables Documentation c7


    Can Anyone tell me where i can find documentation for tables from 11i to related R12 tables.
    Its seems lot of tables have been changed in R12 and lot of tables has no data.
    like table/s IC_item_mst,IC_TRAN_PND,PM_BTCH_HDR etc .
    Please tell me where could i find columns related to these tables(11i) in R12.

    Gaurav

    DB:3.10:11i To R12 Tables Documentation c7

    AFAIK, there is no Metalink Doc that details table changes between 11i and R12. You will have to do this comparison yourself if you have the two releases installed. The R12 RCD's can be found in Doc 404152.1.

    HTH
    Srini

  • RELEVANCY SCORE 3.10

    DB:3.10:Employee Leave Details Tables ca


    I'm new to HRMS and Payroll.

    Can any one help me with the employee leave detail tables

    In which table I can find the below details in R12

    Allowed sick / vacation / comp leave for each employee?

    How many days/hours remaining in sick / vacation / comp for each employee?

    Thanks in advance.

    DB:3.10:Employee Leave Details Tables ca

    Leave Balance is not stored directly in tables but derived using a formula. You have to create accrual plans to create leave accrual balances. Check HRMS guide to find out how you can set up accrual plans

  • RELEVANCY SCORE 3.09

    DB:3.09:R12 With Rac 7a


    Hi,

    can some body help me with the note / doc to setup R12 with 10g RAC

    Thx.

    DB:3.09:R12 With Rac 7a

    The step by step guide is here:

    Configuring Oracle Applications Release 12 with 10g R2 RAC
    http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=388577.1

  • RELEVANCY SCORE 3.08

    DB:3.08:Api To Insert In Payment (Ap_Checks_All) 33


    Hi ,
    Will you guide me how to get the API specialized to insert in payment tables R12
    thanks

    DB:3.08:Api To Insert In Payment (Ap_Checks_All) 33

    Hi ,
    Will you guide me how to get the API specialized to insert in payment tables R12
    thanks

  • RELEVANCY SCORE 3.08

    DB:3.08:How To Calculate Intransit Quantity In Oracle R12 Inventory 19


    Hi Gurus,
    can anyone tell me how to calculate Intransit Quantity in oracle r12. i need a query or tables to find this qty.

    Thanks Regards
    Shariff

    DB:3.08:How To Calculate Intransit Quantity In Oracle R12 Inventory 19

    Hi shariff

    See if this can help

    select T.INVOICED_FLAG, T.ACTUAL_COST , T.TRANSACTION_DATE,T.TRANSACTION_QUANTITY, T.INVENTORY_ITEM_ID , T.SUBINVENTORY_CODE from mtl_material_transactions T, MTL_ONHAND_QUANTITIES O where SUBINVENTORY_CODE = 'INTRANSIT' AND T.INVENTORY_ITEM_ID NOT IN O.INVENTORY_ITEM_ID

    Regards,
    AppsmAsTi
    Sharin IS caRIn

  • RELEVANCY SCORE 3.08

    DB:3.08:Absolute Tables mf


    Hi tech guys,

    we are trying to upgrade oracle applications 11i to r12. Now we need absolute tables under Manufacturying, Distibution and Finance all modules.

    I tried to search in google and other oracle sites.

    Please help me how to find these absolute tables.

    Thanks

    DB:3.08:Absolute Tables mf

    Hi;

    Please see your other thread
    Obsolete Tables in R12

    Regard
    Helios

  • RELEVANCY SCORE 3.08

    DB:3.08:Which Tables Contain Sensitive Data fp


    Are there any documents which list which tables associated with Oracle EBS r12 contain personal and sensitive data?

    DB:3.08:Which Tables Contain Sensitive Data fp

    Srini Chavali wrote:
    There are third party solutions (such as http://www.mentisoftware.com/index.html) that can identify where sensitive data is stored in an EBS database

    HTH
    SriniWhich is not free and you need to pay for its license to use it ;)

    Thanks,
    Hussein

  • RELEVANCY SCORE 3.07

    DB:3.07:Ebs R12 (12.0.6) Giving Slow Response To Clients. 7s


    Hi,

    Anyone can help me to findout the bottleneck of slow response of EBS r12.
    We r using oracle 10g (10.2.0.3) and r12 (12.0.6).

    its urgent...plz.

    thx.

    DB:3.07:Ebs R12 (12.0.6) Giving Slow Response To Clients. 7s

    Hi;

    Similar topic discussed before,Please check:

    -business Performance issuse
    Re: E-business Performance issuse

    You can also check [this search|http://forums.oracle.com/forums/search.jspa?threadID=q=performanceobjID=c3dateRange=alluserID=numResults=15]

    Regard
    Helios

  • RELEVANCY SCORE 3.07

    DB:3.07:Connectivity Between Oracle Soa Suite And Ebs R12 Using .Dbc File ac


    Hi:

    We are integrating Oracle SOA Suite (11.1.1.4) with Oracle EBS R12. In the process we are using Apps and DB adapters in our services to retrieve the informations from APIs , Views and Tables. For that we have created Datasource in Weblogic console (10.3.4) with the credentials provided by Oracle EBS R12.

    Right now EBS has changed their credentials and provided a *.dbc* file and asked us to connect to R12 via this file. We are not sure how to use this *.dbc* file, where to configure, what is the datasource we need to create for this file and lastly what is the adapter we need to create in our services?

    Any help highly appreciated.

    Regards
    RK

    Edited by: RK.. on 18/03/2013 18:17

    DB:3.07:Connectivity Between Oracle Soa Suite And Ebs R12 Using .Dbc File ac

    Thanks. Will proceed with the steps and update if there is any issues

  • RELEVANCY SCORE 3.07

    DB:3.07:India Localizaion R12 Po Interface With Taxes fc


    Hi,

    Please help me to provide india localization PO interface tables and details In R12.
    I want to upload tax information also. Please give the tables. If documents available with you please forward it to me (prasanna884@gmail.com)

    Thanks
    Prasanna

    DB:3.07:India Localizaion R12 Po Interface With Taxes fc

    Hi,

    Please help me to provide india localization PO interface tables and details In R12.
    I want to upload tax information also. Please give the tables. If documents available with you please forward it to me (prasanna884@gmail.com)

    Thanks
    Prasanna

  • RELEVANCY SCORE 3.07

    DB:3.07:R12 Column Mapping For 11i Table Icx_Cat_Items_Tlp.Rt_Item_Id sa


    Hi ,
    we are upgrading the 11.5.10.2 to R12.1.3 . I was found some of the tables got obsolete in 11i and changed those in R12.
    Can anybody tell me the column mapping in R12 for the following 11i column.

    11i Column;
    icx_cat_items_tlp.rt_item_id

    R12 table:
    icx_cat_items_ctx_hdrs_tlp

    Thanks
    Robert.

    DB:3.07:R12 Column Mapping For 11i Table Icx_Cat_Items_Tlp.Rt_Item_Id sa

    Hi Robert;

    Please see below thread:

    Table Changes 11.5.10 to 12.1
    Re: Table Changes 11.5.10 to 12.1

    Regard
    Helios

  • RELEVANCY SCORE 3.05

    DB:3.05:Need Help: R12 : Payment Data Needs To Be Convert k3


    Dear Friends,

    I have to convert the payment data to oracle application tables including SLA tables.

    Customer implemted the R12 newly (12.1.3). There were not used any oracle apps version earlier. So they are going to giving the data in excel sheet, which have to convert to oracle tables.
    I have searched i think there no interface tabels and programs for this payments, Can you please help me how can we achive this requirement that converting payment data oracle apps r12 tables.
    Waiting for valuable help.

    Thanks in the advance.

    Thanks Best Regards,
    Sathiya

    DB:3.05:Need Help: R12 : Payment Data Needs To Be Convert k3

    Dear Friends,

    I have to convert the payment data to oracle application tables including SLA tables.

    Customer implemted the R12 newly (12.1.3). There were not used any oracle apps version earlier. So they are going to giving the data in excel sheet, which have to convert to oracle tables.
    I have searched i think there no interface tabels and programs for this payments, Can you please help me how can we achive this requirement that converting payment data oracle apps r12 tables.
    Waiting for valuable help.

    Thanks in the advance.

    Thanks Best Regards,
    Sathiya

  • RELEVANCY SCORE 3.05

    DB:3.05:New Tables In R12 cc


    Just wondering if new tables are introduced in Oracle Apps R12 that are not in R11.10.5.2 and also if some are dropped.

    DB:3.05:New Tables In R12 cc

    Hi,

    Also refer to eTRM website for details about those new/dropped tables.

    Oracle eTRM
    http://etrm.oracle.com

    Regards,
    Hussein