top of page

Lucinda B. Curiosity Corner

Public·86 members
Landon Stewart
Landon Stewart

Oracle EBS R12 How To Call Standard API Packages From Custom Form Or Reports


(i) If data is corrupted by user error then Oracle Support will not fix the data. For example:- If the user voids a check in error and now would like to use SQL to make the check negotiable again.- If the data were mistakenly uploaded to credit card table and client would like to delete it.- If the customer has inadvertently swept transactions to the next period and wants to pull back the data to current period.- If the GL period was closed before the AP period, and transactions are failing, because they cannot transfer to the GL.- If the user enters incorrect invoice distribution account that may cause out of balance (e.g. enters wrong balancing segment value), and invoice cannot account, or if the Supplier was setup with the incorrect balancing segment value.(ii) If corrupted data is caused by or related to any customization, as customizations are not supported. This also applies any non-supported changes to views, forms, reports, programs/packages or anything provided standard / seeded by Oracle.(iii) If there is a desired customization, data modification, or lack of reporting needed by the business. Example:




Oracle EBS R12 How To Call Standard API Packages From Custom Form Or Reports



Note that these are illustrative examples only and this is NOT an exhaustive list. Essentially these examples stem from mistakes in using the application, ignoring warnings and alerts while using the same, and/or extending or customizing existing or non-existent objects / forms / reports / etc.


Oracle Support is available to assist in the troubleshooting and diagnosis of problems that Customers experience during the implementation and use of Oracle products. Oracle Support is not staffed to deliver Education or Consulting Services nor is this type of service priced into Support fees. When implementing Oracle software, customers should always plan for the cost of educating the project team or internal team (functional and technical) and consider Oracle Consulting, if assistance is required in performing an implementation, upgrade, or customization.Some specific areas that are outside the realm and scope of Support include (this list is not all inclusive and Oracle Support reserves the right to determine out of scope areas):1) Mapping business requirements to product functionality.2) Educating project team members on how to run scripts or navigate through your operating system file structures.3) Diagnosing performance issues that result from hardware issues.4) Customizations to the e-Business Suite. This includes the coding of client extensions and/or API's as well as coding of custom reports/forms.5) Assisting with custom queries or reports against Oracle delivered tables/views that exist in the e-Business Suite (including performance tuning).6) Fixing issues due to user error.


Oracle Support is available to assist in the troubleshooting and diagnosis of problems that customers experience during the implementation and use of Oracle products. Some specific areas that are outside the scope of Support which are related to data fixes include:1) User errors.2) Customizations to any queries, views, reports, forms or changes to any piece of the standard delivered Oracle product.3) Data from outside source (like for conversion from legacy system).4) 3rd party hook (like the Vertex Tax product package).5) Training is not supported. For example what accounts to assign the credit and debit fields when creating the transfer rule.6) If customer changes a critical or major setup (example add a new Primary or Reporting set of book or disabling / enabling automatic offset) and transactions are already in the system but not completed processing.


Support analysts may address questions regarding basic functionality, but the charter does not allow for Oracle Support to assist in debugging custom code, provide support on seeded table relationships/definitions or make updates to tables for the purposes of customization when no bug or data corruption is involved. The Applications architecture is very complex and is under proprietary control. Any issues with the standard Application can be directed to the appropriate Applications support team, (i.e. General Ledger, Accounts Receivable, etc.).Please review: : "Oracle Customer Services Policy Regarding Customizations" for further information. : "FAQ on E-Business Suite Customizations": Oracle Support Services Policy Regarding CustomizationsPlease review the eTRMs and documentation available via My Oracle Support, contact your Oracle Account Manager or Oracle Consulting. Oracle Consulting is available as a resource for those customers who wish to perform customizations within Oracle Applications. Service offerings are available at:


Now, when running the GSCC checks for custom Oracle forms and reports the same violation is presented but they only point to standard EBS schemas i.e. INV.table_name which we will need to amend to APPS.table_name. The GSCC outputs do not display any violation against registered custom schemas in forms and reports i.e. accessing a table via our XXSCHEMA is not listed in the GSCC results.


We are in doubt if Oracle forms and reports could select data from the custom tables (registered schemas) directly i.e. XXSCHEMA.table_name without using the APPS synonym as this is not listed in the GSCC results.


It is just good practice to fix forms and reports that do not point at the APPS editioned view in lieu of pointing at the EBS table (e.g. apps.per_all_people_f in lieu of hr.per_all_people_f or apps.custom_table1 in lieu of xxschema.custom_table1).


