Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple.
Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips by upgrading to "Premium Membership".
Oracle Training

Welcome, Guest
You have to register before you can post on our site.

Username
  

Password
  





Search Forums

(Advanced Search)

Forum Statistics
» Members: 30,485
» Latest member: Narenpdk@gmail.com
» Forum threads: 735
» Forum posts: 1,392

Full Statistics

Online Users
There are currently 7 online users.
» 0 Member(s) | 7 Guest(s)

Latest Threads
Oracle Implementation Pro...
Forum: Oracle Tutorials, Articles, eBooks, Tools & Tips
Last Post: Luz Navarrete
11-18-2017, 02:30 AM
» Replies: 22
» Views: 44,674
Oracle Fusion Financials ...
Forum: Cloud ERP
Last Post: M Irfan
10-27-2017, 07:45 PM
» Replies: 0
» Views: 221
Help in documentation
Forum: Oracle Tutorials, Articles, eBooks, Tools & Tips
Last Post: admin
10-20-2017, 05:46 AM
» Replies: 1
» Views: 175
How to create the Primary...
Forum: Cloud ERP
Last Post: M Irfan
10-08-2017, 09:20 PM
» Replies: 0
» Views: 166
Oracle Cloud Fusion Finan...
Forum: Oracle Tutorials, Articles, eBooks, Tools & Tips
Last Post: M Irfan
10-08-2017, 08:48 PM
» Replies: 0
» Views: 493
Oracle AIM - BR100 Docume...
Forum: Oracle Tutorials, Articles, eBooks, Tools & Tips
Last Post: adroit.ramesh@gmail.com
10-06-2017, 02:13 PM
» Replies: 33
» Views: 122,742
Oracle AIM - BR100 Docume...
Forum: Oracle Tutorials, Articles, eBooks, Tools & Tips
Last Post: adroit.ramesh@gmail.com
10-06-2017, 02:10 PM
» Replies: 2
» Views: 13,894
Important concepts for ne...
Forum: Oracle Tutorials, Articles, eBooks, Tools & Tips
Last Post: yugirala
10-05-2017, 10:44 PM
» Replies: 6
» Views: 5,123
Oracle Fusion Financials ...
Forum: Oracle Tutorials, Articles, eBooks, Tools & Tips
Last Post: M Irfan
10-01-2017, 09:36 PM
» Replies: 0
» Views: 305
Oracle HRMS BR100 documen...
Forum: Oracle Tutorials, Articles, eBooks, Tools & Tips
Last Post: ahmad.ora
09-19-2017, 01:18 AM
» Replies: 4
» Views: 5,980

 
  online GL Account Analysis inquiry
Posted by: Sara Khan - 11-30-2010, 11:54 PM - Forum: Oracle Financials - Replies (2)

is there any online inquiry that displays all transactions against a single Account Code Combinition e.g. 01.110.6160.1400.110 and during a specific period e.g. between 01-JAN-2010 to 14-APR-2010?

Further, is there a drill down available in this Form which takes us to the source transactions from AP/AR/FA/INV etc.

Is there any standard Form / Report available, without any customization?

Print this item

  New implementation on R12?
Posted by: admin - 11-30-2010, 08:33 PM - Forum: Oracle Financials - Replies (1)

We would like to define a Chart of Account with 4 segments (Company, Department, Account and Inter-Company). Is it possible to define a COA with 2 different languges?
For example:

Account Code-Englisth Description-Chinese Description
1000-Stationary-Chinese description for stationary

Is it possible?

Print this item

  Change of Lookup Codes shall amount to Customization
Posted by: Sara Khan - 11-09-2010, 12:34 AM - Forum: Oracle Financials - Replies (1)

We are going to Implement Withholding Tax as a Workaround for Retainage in Payables Module.

We would like to change Invoice Distribution Type Lookup code from 'Withholding Tax' to 'Retainage' so that anybody,who is having a look at Invoice can understand the amount adjusted as Retainage.

My first doubt is, Whether this will be treated as Customization? (Remember we are changing the Meaning of Lookup code and nothing else).

My Second doubt is, Whether Lookup Code Meaning change will have any affect on any Patch Application? (Some Patches will check the Lookup codes)

please clarify

Print this item

  Generate Code Combinations from GL_SUBR_LED table columns
Posted by: admin - 10-26-2010, 06:47 PM - Forum: Oracle Financials - No Replies

