Welcome, Guest |
You have to register before you can post on our site.
|
Forum Statistics |
» Members: 34,067
» Latest member: iorevod
» Forum threads: 25,446
» Forum posts: 51,585
Full Statistics
|
Online Users |
There are currently 215 online users. » 1 Member(s) | 214 Guest(s) iorevod
|
Latest Threads |
Generative AI Enterprise ...
Forum: AI, ML & Data Science
Last Post: admin
01-27-2024, 05:08 AM
» Replies: 0
» Views: 355
|
Join AI Tech Circle
Forum: AI, ML & Data Science
Last Post: admin
12-24-2023, 10:54 PM
» Replies: 0
» Views: 423
|
BR 100 12.2
Forum: Purchasing, Inventory & Order Management
Last Post: murliram
04-04-2023, 07:22 PM
» Replies: 0
» Views: 988
|
BR100 - R12.2
Forum: Oracle Financials
Last Post: murliram
04-04-2023, 07:20 PM
» Replies: 0
» Views: 1,082
|
AIM - RD020 Process Quest...
Forum: Oracle Tutorials, Articles, eBooks, Tools & Tips
Last Post: tneshiwat@hotmail.com
02-14-2023, 08:26 AM
» Replies: 18
» Views: 74,049
|
Oracle EBS R12 Financials...
Forum: Oracle Tutorials, Articles, eBooks, Tools & Tips
Last Post: leo.chen
01-02-2023, 06:50 AM
» Replies: 1
» Views: 14,218
|
How to Add a New Operatin...
Forum: Oracle Tutorials, Articles, eBooks, Tools & Tips
Last Post: leo.chen
01-02-2023, 06:48 AM
» Replies: 1
» Views: 8,949
|
Oracle eBusiness Suite Pr...
Forum: Oracle Tutorials, Articles, eBooks, Tools & Tips
Last Post: Kashif Manzoor
05-26-2022, 06:45 PM
» Replies: 3
» Views: 51,896
|
Oracle R12 i-Procurement ...
Forum: Oracle Tutorials, Articles, eBooks, Tools & Tips
Last Post: Kashif Manzoor
04-05-2022, 10:48 PM
» Replies: 3
» Views: 39,577
|
TAX - How to call pl/sql ...
Forum: Oracle Financials
Last Post: rdallagnol2
03-11-2022, 01:30 AM
» Replies: 0
» Views: 1,638
|
|
|
How to Automate Accounting Schedules in Oracle Financials |
Posted by: vajirap - 02-11-2014, 11:26 AM - Forum: Oracle Financials
- Replies (3)
|
|
Currently, the month end accounting schedules are created manually. I am trying to automate this process so that all these schedules could be generated through the system automatically. Even though I searched the oracle knowledge base I was not able to come up with a solution,
Is there any method of doing it and have anyone of you done this previously
|
|
|
Credit Check Loop Hole - Logistics team can ship infinite amount of goods |
Posted by: PhilipS - 02-03-2014, 09:37 PM - Forum: Oracle Financials
- Replies (4)
|
|
Hi,
I need to seek the attention of credit experts out there and give your opinion on this; potentially is a big issue for Oracle, but would like input from Credit Management people.
- In the credit check rules there is shipping horizon days, this allows for future orders to be excluded from credit exposure value.
- Our company is set to 22 days
- We have credit check set to check all orders at pick release - after pick release there is no further financial system control, goods normally delivered within 2 days, sometimes same day.
- We supply to up to 500 national locations for a single customer and each shipment has separate invoice and normal value is $500 to $2000 USD each shipment
- So we a receive a national order which splits in our system to 500 separate sales orders, the order has a scheduled shipping date of 30 days from now.
- The customer has not paid for two months and the available credit limit is approx $50k, the orders we received is valued at approximately $700k but does not go on credit hold, as the credit exposure calculation excludes it as the order scheduled shipping date is over 22 days.
- The customer contacts us a few days later and requests urgent shipment for the $700k order (which is scheduled for 26 days time)
- The Order management/logistics team pick release the orders and then dispatch all orders to the customer
- Oracle finalises its processes overnight and the next day the account balance exceeds the credit limit by $650k because the $700k was invoiced.
So we have account balance that is in excess of the credit limit by a sizeable amount - no orders went on hold - thoughts? Is oracle malfunctioning?
|
|
|
Financial Statement Generator |
Posted by: Ryan Adam - 01-20-2014, 01:20 AM - Forum: Oracle Financials
- Replies (3)
|
|
Just have a question while I am creating FSG report, how to display conditional value for a row and column.
FSG report row no 1, 2, 3 is returning +ve value and row no 4 is returing -ve value for a column, in this case i want to display the +ve value only in my report, how can i achieve this in EBS R12.
Cheers
|
|
|
GL Approval Action History from Workflow tables |
Posted by: Sneha Rahul - 12-06-2013, 02:05 AM - Forum: Oracle Financials
- Replies (3)
|
|
Hi All,
I have prepared the query to retrieve the Journal Approval Action History from Workflow tables. Below is the Query. This is the Form Personalization. In the Journal Screen i have attached the Menu Action History and placed this query for form personalization.
Now the problem is in GL_JE_BATCHES i have 80 thousand records. In the query which i have written i am getting only 1000 records. How can i achieve all the records.
SELECT DISTINCT gjb.NAME batch, default_period_name period,
wn.recipient_role approver,
DECODE (gjb.approval_status_code,
'A', 'Approved',
'I', 'In Process',
'J', 'Rejected',
'R', 'Required',
'V', 'Validation Failed',
'Z', 'N/A'
) status,
wn.begin_date approval_start_date,
wn.end_date approval_end_date,
wn.due_date approval_due_date
FROM wf_notifications wn, wf_items wi, gl_je_batches gjb
WHERE wn.CONTEXT LIKE
'GLBATCH%'
|| (SELECT item_key
FROM wf_items a
WHERE a.user_key = wi.user_key
AND a.item_type = 'GLBATCH'
AND ROWNUM = 1)
|| '%'
AND wi.item_type = wn.MESSAGE_TYPE
AND wi.user_key = gjb.NAME;
Can any one please suggest me how to proceed on this issue ASAP?
Regards,
|
|
|
Format Payment Instructions |
Posted by: Usman - 08-01-2013, 09:05 PM - Forum: Oracle Financials
- Replies (2)
|
|
Good morning,
We're in trouble in lots of payment, sometimes he does not complete correctly leaving notes selected for payment and no option to conclude the payment batch (PPR).
Regards
|
|
|
GL Personalization |
Posted by: Vikram - 07-22-2013, 06:08 AM - Forum: Oracle Financials
- Replies (3)
|
|
Hello All,
I have a doubt in GL. How to restrict the GL Manual journal. Meaning It should not allow to Enter manual Journal in the GL.
Is it possible through Personalization?
If yes, how because I don't know the Personalization.
Thanks and Regards,
Vikram
|
|
|
Intercompany Elimination programs |
Posted by: mrambojun - 06-21-2013, 04:32 AM - Forum: Oracle Financials
- Replies (4)
|
|
Hi,
The intercompany Elimination program completes with warning. No output file has been generated.
Based on the log file, there seems to be invalid GL code combinations which is causing the problem.However, it does not specify which GL Code combinations are invalid or does not exist.
The program has also been run from a responsiblity that does not have any security or cross validation rules and the issue was retested but still it completes with warning.
Is there any way to identify those invalid GL code combination ? Any report or script that can be used to do so?
Is there any tables in the database that can these info?
please advise..
|
|
|
|