Since forms and reports will be executed using APPS with the end user's context, it is advocated that one not qualify the editioned view (e.g. just use per_all_people_f). References to registered schemas which are custom should also follow this practice.


  • During the data mapping process, list of all the data sets and data elements that will need to be moved into the Oracle tables as part of conversion are identified. Data mapping tables are prepared as part of this activity that show what are the data elements that are needed by the target system to meet the business requirements and from where they will be extracted in the old system.Download ProgramsAfter the conversion data mapping is complete, download programs are developed that are used to extract the identified conversion data elements from the current systems in the form of an ASCII flat file. The structure of the flat file must match the structure of the Oracle standard interface tables. These flat files generated may be in text form or a comma or space delimited, variable or fixed format data file.

  • Upload ProgramOnce the data has been extracted to a flat file, it is then moved to the target file system and the data from the file is loaded into user defined staging tables in the target database using SQL Loader or UTL_FILE utilities. Then programs are written and run which validate the data in the staging tables and insert the same into the Oracle provided standard Interface tables.

Interface ProgramOnce the interface tables are populated, the respective interface program (each data element interface has a specific interface program to run) is submitted. The interface programs validate the data, derive and assign the default values and ultimately populate the production base tables.


This function gets a translated and token substituted message from the message dictionary database. It returns NULL if the message cannot be found. If this function is called from a stored procedure on the database server side, the message is retrieved from the Message Dictionary table. If the function is called from a form or forms library, the message is retrieved from the messages file on the forms server.


Viewed 100K+ times! This question is You Asked Hi Tom,How can I know what a given user is executing if his status is ACTIVE ? How can I know which PL/SQL blocks or SQL statements are being run by him ? As to SQL statemets, I can join v$session.user# with v$sqlarea.parsing_user_id ( am I really right ??? ), but I am not sure about PL/SQL blocks. How can I track the execution of those objects and queries (something like V$transaction for entire trasactions) ?Regards. and Tom said...I use the script at the bottom. It shows everyone logged in and if they are active, what they are doing and how long they've been doing it.If someone is executing PLSQL, what you will see will depend on what the plsql is currently doing. If the plsql is doing SQL, you'll see the SQL. if the plsql is doing lots of PLSQL work -- you'll see that code. What I like to do is have everyone "instrument" their code with calls to dbms_application_info which can fill in the client_info, action, and module columns in v$session. In this fashion, you can see where in a procedure someone is based on the values in these columns. showsql exposes this information to you as well. sqlplus uses it to show you what script someone is running for example...---------------- showsql.sql --------------------------column status format a10set feedback offset serveroutput onselect username, sid, serial#, process, statusfrom v$sessionwhere username is not null/column username format a20column sql_text format a55 word_wrappedset serveroutput on size 1000000declare x number;begin for x in ( select username'('sid','serial# ') ospid = ' process ' program = ' program username, to_char(LOGON_TIME,' Day HH24:MI') logon_time, to_char(sysdate,' Day HH24:MI') current_time, sql_address, LAST_CALL_ET from v$session where status = 'ACTIVE' and rawtohex(sql_address) '00' and username is not null order by last_call_et ) loop for y in ( select max(decode(piece,0,sql_text,null)) max(decode(piece,1,sql_text,null)) max(decode(piece,2,sql_text,null)) max(decode(piece,3,sql_text,null)) sql_text from v$sqltext_with_newlines where address = x.sql_address and piece loop if ( y.sql_text not like '%listener.get_cmd%' and y.sql_text not like '%RAWTOHEX(SQL_ADDRESS)%') then dbms_output.put_line( '--------------------' ); dbms_output.put_line( x.username ); dbms_output.put_line( x.logon_time ' ' x.current_time ' last et = ' x.LAST_CALL_ET); dbms_output.put_line( substr( y.sql_text, 1, 250 ) ); end if; end loop; end loop;end;/column username format a15 word_wrappedcolumn module format a15 word_wrappedcolumn action format a15 word_wrappedcolumn client_info format a30 word_wrappedselect username'('sid','serial#')' username, module, action, client_infofrom v$sessionwhere moduleactionclient_info is not null; Rating (118 ratings)Is this answer out of date? If it is, please let us know via a Comment Comments Comment thanksOlga, July 25, 2001 - 6:01 pm UTC


About

All about horses.

Members

bottom of page