原站：http://scripts4oracle.blogspot.com/

标签：passi anil

“scripts For Oracle Applications”的内容更新

累计：14 篇（自 2008-10-12 起）

更新：约4篇/年，最后更新1227 天前

scripts For Oracle Applications

GL_IMPORT_REFERENCES

Please find a package that will provide you various transaction details when drilling down from GLThanksAnil PassiCREATE OR REPLACE PACKAGE BODY xx_gl_to_modue_trx_details_pkgAS FUNCTION get_transaction_date ( p_source IN VARCHAR2, p_category IN VARCHAR2, p_actual_flag IN VARCHAR2, p_je_header_id IN NUMBER, p_je_line_num IN NUMBER, p_reference_1 IN VARCH... (313 天前)

http://inezha.com/w/xuuw2xy

scripts For Oracle Applications

testing workflow

in response to a query raised on below URLhttp://oracle.anilpassi.com/index.php?option=content&task=view&id=27... (313 天前)

http://inezha.com/w/yx2xbxp

scripts For Oracle Applications

Self Service HR Script 3 to allocate responsibilitie

set scan on ;set scan off ;CREATE OR REPLACE PACKAGE BODY xx_sshr_allocate_resp_pkg IS--DO NOT RUN THIS WITHOUT CHANGING XXPRD--REPLACE XXPRD BY RESULT OF BELOW SQL FROM PRODUCTION--select instance_name from v$instance ; --Created in Nov 06 by Anil Passi /* When By Why ----------------------------------------------- 29Nov06 AnilPassi To allocate responsi... (313 天前)

http://inezha.com/w/08jujxd

scripts For Oracle Applications

Self Service HR rollout Script 2 to create users

CREATE OR REPLACE PACKAGE xx_sshr_allocate_resp_pkg IS PROCEDURE run(errbuf OUT VARCHAR2 ,retcode OUT VARCHAR2 ,p_responsibility_name IN VARCHAR2 ,p_person_type IN VARCHAR2 ,p_cost_centre_group_1 IN VARCHAR2 ,p_cost_centre_group_2 IN VARCHAR2 ,p_parent_org_1 IN VARCHAR2 ,p_parent_org_2 IN VARCHAR2 ,p_cid IN VARCHAR2 ,p_read_only_flag IN VARCHAR2 ,p_test_... (313 天前)

http://inezha.com/w/er5nyx9

scripts For Oracle Applications

SSHR Rollout Script 1 to Create Users

YOU HAVE REACHED HERE FROM ORACLE.ANILPASSI.COMset scan on ;conn xxschema/&2 ;--drop table xx_sshr_allocate_resp ;create table xx_sshr_allocate_resp( sshr_allocate_resp_id INTEGER,person_id INTEGER,future_dated_employee_flag VARCHAR2(1),responsibillity_name VARCHAR2(500),error_during_resp_allocation VARCHAR2(4000),fnd_user_id VARCHAR2(100),fnd_request_id... (313 天前)

http://inezha.com/w/rg13ux5

scripts For Oracle Applications

Fast Refresh Mat...

Fast Refresh Materialized View GL_CODE_COMBINATIONS with DescriptionThis was my third attempt to get the Fast Refresh Materialized views to work on GL_CODE_COMBINATIONS by tricking Oracle 10g. The descriptions are being fetched by using a function. This function is blanked out to return null just prior to the creation of snapshot.Surely, the function bei... (313 天前)

http://inezha.com/w/na6lrws

scripts For Oracle Applications

ORA-12054 for Ma...

ORA-12054 for Materialized View on GL_CODE_COMBINATIONSThe below script was my second attempt to create a fast refresh Materialized View in Oracle. The last step in the scipt failed because Oracle is unable to create a Fast Materialized view referencing a package function because it deems this to be complicated.Anyway, in the third attempt, we will do a ... (313 天前)

http://inezha.com/w/9s542wc

订阅者 ( 1 )

相关订阅源