Do you guys have any idea as to how to generate code combination by combining acct_id field and acctng_unit_id field from gl_subr_led table.

Print this item

  Auto Invoice Program - Issue
Posted by: admin - 10-26-2010, 06:46 PM - Forum: Oracle Financials - Replies (2)

I submitted the Auto Invoice Master Program from back end with the below parameters but it is ends with error.

Kindly guide.

fnd_global.apps_initialize(fnd_profile.value('USER_ID'),fnd_profile.value('RESP_ID'),fnd_profile.value('RESP_APPL_ID'));

l_request_id1:= FND_REQUEST.SUBMIT_REQUEST( 'AR','RAXMTR','Auto',null,false
,1,24,'Property Manager Batch Source',to_char(SYSDATE,'YYYY/MM/DD HH:MM:SS')
,'' ,'' ,'' ,'' ,'' ,'' ,'' ,'' ,'' ,'' ,'' ,'' ,'' ,'' ,'' ,'' ,'' ,'' ,''
,'' ,'','Y','' , l_org_id, CHR(0)
);

Print this item

  Cash Management / Bank Transfer Restriction @ user level
Posted by: Omer Ahmad - 10-09-2010, 10:47 PM - Forum: Oracle Financials - Replies (2)

R 12.0.6: Is there any way, that we can restrict the bank transfer authority rights to the specific users. ?
Currently if the user have the access for bank transfer, he/she can authorize that transfer as well. We'd like to restrcit it to the speciifc finance users.

Print this item

  Bank and Bank Branch Data Providers
Posted by: admin - 10-03-2010, 12:10 AM - Forum: Oracle Financials - No Replies

We are in the middle of a global R12 implementation, but are struggling with poor quality name and address data for banks and bank branches. Has anyone faced similar problems, and if so, did you consider using any external sources for reference information? For example, as anyone addressed this problem using services which provide details of bank and branch names and addresses based on IBAN codes, sort codes etc? We need this for a large range of countries.

I've looked at SWIFT.com for their offerings, but am not convinced that they will provide the level of quality for addresses at the branch level.

Print this item

Forum stats
Latest posts
Topic Date, time  Author Last Sender Forum
  Oracle Implementation Pro... 11-18, 02:30 admin Luz Navarrete Oracle Tutori...
  Oracle Fusion Financials ... 10-27, 19:45 M Irfan M Irfan Cloud ERP
  Help in documentation 10-20, 05:46 mustaqeemahmed admin Oracle Tutori...
  How to create the Primary... 10-08, 21:20 M Irfan M Irfan Cloud ERP
  Oracle Cloud Fusion Finan... 10-08, 20:48 M Irfan M Irfan Oracle Tutori...
  Oracle AIM - BR100 Docume... 10-06, 14:13 admin adroit.ramesh@gmail.com Oracle Tutori...
  Oracle AIM - BR100 Docume... 10-06, 14:10 admin adroit.ramesh@gmail.com Oracle Tutori...
  Important concepts for ne... 10-05, 22:44 Sudhakar Naidu yugirala Oracle Tutori...
  Oracle Fusion Financials ... 10-01, 21:36 M Irfan M Irfan Oracle Tutori...
  Oracle HRMS BR100 documen... 09-19, 01:18 admin ahmad.ora Oracle Tutori...
  Oracle VAT Implementation 09-08, 19:48 admin admin Oracle Financ...
Most views
  Oracle AIM - ... 122742
  Oracle Implem... 44674
  Oracle Financ... 36197
  Oracle E-Busi... 35650
  MEOUG Annual ... 34794
Most reputations
admin 4
M Irfan 3
shirfanarshad 2
Sudhakar Naidu 2
Zishan Ali 1
Most replies
  Oracle AIM - ... 33
  Oracle Implem... 22
  R12.1.3 BR100... 16
  DataLoad Temp... 8
  AIM - RD020 P... 7
Top posters
admin 216
Kashif Manzoor 176
M Irfan 59
fanni339 46
ajkhan80 34
Most thanks
admin 175
Kashif Manzoor 88
rajkishoremokila@gmail.com 7
Pryia Rai 7
fanni339 3
Newest members
Narenpdk@gmail.com Today
fkwilliams@gmail.com Today
walid Yesterday
ashosake@gmail.com Yesterday
GURUGUNTLA Yesterday