Category 337
Discussion List
-
PATD, QATD and YATD calculation from the GL_DAILY_BALANCES tableWe need to develop an extract for EPM with fields PERIOD,COMP(segment1),ACCT(segment2),TRD PTNR(segment5),PRODUCT(segment6),ACCT ACT(segment8),TRANS TYPE(segment7), MTD_…Liya-Oracle 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Ability to Select multiple dimension members in a single column/row in SmartView Ad-Hoc ReportingWhen creating a SmartView Ad-hoc report. When we choose members from a dimension right now, we are only able to push them across columns / down rows , but we want to pla…k.madaan 14 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Can Auto copy source be changed?When we manually copy the journal and create duplicate journal the journal source automatically reflect as auto copy rather it should be manual. How to change the journa…Jiten Jataniya 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
How can we check the list of GL accounts which are not mapped under any hierarchy?How can we check List of GL accounts which are not mapped under any hierarchy of "GL Account Segment"? for eg: if there are 100 GL accounts out of those only 80 GL accou…Jiten Jataniya 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Journal SequencingSummary: Can I create a Sequence by prefix characters other than Numbers Content (please ensure you mask any confidential information): We are trying to create a Journal…RajibPramanik 4 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Transaction tax should not be applicable based on Intercompany Transaction typeSummary: Transaction tax should not be applicable based on Intercompany Transaction type Content (required): There is a requirement where tax should not be applicable or…
-
How to route the Intercompany Batch for APproval based on User who submitted the Intercompany BatchBusiness Requirement: Any Intercompany Batches submitted by "User A" should go to "User B" for approval. We have to create the above in the Provider Organization that if…charanjit channi 17 views 1 comment 0 points Most recent by charanjit channi General Ledger & Intercompany
-
Manual reconciliation screen are typically derived fromHi Team I would like to know how the options below are appearing on the manual reconciliation screen and why other segments are not shown. If we need other segments to b…Aswani Buddiga-Oracle 1 view 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany -
How can you limit transaction amounts to two decimal placesSummary: Client has a requirement to limit transaction amounts to two decimal places to avoid rounding issues Content (please ensure you mask any confidential informatio…bevwhite 31 views 1 comment 0 points Most recent by Pooja Asthana-Oracle General Ledger & Intercompany
-
Trying to retrieve number from AccountingPeriod to use in Formulas in Financial Reporting Web StudioSummary: We are facing a challenge where we need to calculate a specific value using the AccountingPeriod number. However, the AccountingPeriod in the GL cube is represe…Arvind_Behura 21 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany -
Reference Date in GL Journal HeaderSummary: Hi do you know, if it's possible to use Reference Date in the Journal Header level to recalculate value from Primary Ledger to Secondary Ledger with exchange ra…
-
best way to retain cost centre account code hierarchy at the end of each financial year?What is the best way to retain a snapshot of the cost centre account code hierarchy at the end of each financial year? Would I be best to explore the option of versions …
-
How to reorder the Journal category selection list?Summary: Some of the seeded journal category will not be used in our requirement. How can we put them at the last of the journal category selection list? Content (please…Alfred Choi 11 views 3 comments 0 points Most recent by Julien_Dubouis General Ledger & Intercompany
-
Help me correct this Expression Language syntaxI created a HTML Markup through Page Composer. My goal is to check if the batch number value is equal to batch description value. For instance: Inputs Batch Number: 2535…
-
Need to clarification on Journals amount roundingSummary: When Journals are posted to the GL, we need to know whether the system rounds the amount up or down during calculations Content (please ensure you mask any conf…Kannaki Pugalenthi 6 views 1 comment 0 points Most recent by Sharada Beleramane-Oracle General Ledger & Intercompany
-
Search/filter/report on transactions by company and cost centerSummary: Is there a way to search/filter/report on transactions by company and cost center which are two segments in the chart of accounts structure? Content (please ens…bevwhite 2 views 1 comment 0 points Most recent by Sharada Beleramane-Oracle General Ledger & Intercompany
-
How to remove "Post" action from General Accountant roleMy client has a requirement for journal creation. They have three people (GL preparer, GL reviewer, GL approver) with three different duties to process a manual journal.…Alfred Choi 5 views 1 comment 0 points Most recent by Sharada Beleramane-Oracle General Ledger & Intercompany
-
Validating Intercompany Elimination Allocation Rule ImplementationSummary: Hi everyone, I'm working on implementing an intercompany elimination allocation rule in our General Ledger with a specific organization structure. I'd like to v…Patrick Chrabieh 33 views 3 comments 2 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
How to design a ledger for a head office with multiple overseas branchesSummary: Having problem with designing a ledger for a head office with multiple overseas branches Content (please ensure you mask any confidential information): We need …
-
How to enter many-to-many intercompany transactionTypically, intercompany transactions involve one provider organization and multiple receiver organization within a single batch number. There have been discussions and r…
-
7 Legal entities - Suggestion from community - one ledger or multiple LedgersCustomer has 7 legal entities of same country and Same Currency - what would be recommendation ? would be one ledger or multiple ledgers by legal entity wise What would …Sandeep Nihalani 51 views 4 comments 0 points Most recent by Jakeeagarwal General Ledger & Intercompany
-
Can some bsv's create journals in a closed period?Summary: The requirement is to allow some BSV's in a ledger to allow journals created in a closed period. Content (please ensure you mask any confidential information): …
-
General Ledger - A report that includes all prior periods opened during the past 4 weeksWe are looking for a report to accomplish the following : A report from Oracle that includes all prior periods opened during the past 4 weeks, must be generated and revi…Wilson Chelakadan 14 views 1 comment 0 points Most recent by Wilson Chelakadan General Ledger & Intercompany
-
Is there any way to segregate the lease asset and post two different liability accounts every year?Is there any way to segregate the leased assets into short term and long-term liability and post it into respective liability accounts every year by the system?Aishwarya gannoji 11 views 6 comments 0 points Most recent by VINAY K SINGH General Ledger & Intercompany
-
Notification if budget exceededSummary: Need is that if funds check has got failed then the system should send a notification the designated users. Content (please ensure you mask any confidential inf…Gutpe Srujan 11 views 1 comment 0 points Most recent by Sharada Beleramane-Oracle General Ledger & Intercompany
-
Is there any option to secure corporate rates in oracle fusion?Summary: Currently customer have globalized business in multiple countries and conversion rates will be uploaded by separate team for all rate types. For some countries,…Karthikeyan Chendrayan 11 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
Create Balance Cube is failingSummary: Content (please ensure you mask any confidential information): Create Balances Cubes: Transfer General Ledger Balances is ending up error. The log file is sugge…RajibPramanik 40 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
puds.pscr.anonymous.userSummary: What the description of this "puds.pscr.anonymous.user" when you run the "User Password Changes Audit Report". I could not find anything in MOS.I need to unders…
-
How to Reconciling General Ledger and Budget with Different Conversion Rate Types in OracleSummary: Budget Control: Set Default Rate Type: BOT Selling Transaction:Create a Transaction AP Invoice by specifying Coversion rate type as user rate. Compare Amount be…
-
Allocation Rule(Formula) Deployment errorHi, We got a requirement for year end allocation rule where ending balance should go to equity and non equity account. Please help with the Run time variable selection a…D Mandal 1 view 1 comment 0 points Most recent by Sharada Beleramane-Oracle General Ledger & Intercompany